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;
switch (EditAdsCatedrdoads.SelectedItem.Text)
{
case "Cars":
makervalue = EditAdsbarndcardrlst.SelectedValue;
Yearvalue = EditAdsCarYearfrmDrDw.SelectedValue;
Gearvalue = EditcarGearDDL.SelectedValue;
break;
case "Trucks":
makervalue = DropDownList15.SelectedValue;
Yearvalue = DropDownList17.SelectedValue;
Gearvalue = DropDownList16.SelectedValue;
break;
case "Tractor":
makervalue = EditAdsTracktorBrndDDL.SelectedValue;
Yearvalue = EditAdsTracktYearDDL.SelectedValue;
Gearvalue = EditAdsTracktorGEARDDL.SelectedValue;
break;
case "Airplane":
makervalue = EditAdsAirplaneDDL.SelectedValue;
Yearvalue = EditAdsPlanYearFrmDDL.SelectedValue;
break;
case "Apartment":
case "Villa":
case "Office":
RoomNum = EditAdsRomDDL.SelectedValue;
BathNum = DropDownList11.SelectedValue;
garageNum = DropDownList13.SelectedValue;
areasize = DropDownList14.SelectedValue;
break;
default:
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)
{
}
editCVPanel.Visible = false;
rebindUsrCV();
ShowCVPanel.Visible = true;
}
}