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);
}
}
