private void LoadData(string NVOCCId) { ClearText(); SearchCriteria searchCriteria = (SearchCriteria)Session[Constants.SESSION_SEARCH_CRITERIA]; int intNVOCCId = 0; if (NVOCCId == "" || !Int32.TryParse(NVOCCId, out intNVOCCId)) { return; } BLL.DBInteraction dbinteract = new BLL.DBInteraction(); System.Data.DataTable dt = dbinteract.GetSlotOperator(Convert.ToInt32(NVOCCId), "", searchCriteria); if (!ReferenceEquals(dt, null) && dt.Rows.Count > 0) { txtSlotOperatorName.Text = dt.Rows[0]["SlotOperatorName"].ToString(); } }
private void LoadData(string SortExp, string direction) { string nvocc = string.IsNullOrEmpty(txtOperatorName.Text) ? "" : txtOperatorName.Text.Trim(); lblErrorMsg.Text = ""; if (!ReferenceEquals(Session[Constants.SESSION_SEARCH_CRITERIA], null)) { SearchCriteria searchCriteria = (SearchCriteria)Session[Constants.SESSION_SEARCH_CRITERIA]; if (!ReferenceEquals(searchCriteria, null)) { BuildSearchCriteria(searchCriteria); gvwSlotOperator.PageIndex = searchCriteria.PageIndex; if (searchCriteria.PageSize > 0) { gvwSlotOperator.PageSize = searchCriteria.PageSize; } BLL.DBInteraction dbinteract = new BLL.DBInteraction(); try { //DataSet ds = dbinteract.GetSlotOperator(-1, nvocc, searchCriteria); //System.Data.DataView dv = new System.Data.DataView(ds.Tables[0]); //if (!string.IsNullOrEmpty(SortExp) && !string.IsNullOrEmpty(direction)) // dv.Sort = SortExp + " " + direction; gvwSlotOperator.DataSource = dbinteract.GetSlotOperator(-1, nvocc, searchCriteria); gvwSlotOperator.DataBind(); } catch (Exception ex) { gvwSlotOperator.DataSource = null; lblErrorMsg.Text = "Error Occured.Please try again."; } gvwSlotOperator.DataBind(); } } }