public DataSet PartySelect(BankReceiptModel plbankrec)
{
DataSet dsPartySelect = new DataSet();
plbankrec.Ind = 2;
DataTable SecondaryParty = dlBankReceipt.PartySelect(plbankrec);
if (SecondaryParty.Rows.Count > 0)
{
SecondaryParty.TableName = "SecondaryParty";
dsPartySelect.Tables.Add(SecondaryParty);
return(dsPartySelect);
}
plbankrec.Ind = 3;
DataTable OutstandingBill = dlBankReceipt.PartySelect(plbankrec);
if (SecondaryParty.Rows.Count > 0)
{
SecondaryParty.TableName = "OutstandingBill";
dsPartySelect.Tables.Add(OutstandingBill);
return(dsPartySelect);
}
return(dsPartySelect);
}
internal DataTable LoadNarration(BankReceiptModel objBankRec)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPMasters";
ClsCon.cmd.Parameters.AddWithValue("@DataInd", objBankRec.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objBankRec.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objBankRec.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objBankRec.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@VchType", objBankRec.VchType);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtBankReceipt = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtBankReceipt);
dtBankReceipt.TableName = "success";
}
catch (Exception)
{
dtBankReceipt = new DataTable();
dtBankReceipt.TableName = "error";
return(dtBankReceipt);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtBankReceipt);
}
internal DataTable CheckBudgetHead(BankReceiptModel plbankrec)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPBankVoucher";
ClsCon.cmd.Parameters.AddWithValue("@DataInd", plbankrec.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", plbankrec.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", plbankrec.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", plbankrec.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@AccCode", plbankrec.AccCode);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtBankReceipt = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtBankReceipt);
dtBankReceipt.TableName = "success";
}
catch (Exception)
{
dtBankReceipt = new DataTable();
dtBankReceipt.TableName = "error";
return(dtBankReceipt);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtBankReceipt);
}
internal DataTable PartySelect(BankReceiptModel objBankRec)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPSearchByAccount";
ClsCon.cmd.Parameters.AddWithValue("@Ind", objBankRec.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objBankRec.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objBankRec.BrID);
ClsCon.cmd.Parameters.AddWithValue("@AccCode", objBankRec.AccCode);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtBankReceipt = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtBankReceipt);
dtBankReceipt.TableName = "success";
}
catch (Exception)
{
dtBankReceipt = new DataTable();
dtBankReceipt.TableName = "error";
return(dtBankReceipt);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtBankReceipt);
}
internal DataTable SaveBankReceipt(BankReceiptModel objBankRec)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPBankVoucher";
ClsCon.cmd.Parameters.AddWithValue("@DataInd", objBankRec.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objBankRec.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objBankRec.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objBankRec.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@VchType", objBankRec.VchType);
ClsCon.cmd.Parameters.AddWithValue("@CCCode", objBankRec.CCCode);
ClsCon.cmd.Parameters.AddWithValue("@IDARefNo", objBankRec.IDARefNo);
// ClsCon.cmd.Parameters.AddWithValue("@TblBank", objBankRec.Dt);
ClsCon.cmd.Parameters.AddWithValue("@TblBank", JsonConvert.DeserializeObject <DataTable>(objBankRec.Dt));
ClsCon.cmd.Parameters.AddWithValue("@RevenuePartyName", objBankRec.PartyName);
ClsCon.cmd.Parameters.AddWithValue("@RevenuePartyAddress", objBankRec.PartyAddress);
ClsCon.cmd.Parameters.AddWithValue("@RevenuePartyGSTIN", objBankRec.PartyGstIN);
ClsCon.cmd.Parameters.AddWithValue("@RevenueServiceNo", objBankRec.ServiceNo);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtBankReceipt = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtBankReceipt);
dtBankReceipt.TableName = "success";
}
catch (Exception)
{
dtBankReceipt = new DataTable();
dtBankReceipt.TableName = "error";
return(dtBankReceipt);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtBankReceipt);
}
void BindAllBankReceiptDDL()
{
try
{
plbankrec = new BankReceiptModel();
plbankrec.Ind = 11;
plbankrec.OrgID = GlobalSession.OrgID;
plbankrec.BrID = GlobalSession.BrID;
plbankrec.YrCD = GlobalSession.YrCD;
plbankrec.VchType = Convert.ToInt32(ViewState["VchType"]);
string uri = string.Format("BankReceipt/BindAllBankReceiptDDL");
DataSet dsBindAllCRDDL = CommonCls.ApiPostDataSet(uri, plbankrec);
if (dsBindAllCRDDL.Tables.Count > 0)
{
DataTable dtAccountHead = dsBindAllCRDDL.Tables[0];
DataTable dtLastVoucher = dsBindAllCRDDL.Tables[1];
DataTable dtNarration = dsBindAllCRDDL.Tables[2];
DataTable dtCashAccount = dsBindAllCRDDL.Tables[3];
// Cash List Bind
if (dtCashAccount.Rows.Count > 0)
{
ddlbank.DataSource = dtCashAccount;
ddlbank.DataTextField = "AccName";
ddlbank.DataValueField = "AccCode";
ddlbank.DataBind();
if (dtCashAccount.Rows.Count > 1)
{
ddlbank.Items.Insert(0, new ListItem("-- Select --", "0"));
}
}
}
}
catch (Exception ex)
{
ShowMessage(ex.Message, false);
}
}
public DataTable CheckBudgetHead(BankReceiptModel plbankrec)
{
DataTable lstbnkpay = dlBankReceipt.CheckBudgetHead(plbankrec);
return(lstbnkpay);
}
public DataTable SaveBankReceipt(BankReceiptModel plbankrec)
{
DataTable lstbnkpay = dlBankReceipt.SaveBankReceipt(plbankrec);
return(lstbnkpay);
}
public DataSet BindAllBankReceiptDDL(BankReceiptModel plbankrec)
{
DataSet dsBindAllCRDDL = dlBankReceipt.BindAllBankReceiptDDL(plbankrec);
return(dsBindAllCRDDL);
}
public DataTable LoadBankAccount(BankReceiptModel plbankrec)
{
DataTable lstbnkpay = dlBankReceipt.LoadBankAccount(plbankrec);
return(lstbnkpay);
}
public DataTable LoadNarration(BankReceiptModel plbankrec)
{
DataTable NarrationList = dlBankReceipt.LoadNarration(plbankrec);
return(NarrationList);
}
public DataTable LastVoucherNo(BankReceiptModel plbankrec)
{
DataTable LastVoucherNo = dlBankReceipt.LastVoucherNo(plbankrec);
return(LastVoucherNo);
}
public DataTable AccountHead(BankReceiptModel plbankrec)
{
DataTable AccHeadList = dlBankReceipt.AccountHead(plbankrec);
return(AccHeadList);
}