protected void Set_Table_Filtered(string filter, string filterIDstr)
{
DataTable dt;
DataClassesAlbertDataContext db;
GoDine a;
db = new DataClassesAlbertDataContext();
dt = new DataTable("GiftCards");
a = new GoDine();
dt.Columns.Add("BarCode", typeof(string));
dt.Columns.Add("UserName", typeof(string));
dt.Columns.Add("$TotalIn", typeof(decimal));
dt.Columns.Add("$MoneyLeft", typeof(decimal));
dt.Columns.Add("%SaleDealRate", typeof(decimal));
dt.Columns.Add("Company", typeof(string));
dt.Columns.Add("Seller", typeof(string));
dt.Columns.Add("Forced", typeof(bool));
dt.Columns.Add("CreationDate", typeof(DateTime));
dt.Columns.Add("Mode", typeof(string));
dt.Columns.Add("EmailFrom", typeof(string));
if (filterIDstr == "It's a sales filter" || filterIDstr == "It's a company filter")
{
var giftcards = from c in db.GiftCards select c;
if (filterIDstr == "It's a company filter")
{
giftcards = from c in db.GiftCards where c.CompanyID == filter select c; // THIS IS A SELECTED TABLE ACQUISITION
}
else
{
giftcards = from c in db.GiftCards where c.SellerID == filter select c; // THIS IS A SELECTED TABLE ACQUISITION
}
foreach (GiftCard giftcard in giftcards)
{
GiftCardExtras extra = a.getExtraFieldsFor(giftcard);
string giftcard_userkey = giftcard.EmailTo;
DataRow tablerow = dt.NewRow();
tablerow["UserName"] = giftcard_userkey;
tablerow["$TotalIn"] = giftcard.TotalIn;
tablerow["$MoneyLeft"] = giftcard.Money;
tablerow["%SaleDealRate"] = giftcard.SalesDealRate;
tablerow["Company"] = extra.compName;
tablerow["Seller"] = extra.salesPerson;
tablerow["BarCode"] = UTILITIES.appendChecksum(giftcard.BarCode);
tablerow["Forced"] = giftcard.Forced;
tablerow["CreationDate"] = giftcard.Date;
tablerow["Mode"] = giftcard.MODE;
tablerow["EmailFrom"] = giftcard.EmailFrom;
dt.Rows.Add(tablerow);
}
}
else
{
var giftcards = from c in db.GiftCards select c; // THIS IS A SELECTED TABLE ACQUISITION
foreach (GiftCard giftcard in giftcards)
{
GiftCardExtras extra = a.getExtraFieldsFor(giftcard);
string giftcard_userkey = giftcard.EmailTo;
//MembershipUser memberi = Membership.GetUser(userkey_email);
if (((filterIDstr == null) && (giftcard_userkey.Contains(filter) || giftcard_userkey.Contains(filter))) || filterIDstr == giftcard.GiftCardID.ToString())
{
DataRow tablerow = dt.NewRow();
tablerow["UserName"] = giftcard_userkey;
tablerow["$TotalIn"] = giftcard.TotalIn;
tablerow["$MoneyLeft"] = giftcard.Money;
tablerow["%SaleDealRate"] = giftcard.SalesDealRate;
tablerow["Company"] = extra.compName;
tablerow["Seller"] = extra.salesPerson;
tablerow["BarCode"] = UTILITIES.appendChecksum(giftcard.BarCode);
tablerow["Forced"] = giftcard.Forced;
tablerow["CreationDate"] = giftcard.Date;
tablerow["Mode"] = giftcard.MODE;
tablerow["EmailFrom"] = giftcard.EmailFrom;
dt.Rows.Add(tablerow);
}
}
}
Session["dt"] = dt;
GV.DataSource = dt;
GV.AllowSorting = true;
GV.AllowPaging = true;
GV.PageSize = 1000000;
//GV.Columns["Money"].ItemStyle.HorizontalAlign = HorizontalAlign.Right;
GV.DataBind();
}