Hello all
In the below code i am looking to check first if all fileuploads has file before process if statement, the below code is checking one FileUpload only. So can you help me with this case please
protected void EditAdsUpdateBtn_Click(object sender, EventArgs e)
{
SqlConnection EdCVCon = new SqlConnection(sc);
SqlCommand cmd = new SqlCommand();
var AdsNumL = EditAdsNumLbl.Text;
var UsrNme = Session["UsrNme"];
if (DropDownList3.SelectedValue == "no")
{
EditAdswrnglblsPanel.Visible = true;
editadsstutslbl.Text = "- Please select ads status";
}
else
{
}
if (DropDownList2.SelectedValue == "no")
{
EditAdswrnglblsPanel.Visible = true;
editadscondlbl.Text = "- Please select ads condition";
}
else
{
}
if (Session["UsrNme"] != null)
{
string makervalue = string.Empty;
string Yearvalue = string.Empty;
string Gearvalue = string.Empty;
string RoomNum = string.Empty;
string BathNum = string.Empty;
string garageNum = string.Empty;
string areasize = string.Empty;
// Set your values based on your selection
switch (EditAdsCatedrdoads.SelectedItem.Text)
{
case "Cars":
// Set your values
makervalue = EditAdsbarndcardrlst.SelectedValue;
Yearvalue = EditAdsCarYearfrmDrDw.SelectedValue;
Gearvalue = EditcarGearDDL.SelectedValue;
break;
case "Trucks":
// Set your values
makervalue = DropDownList15.SelectedValue;
Yearvalue = DropDownList17.SelectedValue;
Gearvalue = DropDownList16.SelectedValue;
break;
case "Tractor":
// Set your values
makervalue = EditAdsTracktorBrndDDL.SelectedValue;
Yearvalue = EditAdsTracktYearDDL.SelectedValue;
Gearvalue = EditAdsTracktorGEARDDL.SelectedValue;
break;
case "Airplane":
// Set your values
makervalue = EditAdsAirplaneDDL.SelectedValue;
Yearvalue = EditAdsPlanYearFrmDDL.SelectedValue;
// Should you be setting Gearvalue here?
break;
case "Apartment":
case "Villa":
case "Office":
// Set your values
RoomNum = EditAdsRomDDL.SelectedValue;
BathNum = DropDownList11.SelectedValue;
garageNum = DropDownList13.SelectedValue;
areasize = DropDownList14.SelectedValue;
break;
default:
// Consider throwing an error here, none of your options were selected
break;
}
if (FileUpload1 != null && FileUpload1.HasFile)
{
if (FileUpload1.PostedFile.ContentType.ToLower().StartsWith("image/"))
{
string sqlstatment = @"Update ads SET Section=@Section, Category=@Category, State=@State,
City=@City, AdsTit=@AdsTit, AdsDesc=@AdsDesc, AdsPrice=@AdsPrice, Wtags=@Wtags, Website=@Website, Address=@Address, Maker=@Maker, Year=@Year,
Gear=@Gear, Condition=@Condition, RoomNo=@RoomNo, Status=@Status, Space=@Space, Shower=@Shower, Garage=@Garage, Img1=@Img1, Img2=@Img2,
Img3=@Img3, Img4=@Img4, Img5=@Img5, Logo=@Logo Where UID=@UID AND AdsID=@AdsID";
cmd.Connection = EdCVCon;
cmd.CommandType = CommandType.Text;
cmd.CommandText = sqlstatment;
cmd.Parameters.AddWithValue("@UID", UsrNme);
cmd.Parameters.AddWithValue("@AdsID", AdsNumL);
cmd.Parameters.AddWithValue("@Section", editadsSecdrdoads.SelectedItem.Text);
cmd.Parameters.AddWithValue("@Category", EditAdsCatedrdoads.SelectedItem.Text);
cmd.Parameters.AddWithValue("@State", editstatedrdolst.SelectedItem.Text);
cmd.Parameters.AddWithValue("@City", editcitiesdrdolst.SelectedItem.Text);
cmd.Parameters.AddWithValue("@AdsTit", EditAdsTitTxtBox.Text);
cmd.Parameters.AddWithValue("@AdsDesc", EditAdsDescTxtBx.Text);
cmd.Parameters.AddWithValue("@AdsPrice", EditAdsPrisTxtBx.Text);
cmd.Parameters.AddWithValue("@Wtags", TextBox7.Text);
cmd.Parameters.AddWithValue("@Website", LinkdenTextBox.Text);
cmd.Parameters.AddWithValue("@Address", EditAdsAddrsTxtBox.Text);
cmd.Parameters.AddWithValue("@Maker", EditAdsbarndcardrlst.SelectedValue);
cmd.Parameters.AddWithValue("@Year", LNEditTxtBx.Text);
cmd.Parameters.AddWithValue("@Gear", EmailEditTxt.Text);
cmd.Parameters.AddWithValue("@Condition", DropDownList18.SelectedValue);
cmd.Parameters.AddWithValue("@RoomNo", DropDownList11.SelectedValue);
cmd.Parameters.AddWithValue("@Status", DropDownList19.SelectedValue);
cmd.Parameters.AddWithValue("@Space", DropDownList14.SelectedValue);
cmd.Parameters.AddWithValue("@Shower", LNEditTxtBx.Text);
cmd.Parameters.AddWithValue("@Garage", DropDownList13.SelectedValue);
cmd.Parameters.AddWithValue("@Condition", TeleEditTxtB.Text);
string imgnouser = "/images/general/nouser.jpg";
if (FileUpload1.HasFile)
{
cmd.Parameters.AddWithValue("@Img1", FileUpload1.FileName);
FileUpload1.SaveAs(Server.MapPath("~/images/AdsImgs/" + FileUpload1.FileName));
}
else
{
cmd.Parameters.AddWithValue("@Img1", imgnouser);
}
if (FileUpload1.HasFile)
{
cmd.Parameters.AddWithValue("@Img1", FileUpload1.FileName);
FileUpload1.SaveAs(Server.MapPath("~/images/AdsImgs/" + FileUpload1.FileName));
}
else
{
cmd.Parameters.AddWithValue("@Img1", imgnouser);
}
if (FileUpload2.HasFile)
{
cmd.Parameters.AddWithValue("@Img2", FileUpload2.FileName);
FileUpload2.SaveAs(Server.MapPath("~/images/AdsImgs/" + FileUpload2.FileName));
}
else
{
cmd.Parameters.AddWithValue("@Img2", imgnouser);
}
if (FileUpload3.HasFile)
{
cmd.Parameters.AddWithValue("@Img3", FileUpload3.FileName);
FileUpload3.SaveAs(Server.MapPath("~/images/AdsImgs/" + FileUpload3.FileName));
}
else
{
cmd.Parameters.AddWithValue("@Img3", imgnouser);
}
if (FileUpload4.HasFile)
{
cmd.Parameters.AddWithValue("@Img4", FileUpload4.FileName);
FileUpload4.SaveAs(Server.MapPath("~/images/AdsImgs/" + FileUpload4.FileName));
}
else
{
cmd.Parameters.AddWithValue("@Img4", imgnouser);
}
if (FileUpload5.HasFile)
{
cmd.Parameters.AddWithValue("@Img5", FileUpload5.FileName);
FileUpload5.SaveAs(Server.MapPath("~/images/AdsImgs/" + FileUpload5.FileName));
}
else
{
cmd.Parameters.AddWithValue("@Img5", imgnouser);
}
}
}
else
{
string sqlstatment = @"Update ads SET Section=@Section, Category=@Category, State=@State,
City=@City, AdsTit=@AdsTit, AdsDesc=@AdsDesc, AdsPrice=@AdsPrice, Wtags=@Wtags, Website=@Website, Address=@Address, Maker=@Maker, Year=@Year,
Gear=@Gear, Condition=@Condition, RoomNo=@RoomNo, Status=@Status, Space=@Space, Shower=@Shower, Garage=@Garage Where UID=@UID AND AdsID=@AdsID";
cmd.Connection = EdCVCon;
cmd.CommandType = CommandType.Text;
cmd.CommandText = sqlstatment;
cmd.Parameters.AddWithValue("@UID", UsrNme);
cmd.Parameters.AddWithValue("@AdsID", AdsNumL);
cmd.Parameters.AddWithValue("@Section", editadsSecdrdoads.SelectedItem.Text);
cmd.Parameters.AddWithValue("@Category", EditAdsCatedrdoads.SelectedItem.Text);
cmd.Parameters.AddWithValue("@State", editstatedrdolst.SelectedItem.Text);
cmd.Parameters.AddWithValue("@City", editcitiesdrdolst.SelectedItem.Text);
cmd.Parameters.AddWithValue("@AdsTit", EditAdsTitTxtBox.Text);
cmd.Parameters.AddWithValue("@AdsDesc", EditAdsDescTxtBx.Text);
cmd.Parameters.AddWithValue("@AdsPrice", EditAdsPrisTxtBx.Text);
cmd.Parameters.AddWithValue("@Wtags", TextBox7.Text);
cmd.Parameters.AddWithValue("@Website", LinkdenTextBox.Text);
cmd.Parameters.AddWithValue("@Address", EditAdsAddrsTxtBox.Text);
cmd.Parameters.AddWithValue("@Maker", EditAdsbarndcardrlst.SelectedValue);
cmd.Parameters.AddWithValue("@Year", LNEditTxtBx.Text);
cmd.Parameters.AddWithValue("@Gear", EmailEditTxt.Text);
cmd.Parameters.AddWithValue("@Condition", DropDownList18.SelectedValue);
cmd.Parameters.AddWithValue("@RoomNo", DropDownList11.SelectedValue);
cmd.Parameters.AddWithValue("@Status", DropDownList19.SelectedValue);
cmd.Parameters.AddWithValue("@Space", DropDownList14.SelectedValue);
cmd.Parameters.AddWithValue("@Shower", LNEditTxtBx.Text);
cmd.Parameters.AddWithValue("@Garage", DropDownList13.SelectedValue);
cmd.Parameters.AddWithValue("@Condition", TeleEditTxtB.Text);
}
EdCVCon.Open();
int result = cmd.ExecuteNonQuery();
if (result > 0)
{
// Updated successfully;
}
editCVPanel.Visible = false;
rebindUsrCV();
ShowCVPanel.Visible = true;
}
}