Ejemplo n.º 1
0
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        if (string.IsNullOrEmpty(lblId.Text))
        {
            if (cls.CheckExistField("CheckExistField", "PincodeChecker", "Pincode", txtpincode.Text, ""))
            {
                lblMsg.Text = "This Pincode already exists.";
                return;
            }
            else
            {
                cls.ExecuteDA("Insert_PincodeChecker", new SqlParameter("@City", txtCity.Text),
                              new SqlParameter("@Zone", drpZone.SelectedValue.ToString()),
                              new SqlParameter("@Pincode", txtpincode.Text),
                              new SqlParameter("@District", txtDistrict.Text),
                              new SqlParameter("@IsODA", drpoda.SelectedValue.ToString()),
                              new SqlParameter("@StateCode", txtStateCode.Text),
                              new SqlParameter("@IsActive", chkIsActive.Checked));

                clearall();
                lblMsg.Text = "Details inserted successfully.";
                BindPincodeChecker();
            }
        }
        else
        {
            if (cls.CheckExistField("CheckExistField", "PincodeChecker", "Pincode", txtpincode.Text, "and Id <> " + lblId.Text + ""))
            {
                lblMsg.Text = "This Pincode already exists.";
                return;
            }
            else
            {
                cls.ExecuteDA("Update_PincodeChecker", new SqlParameter("@Id", lblId.Text),
                              new SqlParameter("@City", txtCity.Text),
                              new SqlParameter("@Zone", drpZone.SelectedValue.ToString()),
                              new SqlParameter("@Pincode", txtpincode.Text),
                              new SqlParameter("@District", txtDistrict.Text),
                              new SqlParameter("@IsODA", drpoda.SelectedValue.ToString()),
                              new SqlParameter("@StateCode", txtStateCode.Text),
                              new SqlParameter("@IsActive", chkIsActive.Checked));

                clearall();
                lblMsg.Text = "Details Updated Successfully";
                BindPincodeChecker();
            }
        }
    }
Ejemplo n.º 2
0
 protected void CheckUserExists(string name, string email, string password)
 {
     //if exists then login using system
     if (cls.CheckExistField("CheckExistField", "Members", "Email", email, "and IsActive = 1"))
     {
         //get details from db
         DataTable dt = new DataTable();
         dt = cls.ReturnDataTable("Select_MemberDetailsFromEmail", new SqlParameter("@Email", email));
         if (dt.Rows.Count > 0)
         {
             Binduser1("L", dt.Rows[0]["Email"].ToString(), dt.Rows[0]["Password"].ToString());
         }
     }
     else
     {
         //does not exits then register to the system
         cls.ExecuteDA("Insert_Members", new SqlParameter("@Name", name),
                       new SqlParameter("@Email", email),
                       new SqlParameter("@Password", password),
                       new SqlParameter("@Company", ""),
                       new SqlParameter("@Contact", ""));
         //insert into DB
         //MailAdminRegistration1(name, email, password);
         //MailUserRegistration1(name, email, password);
         Binduser1("L", email, password);
     }
 }
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        if (string.IsNullOrEmpty(lblId.Text))
        {
            if (cls.CheckExistField("CheckExistField", "Supplier", "SupplierName", txtsuppliername.Text.Trim(), "and IsActive = 1"))
            {
                lblMsg.Text = "This Supplier already exists.";
                return;
            }
            else
            {
                cls.ExecuteDA("Insert_Supplier", new SqlParameter("@SupplierCode", txtSuppliercode.Text),
                              new SqlParameter("@SupplierName", txtsuppliername.Text),
                              new SqlParameter("@Address", txtsupplieradd.Text),
                              new SqlParameter("@ContactNo", txtcontactno.Text),
                              new SqlParameter("@Email", txtEmailId.Text),
                              new SqlParameter("@IsActive", 1));

                clearall();
                lblMsg.Text = "Details inserted successfully.";
                BindSupplier();
            }
        }
        else
        {
            if (cls.CheckExistField("CheckExistField", "Supplier", "SupplierName", txtsuppliername.Text.Trim(), "and Id<>" + lblId.Text + "  and IsActive = 1"))
            {
                lblMsg.Text = "This Supplier already exists.";
                return;
            }
            else
            {
                cls.ExecuteDA("Update_Supplier", new SqlParameter("@Id", lblId.Text),
                              new SqlParameter("@SupplierCode", txtSuppliercode.Text),
                              new SqlParameter("@SupplierName", txtsuppliername.Text),
                              new SqlParameter("@Address", txtsupplieradd.Text),
                              new SqlParameter("@ContactNo", txtcontactno.Text),
                              new SqlParameter("@Email", txtEmailId.Text),
                              new SqlParameter("@IsActive", 1));

                clearall();
                lblMsg.Text = "Details updated successfully.";
                BindSupplier();
            }
        }
    }
    protected void btnSubmit_OnClick(object sender, EventArgs e)
    {
        if (string.IsNullOrEmpty(lblId.Text))
        {
            if (cls.CheckExistField("CheckExistField", "CurrentOpenings", "Designation", txtDesignation.Text, "and IsActive = 1 "))
            {
                lblMsg.Text = "This designation already exists.";
                return;
            }
            else
            {
                cls.ExecuteDA("Insert_CurrentOpenings", new SqlParameter("@Designation", txtDesignation.Text),
                              new SqlParameter("@Position", txtPosition.Text),
                              new SqlParameter("@NoOfPosition", txtNoOfPosition.Text),
                              new SqlParameter("@Location", txtLocation.Text),
                              new SqlParameter("@DatePosted", DateTime.Now),
                              new SqlParameter("@Responsibilities", txtResponsiblities.Text),
                              new SqlParameter("@Requirements", txtRequirements.Text));

                lblMsg.Text = "Details inserted successfully.";
            }
        }
        else
        {
            if (cls.CheckExistField("CheckExistField", "CurrentOpenings", "Designation", txtDesignation.Text, "and IsActive = 1 and CurrentOpeningID != '" + lblId.Text + "'"))
            {
                lblMsg.Text = "This designation already exists.";
                return;
            }
            else
            {
                cls.ExecuteDA("Update_CurrentOpenings", new SqlParameter("@CurrentOpeningID", lblId.Text),
                              new SqlParameter("@Designation", txtDesignation.Text),
                              new SqlParameter("@Position", txtPosition.Text),
                              new SqlParameter("@NoOfPosition", txtNoOfPosition.Text),
                              new SqlParameter("@Location", txtLocation.Text),
                              new SqlParameter("@DatePosted", DateTime.Now),
                              new SqlParameter("@Responsibilities", txtResponsiblities.Text),
                              new SqlParameter("@Requirements", txtRequirements.Text));

                lblMsg.Text = "Details updated successfully.";
            }
        }
        BindCurrentOpenings();
        clearall();
    }
Ejemplo n.º 5
0
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        if (string.IsNullOrEmpty(lblId.Text))
        {
            if (cls.CheckExistField("CheckExistField", "ColourSetup", "ColourName", txtcolourname.Text, "and IsActive = 1"))
            {
                lblMsg.Text = "This ColourName already exists.";
                return;
            }
            else
            {
                cls.ExecuteDA("Insert_ColourSetup", new SqlParameter("@ColourName", txtcolourname.Text),
                              new SqlParameter("@ColourCode", txtcolourcode.Text),
                              new SqlParameter("@IsActive", 1));

                clearall();
                lblMsg.Text = "Details inserted successfully.";
                BindColourSetup();
            }
        }
        else
        {
            if (cls.CheckExistField("CheckExistField", "ColourSetup", "ColourName", txtcolourname.Text, "and ColourId <> " + lblId.Text + " and IsActive = 1"))
            {
                lblMsg.Text = "This ColourName already exists.";
                return;
            }
            else
            {
                cls.ExecuteDA("Update_ColourSetup", new SqlParameter("@ColourId", lblId.Text),
                              new SqlParameter("@ColourName", txtcolourname.Text),
                              new SqlParameter("@ColourCode", txtcolourcode.Text),
                              new SqlParameter("@IsActive", 1));

                clearall();
                lblMsg.Text = "Details updated successfully.";
                BindColourSetup();
            }
        }
    }
Ejemplo n.º 6
0
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        if (string.IsNullOrEmpty(lblId.Text))
        {
            if (cls.CheckExistField("CheckExistField", "Unit", "Unit", txtUnit.Text.Trim(), "and IsActive = 1"))
            {
                lblMsg.Text = "This Unit already exists.";
                return;
            }
            else
            {
                cls.ExecuteDA("Insert_Unit", new SqlParameter("@Unit", txtUnit.Text),
                              new SqlParameter("@IsActive", 1));

                clearall();
                lblMsg.Text = "Details inserted successfully.";
                BindUnit();
            }
        }
        else
        {
            if (cls.CheckExistField("CheckExistField", "Unit", "Unit", txtUnit.Text.Trim(), " and Id <> " + lblId.Text + " and IsActive = 1"))
            {
                lblMsg.Text = "This Unit already exists.";
                return;
            }
            else
            {
                cls.ExecuteDA("Update_Unit", new SqlParameter("@Id", lblId.Text),
                              new SqlParameter("@Unit", txtUnit.Text),
                              new SqlParameter("@IsActive", 1));

                clearall();
                lblMsg.Text = "Details updated successfully.";
                BindUnit();
            }
        }
    }
Ejemplo n.º 7
0
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        if (string.IsNullOrEmpty(lblId.Text))
        {
            if (clscon.CheckExistField("CheckExistField", "CourierMaster", "CourierName", txtCourierName.Text, "and IsActive = 1"))
            {
                lblMsg.Text = "This Courier Name  Already exists.";
                return;
            }
            else
            {
                clscon.ExecuteDA("Insert_CourierMaster", new SqlParameter("@CourierName", txtCourierName.Text),
                                 new SqlParameter("@Url", txtUrl.Text));

                lblMsg.Text = "Details inserted successfully.";
                BindData();
                clearall();
            }
        }
        else
        {
            if (clscon.CheckExistField("CheckExistField", "CourierMaster", "CourierName", txtCourierName.Text, "and IsActive = 1 and  ID <> '" + lblId.Text + "'"))
            {
                lblMsg.Text = "This Courier Name  Already exists.";
                return;
            }
            else
            {
                clscon.ExecuteDA("Update_CourierMaster", new SqlParameter("@ID", lblId.Text),
                                 new SqlParameter("@CourierName", txtCourierName.Text),
                                 new SqlParameter("@Url", txtUrl.Text));
                lblMsg.Text = "Details updated successfully.";
                BindData();
                clearall();
            }
        }
    }
Ejemplo n.º 8
0
 protected void btnSubmit_Click(object sender, EventArgs e)
 {
     if (string.IsNullOrEmpty(lblId.Text))
     {
         lblMsg.Text = "You cannot insert new category, please update the category name.";
     }
     else
     {
         if (cls.CheckExistField("CheckExistField", "ProductCategory", "CategoryName", txtCategoryName.Text, "and Id <> " + lblId.Text + " and IsActive = 1"))
         {
             lblMsg.Text = "This Category already exists.";
             return;
         }
         else
         {
             cls.ExecuteDA("Update_ProductCategory", new SqlParameter("@Id", lblId.Text),
                           new SqlParameter("@CategoryName", txtCategoryName.Text),
                           new SqlParameter("@IsActive", 1));
             clearall();
             lblMsg.Text = "Details updated successfully.";
             BindCategory();
         }
     }
 }
Ejemplo n.º 9
0
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        int    flag = 0;
        string crA  = "0";
        string crB  = "0";
        string crC  = "0";

        if (chkCriteriaA.Checked)
        {
            if (rbtCriteriaA.SelectedValue != "")
            {
                crA  = rbtCriteriaA.SelectedValue;
                flag = 1;
            }
            else
            {
                lblMsg.Text = "Choose Value in Criteria A";
                return;
            }
        }
        if (chkCriteriaB.Checked)
        {
            if (rbtCriteriaB.SelectedValue != "")
            {
                crB  = rbtCriteriaB.SelectedValue;
                flag = 1;
            }
            else
            {
                lblMsg.Text = "Choose Value in Criteria B";
                return;
            }
        }
        if (chkCriteriaC.Checked)
        {
            if (rbtCriteriaC.SelectedValue != "")
            {
                crC  = rbtCriteriaC.SelectedValue;
                flag = 1;
            }
            else
            {
                lblMsg.Text = "Choose Value in Criteria C";
                return;
            }
        }

        if (flag <= 0)
        {
            lblMsg.Text = "Choose Criteria";
            return;
        }
        else
        {
            if (string.IsNullOrEmpty(lblId.Text))
            {
                if (cls.CheckExistField("CheckExistField", "Coupon", "CouponName", txtCode.Text, "and IsActive = 1 "))
                {
                    lblMsg.Text = "This coupon code already exists.";
                    return;
                }
                else
                {
                    cls.ExecuteDA("Insert_Coupon", new SqlParameter("@CouponName", txtCode.Text),
                                  new SqlParameter("@CriteriaA", crA),
                                  new SqlParameter("@CriteriaB", crB),
                                  new SqlParameter("@CriteriaC", crC),
                                  new SqlParameter("@Discount", txtDiscount.Text),
                                  new SqlParameter("@InUse", chkIsActive.Checked));


                    lblMsg.Text = "Details inserted successfully.";
                }
            }
            else
            {
                if (cls.CheckExistField("CheckExistField", "Coupon", "CouponName", txtCode.Text, "and IsActive = 1 and Id != '" + lblId.Text + "'"))
                {
                    lblMsg.Text = "This coupon code already exists.";
                    return;
                }
                else
                {
                    cls.ExecuteDA("Update_Coupon", new SqlParameter("@Id", lblId.Text),
                                  new SqlParameter("@CouponName", txtCode.Text),
                                  new SqlParameter("@CriteriaA", crA),
                                  new SqlParameter("@CriteriaB", crB),
                                  new SqlParameter("@CriteriaC", crC),
                                  new SqlParameter("@Discount", txtDiscount.Text),
                                  new SqlParameter("@InUse", chkIsActive.Checked));


                    lblMsg.Text = "Details updated successfully.";
                }
            }
            BindData();
            clearall();
        }
    }
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        if (!IsSizeSet())
        {
            MsgBox("Please Select Size");
            return;
        }
        if (!IsColorSet())
        {
            MsgBox("Please Select Color");
            return;
        }

        string concat = Guid.NewGuid().ToString();
        string strDoc = "";

        if (fupPhoto.HasFile != false)
        {
            string ext = null;
            ext = Path.GetExtension(fupPhoto.PostedFile.FileName).ToLower();
            if ((ext != ".jpg") & (ext != ".jpeg") & (ext != ".gif") & (ext != ".png") & (ext != ".bmp"))
            {
                lblMsg.Text = "Please select jpg or gif or png or bmp  files only";
                fupPhoto.Focus();
                return;
            }

            //''''''Create an image object from the uploaded file
            System.Drawing.Image FrontImage = null;
            FrontImage = System.Drawing.Image.FromStream(fupPhoto.PostedFile.InputStream);
            ///'''''''''''Determine width and height of uploaded image
            double UploadedImageWidth  = FrontImage.PhysicalDimension.Width;
            double UploadedImageHeight = FrontImage.PhysicalDimension.Height;
            double isoscalar           = 0;
            double newWidth            = 0;
            double newHeight           = 0;

            isoscalar = Math.Min((356 / UploadedImageWidth), (500 / UploadedImageHeight));
            newWidth  = isoscalar * UploadedImageWidth;
            newHeight = isoscalar * UploadedImageHeight;


            int nwidth  = 0;
            int wheight = 0;
            nwidth  = Convert.ToInt32(newWidth);
            wheight = Convert.ToInt32(newHeight);

            int x = 0;
            int y = 0;
            x = (356 - nwidth) / 2;
            y = (500 - wheight) / 2;

            Bitmap newImage = default(Bitmap);
            newImage = new Bitmap(356, 500);
            newImage.SetResolution(72, 72);
            //web resolution;
            //create a graphics object
            Graphics gr = default(Graphics);
            gr = Graphics.FromImage(newImage);
            //just in case it's a transparent GIF force the bg to white
            SolidBrush sb = default(SolidBrush);
            sb = new SolidBrush(System.Drawing.Color.Transparent);
            //sb = New SolidBrush(System.Drawing.Color.Transparent)
            gr.FillRectangle(sb, 0, 0, newImage.Width, newImage.Height);
            //Re-draw the image to the specified height and width
            gr.DrawImage(FrontImage, x, y, nwidth, wheight);
            newImage.Save(Server.MapPath("../Product/") + concat + ext);
            strDoc = "Product/" + concat + ext;
        }
        else
        {
            if (lblId.Text != "")
            {
                strDoc = ViewState["img"].ToString();
            }
            else
            {
                lblMsg.Text = "Please Select Image";
                return;
            }
        }
        //checking isarrival or not
        bool isaarival;

        if (rbtNewArriaval.SelectedValue == "1")
        {
            isaarival = true;
        }
        else
        {
            isaarival = false;
        }
        //checking special offer or not
        bool isspecial;

        if (RbtSpecialOffer.SelectedValue == "1")
        {
            isspecial = true;
        }
        else
        {
            isspecial = false;
        }

        //checking ISCOD or not
        bool iscod;

        if (rbtCOD.SelectedValue == "1")
        {
            iscod = true;
        }
        else
        {
            iscod = false;
        }


        double mrp = 0;

        if (txtMRP.Text != "")
        {
            mrp = Convert.ToDouble(txtMRP.Text);
        }

        if (string.IsNullOrEmpty(lblId.Text))
        {
            if (cls.CheckExistField("CheckExistField", "Product", "ProductName", txtProductname.Text, "and IsActive = 1 and ProductCategoryID ='" + ddlCategory.SelectedValue + "' and ProductSubCategoryID ='" + ddlSubCategory.SelectedValue + "'"))
            {
                lblMsg.Text = "This product already exists.";
                return;
            }
            else
            {
                Int32 pid;
                pid = (Int32)cls.ReturnScaler("Insert_Product", new SqlParameter("@ProductCategoryId", Convert.ToInt32(ddlCategory.SelectedValue.ToString())),
                                              new SqlParameter("@ProductSubCategoryId", Convert.ToInt32(ddlSubCategory.SelectedValue.ToString())),
                                              new SqlParameter("@SupplierId", Convert.ToInt32(ddlsupplier.SelectedValue.ToString())),
                                              new SqlParameter("@BrandId", Convert.ToInt32(ddlBrand.SelectedValue.ToString())),
                                              new SqlParameter("@ProductName", txtProductname.Text),
                                              new SqlParameter("@Productdescp", txtProductline2.Text),
                                              new SqlParameter("@ProductCode", txtProductCode.Text),
                                              new SqlParameter("@SupplierProductCode", txtSupProductcode.Text),
                                              new SqlParameter("@PackSize", txtpacksize.Text),
                                              new SqlParameter("@ProductCost", Convert.ToDouble(txtProductcost.Text)),
                                              new SqlParameter("@UnitId", Convert.ToInt32(ddlUnit.SelectedValue.ToString())),
                                              new SqlParameter("@ProductWeight", Convert.ToDouble(txtProductweight.Text)),
                                              new SqlParameter("@Image", strDoc),
                                              new SqlParameter("@KeyWords", txtkeywords.Text),
                                              new SqlParameter("@Certification", txtCertification.Text),
                                              new SqlParameter("@Description", txtDescription.Text),
                                              new SqlParameter("@Margin", txtmargin.Text),
                                              new SqlParameter("@SalePrice", Convert.ToDouble(txtsalescost.Text)),
                                              new SqlParameter("@Tax", Convert.ToDouble(txttax.Text)),
                                              new SqlParameter("@SalesPrice_Incl", Convert.ToDouble(txtSalesPriceIncl.Text)),
                                              new SqlParameter("@MRP", mrp),
                                              new SqlParameter("@Discount", Convert.ToDouble(txtDiscount.Text)),
                                              new SqlParameter("@ShippingCost", Convert.ToDouble(txtshippingcost.Text)),
                                              new SqlParameter("@FinalSellingPrice", Convert.ToDouble(txtfinalcost.Text)),
                                              new SqlParameter("@TaxFinalPrice", Convert.ToDouble(txttaxfinalprice.Text)),
                                              new SqlParameter("@Quantity", Convert.ToDouble(txtMinOrdrQty.Text)),
                                              new SqlParameter("@ShippingDays", txtShippngDays.Text),
                                              new SqlParameter("@IsNewArrival", isaarival),
                                              new SqlParameter("@IsSpecialOffer", isspecial),
                                              new SqlParameter("@IsCOD", iscod),
                                              new SqlParameter("@IsActive", 1));

                //insert into product size and product Colour
                InsertProdSize(pid);
                InsertProdColour(pid);

                clearall();
                lblMsg.Text = "Details inserted successfully.";
                BindProduct();
            }
        }
        else
        {
            cls.ExecuteDA("Update_Product", new SqlParameter("@Id", Convert.ToInt32(lblId.Text)),
                          new SqlParameter("@ProductCategoryId", Convert.ToInt32(ddlCategory.SelectedValue.ToString())),
                          new SqlParameter("@ProductSubCategoryId", Convert.ToInt32(ddlSubCategory.SelectedValue.ToString())),
                          new SqlParameter("@SupplierId", Convert.ToInt32(ddlsupplier.SelectedValue.ToString())),
                          new SqlParameter("@BrandId", Convert.ToInt32(ddlBrand.SelectedValue.ToString())),
                          new SqlParameter("@ProductName", txtProductname.Text),
                          new SqlParameter("@Productdescp", "ABC"),
                          new SqlParameter("@ProductCode", txtProductCode.Text),
                          new SqlParameter("@SupplierProductCode", txtSupProductcode.Text),
                          new SqlParameter("@PackSize", txtpacksize.Text),
                          new SqlParameter("@ProductCost", Convert.ToDouble(txtProductcost.Text)),
                          new SqlParameter("@UnitId", Convert.ToInt32(ddlUnit.SelectedValue.ToString())),
                          new SqlParameter("@ProductWeight", Convert.ToDouble(txtProductweight.Text)),
                          new SqlParameter("@Image", strDoc),
                          new SqlParameter("@KeyWords", txtkeywords.Text),
                          new SqlParameter("@Certification", txtCertification.Text),
                          new SqlParameter("@Description", txtDescription.Text),
                          new SqlParameter("@Margin", txtmargin.Text),
                          new SqlParameter("@SalePrice", Convert.ToDouble(txtsalescost.Text)),
                          new SqlParameter("@Tax", Convert.ToDouble(txttax.Text)),
                          new SqlParameter("@SalesPrice_Incl", Convert.ToDouble(txtSalesPriceIncl.Text)),
                          new SqlParameter("@MRP", mrp),
                          new SqlParameter("@Discount", Convert.ToDouble(txtDiscount.Text)),
                          new SqlParameter("@ShippingCost", Convert.ToDouble(txtshippingcost.Text)),
                          new SqlParameter("@FinalSellingPrice", Convert.ToDouble(txtfinalcost.Text)),
                          new SqlParameter("@TaxFinalPrice", Convert.ToDouble(txttaxfinalprice.Text)),
                          new SqlParameter("@Quantity", Convert.ToDouble(txtMinOrdrQty.Text)),
                          new SqlParameter("@ShippingDays", txtShippngDays.Text),
                          new SqlParameter("@IsNewArrival", isaarival),
                          new SqlParameter("@IsSpecialOffer", isspecial),
                          new SqlParameter("@IsCOD", iscod),
                          new SqlParameter("@IsActive", 1));

            //Update Product Size nad product Colour
            cls.ExecuteDA("Delete_ProductColour", new SqlParameter("@ProductId", Convert.ToInt32(lblId.Text)));
            InsertProdColour(Convert.ToInt32(lblId.Text));

            cls.ExecuteDA("Delete_ProductSize", new SqlParameter("@ProductId", Convert.ToInt32(lblId.Text)));
            InsertProdSize(Convert.ToInt32(lblId.Text));

            lblMsg.Text = "Details updated successfully.";
            clearall();
            BindProduct();
        }
    }
Ejemplo n.º 11
0
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        string concat  = Guid.NewGuid().ToString();
        string strDoc  = "";
        string strDoc1 = "";

        if (fupPhoto.HasFile != false)
        {
            string ext = null;
            ext = Path.GetExtension(fupPhoto.PostedFile.FileName).ToLower();
            if ((ext != ".jpg") & (ext != ".jpeg") & (ext != ".gif") & (ext != ".png") & (ext != ".bmp"))
            {
                lblMsg.Text = "Please select jpg or gif or png or bmp  files only";
                fupPhoto.Focus();
                return;
            }

            //''''''Create an image object from the uploaded file
            System.Drawing.Image FrontImage = null;
            FrontImage = System.Drawing.Image.FromStream(fupPhoto.PostedFile.InputStream);
            ///'''''''''''Determine width and height of uploaded image
            double UploadedImageWidth  = FrontImage.PhysicalDimension.Width;
            double UploadedImageHeight = FrontImage.PhysicalDimension.Height;
            double isoscalar           = 0;
            double newWidth            = 0;
            double newHeight           = 0;

            isoscalar = Math.Min((356 / UploadedImageWidth), (500 / UploadedImageHeight));
            newWidth  = isoscalar * UploadedImageWidth;
            newHeight = isoscalar * UploadedImageHeight;

            int nwidth  = 0;
            int wheight = 0;
            nwidth  = Convert.ToInt32(newWidth);
            wheight = Convert.ToInt32(newHeight);

            int x = 0;
            int y = 0;
            x = (356 - nwidth) / 2;
            y = (500 - wheight) / 2;

            Bitmap newImage = default(Bitmap);
            newImage = new Bitmap(356, 500);
            newImage.SetResolution(72, 72);
            //web resolution;
            //create a graphics object
            Graphics gr = default(Graphics);
            gr = Graphics.FromImage(newImage);
            //just in case it's a transparent GIF force the bg to white
            SolidBrush sb = default(SolidBrush);
            sb = new SolidBrush(System.Drawing.Color.Transparent);
            //sb = New SolidBrush(System.Drawing.Color.Transparent)
            gr.FillRectangle(sb, 0, 0, newImage.Width, newImage.Height);
            //Re-draw the image to the specified height and width
            gr.DrawImage(FrontImage, x, y, nwidth, wheight);
            newImage.Save(Server.MapPath("../SubCategory/") + concat + ext);
            strDoc = "SubCategory/" + concat + ext;
        }
        else
        {
            if (lblId.Text != "")
            {
                strDoc = ViewState["img"].ToString();
            }
            else if (imgPhoto.ImageUrl != "")
            {
                // lblMsg.Text = "Please Select Image";
            }
            else
            {
                lblMsg.Text = "Please Select Image";
                return;
            }
        }

        if (fupBannerPhoto.HasFile != false)
        {
            string ext = null;
            ext = Path.GetExtension(fupBannerPhoto.PostedFile.FileName).ToLower();
            if ((ext != ".jpg") & (ext != ".jpeg") & (ext != ".gif") & (ext != ".png") & (ext != ".bmp"))
            {
                lblMsg.Text = "Please select jpg or gif or png or bmp  files only";
                fupBannerPhoto.Focus();
                return;
            }

            //''''''Create an image object from the uploaded file
            System.Drawing.Image FrontImage = null;
            FrontImage = System.Drawing.Image.FromStream(fupBannerPhoto.PostedFile.InputStream);
            ///'''''''''''Determine width and height of uploaded image
            double UploadedImageWidth  = FrontImage.PhysicalDimension.Width;
            double UploadedImageHeight = FrontImage.PhysicalDimension.Height;
            double isoscalar           = 0;
            double newWidth            = 0;
            double newHeight           = 0;

            isoscalar = Math.Min((1170 / UploadedImageWidth), (150 / UploadedImageHeight));
            newWidth  = isoscalar * UploadedImageWidth;
            newHeight = isoscalar * UploadedImageHeight;


            int nwidth  = 0;
            int wheight = 0;
            nwidth  = Convert.ToInt32(newWidth);
            wheight = Convert.ToInt32(newHeight);

            int x = 0;
            int y = 0;
            x = (1170 - nwidth) / 2;
            y = (150 - wheight) / 2;

            Bitmap newImage = default(Bitmap);
            newImage = new Bitmap(1170, 150);
            newImage.SetResolution(72, 72);
            //web resolution;
            //create a graphics object
            Graphics gr = default(Graphics);
            gr = Graphics.FromImage(newImage);
            //just in case it's a transparent GIF force the bg to white
            SolidBrush sb = default(SolidBrush);
            sb = new SolidBrush(System.Drawing.Color.Transparent);
            //sb = New SolidBrush(System.Drawing.Color.Transparent)
            gr.FillRectangle(sb, 0, 0, newImage.Width, newImage.Height);
            //Re-draw the image to the specified height and width
            gr.DrawImage(FrontImage, x, y, nwidth, wheight);
            newImage.Save(Server.MapPath("../SubCategoryBanner/") + concat + ext);
            strDoc1 = "SubCategoryBanner/" + concat + ext;
        }
        else
        {
            if (lblId.Text != "")
            {
                strDoc1 = ViewState["imgBanner"].ToString();
            }
            else if (imgBannerPhoto.ImageUrl != "")
            {
                // lblMsg.Text = "Please Select Image";
            }
            else
            {
                lblMsg.Text = "Please Select Banner Image";
                return;
            }
        }

        if (string.IsNullOrEmpty(lblId.Text))
        {
            if (cls.CheckExistField("CheckExistField", "ProductSubCategory", "SubCategoryName", txtSubCategoryName.Text, "and IsActive = 1 and ProductCategoryId='" + ddlCategory.SelectedValue + "'"))
            {
                lblMsg.Text = "This SubCategory Name already exists.";
                return;
            }
            else
            {
                cls.ExecuteDA("Insert_ProductSubCategory", new SqlParameter("@ProductCategoryId", ddlCategory.SelectedValue),
                              new SqlParameter("@SubCategoryName", txtSubCategoryName.Text),
                              new SqlParameter("@Image", strDoc),
                              new SqlParameter("@ImageBanner", strDoc1),
                              new SqlParameter("@IsActive", 1));

                clearall();
                lblMsg.Text = "Details inserted successfully.";
                BindProductSubCategory();
            }
        }
        else
        {
            if (cls.CheckExistField("CheckExistField", "ProductSubCategory", "SubCategoryName", txtSubCategoryName.Text, "and IsActive = 1 and ProductCategoryId='" + ddlCategory.SelectedValue + "' and Id <> " + lblId.Text + ""))
            {
                lblMsg.Text = "This SubCategory Name already exists.";
                return;
            }
            else
            {
                cls.ExecuteDA("Update_ProductSubCategory", new SqlParameter("@Id", lblId.Text),
                              new SqlParameter("@ProductCategoryId", ddlCategory.SelectedValue),
                              new SqlParameter("@SubCategoryName", txtSubCategoryName.Text),
                              new SqlParameter("@Image", strDoc),
                              new SqlParameter("@ImageBanner", strDoc1),
                              new SqlParameter("@IsActive", 1));

                //update in imagemap table
                cls.ExecuteDA("Update_ImageMapSubCategory", new SqlParameter("@Id", lblId.Text), new SqlParameter("@url", strDoc1));

                clearall();
                lblMsg.Text = "Details updated successfully.";
                BindProductSubCategory();
            }
        }
    }
    //Insert into DB functions
    protected string InsertIntoDB()
    {
        clsCart = new clsAddToCart();
        long orderid;

A:
        orderid = (long)cls.ReturnScaler("Select_MaxOrderID");

        if (cls.CheckExistField("CheckExistField", "InvoiceMaster", "OrderId", orderid.ToString(), " and IsActive=1"))
        {
            goto A;
        }

        long      Memberid = 0;
        DataTable dtMember = new DataTable();

        dtMember = (DataTable)Session["MemberInfo"];
        foreach (DataRow dr in dtMember.Rows)
        {
            Memberid = Convert.ToInt64(dr["MemberId"]);
        }

        bool IsPaid = false;
        bool IsCOD  = false;

        double discount      = 0;
        double discountValue = 0;

        if (Session["Discount"] != null)
        {
            discount      = (double)Session["Discount"];
            discountValue = (double)Session["DiscountValue"];
        }

        //Insert into invoice master
        Int32 invoiceid;

        invoiceid = (Int32)cls.ReturnScaler("Insert_InvoiceMasterForOnlinePay", new SqlParameter("MemberId", Memberid),
                                            new SqlParameter("@OrderId", orderid),
                                            new SqlParameter("@ShippingCharges", "0"),
                                            new SqlParameter("@OrderAmount", clsCart.TotalPrice()),
                                            new SqlParameter("@OrderQty", clsCart.TotalQty()),
                                            new SqlParameter("@PaypalId", ""),
                                            new SqlParameter("@IsPaid", IsPaid),
                                            new SqlParameter("@IsCOD", IsCOD),
                                            new SqlParameter("@PaymentMode", Session["PayMode"].ToString()),
                                            new SqlParameter("@DiscountPer", discount),
                                            new SqlParameter("@DiscountAmount", discountValue),
                                            new SqlParameter("@OriginalAmount", clsCart.TotalPriceWithoutDiscount()));


        //Insert into invoice coupon
        if (Session["CouponCode"] != null)
        {
            DataTable dtCoupon = new DataTable();
            dtCoupon = cls.ReturnDataTable("Select_CouponOnName", new SqlParameter("@CouponName", Session["CouponCode"].ToString()));

            if (dtCoupon.Rows.Count > 0)
            {
                cls.ExecuteDA("Insert_InvoiceCoupon", new SqlParameter("@InvoiceId", invoiceid),
                              new SqlParameter("@CouponName", dtCoupon.Rows[0]["CouponName"]),
                              new SqlParameter("@CriteriaAVal", dtCoupon.Rows[0]["CriteriaAVal"]),
                              new SqlParameter("@CriteriaBVal", dtCoupon.Rows[0]["CriteriaBVal"]),
                              new SqlParameter("@CriteriaCVal", dtCoupon.Rows[0]["CriteriaCVal"]));
            }
        }


        //insert into invoice product table

        DataTable dt = new DataTable();

        dt = clsCart.BindCart();
        foreach (DataRow dr in dt.Rows)
        {
            cls.ExecuteDA("Insert_InvoiceProduct", new SqlParameter("@InvoiceId", invoiceid),
                          new SqlParameter("@ProductId", Convert.ToInt32(dr["ProductId"])),
                          new SqlParameter("@CategoryName", dr["CategoryName"]),
                          new SqlParameter("@SubCategoryName", dr["SubCategoryName"]),
                          new SqlParameter("@ProductName", dr["ProductName"]),
                          new SqlParameter("@Productdescp", dr["Productdescp"]),
                          new SqlParameter("@BrandName", dr["BrandName"]),
                          new SqlParameter("@SupplierName", dr["SupplierName"]),
                          new SqlParameter("@Unit", dr["Unit"]),
                          new SqlParameter("@ColourName", dr["ColourName"]),
                          new SqlParameter("@SizeName", dr["SizeName"]),
                          new SqlParameter("@ProductCode", dr["ProductCode"]),
                          new SqlParameter("@SupplierProductCode", dr["SupplierProductCode"]),
                          new SqlParameter("@PackSize", dr["PackSize"]),
                          new SqlParameter("@ProductCost", dr["ProductCost"]),
                          new SqlParameter("@ProductWeight", dr["ProductWeight"]),
                          new SqlParameter("@Image", dr["Image"]),
                          new SqlParameter("@Certification", dr["Certification"]),
                          new SqlParameter("@Description", dr["Description"]),
                          new SqlParameter("@Margin", Convert.ToDouble(dr["Margin"])),
                          new SqlParameter("@SalePrice", Convert.ToDouble(dr["SalePrice"])),
                          new SqlParameter("@Tax", Convert.ToDouble(dr["Tax"])),
                          new SqlParameter("@SalesPrice_Incl", Convert.ToDouble(dr["SalesPrice_Incl"])),
                          new SqlParameter("@MRP", Convert.ToDouble(dr["MRP"])),
                          new SqlParameter("@Discount", Convert.ToDouble(dr["Discount"])),
                          new SqlParameter("@CalDiscount", Convert.ToDouble(dr["CalDiscount"])),
                          new SqlParameter("@ShippingCost", Convert.ToDouble(dr["ShippingCost"])),
                          new SqlParameter("@FinalSellingPrice", Convert.ToDouble(dr["FinalSellingPrice"])),
                          new SqlParameter("@TaxFinalPrice", Convert.ToDouble(dr["TaxFinalPrice"])),
                          new SqlParameter("@Quantity", Convert.ToDouble(dr["Qty"])),
                          new SqlParameter("@ShippingDays", dr["ShippingDays"]),
                          new SqlParameter("@IsCOD", Convert.ToBoolean(dr["IsCOD"])));
        }

        //inserting into billing and delivery details
        clsBSD = new BillingShippingDetails();
        DataTable dtbilship = new DataTable();

        dtbilship = clsBSD.BindBillShip();

        foreach (DataRow drow in dtbilship.Rows)
        {
            ViewState["ToMail"] = drow["SEmail"];
            cls.ExecuteDA("Insert_InvoiceBillingShipping", new SqlParameter("@InvoiceId", invoiceid),
                          new SqlParameter("@Name", drow["Name"]),
                          new SqlParameter("@Email", drow["Email"]),
                          new SqlParameter("@Company", drow["Company"]),
                          new SqlParameter("@Contact", drow["Contact"]),
                          new SqlParameter("@Address1", drow["Address1"]),
                          new SqlParameter("@Address2", drow["Address2"]),
                          new SqlParameter("@City", drow["City"]),
                          new SqlParameter("@State", drow["State"]),
                          new SqlParameter("@Country", drow["Country"]),
                          new SqlParameter("@Zipcode", drow["Zipcode"]),
                          new SqlParameter("@SName", drow["SName"]),
                          new SqlParameter("@SEmail", drow["SEmail"]),
                          new SqlParameter("@SCompany", drow["SCompany"]),
                          new SqlParameter("@SContact", drow["SContact"]),
                          new SqlParameter("@SAddress1", drow["SAddress1"]),
                          new SqlParameter("@SAddress2", drow["SAddress2"]),
                          new SqlParameter("@SCity", drow["SCity"]),
                          new SqlParameter("@SState", drow["SState"]),
                          new SqlParameter("@SCountry", drow["SCountry"]),
                          new SqlParameter("@SZipcode", drow["SZipcode"]));
        }

        //  Session["OrderId"] = orderid.ToString();
        //  lblOredrId.Text = orderid.ToString();
        setPdfandMail(invoiceid, orderid);
        return(orderid.ToString());
    }
 protected void btnSubmit_Click(object sender, EventArgs e)
 {
     if (string.IsNullOrEmpty(lblId.Text))
     {
         if (cls.CheckExistField("CheckExistField", "Members", "Email", txtEmail.Text.Trim(), "and IsActive = 1"))
         {
             lblMsg.Text = "This Member already exists.";
             return;
         }
         else
         {
             cls.ExecuteDA("Insert_Members", new SqlParameter("@Name", txtMemName.Text),
                           new SqlParameter("@Email", txtEmail.Text),
                           new SqlParameter("@Password", txtPassword.Text),
                           new SqlParameter("@Company", txtCompany.Text),
                           new SqlParameter("@Contact", txtContact.Text),
                           new SqlParameter("@Address1", txtAddress1.Text),
                           new SqlParameter("@Address2", txtAddress2.Text),
                           new SqlParameter("@City", txtCity.Text),
                           new SqlParameter("@State", txtState.Text),
                           new SqlParameter("@Country", txtCountry.Text),
                           new SqlParameter("@ZipCode", txtZipCode.Text),
                           new SqlParameter("@Tinno", txtTin.Text),
                           new SqlParameter("@Cstno", txtCst.Text),
                           new SqlParameter("@BCompany", txtCompany.Text),
                           new SqlParameter("@BContact", txtBContact.Text),
                           new SqlParameter("@BAddress1", txtBAddress1.Text),
                           new SqlParameter("@BAddress2", txtBAddress2.Text),
                           new SqlParameter("@BCity", txtBCity.Text),
                           new SqlParameter("@BState", txtBState.Text),
                           new SqlParameter("@BCountry", txtBCountry.Text),
                           new SqlParameter("@BZipCode", txtBZipCode.Text),
                           new SqlParameter("@IsApproved", chkIsActive.Checked));
             clearall();
             lblMsg.Text = "Details inserted successfully.";
             BindManageUser();
         }
     }
     else
     {
         if (cls.CheckExistField("CheckExistField", "Members", "Email", txtEmail.Text.Trim(), "and MemberId<>" + lblId.Text + "  and IsActive = 1"))
         {
             lblMsg.Text = "This Supplier already exists.";
             return;
         }
         else
         {
             cls.ExecuteDA("Update_ManageUser", new SqlParameter("@MemberId", lblId.Text),
                           new SqlParameter("@Name", txtMemName.Text),
                           new SqlParameter("@Email", txtEmail.Text),
                           new SqlParameter("@Password", txtPassword.Text),
                           new SqlParameter("@Company", txtCompany.Text),
                           new SqlParameter("@Contact", txtContact.Text),
                           new SqlParameter("@Address1", txtAddress1.Text),
                           new SqlParameter("@Address2", txtAddress2.Text),
                           new SqlParameter("@City", txtCity.Text),
                           new SqlParameter("@State", txtState.Text),
                           new SqlParameter("@Country", txtCountry.Text),
                           new SqlParameter("@ZipCode", txtZipCode.Text),
                           new SqlParameter("@Tinno", txtTin.Text),
                           new SqlParameter("@Cstno", txtCst.Text),
                           new SqlParameter("@BCompany", txtCompany.Text),
                           new SqlParameter("@BContact", txtBContact.Text),
                           new SqlParameter("@BAddress1", txtBAddress1.Text),
                           new SqlParameter("@BAddress2", txtBAddress2.Text),
                           new SqlParameter("@BCity", txtBCity.Text),
                           new SqlParameter("@BState", txtBState.Text),
                           new SqlParameter("@BCountry", txtBCountry.Text),
                           new SqlParameter("@BZipCode", txtBZipCode.Text),
                           new SqlParameter("@IsApproved", chkIsActive.Checked),
                           new SqlParameter("@Flag", "A"));
             clearall();
             lblMsg.Text = "Details updated successfully.";
             BindManageUser();
         }
     }
 }