public void SaveData()
{
FileUpload1.SaveAs(Server.MapPath("~/Images/Poster/") + FileUpload1.FileName);
FileUpload2.SaveAs(Server.MapPath("~/Images/FeaturePhoto/") + FileUpload2.FileName);
FileUpload3.SaveAs(Server.MapPath("~/Images/FeaturePhoto/") + FileUpload3.FileName);
FileUpload4.SaveAs(Server.MapPath("~/Images/FeaturePhoto/") + FileUpload4.FileName);
FileUpload5.SaveAs(Server.MapPath("~/Images/FeaturePhoto/") + FileUpload5.FileName);
FileUpload6.SaveAs(Server.MapPath("~/Images/FeaturePhoto/") + FileUpload6.FileName);
string destiny = "~/Images/Poster/" + 10 + ".jpg";
File.Copy("~/Images/Poster/" + FileUpload1.FileName, destiny);
File.Delete("~/Images/Poster/" + FileUpload1.FileName);
int status = obj.InsertUser(txtMovieName.Text, txtCast.Text, txtPlot.Text, calReleaseDate.SelectedDate.ToString(), FileUpload1.FileName, FileUpload2.FileName, FileUpload3.FileName, FileUpload4.FileName, FileUpload5.FileName, FileUpload6.FileName, txtRoyal.Text, txtClassic.Text, txtExecutive.Text);
if (status == 1)
{
lblMsg.Text = "Movie Added successfully";
txtMovieName.Text = "";
txtCast.Text = "";
txtPlot.Text = "";
txtClassic.Text = "";
txtExecutive.Text = "";
txtRoyal.Text = "";
}
else
{
lblMsg.Text = "OOPS !!! Something went wrong....";
}
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
ToolTable TT = new ToolTable();
TT.Cat = Convert.ToInt32(DropDownList1.SelectedValue);
TT.ToolName = TextBox2.Text;
TT.ThumbPic = "~/Dashboard/ThumbnailPic/" + FileUpload1.FileName;
FileUpload1.SaveAs(Server.MapPath("~/Dashboard/ThumbnailPic/" + FileUpload1.FileName));
FileUpload2.SaveAs(Server.MapPath("~/Dashboard/ThumbnailPic/" + FileUpload2.FileName));
FileUpload3.SaveAs(Server.MapPath("~/Dashboard/ThumbnailPic/" + FileUpload3.FileName));
FileUpload4.SaveAs(Server.MapPath("~/Dashboard/ThumbnailPic/" + FileUpload4.FileName));
FileUpload5.SaveAs(Server.MapPath("~/Dashboard/ThumbnailPic/" + FileUpload5.FileName));
FileUpload6.SaveAs(Server.MapPath("~/Dashboard/ThumbnailPic/" + FileUpload5.FileName));
TT.Content1 = TextBox2.Text;
TT.Pic1 = "/Dashboard/ThumbnailPic/" + FileUpload2.FileName;
TT.Content2 = TextBox3.Text;
TT.Pic2 = "/Dashboard/ThumbnailPic/" + FileUpload3.FileName;
TT.Content3 = TextBox4.Text;
TT.Pic3 = "/Dashboard/ThumbnailPic/" + FileUpload4.FileName;
TT.Content4 = TextBox5.Text;
TT.Pic4 = "/Dashboard/ThumbnailPic/" + FileUpload5.FileName;
TT.MianContent = TextBox1.Text;
TT.SourceCode = "/Dashboard/SourceCode/" + FileUpload6.FileName;
dl.da.ToolTables.InsertOnSubmit(TT);
dl.da.SubmitChanges();
Response.Write("<script>alert('Success')</script>");
TextBox1.Text = TextBox2.Text = TextBox3.Text = TextBox4.Text = TextBox5.Text = "";
}
protected void btn第六張圖_Click(object sender, EventArgs e)
{
if (FileUpload6.HasFile)
{
string savePath = Server.MapPath(@"/./images/6.jpg");
FileUpload6.SaveAs(savePath);
lbl6.Visible = true;
lbl6.Text = "上傳成功";
}
}
protected void btnAddThumbnail_Click(object sender, EventArgs e)
{
int simbahanId = Convert.ToInt32(Request["id"]);
if (FileUpload6.PostedFile != null && FileUpload6.PostedFile.FileName != "")
{
var filename = FileUpload6.FileName.Split('.')[FileUpload6.FileName.Split('.').Length - 1];
FileUpload6.SaveAs(Server.MapPath("Images/Photos/Thumbnails/" + simbahanId + "." + filename));
}
}
private void UpLoadAndDisplay5()
{
string imgName = FileUpload6.FileName;
string imgPath = "/assets/image/" + "Question" + imgName;
int imgSize = FileUpload6.PostedFile.ContentLength;
if (FileUpload6.PostedFile != null && FileUpload6.PostedFile.FileName != "")
{
FileUpload6.SaveAs(Server.MapPath(imgPath));
Image6.ImageUrl = ".." + imgPath;
}
}
List <string> SaveImage(int gfid)
{
List <string> listurl = new List <string>();
string newName;
if (FileUpload1.FileName != "")
{
System.IO.FileInfo f = new System.IO.FileInfo(FileUpload1.FileName);
newName = "Girl" + gfid + "-" + Guid.NewGuid().ToString("N") + f.Extension;
FileUpload1.SaveAs(Server.MapPath("/") + "Content/Image/" + newName);
listurl.Add(newName);
}
if (FileUpload2.FileName != "")
{
System.IO.FileInfo f = new System.IO.FileInfo(FileUpload2.FileName);
newName = "Girl" + gfid + "-" + Guid.NewGuid().ToString("N") + f.Extension;
FileUpload2.SaveAs(Server.MapPath("/") + "Content/Image/" + newName);
listurl.Add(newName);
}
if (FileUpload3.FileName != "")
{
System.IO.FileInfo f = new System.IO.FileInfo(FileUpload3.FileName);
newName = "Girl" + gfid + "-" + Guid.NewGuid().ToString("N") + f.Extension;
FileUpload3.SaveAs(Server.MapPath("/") + "Content/Image/" + newName);
listurl.Add(newName);
}
if (FileUpload4.FileName != "")
{
System.IO.FileInfo f = new System.IO.FileInfo(FileUpload4.FileName);
newName = "Girl" + gfid + "-" + Guid.NewGuid().ToString("N") + f.Extension;
FileUpload4.SaveAs(Server.MapPath("/") + "Content/Image/" + newName);
listurl.Add(newName);
}
if (FileUpload5.FileName != "")
{
System.IO.FileInfo f = new System.IO.FileInfo(FileUpload5.FileName);
newName = "Girl" + gfid + "-" + Guid.NewGuid().ToString("N") + f.Extension;
FileUpload5.SaveAs(Server.MapPath("/") + "Content/Image/" + newName);
listurl.Add(newName);
}
if (FileUpload6.FileName != "")
{
System.IO.FileInfo f = new System.IO.FileInfo(FileUpload6.FileName);
newName = "Girl" + gfid + "-" + Guid.NewGuid().ToString("N") + f.Extension;
FileUpload6.SaveAs(Server.MapPath("/") + "Content/Image/" + newName);
listurl.Add(newName);
}
return(listurl);
}
protected void btnupload_Click(object sender, EventArgs e)
{
FileUpload2.SaveAs(Server.MapPath(img1));
Image1.ImageUrl = img1;
FileUpload3.SaveAs(Server.MapPath(img2));
Image2.ImageUrl = img2;
FileUpload4.SaveAs(Server.MapPath(img3));
Image3.ImageUrl = img3;
FileUpload5.SaveAs(Server.MapPath(img4));
Image4.ImageUrl = img4;
FileUpload6.SaveAs(Server.MapPath(img5));
Image5.ImageUrl = img5;
FileUpload7.SaveAs(Server.MapPath(img6));
Image6.ImageUrl = img6;
}
protected void Button7_Click(object sender, EventArgs e)
{
string strMsgSuccess = "Upload Success";
string strMsgSelect = "Please select your file";
if (FileUpload6.HasFile)
{
String strFileName = FileUpload6.FileName;
FileUpload6.SaveAs(Server.MapPath("lecture6/" + strFileName));
//Response.Write("<script> alert('Upload Success');<script>");
TextBox6.Text = strMsgSuccess;
}
else
{
//Response.Write("<script> alert('Pleases select your file');<script>");
TextBox6.Text = strMsgSelect;
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (conn.State == ConnectionState.Closed)
{
//dir location
var directoryInfo = new DirectoryInfo("C:\\Users\\yanyao\\Desktop\\IT\\img\\form\\");
if (directoryInfo.Exists)
{
directoryInfo.CreateSubdirectory(Session["Id"].ToString());
}
FileUpload6.SaveAs("C:\\Users\\yanyao\\Desktop\\IT\\img\\form\\" + Session["Id"].ToString() + "\\" + FileUpload6.FileName);
conn.Open();
string add = "INSERT INTO form (name,email,phone,role,location,problem,image,refID,status,date)values(@name,@email,@phone,@role,@location,@pro,@img,@ref,@status,@date)";
SqlCommand cmd = new SqlCommand(add, conn);
cmd.Parameters.AddWithValue("name", txtName.Text.Trim());
cmd.Parameters.AddWithValue("email", txtEmail.Text.Trim());
cmd.Parameters.AddWithValue("phone", txtPhone.Text.Trim());
cmd.Parameters.AddWithValue("role", ddlRole.Text);
cmd.Parameters.AddWithValue("location", ddlLocation.Text);
cmd.Parameters.AddWithValue("pro", txtProblem.Text);
cmd.Parameters.AddWithValue("img", "\\img\\form\\" + Session["Id"].ToString() + "\\" + FileUpload6.FileName);
cmd.Parameters.AddWithValue("ref", Convert.ToInt32(Session["Id"].ToString()));
cmd.Parameters.AddWithValue("status", "Pending");
cmd.Parameters.AddWithValue("date", DateTime.Now.ToString());
cmd.ExecuteNonQuery();
Response.Write("<script>alert('Submit Successfully!');location.href='monitor.aspx';</script>");
}
}
catch (Exception ex)
{
lblError.Text = "ERROR: " + ex.ToString();
lblError.ForeColor = System.Drawing.Color.Red;
}
}
void imageup()
{
if (FileUpload1.HasFile)
{
FileUpload1.SaveAs(Server.MapPath("/profilepics/") + FileUpload1.FileName);
image[1] = "~/profilepics/" + FileUpload1.FileName;
count++;
}
else
{
image[1] = "";
}
if (FileUpload2.HasFile)
{
FileUpload2.SaveAs(Server.MapPath("/profilepics/") + FileUpload2.FileName);
image[2] = "~/profilepics/" + FileUpload2.FileName;
count++;
}
else
{
image[2] = "";
}
if (FileUpload3.HasFile)
{
FileUpload3.SaveAs(Server.MapPath("/profilepics/") + FileUpload3.FileName);
image[3] = "~/profilepics/" + FileUpload3.FileName;
count++;
}
else
{
image[3] = "";
}
if (FileUpload4.HasFile)
{
FileUpload4.SaveAs(Server.MapPath("/profilepics/") + FileUpload4.FileName);
image[4] = "~/profilepics/" + FileUpload4.FileName;
count++;
}
else
{
image[4] = "";
}
if (FileUpload5.HasFile)
{
FileUpload5.SaveAs(Server.MapPath("/profilepics/") + FileUpload5.FileName);
image[5] = "~/profilepics/" + FileUpload5.FileName;
count++;
}
else
{
image[5] = "";
}
if (FileUpload6.HasFile)
{
FileUpload6.SaveAs(Server.MapPath("/profilepics/") + FileUpload6.FileName);
image[6] = "~/profilepics/" + FileUpload6.FileName;
count++;
}
else
{
image[6] = "";
}
if (FileUpload7.HasFile)
{
FileUpload7.SaveAs(Server.MapPath("/profilepics/") + FileUpload7.FileName);
image[7] = "~/profilepics/" + FileUpload7.FileName;
count++;
}
else
{
image[7] = "";
}
if (FileUpload8.HasFile)
{
FileUpload8.SaveAs(Server.MapPath("/profilepics/") + FileUpload8.FileName);
image[8] = "~/profilepics/" + FileUpload8.FileName;
count++;
}
else
{
image[8] = "";
}
if (FileUpload9.HasFile)
{
FileUpload9.SaveAs(Server.MapPath("/profilepics/") + FileUpload9.FileName);
image[9] = "~/profilepics/" + FileUpload9.FileName;
count++;
}
else
{
image[9] = "";
}
if (FileUpload10.HasFile)
{
FileUpload10.SaveAs(Server.MapPath("/profilepics/") + FileUpload10.FileName);
image[10] = "~/profilepics/" + FileUpload10.FileName;
count++;
}
else
{
image[10] = "";
}
}
protected void SaveInfo()
{
DateTime DateRange = new DateTime();
DateTime DateExpiration = new DateTime();
if (txtDateRange.Text != "")
{
DateRange = DateTime.ParseExact(txtDateRange.Text, "dd/MM/yyyy", null);
}
if (txtDateExpiration.Text != "")
{
DateExpiration = DateTime.ParseExact(txtDateExpiration.Text, "dd/MM/yyyy", null);
}
Cooperative_Info cop = new Cooperative_Info();
cop.Cooperative_Key = Convert.ToInt32(lbkey.Text);
cop.Cooperative_ID = txtCooperative_ID.Text;
cop.Cooperative_Name = txtCooperative_Name.Text;
cop.ProvincesCities_ID = ddProvincesCitiesID.SelectedValue;
cop.Address = txtAddress.Text;
cop.VietGAPCode = txtVietGAPCode.Text;
cop.Phone = txtPhone.Text;
cop.Members = Convert.ToInt32(txtMembers.Text);
cop.Area = Convert.ToInt32(txtArea.Text);
cop.Quantity = Convert.ToInt32(txtQuantity.Text);
cop.TreeType = txtTreeType.Text;
cop.DateRange = DateRange;
cop.DateExpiration = DateExpiration;
cop.Owner = txtOwner.Text;
cop.Description = txtDescription.Text;
cop.CertifiedOrganization = ddCertifiedOrganization.SelectedValue;
string[] arrListStr = txtlat.Text.Split(',');
cop.Lat = arrListStr[0];
cop.Lng = arrListStr[1];
cop.Images = ddImage.SelectedValue;
if (FileUploadControl.HasFile)
{
try
{
string filename = Path.GetFileName(FileUploadControl.FileName);
FileUploadControl.SaveAs(Server.MapPath("~/Img/Tree/") + filename);
cop.Images = filename;
}
catch (Exception ex) {}
}
cop.Save();
Cooperative_Image_Info cooImg = new Cooperative_Image_Info();
if (FileUpload1.HasFile)
{
try{
string Name = lbkey.Text + "_1";
Cooperative_Image_Info cooImgName = new Cooperative_Image_Info(Name);
cooImg.Cooperative_Image_Key = cooImgName.Cooperative_Image_Key;
cooImg.Name = Name;
cooImg.Cooperative_Key = Convert.ToInt32(lbkey.Text);
cooImg.DateTime = DateTime.Now;
cooImg.Description = txtCooperative_Name.Text;
string filename = lbkey.Text + "_img1.png";
FileUpload1.SaveAs(Server.MapPath("~/Img/coop/") + filename);
cooImg.Images = "../Img/coop/" + filename;
cooImg.Save();
}catch (Exception ex) { }
}
if (FileUpload2.HasFile)
{
try
{
string Name = lbkey.Text + "_2";
Cooperative_Image_Info cooImgName = new Cooperative_Image_Info(Name);
cooImg.Cooperative_Image_Key = cooImgName.Cooperative_Image_Key;
cooImg.Name = Name;
cooImg.Cooperative_Key = Convert.ToInt32(lbkey.Text);
cooImg.DateTime = DateTime.Now;
cooImg.Description = txtCooperative_Name.Text;
string filename = lbkey.Text + "_img2.png";
FileUpload2.SaveAs(Server.MapPath("~/Img/coop/") + filename);
cooImg.Images = "../Img/coop/" + filename;
cooImg.Save();
}
catch (Exception ex) { }
}
if (FileUpload3.HasFile)
{
try
{
string Name = lbkey.Text + "_3";
Cooperative_Image_Info cooImgName = new Cooperative_Image_Info(Name);
cooImg.Cooperative_Image_Key = cooImgName.Cooperative_Image_Key;
cooImg.Name = Name;
cooImg.Cooperative_Key = Convert.ToInt32(lbkey.Text);
cooImg.DateTime = DateTime.Now;
cooImg.Description = txtCooperative_Name.Text;
string filename = lbkey.Text + "_img3.png";
FileUpload3.SaveAs(Server.MapPath("~/Img/coop/") + filename);
cooImg.Images = "../Img/coop/" + filename;
cooImg.Save();
}
catch (Exception ex) { }
}
if (FileUpload4.HasFile)
{
try
{
string Name = lbkey.Text + "_4";
Cooperative_Image_Info cooImgName = new Cooperative_Image_Info(Name);
cooImg.Cooperative_Image_Key = cooImgName.Cooperative_Image_Key;
cooImg.Name = Name;
cooImg.Cooperative_Key = Convert.ToInt32(lbkey.Text);
cooImg.DateTime = DateTime.Now;
cooImg.Description = txtCooperative_Name.Text;
string filename = lbkey.Text + "_img4.png";
FileUpload4.SaveAs(Server.MapPath("~/Img/coop/") + filename);
cooImg.Images = "../Img/coop/" + filename;
cooImg.Save();
}
catch (Exception ex) { }
}
if (FileUpload5.HasFile)
{
try
{
string Name = lbkey.Text + "_5";
Cooperative_Image_Info cooImgName = new Cooperative_Image_Info(Name);
cooImg.Cooperative_Image_Key = cooImgName.Cooperative_Image_Key;
cooImg.Name = Name;
cooImg.Cooperative_Key = Convert.ToInt32(lbkey.Text);
cooImg.DateTime = DateTime.Now;
cooImg.Description = txtCooperative_Name.Text;
string filename = lbkey.Text + "_img5.png";
FileUpload5.SaveAs(Server.MapPath("~/Img/coop/") + filename);
cooImg.Images = "../Img/coop/" + filename;
cooImg.Save();
}
catch (Exception ex) { }
}
if (FileUpload6.HasFile)
{
try
{
string Name = lbkey.Text + "_6";
Cooperative_Image_Info cooImgName = new Cooperative_Image_Info(Name);
cooImg.Cooperative_Image_Key = cooImgName.Cooperative_Image_Key;
cooImg.Name = Name;
cooImg.Cooperative_Key = Convert.ToInt32(lbkey.Text);
cooImg.DateTime = DateTime.Now;
cooImg.Description = txtCooperative_Name.Text;
string filename = lbkey.Text + "_img6.png";
FileUpload6.SaveAs(Server.MapPath("~/Img/coop/") + filename);
cooImg.Images = "../Img/coop/" + filename;
cooImg.Save();
}
catch (Exception ex) { }
}
if (FileUpload7.HasFile)
{
try
{
string Name = lbkey.Text + "_7";
Cooperative_Image_Info cooImgName = new Cooperative_Image_Info(Name);
cooImg.Cooperative_Image_Key = cooImgName.Cooperative_Image_Key;
cooImg.Name = Name;
cooImg.Cooperative_Key = Convert.ToInt32(lbkey.Text);
cooImg.DateTime = DateTime.Now;
cooImg.Description = txtCooperative_Name.Text;
string filename = lbkey.Text + "_img7.png";
FileUpload7.SaveAs(Server.MapPath("~/Img/coop/") + filename);
cooImg.Images = "../Img/coop/" + filename;
cooImg.Save();
}
catch (Exception ex) { }
}
if (FileUpload8.HasFile)
{
try
{
string Name = lbkey.Text + "_8";
Cooperative_Image_Info cooImgName = new Cooperative_Image_Info(Name);
cooImg.Cooperative_Image_Key = cooImgName.Cooperative_Image_Key;
cooImg.Name = Name;
cooImg.Cooperative_Key = Convert.ToInt32(lbkey.Text);
cooImg.DateTime = DateTime.Now;
cooImg.Description = txtCooperative_Name.Text;
string filename = lbkey.Text + "_img8.png";
FileUpload8.SaveAs(Server.MapPath("~/Img/coop/") + filename);
cooImg.Images = "../Img/coop/" + filename;
cooImg.Save();
}
catch (Exception ex) { }
}
if (FileUpload9.HasFile)
{
try
{
string Name = lbkey.Text + "_9";
Cooperative_Image_Info cooImgName = new Cooperative_Image_Info(Name);
cooImg.Cooperative_Image_Key = cooImgName.Cooperative_Image_Key;
cooImg.Name = Name;
cooImg.Cooperative_Key = Convert.ToInt32(lbkey.Text);
cooImg.DateTime = DateTime.Now;
cooImg.Description = txtCooperative_Name.Text;
string filename = lbkey.Text + "_img9.png";
FileUpload9.SaveAs(Server.MapPath("~/Img/coop/") + filename);
cooImg.Images = "../Img/coop/" + filename;
cooImg.Save();
}
catch (Exception ex) { }
}
if (FileUpload10.HasFile)
{
try
{
string Name = lbkey.Text + "_10";
Cooperative_Image_Info cooImgName = new Cooperative_Image_Info(Name);
cooImg.Cooperative_Image_Key = cooImgName.Cooperative_Image_Key;
cooImg.Name = Name;
cooImg.Cooperative_Key = Convert.ToInt32(lbkey.Text);
cooImg.DateTime = DateTime.Now;
cooImg.Description = txtCooperative_Name.Text;
string filename = lbkey.Text + "_img10.png";
FileUpload10.SaveAs(Server.MapPath("~/Img/coop/") + filename);
cooImg.Images = "../Img/coop/" + filename;
cooImg.Save();
}
catch (Exception ex) { }
}
}
protected void btnEkle_Click(object sender, EventArgs e)
{
string rsm1, rsm2, rsm3, rsm4, rsm5, video1;
//Eğer FileUpload Tıklanmıssa ybai resim silmişse
if (FileUpload1.HasFile && FileUpload1.PostedFile.ContentType == "image/jpeg")
{
rsm1 = zaman + ".jpg";
}
else
{
rsm1 = ""; // file upload tıklanmamışsa boş bırakacak.
}
if (FileUpload2.HasFile && FileUpload2.PostedFile.ContentType == "image/jpeg")
{
rsm2 = zaman + "2.jpg";
}
else
{
rsm2 = "";
}
if (FileUpload3.HasFile && FileUpload3.PostedFile.ContentType == "image/jpeg")
{
rsm3 = zaman + "3.jpg";
}
else
{
rsm3 = "";
}
if (FileUpload4.HasFile && FileUpload4.PostedFile.ContentType == "image/jpeg")
{
rsm4 = zaman + "4.jpg";
}
else
{
rsm4 = "";
}
if (FileUpload5.HasFile && FileUpload5.PostedFile.ContentType == "image/jpeg")
{
rsm5 = zaman + "5.jpg";
}
else
{
rsm5 = "";
}
if (FileUpload6.HasFile && FileUpload6.PostedFile.ContentType == "video/x-ms-wsv")
{
video1 = zaman + ".wmv";
}
else
{
video1 = "";
}
//Kampanyanın işaretli olup olmadığının kontrolunu yaptık eğer tıklanmıssa kampanya ya 1 değerini verdirdik.
//Tıklanmıs değil ise 0 değerini verdirdik.
int kampanya;
if (CheckKampanya.Checked)
{
kampanya = 1;
}
else
{
kampanya = 0;
}
// Checkboxun tıklanıp tıklanmadıgının kontrolunu yaptık.
int yayinD;
if (CheckYayin.Checked)
{
yayinD = 1;
}
else
{
yayinD = 0;
}
// Girilecek olan ürünlerin veri tabanına kayıt işlemini yaptık.
et.Urunlers.InsertOnSubmit(new Urunler
{
AKID = int.Parse(DropDownList1.SelectedValue), ALTID = int.Parse(DropDownList4.SelectedValue),
MarkaID = int.Parse(DropDownList3.SelectedValue), UrunAD = txtUrunAD.Text, UrunDetay = FCKeditor1.Value,
UrunFiyat = Convert.ToDecimal(txtFiyat.Text), KDV = Convert.ToDecimal(txtKDV.Text),
Taksit = FCKeditor2.Value, EklenmeTarihi = Convert.ToDateTime(DateTime.Now),
Resim1 = rsm1, Resim2 = rsm2, Resim3 = rsm3, Resim4 = rsm4, Resim5 = rsm5, Video = video1, Kampanya = kampanya, YayinDurumu = yayinD
});
//Seçilmiş olan ürün resimlerini Urunler adında bir dosya açarak eklenme işlemini yaptık.
if (FileUpload1.HasFile)
{
FileUpload1.SaveAs(Server.MapPath("../Urunler/" + rsm1));
}
if (FileUpload2.HasFile)
{
FileUpload2.SaveAs(Server.MapPath("../Urunler/" + rsm2));
}
if (FileUpload3.HasFile)
{
FileUpload3.SaveAs(Server.MapPath("../Urunler/" + rsm3));
}
if (FileUpload4.HasFile)
{
FileUpload4.SaveAs(Server.MapPath("../Urunler/" + rsm4));
}
if (FileUpload5.HasFile)
{
FileUpload5.SaveAs(Server.MapPath("../Urunler/" + rsm5));
}
if (FileUpload6.HasFile)
{
FileUpload6.SaveAs(Server.MapPath("../Urunler/" + video1));
}
//veritabanında yapılan değişiklikleri kaydettik.
et.SubmitChanges();
// Response.Redirect("Yonetim.aspx?ad=urunler"); // Sayfımızı yeniledik.
Panel1.Visible = false;
Panel2.Visible = true;
}
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;
}
}
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)
{
string path = Server.MapPath("Images/");
//first
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 user_review set image='" + name + "', name='" + TextBox1.Text + "',city='" + TextBox2.Text + "',contentt='" + TextBox3.Text + "' where id=1";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
//second
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 user_review set image='" + name + "', name='" + TextBox4.Text + "',city='" + TextBox5.Text + "',contentt='" + TextBox6.Text + "' where id=2";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
//third
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 user_review set image='" + name + "', name='" + TextBox7.Text + "',city='" + TextBox8.Text + "',contentt='" + TextBox9.Text + "' where id=3";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
//forth
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 user_review set image='" + name + "', name='" + TextBox10.Text + "',city='" + TextBox11.Text + "',contentt='" + TextBox12.Text + "' where id=4";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
//fifth
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 user_review set image='" + name + "', name='" + TextBox13.Text + "',city='" + TextBox14.Text + "',contentt='" + TextBox15.Text + "' where id=5";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
//sixth
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 user_review set image='" + name + "', name='" + TextBox16.Text + "',city='" + TextBox17.Text + "',contentt='" + TextBox18.Text + "' where id=6";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
//first
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 user_review set image='" + name + "', name='" + TextBox19.Text + "',city='" + TextBox20.Text + "',contentt='" + TextBox21.Text + "' where id=7";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
//eighth
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 user_review set image='" + name + "', name='" + TextBox22.Text + "',city='" + TextBox23.Text + "',contentt='" + TextBox24.Text + "' where id=8";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
//nineth
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 user_review set image='" + name + "', name='" + TextBox25.Text + "',city='" + TextBox26.Text + "',contentt='" + TextBox27.Text + "' where id=9";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
//tenth
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 user_review set image='" + name + "', name='" + TextBox28.Text + "',city='" + TextBox29.Text + "',contentt='" + TextBox30.Text + "' where id=10";
con.Open();
cmd = new SqlCommand(ss, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
count++;
Response.Redirect("adminpanel-user-review.aspx");
}
else
{
a++;
Response.Redirect("adminpanel-user-review.aspx");
}
}
catch (Exception)
{
Label2.Visible = true;
}
}
protected void Button2_Click(object sender, EventArgs e)
{
try
{
bl.id = Convert.ToInt32(Request.QueryString["id"].ToString());
bl.comp_nm = txt_cmp.Text;
bl.address1 = txt_add1.Text;
bl.address2 = txt_add2.Text;
bl.state_id = Convert.ToInt32(dwd_st.SelectedValue.ToString());
bl.city_id = Convert.ToInt32(dwd_ct.SelectedValue.ToString());
bl.range = txt_range.Text;
bl.division = txt_division.Text;
bl.phone = txt_phn.Text;
// bl.vat_1 = dwd_vat.Text;
//bl.tax_4 = DropDownList1.Text;
// bl.ecc_p = dwd_exc.Text;
bl.openinig_date = txt_form.Text;
if (FileUpload7.HasFile)
{
string filename = Path.GetFileName(FileUpload7.FileName);
FileUpload7.SaveAs(Server.MapPath("~/img/") + txt_cmp.Text + "." + Path.GetExtension(FileUpload7.FileName));
filename = "img/" + txt_cmp.Text + "logo." + Path.GetExtension(FileUpload7.FileName);
bl.logo = filename;
}
else
{
bl.logo = dd_logo.NavigateUrl;
}
bl.vat = txt_vat.Text;
bl.vatdate = txt_dt.Text;
if (FileUpload1.HasFile)
{
string filename = Path.GetFileName(FileUpload1.FileName);
FileUpload1.SaveAs(Server.MapPath("~/img/") + txt_cmp.Text + "vat." + Path.GetExtension(FileUpload1.FileName));
filename = "img/" + txt_cmp.Text + "vat." + Path.GetExtension(FileUpload1.FileName);
bl.vatcrt = filename;
}
else
{
bl.vatcrt = dd_vat_crt.NavigateUrl;
}
bl.cst = txt_cst.Text;
bl.cst_date = txt_cstdt.Text;
if (FileUpload2.HasFile)
{
string filename = Path.GetFileName(FileUpload2.FileName);
FileUpload2.SaveAs(Server.MapPath("~/img/") + txt_cmp.Text + "cst." + Path.GetExtension(FileUpload2.FileName));
filename = "img/" + txt_cmp.Text + "cst." + Path.GetExtension(FileUpload2.FileName);
bl.cts = filename;
}
else
{
bl.cts = dd_cst_crt.NavigateUrl;
}
bl.exse = txt_exse.Text;
bl.exse_date = txt_exedt.Text;
if (FileUpload3.HasFile)
{
string filename = Path.GetFileName(FileUpload3.FileName);
FileUpload3.SaveAs(Server.MapPath("~/img/") + txt_cmp.Text + "ecc." + Path.GetExtension(FileUpload3.FileName));
filename = "img/" + txt_cmp.Text + "ecc." + Path.GetExtension(FileUpload3.FileName);
bl.exse_crt = filename;
}
else
{
bl.exse_crt = dd_exc_crt.NavigateUrl;
}
bl.st = txt_st.Text;
bl.stdate = txt_stdt.Text;
if (FileUpload4.HasFile)
{
string filename = Path.GetFileName(FileUpload4.FileName);
FileUpload4.SaveAs(Server.MapPath("~/img/") + txt_cmp.Text + "st." + Path.GetExtension(FileUpload4.FileName));
filename = "img/" + txt_cmp.Text + "st." + Path.GetExtension(FileUpload4.FileName);
bl.st_crt = filename;
}
else
{
bl.st_crt = dd_st_crt.NavigateUrl;
}
bl.tds = txt_tds.Text;
bl.tds_date = txt_tdsdt.Text;
if (FileUpload8.HasFile)
{
string filename = Path.GetFileName(FileUpload8.FileName);
FileUpload7.SaveAs(Server.MapPath("~/img/") + txt_cmp.Text + "." + Path.GetExtension(FileUpload8.FileName));
filename = "img/" + txt_cmp.Text + "tds." + Path.GetExtension(FileUpload8.FileName);
bl.tds_crt = filename;
}
else
{
bl.tds_crt = dd_tds_crt.NavigateUrl;
}
bl.cin = txt_cin.Text;
if (FileUpload5.HasFile)
{
string filename = Path.GetFileName(FileUpload5.FileName);
FileUpload5.SaveAs(Server.MapPath("~/img/") + txt_cmp.Text + "cin." + Path.GetExtension(FileUpload5.FileName));
filename = "img/" + txt_cmp.Text + "cin." + Path.GetExtension(FileUpload5.FileName);
bl.cincrt = filename;
}
else
{
bl.cincrt = dd_cin_crt.NavigateUrl;
}
bl.pan = txt_pan.Text;
if (FileUpload6.HasFile)
{
string filename = Path.GetFileName(FileUpload6.FileName);
FileUpload6.SaveAs(Server.MapPath("~/img/") + txt_cmp.Text + "pan." + Path.GetExtension(FileUpload6.FileName));
filename = "img/" + txt_cmp.Text + "pan." + Path.GetExtension(FileUpload6.FileName);
bl.pancrt = filename;
}
else
{
bl.pancrt = dd_pan_crt.NavigateUrl;
}
bl.website = txt_website.Text;
bl.email = txt_email.Text;
bl.mobile = txt_mobile.Text;
bl.pin_code = txt_pincd.Text;
bl.comissinrt = txt_comis_rt.Text;
bl.notfy = txt_not_under.Text;
dl.update_comapnymaster(bl);
ScriptManager.RegisterStartupScript(this, this.GetType(), "redirect", "alert('Comapany Master update successfully'); window.location='edit_cmp.aspx';", true);
}
catch
{
}
}
public void fileuploadMachine()
{
SqlConnection conn = new SqlConnection(constr);
try
{
if (FileUpload6.HasFile)
{
FileUpload6.Dispose();
string fileName = FileUpload5.ResolveClientUrl(FileUpload6.PostedFile.FileName);
DataTable datatble = new DataTable();
DataSet ds = new DataSet();
string file = FileUpload6.PostedFile.FileName;
string serverpath = Server.MapPath("~/uploads/" + file);
if (File.Exists(serverpath))
{
File.Delete(serverpath);
}
FileUpload6.SaveAs(Server.MapPath("~/uploads/" + file));
string filePath = Server.MapPath("~/uploads/" + file);
bool hasHeaders = false;
string HDR = hasHeaders ? "Yes" : "No";
// string HDR = "Yes";
string strConn;
if (filePath.Substring(filePath.LastIndexOf('.')).ToLower() == ".xlsx")
{
strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filePath + ";Extended Properties=\"Excel 12.0;HDR=" + HDR + ";IMEX=0\"";
}
else
{
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath + ";Extended Properties=\"Excel 8.0;HDR=" + HDR + ";IMEX=0\"";
}
OleDbConnection con = new OleDbConnection(strConn);
con.Open();
DataTable schemaTable = con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
DataRow schemaRow = schemaTable.Rows[0];
string sheet = schemaRow["TABLE_NAME"].ToString();
if (!sheet.EndsWith("_"))
{
string query = "SELECT * FROM [" + sheet + "]";
OleDbDataAdapter data = new OleDbDataAdapter(query, con);
data.Fill(datatble);
DataTable filteredRows = datatble.Rows.Cast <DataRow>()
.Where(row => !row.ItemArray.All(field => field is System.DBNull))
.CopyToDataTable();
ds.Tables.Add(filteredRows);
}
SqlDataAdapter daa1 = new SqlDataAdapter("Select * from Machine ", conn);
DataSet dss = new DataSet();
daa1.Fill(dss);
if (dss.Tables[0].Rows.Count > 0)
{
dss.Locale = System.Globalization.CultureInfo.InvariantCulture;
SqlCommand cmd1 = new SqlCommand("Truncate table Machine", conn);
SqlDataAdapter daa3 = new SqlDataAdapter(cmd1);
conn.Open();
cmd1.ExecuteNonQuery();
conn.Close();
}
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
string cell = Convert.ToString(ds.Tables[0].Rows[i]["Cell"].ToString());
string machine = Convert.ToString(ds.Tables[0].Rows[i]["Machine"].ToString());
ds.Locale = System.Globalization.CultureInfo.InvariantCulture;
SqlCommand cmd = new SqlCommand("insert into Machine(Cell,Machine)values ('" + cell + "','" + machine + "')", conn);
SqlDataAdapter daa = new SqlDataAdapter(cmd);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
con.Close();
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Machine File Uploaded Successfully !');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Invalid file !');", true);
}
finally
{
//conn.Close();
FileUpload6.Dispose();
}
}
