public void BindVendorList()
        {
            try
            {
                using (EDMXConnectionString context = new EDMXConnectionString())
                {
                    var oficio = new SqlParameter
                    {
                        ParameterName = "LastDate",
                        Value         = DateTime.Now.ToString("yyyy-MM-dd")
                    };

                    var Details = "";// context.Database.SqlQuery<NewOpenVendorList_Result2>("exec NewOpenVendorList @LastDate", oficio).ToList<NewOpenVendorList_Result2>();

                    rpt.DataSource = Details;
                    rpt.DataBind();
                }
            }
            catch (Exception ex)
            {
                var message1 = new JavaScriptSerializer().Serialize(ex.Message.ToString());
                var script1  = string.Format("alert({0});", message1);
                ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script1, true);
            }
        }
示例#2
0
        public void GetOutput()
        {
            try
            {
                using (EDMXConnectionString context = new EDMXConnectionString())
                {
                    var oficio = new SqlParameter
                    {
                        ParameterName = "ProdBOMNo",
                        Value         = Convert.ToString(Request.QueryString["BOMNo"])
                    };
                    var Details = context.Database.SqlQuery <NAV_ProdcutionOrderBOMLine_Result>("exec NAV_ProdcutionOrderBOMLine @ProdBOMNo", oficio).ToList <NAV_ProdcutionOrderBOMLine_Result>();

                    //   IEnumerable<NAV_ProdcutionOrderBOMLine_Result> Details = context.Database.SqlQuery<NAV_ProdcutionOrderBOMLine_Result>("exec NAV_ProdcutionOrderBOMLine ").ToList();
                    rptOutput.DataSource = Details;
                    rptOutput.DataBind();
                }
            }
            catch (Exception ex)
            {
                var message1 = new JavaScriptSerializer().Serialize(ex.Message.ToString());
                var script1  = string.Format("alert({0});", message1);
                ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script1, true);
            }
        }
 public void BindVendorList()
 {
     using (EDMXConnectionString context = new EDMXConnectionString())
     {
         IEnumerable <NAVVendorList_Result> Details = context.Database.SqlQuery
                                                      <NAVVendorList_Result>("exec NAVVendorList ").ToList();
         rpt.DataSource = Details;
         rpt.DataBind();
     }
 }
        protected void btnapprv_Click(object sender, EventArgs e)
        {
            try
            {
                if (hf1.Value == "1" && hf2.Value == "1" && hf3.Value == "1" && hf4.Value == "1" && hf5.Value == "1")
                {
                    int venid = Convert.ToInt32(venrID);
                    using (var context = new EDMXConnectionString())
                    {
                        var v = context.VendorRegistrations.SingleOrDefault(a => a.ID == venid);
                        if (v != null)
                        {
                            v.ApprovedVendor = true;
                            context.SaveChanges();
                        }
                    }
                    NetworkCredential NetCredential = new NetworkCredential();
                    NetCredential.UserName = SessionManager.GetNAVUserName(HttpContext.Current);
                    NetCredential.Password = SessionManager.GetNAVUserPassword(HttpContext.Current);

                    WS_NAV_Vendor_Service objservend = new WS_NAV_Vendor_Service();
                    objservend.UseDefaultCredentials = true;
                    objservend.Credentials           = NetCredential;
                    List <WS_NAV_Vendor_Filter> WList  = new List <WS_NAV_Vendor_Filter>();
                    WS_NAV_Vendor_Filter        wField = new WS_NAV_Vendor_Filter();
                    WList.Add(new WS_NAV_Vendor_Filter()
                    {
                        Field = WS_NAV_Vendor_Fields.No, Criteria = venrcode
                    });
                    WS_NAV_Vendor[] vendList = objservend.ReadMultiple(WList.ToArray(), null, 1);
                    if (vendList.Length > 0)
                    {
                        WS_NAV_Vendor vendnew = new WS_NAV_Vendor();
                        string        key     = vendList[0].Key;
                        string        recid   = objservend.GetRecIdFromKey(key);
                        vendnew         = objservend.ReadByRecId(recid);
                        vendnew.Blocked = 0;
                        objservend.Update(ref vendnew);
                    }
                    var message1 = new JavaScriptSerializer().Serialize(venrcode + " has been Approved.!!!");
                    var script1  = string.Format("alert({0});window.location='RegisteredVendorList.aspx';", message1);
                    ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script1, true);
                }
                else
                {
                    ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", "alert('Please check all detailed information!!!');", true);
                }
            }
            catch (Exception ex)
            {
                var message1 = new JavaScriptSerializer().Serialize(ex.Message.ToString());
                var script1  = string.Format("alert({0});", message1);
                ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script1, true);
            }
        }
        public void GetStateoffice()
        {
            using (EDMXConnectionString context = new EDMXConnectionString())
            {
                IEnumerable <GetState_Result> Details = context.Database.SqlQuery
                                                        <GetState_Result>("exec GetState ").ToList();

                drpStateOffice.DataValueField = "Code";
                drpStateOffice.DataTextField  = "Description";
                drpStateOffice.DataSource     = Details;
                drpStateOffice.DataBind();
            }
        }
        public void GetPaymenttemrs()
        {
            using (EDMXConnectionString context = new EDMXConnectionString())
            {
                IEnumerable <GetPaymentTerms_Result> Details = context.Database.SqlQuery
                                                               <GetPaymentTerms_Result>("exec GetPaymentTerms ").ToList();

                drp_PaymentTerm.DataValueField = "Code";
                drp_PaymentTerm.DataTextField  = "Description";
                drp_PaymentTerm.DataSource     = Details;
                drp_PaymentTerm.DataBind();
            }
        }
        public void VendorPostingGroup()
        {
            using (EDMXConnectionString context = new EDMXConnectionString())
            {
                IEnumerable <NAV_VendorPostingGroup_Result> Details = context.Database.SqlQuery
                                                                      <NAV_VendorPostingGroup_Result>("exec NAV_VendorPostingGroup").ToList();

                drpVendorPostingGroup.DataValueField = "Code";
                drpVendorPostingGroup.DataTextField  = "Code";
                drpVendorPostingGroup.DataSource     = Details;
                drpVendorPostingGroup.DataBind();
            }
            drpVendorPostingGroup.Items.Insert(0, new ListItem("-Select-", "0"));
        }
        public void ShipmentMethod()
        {
            using (EDMXConnectionString context = new EDMXConnectionString())
            {
                IEnumerable <NAV_ShipmentMethod_Result> Details = context.Database.SqlQuery
                                                                  <NAV_ShipmentMethod_Result>("exec NAV_ShipmentMethod ").ToList();

                drpShipmentTerm.DataValueField = "Code";
                drpShipmentTerm.DataTextField  = "Description";
                drpShipmentTerm.DataSource     = Details;
                drpShipmentTerm.DataBind();
            }
            drpShipmentTerm.Items.Insert(0, new ListItem("-Select-", "0"));
        }
        public void AuthorisedUser()
        {
            using (EDMXConnectionString context = new EDMXConnectionString())
            {
                IEnumerable <NAV_AuthorisedBy_Result> Details = context.Database.SqlQuery
                                                                <NAV_AuthorisedBy_Result>("exec NAV_AuthorisedBy ").ToList();

                drpAuthorisedby.DataValueField = "Code";
                drpAuthorisedby.DataTextField  = "Name";
                drpAuthorisedby.DataSource     = Details;
                drpAuthorisedby.DataBind();
            }
            drpAuthorisedby.Items.Insert(0, new ListItem("-Select-", "0"));
        }
        public void GetYearList3()
        {
            using (EDMXConnectionString context = new EDMXConnectionString())
            {
                IEnumerable <GetYearList_Result> Details = context.Database.SqlQuery
                                                           <GetYearList_Result>("exec GetYearList").ToList();

                drpYear3.DataValueField = "YearNo";
                drpYear3.DataTextField  = "YearNo";
                drpYear3.DataSource     = Details;
                drpYear3.DataBind();
            }
            drpYear3.Items.Insert(0, new ListItem("-Select-", "0"));
        }
        public void BindVendorNoSeries()
        {
            using (EDMXConnectionString context = new EDMXConnectionString())
            {
                IEnumerable <Vendor_NoSeries_Result3> empDetails = context.Database.SqlQuery
                                                                   <Vendor_NoSeries_Result3>("exec Vendor_NoSeries ").ToList();

                VendorNoSeries.DataValueField = "Series_Code";
                VendorNoSeries.DataTextField  = "Description";
                VendorNoSeries.DataSource     = empDetails;
                VendorNoSeries.DataBind();
            }
            VendorNoSeries.Items.Insert(0, new ListItem("-Select-", "0"));
        }
        public void GetPinCodeoffice()
        {
            using (EDMXConnectionString context = new EDMXConnectionString())
            {
                IEnumerable <GetCity_Result> Details = context.Database.SqlQuery
                                                       <GetCity_Result>("exec NAV_PINCode ").ToList();

                drpPinCode.DataValueField = "Code";
                drpPinCode.DataTextField  = "Code";
                drpPinCode.DataSource     = Details;
                drpPinCode.DataBind();
            }
            drpPinCode.Items.Insert(0, new ListItem("-Select-", "0"));
        }
示例#13
0
        public void BindDashboardMenu()
        {
            using (EDMXConnectionString context = new EDMXConnectionString())
            {
                var oficio = new SqlParameter
                {
                    ParameterName = "UserTypeID",
                    Value         = SessionManager.GetTypeOfUser(HttpContext.Current)
                };

                var Details = context.Database.SqlQuery <DashboardDynamicMenu_Result>("exec DashboardDynamicMenu @UserTypeID", oficio).ToList <DashboardDynamicMenu_Result>();
                //var Details = context.Database.SqlQuery<DashboardDynamicMenu_Result>("exec DashboardDynamicMenu @UserTypeID ", UserTypeID).ToList<DashboardDynamicMenu_Result>();
                rpt_Dashboard.DataSource = Details;
                rpt_Dashboard.DataBind();
            }
        }
 public void GetConsumption()
 {
     try
     {
         using (EDMXConnectionString context = new EDMXConnectionString())
         {
             IEnumerable <GetConsuptionDim_Result> Details = context.Database.SqlQuery <GetConsuptionDim_Result>("exec GetConsuptionDim ").ToList();
             gvCons.DataSource = Details;
             gvCons.DataBind();
         }
     }
     catch (Exception ex)
     {
         var message1 = new JavaScriptSerializer().Serialize(ex.Message.ToString());
         var script1  = string.Format("alert({0});", message1);
         ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script1, true);
     }
 }
        public void BindProductionOrerList()
        {
            using (EDMXConnectionString context = new EDMXConnectionString())
            {
                var oficio = new SqlParameter
                {
                    ParameterName = "UserId",
                    Value         = Convert.ToString(Session["NavUserName"])
                };
                //IEnumerable<NAV_ProductionOrder_Result> Details = context.Database.SqlQuery<NAV_ProductionOrder_Result>("exec NAV_ProductionOrder ").ToList();
                //rpt.DataSource = Details;
                //rpt.DataBind();

                var Details = context.Database.SqlQuery <NAV_ProductionOrder_Result>("exec NAV_ProductionOrder @UserId", oficio).ToList <NAV_ProductionOrder_Result>();
                rpt.DataSource = Details;
                rpt.DataBind();
            }
        }
        public void GetElectricityItems()
        {
            try
            {
                using (EDMXConnectionString context = new EDMXConnectionString())
                {
                    IEnumerable <NAV_ElectricityItems_Result> Details = context.Database.SqlQuery <NAV_ElectricityItems_Result>("exec NAV_ElectricityItems ").ToList();

                    drpItem.DataValueField = "Item";
                    drpItem.DataTextField  = "Description";
                    drpItem.DataSource     = Details;
                    drpItem.DataBind();
                }
            }
            catch (Exception ex)
            {
                var message1 = new JavaScriptSerializer().Serialize(ex.Message.ToString());
                var script1  = string.Format("alert({0});", message1);
                ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script1, true);
            }
        }
        public void GetFullRecord(string Vendorcode, string vendorid)
        {
            int venid = Convert.ToInt32(vendorid);

            using (var context = new EDMXConnectionString())
            {
                VendorRegistration v = new VendorRegistration();// make object of table
                v = context.VendorRegistrations.First(a => a.VendorCode == Vendorcode && a.ID == venid);
                //General Details TAB Fill
                if (v.VendorName_HO != "" && v.VendorName_HO != null)
                {
                    txtNameOffice.Text = v.VendorName_HO;
                }
                if (v.SourceRef == 1)
                {
                    chk_Self.Checked = true;
                }
                if (v.SourceRef == 2)
                {
                    txtInquiry.Text           = v.SourceRefInquiryBy;
                    chk_InquiryByJCIL.Checked = true;
                }
                if (v.SourceRef == 3)
                {
                    txtExtrnCnct.Text = v.SourceRefExternalContNo;
                    chk_AnRef.Checked = true;
                    txtExtrnName.Text = v.SourceRefExternal;
                    txtExtrnOrg.Text  = v.SourceRefExternalOrgName;
                }

                chk_Manufac.Checked         = v.TypeofBusi == 1 ? true : false;
                chk_AgentDT.Checked         = v.TypeofBusi == 2 ? true : false;
                chk_Stockist.Checked        = v.TypeofBusi == 3 ? true : false;
                chk_ServiceProvider.Checked = v.TypeofBusi == 4 ? true : false;
                chk_Supply.Checked          = v.TypeofBusi == 5 ? true : false;

                chk_Public.Checked = v.Title == 1 ? true : false;
                chk_Part.Checked   = v.Title == 2 ? true : false;
                chk_Prop.Checked   = v.Title == 3 ? true : false;
                chk_LLP.Checked    = v.Title == 4 ? true : false;

                //if (!string.IsNullOrEmpty(v.PremisesNo_HO))
                //{
                //    txtPremiseOffice.Text = v.PremisesNo_HO;
                //}
                if (v.Address_1_HO != "" && v.Address_1_HO != null)
                {
                    txtLine1Office.Text = v.Address_1_HO;
                }
                if (v.Address_2_HO != "" && v.Address_2_HO != null)
                {
                    txtLine2Office.Text = v.Address_2_HO;
                }
                //if (!string.IsNullOrEmpty(v.City_HO))
                //{
                //    drpCityOffice.SelectedItem.Text = v.City_HO;
                //}
                if (!string.IsNullOrEmpty(v.StateRegion_HO))
                {
                    drpStateOffice.SelectedItem.Text = v.StateRegion_HO;
                }
                if (v.PinCode_HO != null)
                {
                    drpPinCode.SelectedValue = v.PinCode_HO.ToString();
                }
                if (v.Country_HO != null)
                {
                    drpCountryOffice.SelectedValue = v.Country_HO.ToString();
                }

                //ADDRESS OF WORKSHOP* Filled from DB
                //if (!string.IsNullOrEmpty(v.VendorName_WS))
                //{
                //    txtNameWorkshop.Text = v.VendorName_WS;
                //}
                //if (!string.IsNullOrEmpty(v.PremisesNo_WS))
                //{
                //    txtPremiseWorkshop.Text = v.PremisesNo_WS;
                //}
                //if (!string.IsNullOrEmpty(v.Address_1_WS))
                //{
                //    txtLine1Workshop.Text = v.Address_1_WS;
                //}
                //if (!string.IsNullOrEmpty(v.Address_2_WS))
                //{
                //    txtLine2Workshop.Text = v.Address_2_WS;
                //}
                //if (!string.IsNullOrEmpty(v.City_WS))
                //{
                //    drpCityWorkshop.SelectedItem.Text = v.City_WS;
                //}
                //if (!string.IsNullOrEmpty(v.StateRegion_WS))
                //{
                //    drpStateWorkshop.SelectedItem.Text = v.StateRegion_WS;
                //}
                //General Details TAB Fill

                //Contact Details TAB Fill

                if (!string.IsNullOrEmpty(v.WebSite))
                {
                    txtURL.Text = v.WebSite;
                }
                if (!string.IsNullOrEmpty(v.PaymentTerm))
                {
                    drp_PaymentTerm.SelectedItem.Text = v.PaymentTerm;
                }
                if (!string.IsNullOrEmpty(Convert.ToString(v.TotalStrengthOfManPower)))
                {
                    txt_TotalStrengthofManpower.Text = Convert.ToString(v.TotalStrengthOfManPower);
                }

                //if (!string.IsNullOrEmpty(Convert.ToString(v.ShipmentTerm)))
                //{
                //    if (v.ShipmentTerm == 1)
                //    {
                //        chk_CIF.Checked = true;
                //    }
                //    else if(v.ShipmentTerm == 2)
                //    {
                //        chk_CNF.Checked = true; ;
                //    }
                //    else if (v.ShipmentTerm == 3)
                //    {
                //        chk_FOB.Checked = true; ;
                //    }
                //    else if (v.ShipmentTerm == 4)
                //    {
                //        chk_FOR.Checked = true; ;
                //    }
                //    else if (v.ShipmentTerm == 5)
                //    {
                //        chk_Exworks.Checked = true; ;
                //    }
                //}

                if (!string.IsNullOrEmpty(v.Con_PropDirPar_Name))
                {
                    txtDirectName.Text = v.Con_PropDirPar_Name;
                }
                if (!string.IsNullOrEmpty(v.Con_PropDirPar_PhoneNo))
                {
                    txtDirectPhone.Text = v.Con_PropDirPar_PhoneNo;
                }
                if (!string.IsNullOrEmpty(v.Con_PropDirPar_PhoneNo))
                {
                    txtDirectMobile.Text = v.Con_PropDirPar_PhoneNo;
                }
                if (!string.IsNullOrEmpty(v.Con_PropDirPar_EmailID))
                {
                    txtDirectEmail.Text = v.Con_PropDirPar_EmailID;
                }

                if (!string.IsNullOrEmpty(v.Con_SalesDep_Name))
                {
                    txtSaleName.Text = v.Con_SalesDep_Name;
                }
                if (!string.IsNullOrEmpty(v.Con_SalesDep_PhoneNo))
                {
                    txtSalePhone.Text = v.Con_SalesDep_PhoneNo;
                }
                if (!string.IsNullOrEmpty(v.Con_SalesDep_MobileNo))
                {
                    txtSaleMobile.Text = v.Con_SalesDep_MobileNo;
                }
                if (!string.IsNullOrEmpty(v.Con_SalesDep_EmailID))
                {
                    txtSaleEmail.Text = v.Con_SalesDep_EmailID;
                }

                if (!string.IsNullOrEmpty(v.Con_AccDep_Name))
                {
                    txtAccountName.Text = v.Con_AccDep_Name;
                }
                if (!string.IsNullOrEmpty(v.Con_AccDep_PhoneNo))
                {
                    txtAccountPhone.Text = v.Con_AccDep_PhoneNo;
                }
                if (!string.IsNullOrEmpty(v.Con_AccDep_MobileNo))
                {
                    txtAccountMobile.Text = v.Con_AccDep_MobileNo;
                }
                if (!string.IsNullOrEmpty(v.Con_AccDep_EmailID))
                {
                    txtAccountEmail.Text = v.Con_AccDep_EmailID;
                }


                //Tax Details Fill for For Supplier of Material
                if (!string.IsNullOrEmpty(v.For_SOM_CSTNo))
                {
                    txtCST.Text = v.For_SOM_CSTNo;
                }
                if (!string.IsNullOrEmpty(v.For_SOM_VatNo))
                {
                    txtVAT.Text = v.For_SOM_VatNo;
                }
                if (!string.IsNullOrEmpty(v.For_SOM_PanNo))
                {
                    txtPAN.Text = v.For_SOM_PanNo;
                }
                if (!string.IsNullOrEmpty(v.For_SOM_TanNo))
                {
                    txtTAN.Text = v.For_SOM_TanNo;
                }
                if (v.For_SOM_MicroSmallMediumEnterprise != null)
                {
                    if (Convert.ToBoolean(v.For_SOM_MicroSmallMediumEnterprise) == true)
                    {
                        chk_Yes.Checked = true;
                    }
                    else if (Convert.ToBoolean(v.For_SOM_MicroSmallMediumEnterprise) == false)
                    {
                        chk_No.Checked = true;
                    }
                    else
                    {
                        chk_Yes.Checked = false;
                        chk_No.Checked  = false;
                    }
                }
                //if (!string.IsNullOrEmpty(v.For_SOM_MSMERegNo))
                //{
                //    txtMSMERegNo.Text = v.For_SOM_MSMERegNo;
                //}
                if (v.For_SOM_RegisteredwithExcise != null)
                {
                    if (Convert.ToString(v.For_SOM_RegisteredwithExcise) == "Yes")
                    {
                        chk_reg_Yes.Checked = true;
                    }
                    else if (Convert.ToString(v.For_SOM_RegisteredwithExcise) == "No")
                    {
                        chk_reg_No.Checked = true;
                    }
                    else
                    {
                        chk_reg_Yes.Checked = false;
                        chk_reg_No.Checked  = false;
                    }
                }

                if (!string.IsNullOrEmpty(v.For_SOM_ECCNo))
                {
                    txt_ECCNo.Text = v.For_SOM_ECCNo;
                }
                if (!string.IsNullOrEmpty(v.For_SOM_ExciseRange))
                {
                    txt_ExciseRange.Text = v.For_SOM_ExciseRange;
                }
                if (!string.IsNullOrEmpty(v.For_SOM_ExciseDivision))
                {
                    txt_ExciseDivision.Text = v.For_SOM_ExciseDivision;
                }
                if (!string.IsNullOrEmpty(v.For_SOM_ExciseCollectorate))
                {
                    txt_ExciseCollectorate.Text = v.For_SOM_ExciseCollectorate;
                }
                //Tax Details Fill for For Supplier of Material

                //Tax Details Fill for For Others
                //if (!string.IsNullOrEmpty(v.For_Others_PanNo))
                //{
                //    txtPANOthr.Text = v.For_Others_PanNo;
                //}
                if (!string.IsNullOrEmpty(v.For_Others_ServcieTaxRegNo))
                {
                    txt_ServiceTaxRegNo.Text = v.For_Others_ServcieTaxRegNo;
                }
                if (!string.IsNullOrEmpty(v.For_Others_PFRegNo))
                {
                    txt_PFRegNo.Text = v.For_Others_PFRegNo;
                }
                if (!string.IsNullOrEmpty(v.For_Others_ESIRegNo))
                {
                    txt_ESIRegNo.Text = v.For_Others_ESIRegNo;
                }
                if (!string.IsNullOrEmpty(v.For_Others_ContractLicenseNo))
                {
                    txtContractLicenseNo.Text = v.For_Others_ContractLicenseNo;
                }

                if (!string.IsNullOrEmpty(Convert.ToString(v.For_Others_TDS_Applicability)))
                {
                    if (v.For_Others_TDS_Applicability == 1)
                    {
                        chk_TDS_yes.Checked = true;
                    }
                    else if (v.For_Others_TDS_Applicability == 2)
                    {
                        chk_TDS_No.Checked = true;
                    }
                    else if (v.For_Others_TDS_Applicability == 3)
                    {
                        chk_TDS_Lower.Checked = true;
                    }
                    else
                    {
                        chk_TDS_yes.Checked   = false;
                        chk_TDS_No.Checked    = false;
                        chk_TDS_Lower.Checked = false;
                    }
                }

                if (!string.IsNullOrEmpty(v.For_Others_LowerDeductionCertiNo))
                {
                    txt_LowerDeductionCertiNo.Text = v.For_Others_LowerDeductionCertiNo;
                }
                //Tax Details Fill for For Others

                //Bank Details Fill
                if (!string.IsNullOrEmpty(v.BankName))
                {
                    txtBankName.Text = v.BankName;
                }
                if (!string.IsNullOrEmpty(v.BankBrachName))
                {
                    txtBAnkBrnch.Text = v.BankBrachName;
                }
                if (!string.IsNullOrEmpty(v.BankAccNo))
                {
                    txtAcntNo.Text = v.BankAccNo;
                }
                if (!string.IsNullOrEmpty(Convert.ToString(v.TypeofAcc)))
                {
                    if (v.TypeofAcc == 1)
                    {
                        chk_TypeofSa.Checked = true;
                    }
                    else if (v.TypeofAcc == 2)
                    {
                        chk_TypeofCur.Checked = true;
                    }
                    else if (v.TypeofAcc == 3)
                    {
                        chk_TypeofCC.Checked = true;
                    }
                    else
                    {
                        chk_TypeofSa.Checked  = false;
                        chk_TypeofCur.Checked = false;
                        chk_TypeofCC.Checked  = false;
                    }
                }

                if (!string.IsNullOrEmpty(v.IFSCode))
                {
                    txtIFSC.Text = v.IFSCode;
                }
                //if (!string.IsNullOrEmpty(v.MICRCODE))
                //{
                //    txtMICR.Text = v.MICRCODE;
                //}
                if (!string.IsNullOrEmpty(v.Bank_EmailID_UTR))
                {
                    txtEmailUTR.Text = v.Bank_EmailID_UTR;
                }
                if (!string.IsNullOrEmpty(v.BankingMobileNo))
                {
                    txtMobileUTR.Text = v.BankingMobileNo;
                }
                TextBox100.Text                     = v.For_SOM_MSMERegNo;
                txtFaxNoOffice.Text                 = v.FAX_HO != "" ? v.FAX_HO : "";
                txtLine3Office.Text                 = v.Phone_HO != "" ? v.Phone_HO : "";
                txtMobileNoOffice.Text              = v.Mobile_HO != "" ? v.Mobile_HO : "";
                txtEmailIDOffice.Text               = v.Email_HO != "" ? v.Email_HO : "";
                drpShipmentTerm.SelectedValue       = v.Shipment_Term != "" ? v.Shipment_Term : "";
                VendorNoSeries.SelectedValue        = v.Vendor_No_Series != "" ? v.Vendor_No_Series : "";
                drpGenBusPostingGroup.SelectedValue = v.Gen_Posting_Group != "" ? v.Gen_Posting_Group : "";
                drpVATBusPostingGroup.SelectedValue = v.VAT_Posting_Group != "" ? v.VAT_Posting_Group : "";
                drpServiceEntityType.SelectedValue  = v.Service_Entity_Type != "" ? v.Service_Entity_Type : "";
                drpExcisePostingGroup.SelectedValue = v.Excise_Posting_Group != "" ? v.Excise_Posting_Group : "";
                drpVendorPostingGroup.SelectedValue = v.Vendor_Posting_Group != "" ? v.Vendor_Posting_Group : "";
                drpCurrencyCode.SelectedValue       = v.Currency_Code != "" ? v.Currency_Code : "";
                drpAuthorisedby.SelectedValue       = v.Authorised_by != "" ? v.Authorised_by : "";
                chk_TaxLiable.Checked               = v.Tax_Liable == "Yes" ? true : false;

                //Bank Details Fill
            }
            using (var context = new EDMXConnectionString())
            {
                var business = context.Busi_Annul_Turnover.SingleOrDefault(a => a.VendorId == venid);
                if (business != null)
                {
                    drpYear1.SelectedValue = business.YearFirst != null?Convert.ToString(business.YearFirst) : "";

                    drpYear2.SelectedValue = business.YearSecond != null?Convert.ToString(business.YearSecond) : "";

                    drpYear3.SelectedValue = business.YearThird != null?Convert.ToString(business.YearThird) : "";

                    txtAmount1.Text = business.YearFirstTurnOver != 0.00m ? Convert.ToString(business.YearFirstTurnOver) : "";
                    txtAmount2.Text = business.YearSecondTurnOver != 0.00m ? Convert.ToString(business.YearSecondTurnOver) : "";
                    txtAmount3.Text = business.YearThirdTurnOver != 0.00m ? Convert.ToString(business.YearThirdTurnOver) : "";
                }
            }
            using (var context = new EDMXConnectionString())
            {
                // Busi_Cust_Ref business_ref = new Busi_Cust_Ref();
                var business_ref = context.Busi_Cust_Ref.Where(a => a.VendorID == venid).ToList();
                var recordCount  = context.Busi_Cust_Ref.Where(a => a.VendorID == venid).Count();
                if (business_ref != null)
                {
                    for (int i = 0; i <= recordCount - 1; i++)
                    {
                        TextBox box1 = (TextBox)grd_CustomerDetails.Rows[i].Cells[1].FindControl("txtCustomerName");
                        TextBox box2 = (TextBox)grd_CustomerDetails.Rows[i].Cells[2].FindControl("txtLocationName");
                        TextBox box3 = (TextBox)grd_CustomerDetails.Rows[i].Cells[3].FindControl("txtContactPersonName");
                        TextBox box4 = (TextBox)grd_CustomerDetails.Rows[i].Cells[3].FindControl("txtContactPersonNumber");

                        box1.Text = business_ref[i].Customer_Name;
                        box2.Text = business_ref[i].Location;
                        box3.Text = business_ref[i].Contact_Person;
                        box4.Text = Convert.ToString(business_ref[i].Contact_Number);
                    }
                }
            }
        }