// string con = ConfigurationManager.ConnectionStrings["TransportMandiConnectionString"].ConnectionString;
#endregion
#region Page Load...
protected void Page_Load(object sender, EventArgs e)
{
if (Request.UrlReferrer == null)
{
base.AutoRedirect();
}
txtRcptNo.Attributes.Add("onkeypress", "return allowAlphabetAndNumer(event);");
txtGrDateto.Attributes.Add("onkeypress", "return notAllowAnything(event);");
txtGrDatefrom.Attributes.Add("onkeypress", "return notAllowAnything(event);");
if (!Page.IsPostBack)
{
this.BindDateRange();
ddldateRange.SelectedIndex = 0;
ddldateRange_SelectedIndexChanged(null, null);
this.BindCity();
RcvdAmntAgnstGRDAL obj = new RcvdAmntAgnstGRDAL();
DateTime? dtfrom = null;
DateTime? dtto = null;
Int64 GrNo = Convert.ToInt64((txtRcptNo.Text) == "" ? "0" : txtRcptNo.Text);
if (string.IsNullOrEmpty(Convert.ToString(txtGrDatefrom.Text)) == false)
{
dtfrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtGrDatefrom.Text));
}
if (string.IsNullOrEmpty(Convert.ToString(txtGrDatefrom.Text)) == false)
{
dtto = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtGrDateto.Text));
}
int cityfrom = Convert.ToInt32((drpCityFrom.SelectedIndex != -1) ? "0" : drpCityFrom.SelectedValue);
var lstGridData = obj.search(Convert.ToInt32(ddldateRange.SelectedValue), GrNo, dtfrom, dtto, cityfrom);
obj = null;
if (lstGridData != null && lstGridData.Count > 0)
{
lblTotalRecord.Text = "Total Record (s): " + lstGridData.Count;
}
}
}
private void BindGrid()
{
RcvdAmntAgnstGRDAL obj = new RcvdAmntAgnstGRDAL();
DateTime? dtfrom = null;
DateTime? dtto = null;
Int64 GrNo = Convert.ToInt64((txtRcptNo.Text) == "" ? "0" : txtRcptNo.Text);
if (string.IsNullOrEmpty(Convert.ToString(txtGrDatefrom.Text)) == false)
{
dtfrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtGrDatefrom.Text));
}
if (string.IsNullOrEmpty(Convert.ToString(txtGrDatefrom.Text)) == false)
{
dtto = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtGrDateto.Text));
}
int cityfrom = Convert.ToInt32((drpCityFrom.SelectedIndex == 0) ? "0" : drpCityFrom.SelectedValue);
var lstGridData = obj.search(Convert.ToInt32(ddldateRange.SelectedValue), GrNo, dtfrom, dtto, cityfrom);
obj = null;
if (lstGridData != null && lstGridData.Count > 0)
{
DataTable dt = new DataTable();
dt.Columns.Add("SrNo", typeof(string));
dt.Columns.Add("RecpNo", typeof(string));
dt.Columns.Add("Date", typeof(string));
dt.Columns.Add("FromCity", typeof(string));
dt.Columns.Add("Party", typeof(string));
dt.Columns.Add("NetAmount", typeof(string));
double TNet = 0; double TAmnt = 0;
for (int i = 0; i < lstGridData.Count; i++)
{
DataRow dr = dt.NewRow();
dr["SrNo"] = Convert.ToString(i + 1);
dr["RecpNo"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Rcpt_No"));
dr["Date"] = Convert.ToDateTime(DataBinder.Eval(lstGridData[i], "Rcpt_date")).ToString("dd-MM-yyyy");
dr["FromCity"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "FromCity"));
dr["Party"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Acnt_Name"));
dr["NetAmount"] = Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Net_Amnt")).ToString("N2");
dt.Rows.Add(dr);
TNet += Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Net_Amnt"));
if (i == lstGridData.Count - 1)
{
DataRow drr = dt.NewRow();
drr["Party"] = "Total";
drr["NetAmount"] = (TNet).ToString("N2");
dt.Rows.Add(drr);
lblNetTotalAmount.Text = TNet.ToString("N2");
}
}
if (dt != null && dt.Rows.Count > 0)
{
ViewState["Dt"] = dt;
}
//
grdMain.DataSource = lstGridData;
grdMain.DataBind();
lblTotalRecord.Text = "Total Record (s): " + lstGridData.Count;
imgBtnExcel.Visible = true;
int startRowOnPage = (grdMain.PageIndex * grdMain.PageSize) + 1;
int lastRowOnPage = startRowOnPage + grdMain.Rows.Count - 1;
lblcontant.Text = "Showing " + startRowOnPage.ToString() + " - " + lastRowOnPage.ToString() + " of " + lstGridData.Count.ToString();
lblcontant.Visible = true;
divpaging.Visible = true;
}
else
{
grdMain.DataSource = null;
grdMain.DataBind();
lblTotalRecord.Text = "Total Record (s): 0 ";
divpaging.Visible = false;
imgBtnExcel.Visible = false;
}
}