Expand|Select|Wrap|Line Numbers
- private void Submit_Click(object sender, System.EventArgs e)
- {
- if( filMyFile.PostedFile.ContentLength != 0 )
- {
- string strFilename;
- strFilename = filMyFile.PostedFile.FileName;
- strFilename = System.IO.Path.GetFileName(strFilename);
- filMyFile.PostedFile.SaveAs(@"C:\Advert_images\"+strFilename);
- }
- else
- {
- // No file
- }
- string status;
- string image_name;
- image_name = filMyFile.PostedFile.FileName;
- image_name = System.IO.Path.GetFileName(image_name);
- status = "unverified";
- SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
- SqlCommand cmd = new SqlCommand("Add_advert_new", con);
- cmd.CommandType = CommandType.StoredProcedure;
- con.Open();
- cmd.Parameters.Add("@Title",SqlDbType.VarChar);
- cmd.Parameters["@Title"].Value = txtTitle.Text;
- cmd.Parameters.Add("@Expiry_date",SqlDbType.DateTime);
- cmd.Parameters["@Expiry_date"].Value = Session["SelectedDate"].ToString();
- cmd.Parameters.Add("@Description",SqlDbType.Text );
- cmd.Parameters["@Description"].Value = txtDescr.Text;
- cmd.Parameters.Add("@Added_by",SqlDbType.VarChar );
- cmd.Parameters["@Added_by"].Value = Session["Name"].ToString();
- cmd.Parameters.Add("@Surname",SqlDbType.VarChar );
- cmd.Parameters["@Surname"].Value = Session["SName"].ToString();
- cmd.Parameters.Add("@status",SqlDbType.VarChar );
- cmd.Parameters["@status"].Value = status;
- cmd.Parameters.Add("@image_name",SqlDbType.VarChar );
- cmd.Parameters["@image_name"].Value = image_name;
- cmd.ExecuteNonQuery();
- con.Close();
- Response.Write(@"<script language='javascript'>alert('Advert has been uploaded but it will be verified by the webmaster fisrt before it can be displayed. Have a nice day!')</script>");
- SmtpMail.SmtpServer = ConfigurationSettings.AppSettings["EmailServer"];
- string strTo = "MicheleH@int.scm";
- string strFrom = "webmaster@int.scm";
- string strSubject = "New advert to be verified";
- SmtpMail.Send(strFrom, strTo, strSubject,
- "A new advert has been loaded, please click on the link http://jhb-ds-web1/scmnet/doc/verifyadverts.aspx to verify the advert.");
- Response.Redirect("classifieds_1.aspx");
- }