internal DataTable LoadNarration(UpdCashPaymentModel objUpdCashPay)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPMasters";
ClsCon.cmd.Parameters.AddWithValue("@DataInd", objUpdCashPay.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdCashPay.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdCashPay.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdCashPay.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@VchType", objUpdCashPay.VchType);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtUpdCashPay = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtUpdCashPay);
dtUpdCashPay.TableName = "success";
}
catch (Exception)
{
dtUpdCashPay = new DataTable();
dtUpdCashPay.TableName = "error";
return(dtUpdCashPay);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtUpdCashPay);
}
internal DataTable UpdateCashPay(UpdCashPaymentModel objUpdCashPay)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPCashVoucher";
ClsCon.cmd.Parameters.AddWithValue("@DataInd", objUpdCashPay.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdCashPay.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdCashPay.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdCashPay.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@VchType", objUpdCashPay.VchType);
ClsCon.cmd.Parameters.AddWithValue("@DocNo", objUpdCashPay.DocNo);
ClsCon.cmd.Parameters.AddWithValue("@CCCode", objUpdCashPay.CCCode);
ClsCon.cmd.Parameters.AddWithValue("@DeptID", objUpdCashPay.DeptID);
ClsCon.cmd.Parameters.AddWithValue("@SubDeptID", objUpdCashPay.SubDeptID);
ClsCon.cmd.Parameters.AddWithValue("@IsAudit", objUpdCashPay.IsAudit);
ClsCon.cmd.Parameters.AddWithValue("@IsSendToAudit", objUpdCashPay.IsSendToAudit);
ClsCon.cmd.Parameters.AddWithValue("@TblCash", JsonConvert.DeserializeObject <DataTable>(objUpdCashPay.Dt));
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtUpdCashPay = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtUpdCashPay);
dtUpdCashPay.TableName = "success";
}
catch (Exception)
{
dtUpdCashPay = new DataTable();
dtUpdCashPay.TableName = "error";
return(dtUpdCashPay);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtUpdCashPay);
}
public DataTable CheckBudgetHead(UpdCashPaymentModel objUpdCashPay)
{
DataTable UpdateCashPayList = UpdCashPaymentDA.CheckBudgetHead(objUpdCashPay);
return(UpdateCashPayList);
}
public DataTable UpdateCashPay(UpdCashPaymentModel objUpdCashPay)
{
DataTable UpdateCashPayList = UpdCashPaymentDA.UpdateCashPay(objUpdCashPay);
return(UpdateCashPayList);
}
public DataTable CancelVoucher(UpdCashPaymentModel objUpdCashPay)
{
DataTable dtCancelVoucher = UpdCashPaymentDA.CancelVoucher(objUpdCashPay);
return(dtCancelVoucher);
}
public DataTable SearchCashPay(UpdCashPaymentModel objUpdCashPay)
{
DataTable SearchCashpayList = UpdCashPaymentDA.SearchCashPay(objUpdCashPay);
return(SearchCashpayList);
}
public DataSet BindAllUpdCashPaymentDDL(UpdCashPaymentModel objUpdCashPay)
{
DataSet dsBindAllCPDDL = UpdCashPaymentDA.BindAllUpdCashPaymentDDL(objUpdCashPay);
return(dsBindAllCPDDL);
}
public DataTable LoadCashAccount(UpdCashPaymentModel objUpdCashPay)
{
DataTable lstcashpay = UpdCashPaymentDA.LoadCashAccount(objUpdCashPay);
return(lstcashpay);
}
public DataTable LoadNarration(UpdCashPaymentModel objUpdCashPay)
{
DataTable NarrationList = UpdCashPaymentDA.LoadNarration(objUpdCashPay);
return(NarrationList);
}
public DataTable AccountHead(UpdCashPaymentModel objUpdCashPay)
{
DataTable AccHeadList = UpdCashPaymentDA.AccountHead(objUpdCashPay);
return(AccHeadList);
}
