protected void btnUpload_Click(object sender, EventArgs e) { if (FileImgSave.HasFile) { string filename = Path.GetFileName(FileImgSave.PostedFile.FileName); //if (uploadedImgNames.Contains(filename)) //{ // LblMsg.Text = "Sorry you cannot upload the same file!"; // LblMsg.ForeColor = Color.Red; //} //else //{ if (DataList1.Items.Count < 4) { FileImgSave.SaveAs(Server.MapPath("~/Img/" + filename)); threadImage = filename; imagesNames.Add(filename); show_data(); } else { LblMsgImg.Text = "Sorry you can only upload a maximum of 4 pictures!"; LblMsgImg.ForeColor = Color.Red; } //} } }
protected void Button5_Click(object sender, EventArgs e) { if (FileImgSave.HasFile) { SqlCommand sqlCmd = new SqlCommand(); string DBConnect = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString; SqlConnection myConn = new SqlConnection(DBConnect); string filename = Path.GetFileName(FileImgSave.PostedFile.FileName); if (Session["firstImage"].ToString() == "") { string sqlStmt = "UPDATE Threads SET threadImage1 = @paraThreadImage1 WHERE Id = @parathreadId"; sqlCmd = new SqlCommand(sqlStmt, myConn); sqlCmd.Parameters.AddWithValue("@paraThreadImage1", filename); sqlCmd.Parameters.AddWithValue("@parathreadId", HFthreadId.Value); FileImgSave.SaveAs(Server.MapPath("~/Img/" + filename)); myConn.Open(); sqlCmd.ExecuteNonQuery(); myConn.Close(); } else if (Session["secondImage"].ToString() == "") { string sqlStmt = "UPDATE Threads SET threadImage2 = @paraThreadImage2 WHERE Id = @parathreadId"; sqlCmd = new SqlCommand(sqlStmt, myConn); sqlCmd.Parameters.AddWithValue("@paraThreadImage2", filename); sqlCmd.Parameters.AddWithValue("@parathreadId", HFthreadId.Value); FileImgSave.SaveAs(Server.MapPath("~/Img/" + filename)); myConn.Open(); sqlCmd.ExecuteNonQuery(); myConn.Close(); } else if (Session["thirdImage"].ToString() == "") { string sqlStmt = "UPDATE Threads SET threadImage3 = @paraThreadImage3 WHERE Id = @parathreadId"; sqlCmd = new SqlCommand(sqlStmt, myConn); sqlCmd.Parameters.AddWithValue("@paraThreadImage3", filename); sqlCmd.Parameters.AddWithValue("@parathreadId", HFthreadId.Value); FileImgSave.SaveAs(Server.MapPath("~/Img/" + filename)); myConn.Open(); sqlCmd.ExecuteNonQuery(); myConn.Close(); } else if (Session["fourthImage"].ToString() == "") { string sqlStmt = "UPDATE Threads SET threadImage4 = @paraThreadImage4 WHERE Id = @parathreadId"; sqlCmd = new SqlCommand(sqlStmt, myConn); sqlCmd.Parameters.AddWithValue("@paraThreadImage4", filename); sqlCmd.Parameters.AddWithValue("@parathreadId", HFthreadId.Value); FileImgSave.SaveAs(Server.MapPath("~/Img/" + filename)); myConn.Open(); sqlCmd.ExecuteNonQuery(); myConn.Close(); } else { LblMsg.Text = "CCB KNN"; LblMsg.ForeColor = Color.Red; } //if (DataList1.Items.Count < 4) //{ // FileImgSave.SaveAs(Server.MapPath("~/Img/" + filename)); // threadImage = filename; // imagesNamesForEdit.Add(filename); // show_data(); //} //else //{ // LblMsg.Text = "sorry no more pictures for you bitch!"; //} } }