private void LoadGrid()
{
try
{
DataSet dsStatement = sqlobj.ExecuteSP("SP_ScheduleSummary ",
new SqlParameter()
{
ParameterName = "@FromDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpfordate.SelectedDate
},
new SqlParameter()
{
ParameterName = "@ToDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpuntildate.SelectedDate
}
);
if (dsStatement.Tables[0].Rows.Count > 0)
{
ReportList.DataSource = dsStatement;
ReportList.DataBind();
}
dsStatement.Dispose();
}
catch (Exception ex)
{
WebMsgBox.Show(ex.Message);
}
}
protected void LoadGrid()
{
SqlProcsNew proc = new SqlProcsNew();
DataSet dsGrid = new DataSet();
dsGrid = proc.ExecuteSP("SP_GetMobAppDinersList",
new SqlParameter()
{
ParameterName = "@iMode", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.Int, Value = 1
},
new SqlParameter()
{
ParameterName = "@FromDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpfordate.SelectedDate
},
new SqlParameter()
{
ParameterName = "@ToDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpuntildate.SelectedDate
});
if (dsGrid != null && dsGrid.Tables.Count > 0 && dsGrid.Tables[0].Rows.Count > 0)
{
ReportList.DataSource = dsGrid.Tables[0];
ReportList.DataBind();
}
else
{
ReportList.DataSource = new String[] { };
ReportList.DataBind();
}
}
protected void BtnShow_Click(object sender, EventArgs e)
{
try
{
ReportList.Visible = true;
string strrsnfilter = cmbResident.SelectedItem.Text;
if (cmbResident.SelectedValue != "0" && cmbResident.SelectedValue != "1")
{
rdTrailBal.Visible = false;
string[] custrsn = strrsnfilter.Split(',');
Session["RName"] = custrsn[0].ToString();
lblClosingbal.Visible = true;
lblClosingbalval.Visible = true;
//LoadGrid1();
LoadOtherDet();
}
else if (cmbResident.SelectedValue != "0" && cmbResident.SelectedValue == "1")
{
LoadGrid1();
}
else
{
ReportList.DataSource = string.Empty;
ReportList.DataBind();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "alert", "alert('There is no Transaction for selected date range!');", true);
}
}
catch (Exception ex)
{
WebMsgBox.Show(ex.ToString());
}
}
private void LoadStockSummaryReport()
{
try
{
DataSet dsStockTransaction = sqlobj.ExecuteSP("SP_StockDailySummary",
new SqlParameter()
{
ParameterName = "@Group", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.NVarChar, Value = ddlGroup.SelectedValue == "All" ? null : ddlGroup.SelectedValue
},
new SqlParameter()
{
ParameterName = "@Date", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpfordate.SelectedDate
}
);
if (dsStockTransaction.Tables[0].Rows.Count > 0)
{
ReportList.DataSource = dsStockTransaction;
ReportList.DataBind();
}
else
{
ReportList.DataSource = string.Empty;
ReportList.DataBind();
}
}
catch (Exception ex)
{
WebMsgBox.Show(ex.Message);
}
}
private void BindData()
{
ReportBLL reportBL = new ReportBLL(connectionString);
ReportList.DataSource = reportBL.GetReportInventory();
ReportList.DataBind();
}
protected void LoadGrid()
{
try
{
SqlProcsNew sqlobj = new SqlProcsNew();
DataSet dsGroup = null;
dsGroup = sqlobj.ExecuteSP("SP_DiningHealthCheck",
new SqlParameter()
{
ParameterName = "@IMODE", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.Int, Value = 1
},
new SqlParameter()
{
ParameterName = "@BillPeriod", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.Decimal, Value = Convert.ToDecimal(ddlBilling.SelectedValue)
},
new SqlParameter()
{
ParameterName = "@Type", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.NVarChar, Value = Convert.ToDecimal(ddlType.SelectedValue)
});
ReportList.DataSource = dsGroup.Tables[0];
ReportList.DataBind();
dsGroup.Dispose();
txtHSTot.Text = "Confirmation Pending (" + dsGroup.Tables[1].Rows[0]["TotCnt"].ToString() + ")";
}
catch (Exception ex)
{
WebMsgBox.Show(ex.Message.ToString());
}
}
private void LoadUsageBilling()
{
try
{
DataSet dsStatement = sqlobj.ExecuteSP("SP_DailyUsageBilling ",
new SqlParameter()
{
ParameterName = "@FromDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpfordate.SelectedDate
},
new SqlParameter()
{
ParameterName = "@ToDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpuntildate.SelectedDate
}
);
if (dsStatement.Tables[0].Rows.Count > 0)
{
ReportList.DataSource = dsStatement;
ReportList.DataBind();
}
else
{
ReportList.DataSource = string.Empty;
ReportList.DataBind();
}
}
catch (Exception ex)
{
WebMsgBox.Show(ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!IsPostBack)
{
LoadTitle();
ReportList.DataSource = string.Empty;
ReportList.DataBind();
DateTime sd = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
dtpfordate.SelectedDate = sd;
dtpuntildate.SelectedDate = DateTime.Now;
lbltotdebitcredit.Text = "";
}
}
catch (Exception ex)
{
WebMsgBox.Show(ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
SqlProcsNew proc = new SqlProcsNew();
DataSet dsDT = null;
if (!IsPostBack)
{
LoadTitle();
CheckPermission();
dsDT = proc.ExecuteSP("GetServerDateTime");
// LoadBillingPeriod();
//ddlBillingPeriod.SelectedValue = Session["CurrentBillingPeriod"].ToString();
ReportList.Visible = false;
ReportListAll.Visible = false;
ReportList.DataSource = string.Empty;
ReportList.DataBind();
DateTime sd = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
dtpfordate.SelectedDate = sd;
dtpuntildate.SelectedDate = DateTime.Now;
lbltotdebitcredit.Text = "";
LoadResidentDet();
LoadSessionFilter();
LoadAccountNo();
LoadDate();
//LoadGrid1();
}
}
protected void LoadGrid1()
{
SqlCommand cmd = new SqlCommand("[SP_FetchGBilledTransaction]", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@BCode ", SqlDbType.NVarChar).Value = ddlSession.SelectedValue;
cmd.Parameters.Add("@TxnDate", SqlDbType.DateTime).Value = BillingDate.SelectedDate;
DataSet dsGrid = new DataSet();
ReportList.DataBind();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dsGrid);
if (dsGrid != null && dsGrid.Tables.Count > 0 && dsGrid.Tables[0].Rows.Count > 0)
{
ReportList.DataSource = dsGrid.Tables[0];
ReportList.DataBind();
ReportList.AllowPaging = true;
lblTotalAmt.Text = "Total Amount : " + dsGrid.Tables[1].Rows[0]["TotAmount"].ToString();
}
else
{
ReportList.DataSource = new String[] { };
ReportList.DataBind();
}
}
private void GetMail()
{
string receiverid = Request.Cookies["id"].Value.ToString();
string mailtype = "开题材料";
Fannie.Mail ml = new Fannie.Mail();
DataTable dt = new DataTable();
DataSet ds = ml.GetMail("2", receiverid, mailtype);
DataColumn dc = new DataColumn();
dc.ColumnName = "DataNo";
ds.Tables[0].Columns.Add(dc);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
ds.Tables[0].Rows[i]["DataNo"] = (i + 1).ToString();
}
ReportList.DataKeyNames = new string[] { "MailNo" };
ReportList.DataSource = ds;
ReportList.DataBind();
dt = ds.Tables[0];
if (dt.Rows.Count == 0)
{
Label1.Visible = true;
}
else
{
Label1.Visible = false;
}
}
protected void BtnShow_Click(object sender, EventArgs e)
{
try
{
string strrsnfilter = cmbResident.SelectedItem.Text;
if (cmbResident.SelectedValue != "0")
{
rdTrailBal.Visible = false;
string[] custrsn = strrsnfilter.Split(',');
Session["RName"] = custrsn[0].ToString();
ReportList.DataSource = string.Empty;
ReportList.DataBind();
LoadGrid1();
}
if (cmbResident.SelectedValue == "0")
{
string STR = cmbResident.SelectedValue;
DataSet dsStatement = new DataSet();
dsStatement = sqlobj.ExecuteSP("SP_DayBookData",
new SqlParameter()
{
ParameterName = "@IMode", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.Int, Value = 1
},
new SqlParameter()
{
ParameterName = "@FromDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpfordate.SelectedDate
},
new SqlParameter()
{
ParameterName = "@ToDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpuntildate.SelectedDate
}
);
Session["Exportexcel"] = null;
if (dsStatement.Tables[0].Rows.Count > 0)
{
ReportList.DataSource = dsStatement.Tables[0];
ReportList.DataBind();
Session["Exportexcel"] = dsStatement.Tables[0];
}
else
{
ReportList.DataSource = string.Empty;
ReportList.DataBind();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "alert", "alert('No data for your selection, Please try again for some other details.');", true);
return;
}
dsStatement.Dispose();
}
}
catch (Exception ex)
{
WebMsgBox.Show(ex.ToString());
}
}
protected void LoadAccountLedger()
{
try
{
DataSet dsCategory = sqlobj.ExecuteSP("SP_AccountMaster",
new SqlParameter()
{
ParameterName = "@IMode", SqlDbType = SqlDbType.Int, Value = 3
});
if (dsCategory.Tables[0].Rows.Count > 0)
{
ReportList.DataSource = dsCategory.Tables[0];
ReportList.DataBind();
lblCount.Text = "Count :" + dsCategory.Tables[0].Rows.Count.ToString();
Session["ExportExcel"] = null;
Session["ExportExcel"] = dsCategory.Tables[0];
BtnnExcelExport.Visible = true;
}
else
{
ReportList.DataSource = string.Empty;
ReportList.DataBind();
}
dsCategory.Dispose();
}
catch (Exception ex)
{
WebMsgBox.Show(ex.Message);
}
}
protected void LoadGrid1()
{
try
{
string STR = cmbResident.SelectedValue;
DataSet dsStatement = new DataSet();
if (cmbResident.SelectedValue != "0")
{
dsStatement = sqlobj.ExecuteSP("SP_SOAGeneralTransactions",
new SqlParameter()
{
ParameterName = "@IMode", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.Int, Value = 1
},
new SqlParameter()
{
ParameterName = "@FromDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpfordate.SelectedDate
},
new SqlParameter()
{
ParameterName = "@ToDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpuntildate.SelectedDate
},
new SqlParameter()
{
ParameterName = "@AccountCode", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.NVarChar, Value = lblAccountCode.Text.ToString()
}
);
}
Session["Exportexcel"] = null;
if (dsStatement.Tables[0].Rows.Count > 0)
{
//int rowindex = Convert.ToInt32(dsStatement.Tables[0].Rows.Count - 1);
//lblClosingbalval.Visible = true;
//lblClosingbal.Visible = true;
//lblClosingbalval.Text = dsStatement.Tables[0].Rows[rowindex]["Closing"].ToString();
ReportList.DataSource = dsStatement;
ReportList.DataBind();
Session["Exportexcel"] = dsStatement.Tables[0];
}
else
{
ReportList.DataSource = string.Empty;
ReportList.DataBind();
}
//if (dsStatement.Tables[1].Rows.Count > 0)
//{
// lblDebitCnt.Text = dsStatement.Tables[1].Rows[0]["DR"].ToString();
//}
//if (dsStatement.Tables[2].Rows.Count > 0)
//{
// lblCreditcnt.Text = dsStatement.Tables[2].Rows[0]["CR"].ToString();
//}
dsStatement.Dispose();
}
catch (Exception ex)
{
WebMsgBox.Show(ex.Message);
}
}
protected void LoadGrid1()
{
try
{
string STR = cmbResident.SelectedValue;
DataSet dsStatement = new DataSet();
if (cmbResident.SelectedValue != "0")
{
dsStatement = sqlobj.ExecuteSP("SP_SOAGeneralTransactions",
new SqlParameter()
{
ParameterName = "@IMode", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.Int, Value = 1
},
new SqlParameter()
{
ParameterName = "@FromDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpfordate.SelectedDate
},
new SqlParameter()
{
ParameterName = "@ToDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpuntildate.SelectedDate
},
new SqlParameter()
{
ParameterName = "@AccountCode", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.NVarChar, Value = lblAccountCode.Text.ToString()
}
);
}
Session["Exportexcel"] = null;
if (dsStatement.Tables[0].Rows.Count > 0)
{
ReportList.DataSource = dsStatement;
ReportList.DataBind();
Session["Exportexcel"] = dsStatement.Tables[0];
}
else
{
ReportList.DataSource = string.Empty;
ReportList.DataBind();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "alert", "alert('No data for your selection, Please try again for some other details.');", true);
return;
}
//if (dsStatement.Tables[1].Rows.Count > 0)
//{
// lblDebitCnt.Text = dsStatement.Tables[1].Rows[0]["DR"].ToString();
//}
//if (dsStatement.Tables[2].Rows.Count > 0)
//{
// lblCreditcnt.Text = dsStatement.Tables[2].Rows[0]["CR"].ToString();
//}
dsStatement.Dispose();
}
catch (Exception ex)
{
WebMsgBox.Show(ex.Message);
}
}
protected void LoadGrid1()
{
try
{
string STR = cmbResident.SelectedValue;
DataSet dsStatement = new DataSet();
if (cmbResident.SelectedValue != "0" && ddlAccountNumber.SelectedValue != "0")
{
dsStatement = sqlobj.ExecuteSP("SP_SOAGeneralTransactions",
new SqlParameter()
{
ParameterName = "@IMode", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.Int, Value = 1
},
new SqlParameter()
{
ParameterName = "@FromDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpfordate.SelectedDate
},
new SqlParameter()
{
ParameterName = "@ToDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpuntildate.SelectedDate
},
new SqlParameter()
{
ParameterName = "@AccountCode", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.NVarChar, Value = ddlAccountNumber.SelectedValue
});
}
if (dsStatement.Tables[0].Rows.Count > 0)
{
ReportList.DataSource = dsStatement;
ReportList.DataBind();
}
else
{
ReportList.DataSource = string.Empty;
ReportList.DataBind();
}
dsStatement.Dispose();
}
catch (Exception ex)
{
WebMsgBox.Show(ex.Message);
}
}
private void bindReportList()
{
OracleQuery2 cc2 = new OracleQuery2();
DataTable dt = cc2.LoadReport();
ReportList.DataSource = dt;
ReportList.DataTextField = "REPORT_NAME";
ReportList.DataValueField = "REPORT_ID";
ReportList.DataBind();
ReportList.Items.Insert(0, new ListItem("--เลือกรายงาน--", "-1"));
ReportList.SelectedIndex = 0;
//ReportList.Items.FindByValue("4").Enabled = false;
}
private void BindData()
{
ReportBLL ReportBL = new ReportBLL(connectionString);
List <ReportViewModel> incident_reports = ReportBL.GetIncidentReportInventory();
foreach (ReportViewModel model in incident_reports)
{
model.Name = GetCarNameFromCarID(model.CarID);
string[] date_element = model.DateOfIncident.Split(' ');
model.DateOfIncident = date_element[0];
}
ReportList.DataSource = incident_reports;
ReportList.DataBind();
}
protected void cmbResident_SelectedIndexChanged(object sender, RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
lblname.Text = cmbResident.SelectedItem.Text;
ReportList.Visible = false;
ReportList.DataSource = string.Empty;
ReportList.DataBind();
ReportListAll.Visible = false;
ReportListAll.DataSource = string.Empty;
ReportListAll.DataBind();
if (cmbResident.SelectedValue == "0")
{
ddlAccountNumber.Items.Clear();
ddlAccountNumber.Items.Add(new ListItem("All", "0"));
//ddlAccountNumber.Items.Add("G1000000");
//ddlAccountNumber.Items.Add("D1000000");
}
else
{
DataSet dsResident = new DataSet();
DataSet ds = new DataSet();
dsResident = sqlobj.ExecuteSP("SP_GenDropDownList",
new SqlParameter()
{
ParameterName = "@iMode", SqlDbType = SqlDbType.Int, Value = 11
},
new SqlParameter()
{
ParameterName = "@RTRSN", SqlDbType = SqlDbType.Decimal, Value = cmbResident.SelectedValue
});
ddlAccountNumber.DataSource = dsResident.Tables[0];
ddlAccountNumber.DataValueField = "AccountNo";
ddlAccountNumber.DataTextField = "AccountNo";
ddlAccountNumber.DataBind();
LoadOtherDet();
ReportList.DataSource = string.Empty;
ReportList.DataBind();
}
}
catch (Exception ex)
{
}
}
protected void LoadGrid()
{
try
{
string STR = cmbResident.SelectedValue;
DataSet dsStatement = new DataSet();
dsStatement = sqlobj.ExecuteSP("SP_DayBookData",
new SqlParameter()
{
ParameterName = "@IMode", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.Int, Value = 2
},
new SqlParameter()
{
ParameterName = "@FromDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpfordate.SelectedDate
},
new SqlParameter()
{
ParameterName = "@ToDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpuntildate.SelectedDate
}
);
Session["Exportexcel"] = null;
if (dsStatement.Tables[0].Rows.Count > 0)
{
ReportList.DataSource = dsStatement;
ReportList.DataBind();
Session["Exportexcel"] = dsStatement.Tables[0];
}
else
{
ReportList.DataSource = string.Empty;
ReportList.DataBind();
}
dsStatement.Dispose();
}
catch (Exception ex)
{
WebMsgBox.Show(ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
SqlProcsNew proc = new SqlProcsNew();
DataSet dsDT = null;
if (!IsPostBack)
{
ReportList.Visible = false;
LoadTitle();
CheckPermission();
dsDT = proc.ExecuteSP("GetServerDateTime");
ReportList.DataSource = string.Empty;
ReportList.DataBind();
//DateTime sd = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
//dtpfordate.SelectedDate = sd;
//dtpuntildate.SelectedDate = DateTime.Now;
LoadDate();
LoadResidentDet();
}
}
protected void cmbResident_SelectedIndexChanged(object sender, RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
ReportList.Visible = false;
ReportList.DataSource = string.Empty;
ReportList.DataBind();
if (cmbResident.SelectedValue != "0")
{
DataSet dsResident = new DataSet();
dsResident = sqlobj.ExecuteSP("SP_GeneralTransactions",
new SqlParameter()
{
ParameterName = "@IMode", SqlDbType = SqlDbType.Int, Value = 2
},
new SqlParameter()
{
ParameterName = "@AccountsMRSN", SqlDbType = SqlDbType.Decimal, Value = cmbResident.SelectedValue
});
if (cmbResident.SelectedValue != "0" && cmbResident.SelectedValue != "1")
{
lblAccountCode.Text = dsResident.Tables[0].Rows[0]["AccountCode"].ToString();
}
else if (cmbResident.SelectedValue != "0" && cmbResident.SelectedValue == "1")
{
lblAccountCode.Text = cmbResident.SelectedValue.ToString();
}
else
{
lblAccountCode.Text = cmbResident.SelectedValue.ToString();
}
dsResident.Dispose();
LoadOtherDet();
}
}
catch (Exception ex)
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
LoadTitle();
LoadProvisionGroup();
LoadTransactionType();
ReportList.DataSource = string.Empty;
ReportList.DataBind();
ReportSummary.DataSource = string.Empty;
ReportSummary.DataBind();
DateTime sd = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
dtpfordate.SelectedDate = sd;
dtpuntildate.SelectedDate = DateTime.Now;
}
}
protected void Page_Load(object sender, EventArgs e)
{
SqlProcsNew proc = new SqlProcsNew();
DataSet dsDT = null;
if (!IsPostBack)
{
LoadTitle();
CheckPermission();
dsDT = proc.ExecuteSP("GetServerDateTime");
// LoadBillingPeriod();
//ddlBillingPeriod.SelectedValue = Session["CurrentBillingPeriod"].ToString();
ReportList.DataSource = string.Empty;
ReportList.DataBind();
rgDiningSummaryBills.DataSource = string.Empty;
rgDiningSummaryBills.DataBind();
rgTCMBillSummary.DataSource = string.Empty;
rgTCMBillSummary.DataBind();
DateTime sd = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
dtpfordate.SelectedDate = sd;
dtpuntildate.SelectedDate = DateTime.Now;
LoadResidentDet();
LoadAccountNo();
//LoadGrid1();
}
}
private void BindValues()
{
EntityObject[] reports = BusinessManager.List(ReportEntity.GetAssignedMetaClassName(), new FilterElementCollection().ToArray());
if (reports != null && reports.Length > 0)
{
ReportList.DataSource = reports;
ReportList.DataBind();
ControlPropertiesBase properties = ControlProperties.Provider;
if (properties.GetValue(this.ID, keyReport) != null)
{
CommonHelper.SafeSelect(ReportList, (string)properties.GetValue(this.ID, keyReport));
}
ReportsRow.Visible = true;
NoReportsRow.Visible = false;
}
else
{
ReportsRow.Visible = false;
NoReportsRow.Visible = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
SqlProcsNew proc = new SqlProcsNew();
DataSet dsDT = null;
rwTransactions.VisibleOnPageLoad = true;
rwTransactions.Visible = false;
rdMEB.VisibleOnPageLoad = true;
rdMEB.Visible = false;
DataTable dt = new DataTable();
if (!IsPostBack)
{
LoadTitle();
dsDT = proc.ExecuteSP("GetServerDateTime");
ReportList.DataSource = string.Empty;
ReportList.DataBind();
DateTime sd = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
LoadBilling();
LoadTrailBalance();
ReportList.Visible = false;
BtnnExcelExport.Visible = false;
}
}
protected void LoadGrid1()
{
try
{
string STR = cmbResident.SelectedValue;
DataSet dsStatement = new DataSet();
//DataSet dsStatement = sqlobj.ExecuteSP("SP_GetStatementofAccount",
// new SqlParameter() { ParameterName = "@RTRSN", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.BigInt, Value = Convert.ToInt32(cmbResident.SelectedValue.ToString()) },
// new SqlParameter() { ParameterName = "@FromDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpfordate.SelectedDate },
// new SqlParameter() { ParameterName = "@ToDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpuntildate.SelectedDate },
// new SqlParameter() { ParameterName = "@AcccountNo", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.NVarChar, Value = ddlAccountNumber.SelectedValue});
if (cmbResident.SelectedValue == "0" && ddlAccountNumber.SelectedValue == "0")
{
dsStatement = sqlobj.ExecuteSP("SP_GetStatementofAccount",
new SqlParameter()
{
ParameterName = "@iMode", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.Int, Value = 1
},
new SqlParameter()
{
ParameterName = "@FromDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpfordate.SelectedDate
},
new SqlParameter()
{
ParameterName = "@ToDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpuntildate.SelectedDate
},
new SqlParameter()
{
ParameterName = "@RTRSN", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.Decimal, Value = 1
},
new SqlParameter()
{
ParameterName = "@AccountNo", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.NVarChar, Value = "NA"
});
}
else if (cmbResident.SelectedValue == "0" && ddlAccountNumber.SelectedValue == "1")
{
dsStatement = sqlobj.ExecuteSP("SP_GetStatementofAccount",
new SqlParameter()
{
ParameterName = "@iMode", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.Int, Value = 2
},
new SqlParameter()
{
ParameterName = "@FromDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpfordate.SelectedDate
},
new SqlParameter()
{
ParameterName = "@ToDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpuntildate.SelectedDate
},
new SqlParameter()
{
ParameterName = "@RTRSN", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.Decimal, Value = cmbResident.SelectedValue
},
new SqlParameter()
{
ParameterName = "@AccountNo", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.NVarChar, Value = ddlAccountNumber.SelectedValue
});
}
else if (cmbResident.SelectedValue == "0" && ddlAccountNumber.SelectedValue == "2")
{
dsStatement = sqlobj.ExecuteSP("SP_GetStatementofAccount",
new SqlParameter()
{
ParameterName = "@iMode", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.Int, Value = 3
},
new SqlParameter()
{
ParameterName = "@FromDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpfordate.SelectedDate
},
new SqlParameter()
{
ParameterName = "@ToDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpuntildate.SelectedDate
},
new SqlParameter()
{
ParameterName = "@RTRSN", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.Decimal, Value = cmbResident.SelectedValue
},
new SqlParameter()
{
ParameterName = "@AccountNo", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.NVarChar, Value = ddlAccountNumber.SelectedValue
});
}
else if (cmbResident.SelectedValue != "0" && ddlAccountNumber.SelectedValue == "0")
{
dsStatement = sqlobj.ExecuteSP("SP_GetStatementofAccount",
new SqlParameter()
{
ParameterName = "@iMode", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.Int, Value = 4
},
new SqlParameter()
{
ParameterName = "@FromDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpfordate.SelectedDate
},
new SqlParameter()
{
ParameterName = "@ToDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpuntildate.SelectedDate
},
new SqlParameter()
{
ParameterName = "@RTRSN", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.Decimal, Value = cmbResident.SelectedValue
},
new SqlParameter()
{
ParameterName = "@AccountNo", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.NVarChar, Value = ddlAccountNumber.SelectedValue
});
}
else if (cmbResident.SelectedValue != "0" && ddlAccountNumber.SelectedValue != "0")
{
dsStatement = sqlobj.ExecuteSP("SP_GetStatementofAccount",
new SqlParameter()
{
ParameterName = "@iMode", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.Int, Value = 5
},
new SqlParameter()
{
ParameterName = "@FromDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpfordate.SelectedDate
},
new SqlParameter()
{
ParameterName = "@ToDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpuntildate.SelectedDate
},
new SqlParameter()
{
ParameterName = "@RTRSN", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.Decimal, Value = cmbResident.SelectedValue
},
new SqlParameter()
{
ParameterName = "@AccountNo", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.NVarChar, Value = ddlAccountNumber.SelectedValue
});
}
ReportList.DataSource = dsStatement;
ReportList.DataBind();
//if (dsStatement.Tables[0].Rows.Count > 0)
//{
// ReportList.DataSource = dsStatement;
// ReportList.DataBind();
//}
dsStatement.Dispose();
//DataSet dsgetoutstanding = sqlobj.ExecuteSP("SP_GetResidentOutStanding",
// new SqlParameter() { ParameterName = "@RSN", SqlDbType = SqlDbType.BigInt, Value = rtrsn.ToString() });
//if (dsgetoutstanding.Tables[0].Rows.Count > 0)
//{
// decimal os = Convert.ToDecimal(dsgetoutstanding.Tables[0].Rows[0]["OutStanding2"].ToString());
// string sos = "0";
// if (os < 0)
// {
// os = Math.Abs(os);
// sos = os.ToString() + "CR";
// }
// else
// {
// sos = os.ToString();
// }
// lbloutstanding.Text = DateTime.Now.ToString("dd-MM-yyyy HH:mm") + " Current Outstandings as of now :" + sos.ToString();
// Session["Rstatus"] = dsgetoutstanding.Tables[0].Rows[0]["Status"].ToString();
// Session["RDescription"] = dsgetoutstanding.Tables[0].Rows[0]["sDescription"].ToString();
//}
//if (dsgetoutstanding.Tables[1].Rows.Count > 0)
//{
// lbldepositamount.Text = "Deposit Amount : " + dsgetoutstanding.Tables[1].Rows[0]["DepositAmount"].ToString();
//}
//dsgetoutstanding.Dispose();
}
catch (Exception ex)
{
WebMsgBox.Show(ex.Message);
}
}
protected void chkstatus_CheckedChanged(object sender, EventArgs e)
{
DataSet dsStatement = new DataSet();
if (chkstatus.Checked == true)
{
if (cmbResident.SelectedValue == "0")
{
dsStatement = sqlobj.ExecuteSP("SP_GetUnbilledTransactions",
new SqlParameter()
{
ParameterName = "@iMode", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.Int, Value = 3
},
new SqlParameter()
{
ParameterName = "@FromDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpfordate.SelectedDate
},
new SqlParameter()
{
ParameterName = "@ToDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpuntildate.SelectedDate
},
new SqlParameter()
{
ParameterName = "@RTRSN", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.Decimal, Value = 1
},
new SqlParameter()
{
ParameterName = "@AccountNo", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.NVarChar, Value = "NA"
});
}
else if (cmbResident.SelectedValue != "0")
{
dsStatement = sqlobj.ExecuteSP("SP_GetUnbilledTransactions",
new SqlParameter()
{
ParameterName = "@iMode", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.Int, Value = 4
},
new SqlParameter()
{
ParameterName = "@FromDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpfordate.SelectedDate
},
new SqlParameter()
{
ParameterName = "@ToDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpuntildate.SelectedDate
},
new SqlParameter()
{
ParameterName = "@RTRSN", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.Decimal, Value = cmbResident.SelectedValue
},
new SqlParameter()
{
ParameterName = "@AccountNo", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.NVarChar, Value = ddlAccountNumber.SelectedValue
});
}
}
if (chkstatus.Checked == false)
{
if (cmbResident.SelectedValue == "0")
{
dsStatement = sqlobj.ExecuteSP("SP_GetUnbilledTransactions",
new SqlParameter()
{
ParameterName = "@iMode", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.Int, Value = 1
},
new SqlParameter()
{
ParameterName = "@FromDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpfordate.SelectedDate
},
new SqlParameter()
{
ParameterName = "@ToDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpuntildate.SelectedDate
},
new SqlParameter()
{
ParameterName = "@RTRSN", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.Decimal, Value = 1
},
new SqlParameter()
{
ParameterName = "@AccountNo", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.NVarChar, Value = "NA"
});
}
else if (cmbResident.SelectedValue != "0")
{
dsStatement = sqlobj.ExecuteSP("SP_GetUnbilledTransactions",
new SqlParameter()
{
ParameterName = "@iMode", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.Int, Value = 2
},
new SqlParameter()
{
ParameterName = "@FromDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpfordate.SelectedDate
},
new SqlParameter()
{
ParameterName = "@ToDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpuntildate.SelectedDate
},
new SqlParameter()
{
ParameterName = "@RTRSN", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.Decimal, Value = cmbResident.SelectedValue
},
new SqlParameter()
{
ParameterName = "@AccountNo", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.NVarChar, Value = ddlAccountNumber.SelectedValue
});
}
}
if (dsStatement.Tables[0].Rows.Count > 0)
{
LoadOtherDet();
ReportList.DataSource = dsStatement;
ReportList.DataBind();
ReportListAll.DataSource = dsStatement;
ReportListAll.DataBind();
lblDebitCnt.Text = Convert.ToString(dsStatement.Tables[0].Rows.Count);
}
else
{
lblDebitCnt.Visible = false;
lblCreditcnt.Visible = false;
lblTCt.Visible = false;
lblLatTxnDt.Visible = false;
lblTDt.Visible = false;
lblTCt.Visible = false;
Label5.Visible = false;
Label6.Visible = false;
Label8.Visible = false;
Label10.Visible = false;
Label11.Visible = false;
ReportList.DataSource = string.Empty;
ReportList.DataBind();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "alert", "alert('No record for your selected date range.');", true);
}
//if (dsStatement.Tables[0].Rows.Count > 0)
//{
// ReportList.DataSource = dsStatement;
// ReportList.DataBind();
//}
dsStatement.Dispose();
}
protected void LoadGrid1()
{
try
{
drpSessionfilters.SelectedValue = "0";
string STR = cmbResident.SelectedValue;
DataSet dsStatement = new DataSet();
if (chkstatus.Checked == true)
{
if (cmbResident.SelectedValue == "0")
{
dsStatement = sqlobj.ExecuteSP("SP_GetUnbilledTransactions",
new SqlParameter()
{
ParameterName = "@iMode", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.Int, Value = 3
},
new SqlParameter()
{
ParameterName = "@FromDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpfordate.SelectedDate
},
new SqlParameter()
{
ParameterName = "@ToDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpuntildate.SelectedDate
},
new SqlParameter()
{
ParameterName = "@RTRSN", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.Decimal, Value = 1
},
new SqlParameter()
{
ParameterName = "@AccountNo", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.NVarChar, Value = "NA"
});
}
else if (cmbResident.SelectedValue != "0")
{
dsStatement = sqlobj.ExecuteSP("SP_GetUnbilledTransactions",
new SqlParameter()
{
ParameterName = "@iMode", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.Int, Value = 4
},
new SqlParameter()
{
ParameterName = "@FromDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpfordate.SelectedDate
},
new SqlParameter()
{
ParameterName = "@ToDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpuntildate.SelectedDate
},
new SqlParameter()
{
ParameterName = "@RTRSN", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.Decimal, Value = cmbResident.SelectedValue
},
new SqlParameter()
{
ParameterName = "@AccountNo", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.NVarChar, Value = ddlAccountNumber.SelectedValue
});
}
}
if (chkstatus.Checked == false)
{
if (cmbResident.SelectedValue == "0")
{
dsStatement = sqlobj.ExecuteSP("SP_GetUnbilledTransactions",
new SqlParameter()
{
ParameterName = "@iMode", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.Int, Value = 1
},
new SqlParameter()
{
ParameterName = "@FromDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpfordate.SelectedDate
},
new SqlParameter()
{
ParameterName = "@ToDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpuntildate.SelectedDate
},
new SqlParameter()
{
ParameterName = "@RTRSN", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.Decimal, Value = 1
},
new SqlParameter()
{
ParameterName = "@AccountNo", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.NVarChar, Value = "NA"
});
}
else if (cmbResident.SelectedValue != "0")
{
dsStatement = sqlobj.ExecuteSP("SP_GetUnbilledTransactions",
new SqlParameter()
{
ParameterName = "@iMode", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.Int, Value = 2
},
new SqlParameter()
{
ParameterName = "@FromDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpfordate.SelectedDate
},
new SqlParameter()
{
ParameterName = "@ToDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpuntildate.SelectedDate
},
new SqlParameter()
{
ParameterName = "@RTRSN", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.Decimal, Value = cmbResident.SelectedValue
},
new SqlParameter()
{
ParameterName = "@AccountNo", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.NVarChar, Value = ddlAccountNumber.SelectedValue
});
}
}
if (dsStatement.Tables[0].Rows.Count > 0)
{
LoadOtherDet();
ReportList.DataSource = dsStatement;
ReportList.DataBind();
ReportListAll.DataSource = dsStatement;
ReportListAll.DataBind();
lblDebitCnt.Text = Convert.ToString(dsStatement.Tables[0].Rows.Count);
}
else
{
lblDebitCnt.Visible = false;
lblCreditcnt.Visible = false;
lblTCt.Visible = false;
lblLatTxnDt.Visible = false;
lblTDt.Visible = false;
lblTCt.Visible = false;
Label5.Visible = false;
Label6.Visible = false;
Label8.Visible = false;
Label10.Visible = false;
Label11.Visible = false;
ReportList.DataSource = string.Empty;
ReportList.DataBind();
ReportListAll.DataSource = string.Empty;
ReportListAll.DataBind();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "alert", "alert('No record for your selected date range.');", true);
}
//if (dsStatement.Tables[0].Rows.Count > 0)
//{
// ReportList.DataSource = dsStatement;
// ReportList.DataBind();
//}
dsStatement.Dispose();
DataSet dsdatewise = sqlobj.ExecuteSP("[SP_GetDatewiseDebitCreditTotal]",
new SqlParameter()
{
ParameterName = "@FromDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpfordate.SelectedDate
},
new SqlParameter()
{
ParameterName = "@ToDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpuntildate.SelectedDate
});
if (dsdatewise.Tables[0].Rows.Count > 0)
{
decimal totdebit = Convert.ToDecimal(dsdatewise.Tables[0].Rows[0]["TotalDebit"].ToString());
decimal totcredit = Convert.ToDecimal(dsdatewise.Tables[0].Rows[0]["TotalCredit"].ToString());
decimal FOutstading = totdebit - totcredit;
String SFOutstading;
if (FOutstading < 0)
{
SFOutstading = Convert.ToString(FOutstading * -1) + " CR";
}
else
{
SFOutstading = Convert.ToString(FOutstading);
}
lbltotdebitcredit.Text = "Total Debit:" + totdebit.ToString("0.00") + " Total Credit:" + totcredit.ToString("0.00");
lbltotoutstanding.Text = DateTime.Now.ToString("dd/MM/yyyy HH:mm") + " Total Current Outstanding as of now :" + SFOutstading;
}
dsdatewise.Dispose();
DataSet dsgetdebitcredittoal = sqlobj.ExecuteSP("[SP_GetFTDebitCreditTotal]");
if (dsgetdebitcredittoal.Tables[0].Rows.Count > 0)
{
decimal totdebit = Convert.ToDecimal(dsgetdebitcredittoal.Tables[0].Rows[0]["TotalDebit"].ToString());
decimal totcredit = Convert.ToDecimal(dsgetdebitcredittoal.Tables[0].Rows[0]["TotalCredit"].ToString());
//lbltotoutstanding.Text = DateTime.Now.ToString("dd/MM/yyyy HH:mm") + " Total Current Outstanding as of now :" + (totdebit - totcredit).ToString("0.00");
}
else
{
lbltotdebitcredit.Text = "";
}
dsgetdebitcredittoal.Dispose();
}
catch (Exception ex)
{
WebMsgBox.Show(ex.Message);
}
}
protected void LoadOtherDet()
{
try
{
string STR = cmbResident.SelectedValue;
DataSet dsStatement = new DataSet();
lblDebitCnt.Visible = false;
lblCreditcnt.Visible = false;
lblTCt.Visible = false;
lblLatTxnDt.Visible = false;
lblTDt.Visible = false;
lblTCt.Visible = false;
Label5.Visible = false;
Label6.Visible = false;
Label8.Visible = false;
Label10.Visible = false;
Label11.Visible = false;
if (cmbResident.SelectedValue != "0")
{
dsStatement = sqlobj.ExecuteSP("SP_SOAGeneralTransactions",
new SqlParameter()
{
ParameterName = "@IMode", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.Int, Value = 5
},
new SqlParameter()
{
ParameterName = "@FromDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpfordate.SelectedDate
},
new SqlParameter()
{
ParameterName = "@ToDate", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.DateTime, Value = dtpuntildate.SelectedDate
},
new SqlParameter()
{
ParameterName = "@AccountCode", Direction = ParameterDirection.Input, SqlDbType = SqlDbType.NVarChar, Value = ddlAccountNumber.SelectedValue.ToString()
}
);
if (dsStatement.Tables[1].Rows.Count > 0)
{
//lblDebitCnt.Text = dsStatement.Tables[1].Rows[0]["DR"].ToString();
}
else
{
lblDebitCnt.Text = "-";
}
if (dsStatement.Tables[2].Rows.Count > 0)
{
lblCreditcnt.Text = dsStatement.Tables[2].Rows[0]["CR"].ToString();
}
else
{
lblCreditcnt.Text = "-";
}
//if (dsStatement.Tables[3].Rows.Count > 0)
//{
// lblCategory.Text = dsStatement.Tables[3].Rows[0]["AccountGroup"].ToString();
// lblSubGrp1.Text = dsStatement.Tables[3].Rows[0]["SubGroup1"].ToString();
//}
//else
//{
// lblCategory.Text = "-";
// lblSubGrp1.Text = "-";
//}
if (dsStatement.Tables[3].Rows.Count > 0)
{
lblLatTxnDt.Text = dsStatement.Tables[3].Rows[0]["LastTxn"].ToString();
}
else
{
ReportList.DataSource = string.Empty;
ReportList.DataBind();
lblTCt.Text = "0.00";
lblLatTxnDt.Text = "-";
}
if (dsStatement.Tables[4].Rows.Count > 0)
{
lblTDt.Text = dsStatement.Tables[4].Rows[0]["DR"].ToString();
}
else
{
lblTDt.Text = "0.00";
}
if (dsStatement.Tables[5].Rows.Count > 0)
{
lblTCt.Text = dsStatement.Tables[5].Rows[0]["CR"].ToString();
}
else
{
ReportList.DataSource = string.Empty;
ReportList.DataBind();
lblTCt.Text = "0.00";
}
Label6.Visible = true;
Label8.Visible = true;
Label10.Visible = true;
lblDebitCnt.Visible = true;
lblLatTxnDt.Visible = true;
lblTDt.Visible = true;
dsStatement.Dispose();
}
}
catch (Exception ex)
{
WebMsgBox.Show(ex.Message);
}
}