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!";
//}
}
}
