internal DataTable LoadNarration(BankPaymentModel objBankPay)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPMasters";
ClsCon.cmd.Parameters.AddWithValue("@DataInd", objBankPay.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objBankPay.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objBankPay.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objBankPay.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@VchType", objBankPay.VchType);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtBankPayment = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtBankPayment);
dtBankPayment.TableName = "success";
}
catch (Exception)
{
dtBankPayment = new DataTable();
dtBankPayment.TableName = "error";
return(dtBankPayment);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtBankPayment);
}
public DataSet PartySelect(BankPaymentModel objBankPay)
{
DataSet dsPartySelect = new DataSet();
objBankPay.Ind = 2;
DataTable SecondaryParty = dlBankAccount.PartySelect(objBankPay);
if (SecondaryParty.Rows.Count > 0)
{
SecondaryParty.TableName = "SecondaryParty";
dsPartySelect.Tables.Add(SecondaryParty);
return(dsPartySelect);
}
objBankPay.Ind = 3;
DataTable OutstandingBill = dlBankAccount.PartySelect(objBankPay);
if (SecondaryParty.Rows.Count > 0)
{
SecondaryParty.TableName = "OutstandingBill";
dsPartySelect.Tables.Add(OutstandingBill);
return(dsPartySelect);
}
return(dsPartySelect);
}
internal DataTable PartySelect(BankPaymentModel objBankPay)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPSearchByAccount";
ClsCon.cmd.Parameters.AddWithValue("@Ind", objBankPay.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objBankPay.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objBankPay.BrID);
ClsCon.cmd.Parameters.AddWithValue("@AccCode", objBankPay.AccCode);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtBankPayment = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtBankPayment);
dtBankPayment.TableName = "success";
}
catch (Exception)
{
dtBankPayment = new DataTable();
dtBankPayment.TableName = "error";
return(dtBankPayment);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtBankPayment);
}
internal DataTable SaveBankPayment(BankPaymentModel objBankPay)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPBankVoucher";
ClsCon.cmd.Parameters.AddWithValue("@DataInd", objBankPay.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objBankPay.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objBankPay.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objBankPay.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@VchType", objBankPay.VchType);
ClsCon.cmd.Parameters.AddWithValue("@CCCode", objBankPay.CCCode);
ClsCon.cmd.Parameters.AddWithValue("@IDARefNo", objBankPay.IDARefNo);
ClsCon.cmd.Parameters.AddWithValue("@DeptID", objBankPay.DeptID);
ClsCon.cmd.Parameters.AddWithValue("@SubDeptID", objBankPay.SubDeptID);
ClsCon.cmd.Parameters.AddWithValue("@TblBank", JsonConvert.DeserializeObject <DataTable>(objBankPay.Dt));
ClsCon.cmd.Parameters.AddWithValue("@RevenuePartyName", objBankPay.PartyName);
ClsCon.cmd.Parameters.AddWithValue("@RevenuePartyAddress", objBankPay.PartyAddress);
ClsCon.cmd.Parameters.AddWithValue("@RevenuePartyGSTIN", objBankPay.PartyGstIN);
ClsCon.cmd.Parameters.AddWithValue("@RevenueServiceNo", objBankPay.ServiceNo);
ClsCon.cmd.Parameters.AddWithValue("@IsFinal", objBankPay.IsFinal);
ClsCon.cmd.Parameters.AddWithValue("@IsAudit", objBankPay.IsAudit);
ClsCon.cmd.Parameters.AddWithValue("@IsSendToAudit", objBankPay.IsSendToAudit);
ClsCon.cmd.Parameters.AddWithValue("@BankPayVoucherInd", objBankPay.BankPayVoucherInd);
ClsCon.cmd.Parameters.AddWithValue("@ChequeDrawn", objBankPay.ChequeDrawn);
ClsCon.cmd.Parameters.AddWithValue("@User", objBankPay.User);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtBankPayment = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtBankPayment);
dtBankPayment.TableName = "success";
}
catch (Exception)
{
dtBankPayment = new DataTable();
dtBankPayment.TableName = "error";
return(dtBankPayment);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtBankPayment);
}
public DataTable LoadBankAccount(BankPaymentModel objBankPay)
{
DataTable lstbnkpay = ObjReportDA.LoadBankAccount(objBankPay);
return(lstbnkpay);
}
public DataTable CheckBudgetHead(BankPaymentModel objBankPay)
{
DataTable lstbnkpay = dlBankAccount.CheckBudgetHead(objBankPay);
return(lstbnkpay);
}
public DataTable SaveBankPayment(BankPaymentModel objBankPay)
{
DataTable lstbnkpay = dlBankAccount.SaveBankPayment(objBankPay);
return(lstbnkpay);
}
public DataSet BindAllBankPaymentDDL(BankPaymentModel objBankPay)
{
DataSet dsBindAllCRDDL = dlBankAccount.BindAllBankPaymentDDL(objBankPay);
return(dsBindAllCRDDL);
}
public DataTable LoadNarration(BankPaymentModel objBankPay)
{
DataTable NarrationList = dlBankAccount.LoadNarration(objBankPay);
return(NarrationList);
}
public DataTable LastVoucherNo(BankPaymentModel objBankPay)
{
DataTable LastVoucherNo = dlBankAccount.LastVoucherNo(objBankPay);
return(LastVoucherNo);
}
public DataTable AccountHead(BankPaymentModel objBankPay)
{
DataTable AccHeadList = dlBankAccount.AccountHead(objBankPay);
return(AccHeadList);
}
