internal DataTable LoadGroupName(UpdateAccounHeadModel objUAHModel) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPMasters"; ClsCon.cmd.Parameters.AddWithValue("@DataInd", objUAHModel.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUAHModel.OrgID); ClsCon.cmd.Parameters.AddWithValue("@BrID", objUAHModel.BrID); ClsCon.cmd.Parameters.AddWithValue("@IsAdmin", objUAHModel.IsAdmin); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dtUpdAccountHead = new DataTable(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dtUpdAccountHead); dtUpdAccountHead.TableName = "success"; } catch (Exception) { dtUpdAccountHead = new DataTable(); dtUpdAccountHead.TableName = "error"; return(dtUpdAccountHead); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dtUpdAccountHead); }
public DataSet BindAccountHeadDDL(UpdateAccounHeadModel objUAHModel) { DataSet dsAccountHead = new DataSet(); objUAHModel.Ind = 7; DataTable dtUpdAccountHead = objUAHDA.LoadAccountHead(objUAHModel); dtUpdAccountHead.TableName = "AccountHead"; dsAccountHead.Tables.Add(dtUpdAccountHead); objUAHModel.Ind = 15; DataTable dtClientState = objUAHDA.LoadState(objUAHModel); dtClientState.TableName = "State"; dsAccountHead.Tables.Add(dtClientState); objUAHModel.Ind = 16; DataTable dtGroupName = objUAHDA.LoadGroupName(objUAHModel); dtGroupName.TableName = "GroupName"; dsAccountHead.Tables.Add(dtGroupName); objUAHModel.Ind = 19; DataTable dtExportCat = objUAHDA.LoadExportCategory(objUAHModel); dtExportCat.TableName = "ExportCategory"; dsAccountHead.Tables.Add(dtExportCat); return(dsAccountHead); }
internal DataSet LoadShippingInfo(UpdateAccounHeadModel objUAHModel) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPUpdateAccountHead"; ClsCon.cmd.Parameters.AddWithValue("@Ind", objUAHModel.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUAHModel.OrgID); ClsCon.cmd.Parameters.AddWithValue("@BrID", objUAHModel.BrID); ClsCon.cmd.Parameters.AddWithValue("@AccCode", objUAHModel.AccCode); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dsUpdAccountHead = new DataSet(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dsUpdAccountHead); dsUpdAccountHead.DataSetName = "success"; } catch (Exception) { dsUpdAccountHead = new DataSet(); dsUpdAccountHead.DataSetName = "error"; return(dsUpdAccountHead); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dsUpdAccountHead); }
internal DataTable UpdateShippingInfo(UpdateAccounHeadModel objUAHModel) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPUpdateAccountHead"; ClsCon.cmd.Parameters.AddWithValue("@Ind", objUAHModel.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUAHModel.OrgID); ClsCon.cmd.Parameters.AddWithValue("@BrID", objUAHModel.BrID); ClsCon.cmd.Parameters.AddWithValue("@UserID", objUAHModel.User); ClsCon.cmd.Parameters.AddWithValue("@IPAddress", objUAHModel.IP); ClsCon.cmd.Parameters.AddWithValue("@TblAccPOS", objUAHModel.DtAccPOS); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dtUpdAccountHead = new DataTable(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dtUpdAccountHead); dtUpdAccountHead.TableName = "success"; } catch (Exception) { dtUpdAccountHead = new DataTable(); dtUpdAccountHead.TableName = "error"; return(dtUpdAccountHead); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dtUpdAccountHead); }
internal DataTable UpdateClientInfo(UpdateAccounHeadModel objUAHModel) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPUpdateAccountHead"; ClsCon.cmd.Parameters.AddWithValue("@Ind", objUAHModel.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUAHModel.OrgID); ClsCon.cmd.Parameters.AddWithValue("@BrID", objUAHModel.BrID); ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUAHModel.YrCD); ClsCon.cmd.Parameters.AddWithValue("@AccCode", objUAHModel.AccCode); ClsCon.cmd.Parameters.AddWithValue("@AccName", objUAHModel.AccName); ClsCon.cmd.Parameters.AddWithValue("@AccNameHindi", objUAHModel.AccNameHindi); ClsCon.cmd.Parameters.AddWithValue("@MainGroupID", objUAHModel.MainGroupID); ClsCon.cmd.Parameters.AddWithValue("@SubGroupID", objUAHModel.SubGroupID); ClsCon.cmd.Parameters.AddWithValue("@AccGroupID", objUAHModel.AccGroupID); ClsCon.cmd.Parameters.AddWithValue("@AccSubGroupID", objUAHModel.AccSubGroupID); ClsCon.cmd.Parameters.AddWithValue("@Address", objUAHModel.Address); ClsCon.cmd.Parameters.AddWithValue("@City", objUAHModel.City); ClsCon.cmd.Parameters.AddWithValue("@StateID", objUAHModel.StateID); ClsCon.cmd.Parameters.AddWithValue("@PinCode", objUAHModel.PinCode); ClsCon.cmd.Parameters.AddWithValue("@PanNo", objUAHModel.PanNo); ClsCon.cmd.Parameters.AddWithValue("@MobileNo", objUAHModel.MobileNo); ClsCon.cmd.Parameters.AddWithValue("@LandlineNo", objUAHModel.LandlineNo); ClsCon.cmd.Parameters.AddWithValue("@Email", objUAHModel.Email); ClsCon.cmd.Parameters.AddWithValue("@ContactPerson", objUAHModel.ContactPerson); ClsCon.cmd.Parameters.AddWithValue("@DrOpBalance", objUAHModel.DrOpBalance); ClsCon.cmd.Parameters.AddWithValue("@CrOpBalance", objUAHModel.CrOpBalance); ClsCon.cmd.Parameters.AddWithValue("@CategoryID", objUAHModel.CategoryID); ClsCon.cmd.Parameters.AddWithValue("@ISDApplicable", objUAHModel.ISDApplicable); ClsCon.cmd.Parameters.AddWithValue("@TDSApplicable", objUAHModel.TDSApplicable); ClsCon.cmd.Parameters.AddWithValue("@RCMApplicable", objUAHModel.RCMApplicable); ClsCon.cmd.Parameters.AddWithValue("@TCSApplicable", objUAHModel.TCSApplicable); ClsCon.cmd.Parameters.AddWithValue("@MerchantID", objUAHModel.MerchantID); ClsCon.cmd.Parameters.AddWithValue("@BankName", objUAHModel.BankName); ClsCon.cmd.Parameters.AddWithValue("@BranchName", objUAHModel.BranchName); ClsCon.cmd.Parameters.AddWithValue("@IFSCCode", objUAHModel.IFSCCode); ClsCon.cmd.Parameters.AddWithValue("@BankAccountNo", objUAHModel.BankAccountNo); ClsCon.cmd.Parameters.AddWithValue("@UserID", objUAHModel.User); ClsCon.cmd.Parameters.AddWithValue("@IPAddress", objUAHModel.IP); ClsCon.cmd.Parameters.AddWithValue("@CompositionOpted", objUAHModel.CompositionOpted); ClsCon.cmd.Parameters.AddWithValue("@ReffPartyCode", objUAHModel.ReffPartyCode); ClsCon.cmd.Parameters.AddWithValue("@IsSubDealer", objUAHModel.IsSubDealer); ClsCon.cmd.Parameters.AddWithValue("@DiscountRate", objUAHModel.DiscountRate); ClsCon.cmd.Parameters.AddWithValue("@BrokerageRate", objUAHModel.BrokerageRate); ClsCon.cmd.Parameters.AddWithValue("@TblAccTerms", objUAHModel.TblAccTerms); ClsCon.cmd.Parameters.AddWithValue("@TaxCalcForSEZParty", objUAHModel.TaxCalcForSEZParty); ClsCon.cmd.Parameters.AddWithValue("@BrokerageLimit", objUAHModel.BrokerageLimit); ClsCon.cmd.Parameters.AddWithValue("@BrokerageType", objUAHModel.BrokerageType); ClsCon.cmd.Parameters.AddWithValue("@Remark", objUAHModel.Remark); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dtUpdAccountHead = new DataTable(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dtUpdAccountHead); dtUpdAccountHead.TableName = "success"; } catch (Exception) { dtUpdAccountHead = new DataTable(); dtUpdAccountHead.TableName = "error"; return(dtUpdAccountHead); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dtUpdAccountHead); }
public DataTable UpdateShippingInfo(UpdateAccounHeadModel objUAHModel) { DataTable dtUpdShippingInfo = objUAHDA.UpdateShippingInfo(objUAHModel); return(dtUpdShippingInfo); }
public DataTable UpdateGSTINInfo(UpdateAccounHeadModel objUAHModel) { DataTable dtUpdGSTINInfo = objUAHDA.UpdateGSTINInfo(objUAHModel); return(dtUpdGSTINInfo); }
public DataTable LoadBranchState(UpdateAccounHeadModel objUAHModel) { DataTable dtBranchState = objUAHDA.LoadBranchState(objUAHModel); return(dtBranchState); }
public DataSet LoadShippingInfo(UpdateAccounHeadModel objUAHModel) { DataSet dsShippingInfo = objUAHDA.LoadShippingInfo(objUAHModel); return(dsShippingInfo); }
public DataSet LoadBasicInfo(UpdateAccounHeadModel objUAHModel) { DataSet dtBasicInfo = objUAHDA.LoadBasicInfo(objUAHModel); return(dtBasicInfo); }