private void StartUpLoad()
{
//get the file name of the posted image
string imgName = FileUpload11.FileName;
//sets the image path
string imgPath = "Images/" + imgName;
//get the size in bytes that
int imgSize = FileUpload11.PostedFile.ContentLength;
//validates the posted file before saving
if (FileUpload11.PostedFile != null && FileUpload11.PostedFile.FileName != "")
{
// 10240 KB means 10MB, You can change the value based on your requirement
//then save it to the Folder
FileUpload11.SaveAs(Server.MapPath(imgPath));
r_image_pswd.ImageUrl = "~/" + imgPath;
// Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "Alert", "alert('Image saved!')", true);
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
int proid = tempProID;
if (proid != -1)
{
using (SaleCarsEntities ctx = new SaleCarsEntities())
{
Product p = ctx.Products.Where(pro => pro.ProID == proid).FirstOrDefault();
if (p != null)
{
p.ProName = txtProNamee.Text;;
p.CatID = Convert.ToInt32(ddlCategorye.SelectedItem.Value);
p.Quantity = Convert.ToInt32(txtQuantitye.Text);
p.Price = Convert.ToInt32(txtPricee.Text);
p.TinyDes = txtTinyDese.Text;
p.FullDes = txtFullDese.Text;
ctx.Entry(p).State = System.Data.Entity.EntityState.Modified;
ctx.SaveChanges();
if (FileUpload1.HasFile && FileUpload11.HasFile && FileUpload2.HasFile && FileUpload22.HasFile)
{
string spDirPath = Server.MapPath("~/images/products");
string targetDirPath = Path.Combine(spDirPath, p.ProID.ToString());
if (Directory.Exists(targetDirPath) == false)
{
Directory.CreateDirectory(targetDirPath);
}
//copy hình lên
//hinh 1
string mainFileName = Path.Combine(targetDirPath, "1.jpg");
FileUpload1.SaveAs(mainFileName);
string thumbsFileName = Path.Combine(targetDirPath, "1_thumbs.jpg");
FileUpload11.SaveAs(thumbsFileName);
//hình 2
mainFileName = Path.Combine(targetDirPath, "2.jpg");
FileUpload2.SaveAs(mainFileName);
thumbsFileName = Path.Combine(targetDirPath, "2_thumbs.jpg");
FileUpload22.SaveAs(thumbsFileName);
}
}
}
ClientScript.RegisterStartupScript(this.GetType(),
"swal",
"alert('Đã Chỉnh sửa');",
true
);
ClearProductInfo();
tempProID = -1;
LoadProducts();
}
}
protected void Button12_Click(object sender, EventArgs e)
{
string strMsgSuccess = "Upload Success";
string strMsgSelect = "Please select your file";
if (FileUpload11.HasFile)
{
String strFileName = FileUpload11.FileName;
FileUpload11.SaveAs(Server.MapPath("lecture11/" + strFileName));
//Response.Write("<script> alert('Upload Success');<script>");
TextBox11.Text = strMsgSuccess;
}
else
{
//Response.Write("<script> alert('Pleases select your file');<script>");
TextBox11.Text = strMsgSelect;
}
}
protected void Btnupload_Command(object sender, CommandEventArgs e)
{
if (e.CommandArgument == "DDinsert")
{
HttpFileCollection hfc = Request.Files;
for (int i = 0; i < hfc.Count; i++)
{
HttpPostedFile hpf = hfc[i];
if (hpf.ContentLength > 0)
{
string filepath1 = "DailyImages/" + hpf.FileName;
hpf.SaveAs(Server.MapPath("DailyImages") + "\\" + Path.GetFileName(hpf.FileName));
cmd = new SqlCommand("insert into DailyDarshan values('" + filepath1 + "','" + Calendar1.SelectedDate + "')", cn);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}
}
}
else if (e.CommandArgument == "SDinsert")
{
HttpFileCollection hfc = Request.Files;
for (int i = 0; i < hfc.Count; i++)
{
HttpPostedFile hpf = hfc[i];
if (hpf.ContentLength > 0)
{
string filepath1 = "ShayanImages/" + hpf.FileName;
hpf.SaveAs(Server.MapPath("ShayanImages") + "\\" + Path.GetFileName(hpf.FileName));
cmd = new SqlCommand("insert into ShayanDarshan values('" + filepath1 + "','" + Calendar2.SelectedDate + "')", cn);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}
}
}
else if (e.CommandArgument == "DWinsert")
{
HttpFileCollection hfc = Request.Files;
for (int i = 0; i < hfc.Count; i++)
{
HttpPostedFile hpf = hfc[i];
if (hpf.ContentLength > 0)
{
string filepath1 = "DeskWallpaper/" + hpf.FileName;
hpf.SaveAs(Server.MapPath("DeskWallpaper") + "\\" + Path.GetFileName(hpf.FileName));
cmd = new SqlCommand("insert into DeskWallpaper values('" + filepath1 + "','" + Calendar3.SelectedDate + "')", cn);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}
}
}
else if (e.CommandArgument == "MWinsert")
{
HttpFileCollection hfc = Request.Files;
for (int i = 0; i < hfc.Count; i++)
{
HttpPostedFile hpf = hfc[i];
if (hpf.ContentLength > 0)
{
string filepath1 = "MobileWallpaper/" + hpf.FileName;
hpf.SaveAs(Server.MapPath("MobileWallpaper") + "\\" + Path.GetFileName(hpf.FileName));
cmd = new SqlCommand("insert into MobileWallpaper values('" + filepath1 + "','" + Calendar4.SelectedDate + "')", cn);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}
}
}
else if (e.CommandArgument == "PGinsert")
{
if (FileUpload5.HasFile)
{
HttpFileCollection hfc = Request.Files;
string filepath = "Gallary/" + FileUpload5.PostedFile.FileName;
int count = hfc.Count - 1;
cmd = new SqlCommand("insert into Album1 values ('" + TextBox1.Text + "','" + filepath + "','" + TextBox2.Text + "','" + Calendar7.SelectedDate + "','" + count + "')", cn);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
cmd = new SqlCommand("select id from Album1 where a_name = '" + TextBox1.Text + "'", cn);
cn.Open();
adp = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adp.Fill(ds, "Album1");
cn.Close();
string albid = ds.Tables["Album1"].Rows[0][0].ToString();
for (int i = 0; i < hfc.Count; i++)
{
HttpPostedFile hpf = hfc[i];
if (hpf.ContentLength > 0)
{
string filepath1 = "Gallary/" + hpf.FileName;
hpf.SaveAs(Server.MapPath("Gallary") + "\\" + Path.GetFileName(hpf.FileName));
cmd = new SqlCommand("insert into Alb_Photo1 values ('" + Convert.ToInt16(albid) + "','" + filepath1 + "','" + Calendar7.SelectedDate + "')", cn);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}
}
}
}
else if (e.CommandArgument == "EMGinsert")
{
string filename = "E_Magazine/" + Path.GetFileName(FileUpload9.PostedFile.FileName);
FileUpload9.SaveAs(Server.MapPath(filename));
string filename1 = "E_Magazine/" + Path.GetFileName(FileUpload10.PostedFile.FileName);
FileUpload10.SaveAs(Server.MapPath(filename1));
cmd = new SqlCommand("insert into E_Magazine values('" + TextBox5.Text + "','" + TextBox6.Text + "','" + filename + "','" + filename1 + "')", cn);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}
else if (e.CommandArgument == "EBKinsert")
{
string filename = "E_Book/" + Path.GetFileName(FileUpload11.PostedFile.FileName);
FileUpload11.SaveAs(Server.MapPath(filename));
string filename1 = "E_Book/" + Path.GetFileName(FileUpload12.PostedFile.FileName);
FileUpload12.SaveAs(Server.MapPath(filename1));
cmd = new SqlCommand("insert into E_Book values('" + TextBox7.Text + "','" + TextBox8.Text + "','" + TextBox9.Text + "','" + TextBox10.Text + "','" + DropDownList1.SelectedItem.ToString() + "','" + filename + "','" + filename1 + "')", cn);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}
else if (e.CommandArgument == "DMPinsert")
{
string delimg = null;
if (FileUpload7.HasFile)
{
HttpFileCollection hfc = Request.Files;
string img = null;
string imgname = file(img);
string filepath = "DMP/" + imgname;
delimg = filepath;
cmd = new SqlCommand("insert into DivineAlbum values ('" + TextBox3.Text + "','" + filepath + "','" + TextBox4.Text + "','" + Calendar8.SelectedDate + "','" + hfc.Count + "')", cn);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}
if (FileUpload8.HasFile)
{
//HttpFileCollection hfc = Request.Files;
//string img = null;
//string imgname = file(img);
//string filepath = "DMP/" + imgname;
//cmd = new SqlCommand("insert into DivineAlbum values ('" + TextBox3.Text + "','" + filepath + "','" + TextBox4.Text + "','" + Calendar8.SelectedDate + "','" + hfc.Count + "')", cn);
//cn.Open();
//cmd.ExecuteNonQuery();
//cn.Close();
HttpFileCollection hfc1 = Request.Files;
cmd = new SqlCommand("select id from DivineAlbum where a_name = '" + TextBox3.Text + "'", cn);
cn.Open();
adp = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adp.Fill(ds, "DivineAlbum");
cn.Close();
string albid = ds.Tables["DivineAlbum"].Rows[0][0].ToString();
for (int i = 0; i < hfc1.Count; i++)
{
HttpPostedFile hpf = hfc1[i];
if (hpf.ContentLength > 0)
{
string filepath1 = "DMP/" + hpf.FileName;
hpf.SaveAs(Server.MapPath("DMP") + "\\" + Path.GetFileName(hpf.FileName));
cmd = new SqlCommand("insert into DivineMusic values ('" + Convert.ToInt16(albid) + "','" + hpf.FileName + "','" + filepath1 + "')", cn);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}
}
int ts = hfc1.Count - 2;
cmd = new SqlCommand("update DivineAlbum set total_song='" + ts + "' where id='" + Convert.ToInt64(albid) + "'", cn);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}
cmd = new SqlCommand("delete from DivineMusic where m_path='" + delimg + "'", cn);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}
else if (e.CommandArgument == "MRinsert")
{
HttpFileCollection hfc = Request.Files;
for (int i = 0; i < hfc.Count; i++)
{
HttpPostedFile hpf = hfc[i];
if (hpf.ContentLength > 0)
{
string filepath1 = "MobileRingtone/" + hpf.FileName;
hpf.SaveAs(Server.MapPath("MobileRingtone") + "\\" + Path.GetFileName(hpf.FileName));
cmd = new SqlCommand("insert into MobileRingtone values('" + hpf.FileName + "','" + filepath1 + "')", cn);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}
}
}
else
{
}
}
protected void Button7_Click(object sender, EventArgs e)
{
try
{
if (FileUpload1.HasFile || FileUpload2.HasFile || FileUpload3.HasFile || FileUpload4.HasFile || FileUpload5.HasFile || FileUpload6.HasFile || FileUpload7.HasFile || FileUpload8.HasFile || FileUpload9.HasFile || FileUpload10.HasFile || FileUpload11.HasFile || FileUpload12.HasFile || FileUpload13.HasFile || FileUpload14.HasFile || FileUpload15.HasFile || FileUpload16.HasFile || FileUpload17.HasFile || FileUpload18.HasFile || FileUpload19.HasFile || FileUpload20.HasFile || FileUpload21.HasFile || FileUpload22.HasFile || FileUpload23.HasFile || FileUpload24.HasFile || FileUpload25.HasFile || FileUpload26.HasFile || FileUpload27.HasFile || FileUpload28.HasFile || FileUpload29.HasFile || FileUpload30.HasFile || FileUpload31.HasFile || FileUpload32.HasFile || FileUpload33.HasFile || FileUpload34.HasFile || FileUpload35.HasFile || FileUpload36.HasFile || FileUpload37.HasFile || FileUpload38.HasFile || FileUpload39.HasFile)
{
string path = Server.MapPath("Images/");
//HOME
if (FileUpload1.HasFile)
{
string ext = Path.GetExtension(FileUpload1.FileName);
if (ext == ".jpg" || ext == ".png")
{
FileUpload1.SaveAs(path + FileUpload1.FileName);
string name = "Images/" + FileUpload1.FileName;
string ss = "update slider set image1='" + name + "' where id=14";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
if (FileUpload2.HasFile)
{
string ext = Path.GetExtension(FileUpload2.FileName);
if (ext == ".jpg" || ext == ".png")
{
FileUpload2.SaveAs(path + FileUpload2.FileName);
string name = "Images/" + FileUpload2.FileName;
string ss = "update slider set image2='" + name + "' where id=14";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
if (FileUpload3.HasFile)
{
string ext = Path.GetExtension(FileUpload3.FileName);
if (ext == ".jpg" || ext == ".png")
{
FileUpload3.SaveAs(path + FileUpload3.FileName);
string name = "Images/" + FileUpload3.FileName;
string ss = "update slider set image3='" + name + "' where id=14";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
//BUY FLAT
if (FileUpload4.HasFile)
{
string ext = Path.GetExtension(FileUpload4.FileName);
if (ext == ".jpg" || ext == ".png")
{
FileUpload4.SaveAs(path + FileUpload4.FileName);
string name = "Images/" + FileUpload4.FileName;
string ss = "update slider set image1='" + name + "' where id=1";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
if (FileUpload5.HasFile)
{
string ext = Path.GetExtension(FileUpload5.FileName);
if (ext == ".jpg" || ext == ".png")
{
FileUpload5.SaveAs(path + FileUpload5.FileName);
string name = "Images/" + FileUpload5.FileName;
string ss = "update slider set image2='" + name + "' where id=1";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
if (FileUpload6.HasFile)
{
string ext = Path.GetExtension(FileUpload6.FileName);
if (ext == ".jpg" || ext == ".png")
{
FileUpload6.SaveAs(path + FileUpload6.FileName);
string name = "Images/" + FileUpload6.FileName;
string ss = "update slider set image3='" + name + "' where id=1";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
//BUY HOUSE
if (FileUpload7.HasFile)
{
string ext = Path.GetExtension(FileUpload7.FileName);
if (ext == ".jpg" || ext == ".png")
{
FileUpload7.SaveAs(path + FileUpload7.FileName);
string name = "Images/" + FileUpload7.FileName;
string ss = "update slider set image1='" + name + "' where id=2";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
if (FileUpload8.HasFile)
{
string ext = Path.GetExtension(FileUpload8.FileName);
if (ext == ".jpg" || ext == ".png")
{
FileUpload8.SaveAs(path + FileUpload8.FileName);
string name = "Images/" + FileUpload8.FileName;
string ss = "update slider set image2='" + name + "' where id=2";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
if (FileUpload9.HasFile)
{
string ext = Path.GetExtension(FileUpload9.FileName);
if (ext == ".jpg" || ext == ".png")
{
FileUpload9.SaveAs(path + FileUpload9.FileName);
string name = "Images/" + FileUpload9.FileName;
string ss = "update slider set image3='" + name + "' where id=2";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
//BUY VILLA
if (FileUpload10.HasFile)
{
string ext = Path.GetExtension(FileUpload10.FileName);
if (ext == ".jpg" || ext == ".png")
{
FileUpload10.SaveAs(path + FileUpload10.FileName);
string name = "Images/" + FileUpload10.FileName;
string ss = "update slider set image1='" + name + "' where id=3";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
if (FileUpload11.HasFile)
{
string ext = Path.GetExtension(FileUpload11.FileName);
if (ext == ".jpg" || ext == ".png")
{
FileUpload11.SaveAs(path + FileUpload11.FileName);
string name = "Images/" + FileUpload11.FileName;
string ss = "update slider set image2='" + name + "' where id=3";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
if (FileUpload12.HasFile)
{
string ext = Path.GetExtension(FileUpload12.FileName);
if (ext == ".jpg" || ext == ".png")
{
FileUpload12.SaveAs(path + FileUpload12.FileName);
string name = "Images/" + FileUpload12.FileName;
string ss = "update slider set image3='" + name + "' where id=3";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
//BUY LUXURY HOUSE
if (FileUpload13.HasFile)
{
string ext = Path.GetExtension(FileUpload13.FileName);
if (ext == ".jpg" || ext == ".png")
{
FileUpload13.SaveAs(path + FileUpload13.FileName);
string name = "Images/" + FileUpload13.FileName;
string ss = "update slider set image1='" + name + "' where id=5";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
if (FileUpload14.HasFile)
{
string ext = Path.GetExtension(FileUpload14.FileName);
if (ext == ".jpg" || ext == ".png")
{
FileUpload14.SaveAs(path + FileUpload14.FileName);
string name = "Images/" + FileUpload14.FileName;
string ss = "update slider set image2='" + name + "' where id=5";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
if (FileUpload15.HasFile)
{
string ext = Path.GetExtension(FileUpload15.FileName);
if (ext == ".jpg" || ext == ".png")
{
FileUpload15.SaveAs(path + FileUpload15.FileName);
string name = "Images/" + FileUpload15.FileName;
string ss = "update slider set image3='" + name + "' where id=5";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
//BUY BUDGET DEAL
if (FileUpload16.HasFile)
{
string ext = Path.GetExtension(FileUpload16.FileName);
if (ext == ".jpg" || ext == ".png")
{
FileUpload16.SaveAs(path + FileUpload16.FileName);
string name = "Images/" + FileUpload16.FileName;
string ss = "update slider set image1='" + name + "' where id=6";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
if (FileUpload17.HasFile)
{
string ext = Path.GetExtension(FileUpload17.FileName);
if (ext == ".jpg" || ext == ".png")
{
FileUpload17.SaveAs(path + FileUpload17.FileName);
string name = "Images/" + FileUpload17.FileName;
string ss = "update slider set image2='" + name + "' where id=6";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
if (FileUpload18.HasFile)
{
string ext = Path.GetExtension(FileUpload18.FileName);
if (ext == ".jpg" || ext == ".png")
{
FileUpload18.SaveAs(path + FileUpload18.FileName);
string name = "Images/" + FileUpload18.FileName;
string ss = "update slider set image3='" + name + "' where id=6";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
//RENT FLAT
if (FileUpload19.HasFile)
{
string ext = Path.GetExtension(FileUpload19.FileName);
if (ext == ".jpg" || ext == ".png")
{
FileUpload19.SaveAs(path + FileUpload19.FileName);
string name = "Images/" + FileUpload19.FileName;
string ss = "update slider set image1='" + name + "' where id=7";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
if (FileUpload20.HasFile)
{
string ext = Path.GetExtension(FileUpload20.FileName);
if (ext == ".jpg" || ext == ".png")
{
FileUpload20.SaveAs(path + FileUpload20.FileName);
string name = "Images/" + FileUpload20.FileName;
string ss = "update slider set image2='" + name + "' where id=7";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
if (FileUpload21.HasFile)
{
string ext = Path.GetExtension(FileUpload21.FileName);
if (ext == ".jpg" || ext == ".png")
{
FileUpload21.SaveAs(path + FileUpload21.FileName);
string name = "Images/" + FileUpload21.FileName;
string ss = "update slider set image3='" + name + "' where id=7";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
//RENT HOUSE
if (FileUpload22.HasFile)
{
string ext = Path.GetExtension(FileUpload22.FileName);
if (ext == ".jpg" || ext == ".png")
{
FileUpload22.SaveAs(path + FileUpload22.FileName);
string name = "Images/" + FileUpload22.FileName;
string ss = "update slider set image1='" + name + "' where id=8";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
if (FileUpload23.HasFile)
{
string ext = Path.GetExtension(FileUpload23.FileName);
if (ext == ".jpg" || ext == ".png")
{
FileUpload23.SaveAs(path + FileUpload23.FileName);
string name = "Images/" + FileUpload23.FileName;
string ss = "update slider set image2='" + name + "' where id=8";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
if (FileUpload24.HasFile)
{
string ext = Path.GetExtension(FileUpload24.FileName);
if (ext == ".jpg" || ext == ".png")
{
FileUpload24.SaveAs(path + FileUpload24.FileName);
string name = "Images/" + FileUpload24.FileName;
string ss = "update slider set image3='" + name + "' where id=8";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
//RENT VILLA
if (FileUpload25.HasFile)
{
string ext = Path.GetExtension(FileUpload25.FileName);
if (ext == ".jpg" || ext == ".png")
{
FileUpload25.SaveAs(path + FileUpload25.FileName);
string name = "Images/" + FileUpload25.FileName;
string ss = "update slider set image1='" + name + "' where id=9";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
if (FileUpload26.HasFile)
{
string ext = Path.GetExtension(FileUpload26.FileName);
if (ext == ".jpg" || ext == ".png")
{
FileUpload26.SaveAs(path + FileUpload26.FileName);
string name = "Images/" + FileUpload26.FileName;
string ss = "update slider set image2='" + name + "' where id=9";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
if (FileUpload27.HasFile)
{
string ext = Path.GetExtension(FileUpload27.FileName);
if (ext == ".jpg" || ext == ".png")
{
FileUpload27.SaveAs(path + FileUpload27.FileName);
string name = "Images/" + FileUpload27.FileName;
string ss = "update slider set image3='" + name + "' where id=9";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
//RENT BACHELOR FRIENDLY
if (FileUpload28.HasFile)
{
string ext = Path.GetExtension(FileUpload28.FileName);
if (ext == ".jpg" || ext == ".png")
{
FileUpload28.SaveAs(path + FileUpload28.FileName);
string name = "Images/" + FileUpload28.FileName;
string ss = "update slider set image1='" + name + "' where id=10";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
if (FileUpload29.HasFile)
{
string ext = Path.GetExtension(FileUpload29.FileName);
if (ext == ".jpg" || ext == ".png")
{
FileUpload29.SaveAs(path + FileUpload29.FileName);
string name = "Images/" + FileUpload29.FileName;
string ss = "update slider set image2='" + name + "' where id=10";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
if (FileUpload30.HasFile)
{
string ext = Path.GetExtension(FileUpload30.FileName);
if (ext == ".jpg" || ext == ".png")
{
FileUpload30.SaveAs(path + FileUpload30.FileName);
string name = "Images/" + FileUpload30.FileName;
string ss = "update slider set image3='" + name + "' where id=10";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
//RENT BUDGET DEAL
if (FileUpload31.HasFile)
{
string ext = Path.GetExtension(FileUpload31.FileName);
if (ext == ".jpg" || ext == ".png")
{
FileUpload31.SaveAs(path + FileUpload31.FileName);
string name = "Images/" + FileUpload31.FileName;
string ss = "update slider set image1='" + name + "' where id=11";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
if (FileUpload32.HasFile)
{
string ext = Path.GetExtension(FileUpload32.FileName);
if (ext == ".jpg" || ext == ".png")
{
FileUpload32.SaveAs(path + FileUpload32.FileName);
string name = "Images/" + FileUpload32.FileName;
string ss = "update slider set image2='" + name + "' where id=11";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
if (FileUpload33.HasFile)
{
string ext = Path.GetExtension(FileUpload33.FileName);
if (ext == ".jpg" || ext == ".png")
{
FileUpload33.SaveAs(path + FileUpload33.FileName);
string name = "Images/" + FileUpload33.FileName;
string ss = "update slider set image3='" + name + "' where id=11";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
//OFFICE SPACE
if (FileUpload34.HasFile)
{
string ext = Path.GetExtension(FileUpload34.FileName);
if (ext == ".jpg" || ext == ".png")
{
FileUpload34.SaveAs(path + FileUpload34.FileName);
string name = "Images/" + FileUpload34.FileName;
string ss = "update slider set image1='" + name + "' where id=11";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
if (FileUpload35.HasFile)
{
string ext = Path.GetExtension(FileUpload35.FileName);
if (ext == ".jpg" || ext == ".png")
{
FileUpload35.SaveAs(path + FileUpload35.FileName);
string name = "Images/" + FileUpload35.FileName;
string ss = "update slider set image2='" + name + "' where id=12";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
if (FileUpload36.HasFile)
{
string ext = Path.GetExtension(FileUpload36.FileName);
if (ext == ".jpg" || ext == ".png")
{
FileUpload36.SaveAs(path + FileUpload36.FileName);
string name = "Images/" + FileUpload36.FileName;
string ss = "update slider set image3='" + name + "' where id=12";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
//BHK FLAT
if (FileUpload37.HasFile)
{
string ext = Path.GetExtension(FileUpload37.FileName);
if (ext == ".jpg" || ext == ".png")
{
FileUpload37.SaveAs(path + FileUpload37.FileName);
string name = "Images/" + FileUpload37.FileName;
string ss = "update slider set image1='" + name + "' where id=13";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
if (FileUpload38.HasFile)
{
string ext = Path.GetExtension(FileUpload38.FileName);
if (ext == ".jpg" || ext == ".png")
{
FileUpload38.SaveAs(path + FileUpload38.FileName);
string name = "Images/" + FileUpload38.FileName;
string ss = "update slider set image2='" + name + "' where id=13";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
if (FileUpload39.HasFile)
{
string ext = Path.GetExtension(FileUpload39.FileName);
if (ext == ".jpg" || ext == ".png")
{
FileUpload39.SaveAs(path + FileUpload39.FileName);
string name = "Images/" + FileUpload39.FileName;
string ss = "update slider set image3='" + name + "' where id=13";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
count++;
Response.Redirect("adminpanel-slider.aspx");
}
else
{
a++;
Response.Redirect("adminpanel-slider.aspx");
}
}
catch (Exception)
{
Label2.Visible = true;
}
}