protected void Page_Load(object sender, EventArgs e) { // Load GridView if (!Page.IsPostBack) { //Read Traveler From Daase var Result = (from T in TDC.TblTravelers join TP in TDC.TblTravelerProcesses on T.AutoID equals TP.TravelerAutoID where T.Finished == true select new { T, TP }).ToList(); //Add Row Number int RowNo = 1; var ResultWithRowNo = (from i in Result select new TravelerViewObject() { RowNumber = RowNo++, DateIn = i.TP.DateIn, JobDescription = i.T.JobDescription, TravelerNo = i.T.TravelerNo, Status = i.T.TblStatus.Status, Process = i.TP.TblProcess.Process, Priority = i.T.TblPriority.Priority, DateOut = i.TP.DateOut }).ToList(); // Load Traveler Data To Grid GridViewTraveler.DataSource = ResultWithRowNo.ToList(); GridViewTraveler.DataBind(); //Save To Session if (Session["TravelerViewObjectList"] == null) { Session.Add("TravelerViewObjectList", ResultWithRowNo.ToList()); } else { Session["TravelerViewObjectList"] = ResultWithRowNo.ToList(); } } }
protected void GridViewTraveler_Sorting(object sender, GridViewSortEventArgs e) { //Get TravelerViewObject List var TravelerViewObjectList = Session["TravelerViewObjectList"] as List <TravelerViewObject>; //Save Sort Direction if (Session["SordDir"] == null) { Session.Add("SordDir", "Ascending"); } //Do Sort if (e.SortExpression == "Status") { if (Session["SordDir"] as String == "Ascending") { TravelerViewObjectList = TravelerViewObjectList.OrderBy(p => p.Status).ToList(); Session["SordDir"] = "Descending"; } else { TravelerViewObjectList = TravelerViewObjectList.OrderByDescending(p => p.Status).ToList(); Session["SordDir"] = "Ascending"; } //Refresh GridView GridViewTraveler.DataSource = TravelerViewObjectList; GridViewTraveler.DataBind(); } }
/// <summary> /// Load Data Traveler From DataBase To GridViewTraveler /// </summary> private void LoadTravelerInfoGrid() { try { //Read Traveler From Database var Result = (from T in TDC.TblTravelers join TP in TDC.TblTravelerProcesses on T.AutoID equals TP.TravelerAutoID where (T.Finished == null || T.Finished == false) select new { T, TP }).ToList(); //Add Row Number int RowNo = 1; var ResultWithRowNo = (from i in Result select new TravelerViewObject() { AutoID = i.T.AutoID, RowNumber = RowNo++, OrderDate = i.T.OrderDate, JobDescription = i.T.JobDescription, TravelerNo = i.T.TravelerNo, Status = i.T.TblStatus.Status, Process = i.TP.TblProcess.Process, Priority = i.T.TblPriority.Priority }).ToList(); // Load Traveler Data To Grid GridViewTraveler.DataSource = ResultWithRowNo.OrderBy(x => x.Priority).ThenBy(x => x.OrderDate).ToList(); GridViewTraveler.DataBind(); //update Status Lable LabelTotalTraveler.Text = TDC.TblTravelers.Where(x => x.Finished != true || x.Finished == null).Count().ToString(); lbl_hi.Text = TDC.TblTravelers.Where(x => x.Finished != true || x.Finished == null).Where(x => x.TblPriority.Priority == "Hi").Count().ToString(); Lbl_normal.Text = TDC.TblTravelers.Where(x => x.Finished != true || x.Finished == null).Where(x => x.TblPriority.Priority == "normal").Count().ToString(); //Save To Session if (Session["TravelerViewObjectList"] == null) { Session.Add("TravelerViewObjectList", ResultWithRowNo.ToList()); } else { Session["TravelerViewObjectList"] = ResultWithRowNo.ToList(); } } catch (Exception) { //show message string msg = " alert('Error To Load Traveler');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "key", msg, true); } }