internal DataTable PartySelect(InterBranchModel objInterBranch)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPSearchByAccount";
ClsCon.cmd.Parameters.AddWithValue("@Ind", objInterBranch.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objInterBranch.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objInterBranch.BrID);
ClsCon.cmd.Parameters.AddWithValue("@AccCode", objInterBranch.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 LoadNarration(InterBranchModel objInterBranch)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPMasters";
ClsCon.cmd.Parameters.AddWithValue("@DataInd", objInterBranch.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objInterBranch.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objInterBranch.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objInterBranch.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@VchType", objInterBranch.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 DataSet LoadBranchList(InterBranchModel objInterBranch)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPInterBranch";
ClsCon.cmd.Parameters.AddWithValue("@DataInd", objInterBranch.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objInterBranch.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objInterBranch.BrID);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtBranchList = new DataSet();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtBranchList);
dtBranchList.DataSetName = "success";
}
catch (Exception)
{
dtBranchList = new DataSet();
dtBranchList.DataSetName = "error";
return(dtBranchList);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtBranchList);
}
public DataSet PartySelect(InterBranchModel objInterBranch)
{
DataSet dsPartySelect = new DataSet();
objInterBranch.Ind = 2;
DataTable SecondaryParty = InterBranchDA.PartySelect(objInterBranch);
if (SecondaryParty.Rows.Count > 0)
{
SecondaryParty.TableName = "SecondaryParty";
dsPartySelect.Tables.Add(SecondaryParty);
return(dsPartySelect);
}
objInterBranch.Ind = 3;
DataTable OutstandingBill = InterBranchDA.PartySelect(objInterBranch);
if (SecondaryParty.Rows.Count > 0)
{
SecondaryParty.TableName = "OutstandingBill";
dsPartySelect.Tables.Add(OutstandingBill);
return(dsPartySelect);
}
return(dsPartySelect);
}
internal DataTable SaveInterBranch(InterBranchModel objInterBranch)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPInterBranch";
ClsCon.cmd.Parameters.AddWithValue("@DataInd", objInterBranch.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objInterBranch.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objInterBranch.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objInterBranch.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@VchType", objInterBranch.VchType);
ClsCon.cmd.Parameters.AddWithValue("@AmountDr", objInterBranch.AmountDr);
ClsCon.cmd.Parameters.AddWithValue("@AmountCr", objInterBranch.AmountCr);
ClsCon.cmd.Parameters.AddWithValue("@IP", objInterBranch.IP);
ClsCon.cmd.Parameters.AddWithValue("@DocDesc", objInterBranch.DocDesc);
ClsCon.cmd.Parameters.AddWithValue("@BankCode", objInterBranch.BankCode);
ClsCon.cmd.Parameters.AddWithValue("@InterBrID", objInterBranch.InterBrID);
ClsCon.cmd.Parameters.AddWithValue("@AccCode", objInterBranch.AccCode);
ClsCon.cmd.Parameters.AddWithValue("@AccCode2", objInterBranch.AccCode2);
ClsCon.cmd.Parameters.AddWithValue("@DocDate", objInterBranch.DocDate);
ClsCon.cmd.Parameters.AddWithValue("@AdvanceInd", objInterBranch.AdvanceInd);
ClsCon.cmd.Parameters.AddWithValue("@EntryType", objInterBranch.EntryType);
ClsCon.cmd.Parameters.AddWithValue("@User", objInterBranch.User);
ClsCon.cmd.Parameters.AddWithValue("@TblBank", objInterBranch.Dt);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtInterBranch = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtInterBranch);
dtInterBranch.TableName = "success";
}
catch (Exception)
{
dtInterBranch = new DataTable();
dtInterBranch.TableName = "error";
return(dtInterBranch);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtInterBranch);
}
public DataTable SaveInterBranch(InterBranchModel objInterBranch)
{
DataTable dtInterBranch = InterBranchDA.SaveInterBranch(objInterBranch);
return(dtInterBranch);
}
public DataSet LoadBranchList(InterBranchModel objInterBranch)
{
DataSet lstBranch = InterBranchDA.LoadBranchList(objInterBranch);
return(lstBranch);
}
public DataTable LoadBankAccount(InterBranchModel objInterBranch)
{
DataTable lstbnkpay = InterBranchDA.LoadBankAccount(objInterBranch);
return(lstbnkpay);
}
public DataTable LoadNarration(InterBranchModel objInterBranch)
{
DataTable NarrationList = InterBranchDA.LoadNarration(objInterBranch);
return(NarrationList);
}
public DataTable LastVoucherNo(InterBranchModel objInterBranch)
{
DataTable LastVoucherNo = InterBranchDA.LastVoucherNo(objInterBranch);
return(LastVoucherNo);
}
public DataTable AccountHead(InterBranchModel objInterBranch)
{
DataTable AccHeadList = InterBranchDA.AccountHead(objInterBranch);
return(AccHeadList);
}