try
{
if (HttpContext.Current.Request.Cookies["CRegistrationID"].Value != "")
{
if (FUImages.HasFile && FUBrochure.HasFile)
{
string CateName = ddlCreateAddCategory.SelectedItem.ToString();
string ArName = ddlCreateAddArea.SelectedItem.ToString();
Con.Open();
string uid = HttpContext.Current.Request.Cookies["CRegistrationID"].Value;
HttpContext.Current.Response.Cookies["Image"].Value = CateName;
HttpContext.Current.Response.Cookies["Upload"].Value = ArName;
ImageAutoNum = Guid.NewGuid().ToString();
ImageAutoNum = ImageAutoNum.Substring(0, 3);
FUImages.SaveAs(Server.MapPath("~/ConsumerImages/" + ImageAutoNum + FUImages.FileName));
ImageUrl = "~/ConsumerImages/" + ImageAutoNum + FUImages.FileName;
ImageAutoNum2 = Guid.NewGuid().ToString();
ImageAutoNum2 = ImageAutoNum2.Substring(0, 3);
FUBrochure.SaveAs(Server.MapPath("~/ConsumerImages/" + ImageAutoNum2 + FUBrochure.FileName));
FUBImages = "~/ConsumerImages/" + ImageAutoNum2 + FUBrochure.FileName;
Cmd = new SqlCommand("Insert into ConsumerAdvertiesment(CategoryName,ADshop_name,ADShop_Address,ADshop_city,ADShop_mob,ADshop_Email,RegistrationId,startddate,endddate,ImageName,Description,ImagePath,BImageName,BImagePath,Status) values('" + CateName + "','" + txtshopname.Text + "','" + txtCadress.Text + "','" + txtCity.Text + "','" + txtcontact.Text + "','" + txtemail.Text + "','" + uid + "','" + txtstart.Text + "','" + txtEnd.Text + "','" + ImageUrl + "','" + txtDesc.Text + "','" + ImageUrl + "','" + FUBImages + "','" + FUBImages + "','Active')", Con);
Cmd.ExecuteNonQuery();
Response.Redirect("Success.aspx?Pop=Adv");
Con.Close();
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please Select Image & Brochure');", true);
}
}
else
{
Response.Cookies["LoginRedirect"].Value = "Yes";
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please Log in First !!! ');", true);
}
}
catch (Exception ex)
{ }
finally
{
Con.Close();
}