protected void Sort(string sortExpression, params string[] sortExpr) { DataTable dataTable = Session["data_sms_credit"] as DataTable; if (dataTable != null) { if (Session["sortExpression_sms_credit"] == null) { Session["sortExpression_sms_credit"] = ""; } DataView dataView = new DataView(dataTable); string[] sortData = Session["sortExpression_sms_credit"].ToString().Trim().Split(' '); string newSortExpr = (sortExpr.Length == 0) ? (sortExpression == sortData[0] && sortData[1] == "ASC") ? "DESC" : "ASC" : sortExpr[0]; dataView.Sort = sortExpression + " " + newSortExpr; Session["sortExpression_sms_credit"] = sortExpression + " " + newSortExpr; GrdSMSCredit.DataSource = dataView; GrdSMSCredit.DataBind(); } }
protected void FillGrid() { DataTable dt = SMSCreditDataDB.GetDataTable(); Session["data_sms_credit"] = dt; if (dt.Rows.Count > 0) { if (IsPostBack && Session["sortExpression_sms_credit"] != null && Session["sortExpression_sms_credit"].ToString().Length > 0) { DataView dataView = new DataView(dt); dataView.Sort = Session["sortExpression_sms_credit"].ToString(); GrdSMSCredit.DataSource = dataView; } else { GrdSMSCredit.DataSource = dt; } try { GrdSMSCredit.DataBind(); GrdSMSCredit.PagerSettings.FirstPageText = "1"; GrdSMSCredit.PagerSettings.LastPageText = GrdSMSCredit.PageCount.ToString(); GrdSMSCredit.DataBind(); } catch (Exception ex) { SetErrorMessage(ex.ToString()); } } else { dt.Rows.Add(dt.NewRow()); GrdSMSCredit.DataSource = dt; GrdSMSCredit.DataBind(); int TotalColumns = GrdSMSCredit.Rows[0].Cells.Count; GrdSMSCredit.Rows[0].Cells.Clear(); GrdSMSCredit.Rows[0].Cells.Add(new TableCell()); GrdSMSCredit.Rows[0].Cells[0].ColumnSpan = TotalColumns; GrdSMSCredit.Rows[0].Cells[0].Text = "No Record Found"; } if (hideFotter) { GrdSMSCredit.FooterRow.Visible = false; } decimal credit = SMSCreditDataDB.GetTotal(); decimal used = SMSHistoryDataDB.GetTotal(); lblTotalCredit.Text = credit.ToString("0.00"); lblTotalUsed.Text = used.ToString("0.00"); lblTotalRemaining.Text = (credit - used).ToString("0.00"); DateTime fromDate = IsValidDate(txtStartDate.Text) ? GetDate(txtStartDate.Text) : DateTime.MinValue; DateTime toDate = IsValidDate(txtEndDate.Text) ? GetDate(txtEndDate.Text).Add(new TimeSpan(23, 59, 59)) : DateTime.MinValue; decimal ptRemidners = SMSHistoryDataDB.GetPTReminders(fromDate, toDate); decimal ptBirthdays = SMSHistoryDataDB.GetPTBirthdays(fromDate, toDate); decimal staffRemidners = SMSHistoryDataDB.GetStaffReminders(fromDate, toDate); lblPTReminders.Text = ptRemidners.ToString("0.00"); lblPTBirthdays.Text = ptBirthdays.ToString("0.00"); lblStaffReminders.Text = staffRemidners.ToString("0.00"); }