internal DataTable LoadNarration(UpdateCashReceiptModel objUpdCashRec)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPMasters";
ClsCon.cmd.Parameters.AddWithValue("@DataInd", objUpdCashRec.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdCashRec.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdCashRec.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdCashRec.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@VchType", objUpdCashRec.VchType);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtUpdCashReceipt = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtUpdCashReceipt);
dtUpdCashReceipt.TableName = "success";
}
catch (Exception)
{
dtUpdCashReceipt = new DataTable();
dtUpdCashReceipt.TableName = "error";
return(dtUpdCashReceipt);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtUpdCashReceipt);
}
internal DataTable UpdateCashReceipt(UpdateCashReceiptModel objUpdCashRec)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPCashVoucher";
ClsCon.cmd.Parameters.AddWithValue("@DataInd", objUpdCashRec.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdCashRec.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdCashRec.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdCashRec.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@VchType", objUpdCashRec.VchType);
ClsCon.cmd.Parameters.AddWithValue("@DocNo", objUpdCashRec.DocNo);
ClsCon.cmd.Parameters.AddWithValue("@CCCode", objUpdCashRec.CCCode);
ClsCon.cmd.Parameters.AddWithValue("@TblCash", JsonConvert.DeserializeObject <DataTable>(objUpdCashRec.Dt));
ClsCon.cmd.Parameters.AddWithValue("@RevenuePartyName", objUpdCashRec.PartyName);
ClsCon.cmd.Parameters.AddWithValue("@RevenuePartyAddress", objUpdCashRec.PartyAddress);
ClsCon.cmd.Parameters.AddWithValue("@RevenuePartyGSTIN", objUpdCashRec.PartyGstIN);
ClsCon.cmd.Parameters.AddWithValue("@RevenueServiceNo", objUpdCashRec.ServiceNo);
//ClsCon.cmd.Parameters.AddWithValue("@TblCash", objUpdCashRec.Dt);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtUpdCashReceipt = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtUpdCashReceipt);
dtUpdCashReceipt.TableName = "success";
}
catch (Exception)
{
dtUpdCashReceipt = new DataTable();
dtUpdCashReceipt.TableName = "error";
return(dtUpdCashReceipt);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtUpdCashReceipt);
}
public DataTable CancelVoucher(UpdateCashReceiptModel objUpdCashRec)
{
DataTable dtCancelVoucher = objUpdCashReceiptDA.CancelVoucher(objUpdCashRec);
return(dtCancelVoucher);
}
public DataTable CheckBudgetHead(UpdateCashReceiptModel objUpdCashRec)
{
DataTable lstcashrec = objUpdCashReceiptDA.CheckBudgetHead(objUpdCashRec);
return(lstcashrec);
}
public DataTable UpdateCashReceipt(UpdateCashReceiptModel objUpdCashRec)
{
DataTable UpdateCashReceiptList = objUpdCashReceiptDA.UpdateCashReceipt(objUpdCashRec);
return(UpdateCashReceiptList);
}
public DataSet BindAllUpdCashReceiptDDL(UpdateCashReceiptModel objUpdCashRec)
{
DataSet dsBindAllCRDDL = objUpdCashReceiptDA.BindAllUpdCashReceiptDDL(objUpdCashRec);
return(dsBindAllCRDDL);
}
public DataTable LoadNarration(UpdateCashReceiptModel objUpdCashRec)
{
DataTable NarrationList = objUpdCashReceiptDA.LoadNarration(objUpdCashRec);
return(NarrationList);
}
public DataTable AccountHead(UpdateCashReceiptModel objUpdCashRec)
{
DataTable AccHeadList = objUpdCashReceiptDA.AccountHead(objUpdCashRec);
return(AccHeadList);
}
public DataTable LoadCashAccount(UpdateCashReceiptModel objUpdCashRec)
{
DataTable lstcashrec = objUpdCashReceiptDA.LoadCashAccount(objUpdCashRec);
return(lstcashrec);
}
