protected void Set_Table_Filtered(string filterUser, string filterCompany)
{
GoDine GD = new GoDine();
DataTable dt;
DataClassesAlbertDataContext db;
db = new DataClassesAlbertDataContext();
dt = new DataTable("CUsers");
//var companies = db.Companies; // THIS IS A FULL TABLE ACQUISITION FROM DATABASE
var Cusers = from cu in db.CUsers where cu.UserCode.Contains(filterUser) && cu.Company.Name.Contains(filterCompany) select new {
CUserID = cu.CUserID,
UserCode = cu.UserCode,
CompanyName = cu.Company.Name,
TotalIn = (GD.Cuser_TotalFromTrans_CuserID(cu.CUserID)).TotalIn,
TotalInDiscounted = (GD.Cuser_TotalFromTrans_CuserID(cu.CUserID)).TotalInDiscounted,
Benefit = cu.TotalIn-cu.TotalInDiscounted,
Forced = cu.Forced,
Date = cu.Date
}; // THIS IS A SELECTED TABLE ACQUISITION
dt.Columns.Add("CuserID", typeof(int));
dt.Columns.Add("UserCode", typeof(string));
dt.Columns.Add("Company", typeof(string));
dt.Columns.Add("$CustomerExpenses", typeof(decimal));
dt.Columns.Add("$AfterDiscount", typeof(decimal));
dt.Columns.Add("$BrutBenefit", typeof(decimal));
dt.Columns.Add("Forced", typeof(bool));
dt.Columns.Add("CreationDate", typeof(DateTime));
foreach (var cuser in Cusers)
{
DataRow tablerow = dt.NewRow();
tablerow["CuserID"] = cuser.CUserID;
tablerow["UserCode"] = cuser.UserCode;
tablerow["Company"] = cuser.CompanyName;
tablerow["$CustomerExpenses"] = Math.Round(cuser.TotalIn,2);
tablerow["$AfterDiscount"] = Math.Round(cuser.TotalInDiscounted,2);
tablerow["$BrutBenefit"] = cuser.Benefit;
tablerow["Forced"] = cuser.Forced;
tablerow["CreationDate"] = cuser.Date;
dt.Rows.Add(tablerow);
}
Session["dt"] = dt;
GV.DataSource = dt;
GV.AllowSorting = true;
GV.AllowPaging = true;
GV.PageSize = 50;
//GV.Columns["Money"].ItemStyle.HorizontalAlign = HorizontalAlign.Right;
GV.DataBind();
}