internal DataTable LoadNarration(UpdateJournalVoucherModel objUJVModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPMasters";
ClsCon.cmd.Parameters.AddWithValue("@DataInd", objUJVModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUJVModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objUJVModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUJVModel.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@VchType", objUJVModel.VchType);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtUJV = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtUJV);
dtUJV.TableName = "success";
}
catch (Exception)
{
dtUJV = new DataTable();
dtUJV.TableName = "error";
return(dtUJV);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtUJV);
}
internal DataTable UpdateJV(UpdateJournalVoucherModel objUJVModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPUpdateJournalVoucher";
ClsCon.cmd.Parameters.AddWithValue("@DataInd", objUJVModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUJVModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objUJVModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUJVModel.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@VchType", objUJVModel.VchType);
ClsCon.cmd.Parameters.AddWithValue("@DocNo", objUJVModel.DocNo);
ClsCon.cmd.Parameters.AddWithValue("@CCCode", objUJVModel.CCCode);
ClsCon.cmd.Parameters.AddWithValue("@IDARefNo", objUJVModel.IDARefNo);
ClsCon.cmd.Parameters.AddWithValue("@TblJV", JsonConvert.DeserializeObject <DataTable>(objUJVModel.DtJV));
//ClsCon.cmd.Parameters.AddWithValue("@TblJV", objUJVModel.DtJV);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtUJV = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtUJV);
dtUJV.TableName = "success";
}
catch (Exception)
{
dtUJV = new DataTable();
dtUJV.TableName = "error";
return(dtUJV);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtUJV);
}
public DataTable CheckBudgetHead(UpdateJournalVoucherModel objUJVModel)
{
DataTable dtAccHeadList = objUJVDA.CheckBudgetHead(objUJVModel);
return(dtAccHeadList);
}
public DataTable CancelVoucher(UpdateJournalVoucherModel objUJVModel)
{
DataTable dtCancelVoucher = objUJVDA.CancelVoucher(objUJVModel);
return(dtCancelVoucher);
}
public DataTable UpdateJV(UpdateJournalVoucherModel objUJVModel)
{
DataTable dtSaveJV = objUJVDA.UpdateJV(objUJVModel);
return(dtSaveJV);
}
public DataTable SearchJV(UpdateJournalVoucherModel objUJVModel)
{
DataTable dtSearch = objUJVDA.SearchJV(objUJVModel);
return(dtSearch);
}
public DataTable LoadControlAccount(UpdateJournalVoucherModel objUJVModel)
{
DataTable dtControlAccount = objUJVDA.LoadControlAccount(objUJVModel);
return(dtControlAccount);
}
public DataSet BindAllUpdJVDDL(UpdateJournalVoucherModel objUJVModel)
{
DataSet dsBindAllUpdJVDDL = objUJVDA.BindAllUpdJVDDL(objUJVModel);
return(dsBindAllUpdJVDDL);
}
public DataTable LoadNarration(UpdateJournalVoucherModel objUJVModel)
{
DataTable dtNarrationList = objUJVDA.LoadNarration(objUJVModel);
return(dtNarrationList);
}
public DataTable LastVoucherNo(UpdateJournalVoucherModel objUJVModel)
{
DataTable dtLastVoucherNo = objUJVDA.LastVoucherNo(objUJVModel);
return(dtLastVoucherNo);
}
public DataTable AccountHead(UpdateJournalVoucherModel objUJVModel)
{
DataTable dtAccHeadList = objUJVDA.AccountHead(objUJVModel);
return(dtAccHeadList);
}
