Example #1
0
        public void GetTableDetails()
        {
            BAVendor2 objBAVendor = new BAVendor2();
            DataTable dt          = new DataTable();

            dt = objBAVendor.BAGetTable();

            gd.DataSource = dt;
            gd.DataBind();
        }
Example #2
0
        protected void Button1_Click1(object sender, EventArgs e)
        {
            int validate = 0;

            VendorEntities objVendorDetails = new VendorEntities();

            try
            {
                //objVendorDetails.VendorId = Convert.ToInt32(VendorId.Text);
                objVendorDetails.CompanyName   = CompanyName.Text;
                objVendorDetails.VendorName    = VendorName.Text;
                objVendorDetails.MobileNo      = MobileNo.Text;
                objVendorDetails.Address       = Address.Text;
                objVendorDetails.EmailId       = EmailId.Text;
                objVendorDetails.VendorGSTNo   = VendorGSTNo.Text;
                objVendorDetails.BankAccountNo = BankAccountNo.Text;
                objVendorDetails.BankName      = BankName.Text;
                objVendorDetails.Branch        = Branch.Text;
                objVendorDetails.IFSCCode      = IFSCCode.Text;
                objVendorDetails.PanCard       = PanCard.Text;
                objVendorDetails.AadharCard    = AadharCard.Text;
            }
            catch (Exception ex)
            {
                ex.ToString();
            }


            //BAL
            BAVendor2 objVendorBA = new BAVendor2();

            validate = objVendorBA.BA_ValidateVendor(objVendorDetails);
            if (validate > 0)
            {
                Response.Write("<script> alert('Data already exist!')</script>");
            }
            else
            {
                int rValue = objVendorBA.BAaddVendorDetails(objVendorDetails);
                if (rValue > 0)
                {
                    Response.Write("<script>alert('success')</script>");
                }
                else
                {
                    Response.Write("<script>alert('Error')</script>");
                }
            }
        }
Example #3
0
        protected void gd_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            int VendorId = Convert.ToInt16(gd.DataKeys[e.RowIndex].Value);

            VendorEntities obj_BEVendor = new VendorEntities();

            obj_BEVendor.VendorId = VendorId;


            BAVendor2 obj_BAVendor = new BAVendor2();
            int       val          = obj_BAVendor.BA_EditVendor(obj_BEVendor);

            if (val > 0)
            {
                Response.Write("<script>alert('Vendor deleted successfully')</script>");
                GetTableDetails();
            }
            else
            {
                Response.Write("<script>alert('Error Occured')</script>");
            }
        }