internal DataTable FillSectionName(BudgetReportModel ObjRptModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPBudgetReport";
ClsCon.cmd.Parameters.AddWithValue("@RptInd", ObjRptModel.RptInd);
ClsCon.cmd.Parameters.AddWithValue("@CompanyID", ObjRptModel.CompanyID);
ClsCon.cmd.Parameters.AddWithValue("@BranchID", ObjRptModel.BranchID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjRptModel.YrCD);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtReport = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtReport);
dtReport.TableName = "success";
}
catch (Exception ex)
{
dtReport = new DataTable();
dtReport.TableName = "error";
return(dtReport);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtReport);
}
public DataTable FillSectionName(BudgetReportModel ObjRptModel)
{
DataTable dtSectioname = ObjReportDA.FillSectionName(ObjRptModel);
return(dtSectioname);
}
public DataTable FillScheme(BudgetReportModel ObjRptModel)
{
DataTable dtLoadScheme = ObjReportDA.LoadScheme(ObjRptModel);
return(dtLoadScheme);
}
public DataTable AccountHeadLoad(BudgetReportModel ObjRptModel)
{
DataTable dtAccountHeadLoad = ObjReportDA.AccountHeadLoad(ObjRptModel);
return(dtAccountHeadLoad);
}
