protected void btnProdUpdate_Click(object sender, EventArgs e) { bool hasTitle = false; bool validImage = false; lblErr2.Items.Clear(); if (txtTitle2.Text != null && txtTitle2.Text != "") { hasTitle = true; } else { lblErr2.Items.Add("there must be a title."); lblErr2.Visible = true; } if (chkbxImage.SelectedValue == "Use Existing Photo") { if (hasTitle == true) { string path = "~/Images/Products/" + ddlImages.SelectedValue; GoodEatsFarmDataContext db = new GoodEatsFarmDataContext(); db.uspProductUpdate(lblProdID.Text, txtTitle2.Text, txtPrice2.Text, txtDesc2.Text, path, Convert.ToInt32(ddlOrderIndex.SelectedValue)); plEditProduct.Visible = false; plUpdatProdSucc.Visible = true; } } if (chkbxImage.SelectedValue == "Upload New Photo") { if (FileUpload2.HasFile) { if (!Methods.isPictureFile(FileUpload2.FileName)) { validImage = false; lblErr2.Items.Add("Image file must be JPEG."); lblErr2.Visible = true; } else { validImage = true; } } else { validImage = true; } } if (hasTitle && validImage) { string fileName = FileUpload2.FileName; string tempFileName = fileName; string path = null; int somnum = 0; while (Methods.fileExists(Server.MapPath("~/Images/Products/"), tempFileName)) { tempFileName = "(" + somnum + ")" + fileName; somnum++; } try { GoodEatsFarmDataContext db = new GoodEatsFarmDataContext(); FileUpload2.PostedFile.SaveAs(Server.MapPath("~/Images/Products/") + tempFileName); path = "~/Images/Products/" + tempFileName; // If atleast a name, category, and file was given, and the file succesfully got saved. Upload all of it to the database. db.uspProductUpdate(lblProdID.Text, txtTitle2.Text, txtPrice2.Text, txtDesc2.Text, path, Convert.ToInt32(ddlOrderIndex.SelectedValue)); plEditProduct.Visible = false; plUpdatProdSucc.Visible = true; } catch (Exception ex) { lblErr2.Visible = true; lblErr2.Items.Add(ex.Message); } } }