private void IncomeStatment()
{
string fromDate = Request.QueryString["fromDate"].ToString();
string toDate = Request.QueryString["toDate"].ToString();
string query = @"exec IncomeStatement '" + fromDate + "','" + toDate + "'";
oResult = oDAL.Select(query);
DataSet dt = null;
dt = oResult.ds as DataSet;
}
public string GetMaxIdWithPrfix(string coloumName, string rightStringLength, string initialValue, string tableName, string prefix)
{
string id = "";
string maxId = "";
_selectQuery = "SELECT ISNULL(MAX(RIGHT(" + coloumName + ", " + rightStringLength + ")) + 1, " + initialValue + ") AS maxID " +
" FROM " + tableName + " where left(" + coloumName + "," + prefix.Length + ")='" + prefix + "' ";
SQLDAL dal = new SQLDAL();
DataTable dt = dal.Select(_selectQuery).Data;
if (dt != null && dt.Rows.Count > 0)
{
id = (dt.Rows[0]["maxID"].ToString());
}
if (id.Length < initialValue.Length)
{
int prefixZero = initialValue.Length - id.Length;
string _prefix = "";
for (int i = 0; i < prefixZero; i++)
{
_prefix += "0";
}
id = _prefix + id;
}
maxId = prefix + id;
return(maxId);
}
private void UnApprovedPaymentVoucherList()
{
string invoiceId = Request.QueryString["invoiceId"].ToString();
string query = @"exec rptUnApprovedPaymentList";
oResult = oDAL.Select(query);
DataTable dt = null;
dt = oResult.Data as DataTable;
ReportViewer1.ProcessingMode = ProcessingMode.Local;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Report/RPT/UnApprovedPaymentList.rdlc");
ReportDataSource datasource = new ReportDataSource("dsrptUnApprovedPaymentList", dt);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(datasource);
}