Click here to Skip to main content
15,891,033 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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

C#
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;
            }
        }
Posted

1 solution

Not sure if I understand your question correctly, but instead of
C#
if (FileUpload1 != null && FileUpload1.HasFile)

try
C#
if (FileUpload1 != null && FileUpload1.HasFile
   && FileUpload2 != null && FileUpload2.HasFile
   && FileUpload3 != null && FileUpload3.HasFile
   && FileUpload4 != null && FileUpload4.HasFile
   && FileUpload5 != null && FileUpload5.HasFile)
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900