protected void btnCardDealRate_Click(object sender, EventArgs e) { decimal number = -1; string num = tbCardDealRate.Text; string strcompany = ddCardDealRate.SelectedValue; if (!strcompany.Contains("---company")) { number = Convert.ToDecimal(num); if (number >= 0 && number <= 100) { DataClassesAlbertDataContext db = new DataClassesAlbertDataContext(); Company qry = (from c in db.Companies where c.Name == strcompany select c).Single(); //Company qry = qry.Single(); // if we do not insert the fist single qry.GCSaleDealRate = number; db.SubmitChanges(); lblDealRate.Text = "OK -> Deal Rate set to " + number.ToString("0.0000") + " % for company " + strcompany; tbDealRate.Text = number.ToString("0.0000") + " %"; } else { lblDealRate.Text = "ERROR -> Entered value must be an integer between 1 and 99 for company " + strcompany; } } else { lblDealRate.Text = "ERROR -> Entered value must be an integer between 1 and 99 for the selected company" + strcompany; } }
protected void Page_Load(object sender, EventArgs e) { string inGCnum = Request["GC"]; long GCnum = 0; DataClassesAlbertDataContext db = new DataClassesAlbertDataContext(); GiftCard giftCard = new GiftCard(); GCnum = Convert.ToInt64(inGCnum.Remove(inGCnum.Length - 1)); try { giftCard = (from gc in db.GiftCards where gc.BarCode == GCnum select gc).Single(); string companyName = ""; if (giftCard.CompanyID != "00000000-0000-0000-0000-000000000000" && giftCard.CompanyID != "") { try { Company comp = (from c in db.Companies where c.UserID.ToString() == giftCard.CompanyID select c).Single(); companyName = comp.Name; } catch { } } GoDineEmails.sendSuccessEmail(giftCard, companyName); lblinfo.Text = "Email sent"; } catch { } }
protected void Page_Load(object sender, EventArgs e) { ((Site)this.Master).showNavbar = false; // Public links will contain an encrypted barcode number, private admin pages will point to the plain number instead string encryptedBarcode = Request.QueryString["GC"]; string barcodeNumber = Request.QueryString["barcodeNumber"]; if (barcodeNumber == null && encryptedBarcode != null) barcodeNumber = SecurityUtils.decrypt(encryptedBarcode); if (barcodeNumber != null) { DataClassesAlbertDataContext db = new DataClassesAlbertDataContext(); long barcodeNumberL = Convert.ToInt64(barcodeNumber.Remove(barcodeNumber.Length-1)); try { GiftCard card = (from gc in db.GiftCards where gc.BarCode == barcodeNumberL select gc).Single(); string barcodeWithChecksum = UTILITIES.appendChecksum(card.BarCode); // populate gift card fields message.InnerText = card.GCText; if (card.DisplayName == 1) { from.InnerText = "From: " + card.NameFrom; to.InnerText = "To: " + card.NameTo; } value.InnerText = card.Money.ToString("0.00"); backgroundImage.Src = "/img/GC/" + card.DIRImgGC; barcodeImage.Src = "/barcodeStream.aspx?code=" + barcodeWithChecksum; barcodeLabel.InnerText = barcodeWithChecksum; //populate company name try { Company gcComp = (from c in db.Companies where c.UserID.ToString() == card.CompanyID select c).Single(); String name = gcComp.Name; StoreName1.Text = name; StoreName2.Text = name; StoreName3.Text = name; StoreName4.Text = name; } catch { } } catch (Exception ex) { // Show error - no gift card found showErrorMessage("Sorry, we can't find a gift card with that number. Please verify the link and try again."); log.Error("Error fetching gift card with number: " + barcodeNumber + ", hash: " + encryptedBarcode, ex); } } else { // Show error - missing parameter
protected void Page_Load(object sender, EventArgs e) { try { GCready = (UTILITIES.GiftCardReady)Session["GCready"]; DataClassesAlbertDataContext db = new DataClassesAlbertDataContext(); GiftCard GCqry = (from gc in db.GiftCards where gc.BarCode == GCready.barcode select gc).Single(); GoDineEmails.Payment_Fail_Case(GCqry); } catch { } }
protected void Page_Load(object sender, EventArgs e) { DataClassesAlbertDataContext db; db = new DataClassesAlbertDataContext(); GoDine a = new GoDine(); MembershipUser user = Membership.GetUser(); Guid userID = (Guid)user.ProviderUserKey; var company = (from c in db.Companies where c.UserID == userID select c).Single(); Setup_GiftCardSales(userID.ToString()); GiftcardSellingMesage.Text = "Here's your gift card link, where your customers can buy gift cards for just your store, any time, even when your store is closed. " + HOST_URL + "/BuyGiftCard.aspx?Company=" + userID.ToString(); LabelTitle.Text = company.Name; }
protected void Set_Table_Filtered(string filterSeller) { GoDine GD = new GoDine(); DataTable dt; DataClassesAlbertDataContext db; db = new DataClassesAlbertDataContext(); dt = new DataTable("Sellers"); var Sellers = from sl in db.SalesIDs select sl; dt.Columns.Add("Email", typeof(string)); dt.Columns.Add("NumberOfSales", typeof(string)); dt.Columns.Add("%CurrentDealRate", typeof(string)); dt.Columns.Add("$TotalOfGiftCardsSold", typeof(string)); dt.Columns.Add("$TotalIncomeFromSales", typeof(decimal)); dt.Columns.Add("$WePaidThem", typeof(decimal)); dt.Columns.Add("CreationDate", typeof(DateTime)); dt.Columns.Add("SellerID", typeof(string)); foreach (var seller in Sellers) { MembershipUser user = Membership.GetUser(seller.UserID); String username = user.UserName; if (username.Contains(filterSeller)) { SellerStats stats = GD.SellerSts(seller.SellerID); DataRow tablerow = dt.NewRow(); tablerow["Email"] = username; tablerow["NumberOfSales"] = stats.numSales.ToString(); tablerow["%CurrentDealRate"] = seller.DealRate.ToString("0.00"); tablerow["$TotalOfGiftCardsSold"] = stats.sold.ToString("0.00"); tablerow["$TotalIncomeFromSales"] = stats.owed; tablerow["$WePaidThem"] = GD.getPaidToSeller(seller.SellerID); tablerow["CreationDate"] = user.CreationDate; tablerow["SellerID"] = seller.SellerID.ToString(); 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(); }
protected void Set_Table_Filtered(string filter) { DataTable dt; DataClassesAlbertDataContext db; db = new DataClassesAlbertDataContext(); dt = new DataTable("Payments"); //var companies = db.Companies; // THIS IS A FULL TABLE ACQUISITION FROM DATABASE var payments = from p in db.Payments select p; // THIS IS A SELECTED TABLE ACQUISITION dt.Columns.Add("PaymentID", typeof(int)); dt.Columns.Add("User", typeof(string)); dt.Columns.Add("GiftCardID", typeof(int)); dt.Columns.Add("$Amount", typeof(decimal)); dt.Columns.Add("$AmountReceived", typeof(decimal)); dt.Columns.Add("Forced", typeof(bool)); dt.Columns.Add("Date", typeof(DateTime)); dt.Columns.Add("Concept", typeof(string)); foreach (Payment payment in payments) { string userkey_email = payment.UserID; //MembershipUser memberi = Membership.GetUser(userkey_email); if (userkey_email.Contains(filter)) { DataRow tablerow = dt.NewRow(); tablerow["PaymentID"] = payment.PaymentID; tablerow["User"] = userkey_email; tablerow["GiftCardID"] = payment.GiftCardID; tablerow["$Amount"] = Math.Round(payment.Amount,2); tablerow["$AmountReceived"] = Math.Round(payment.AmountReceived,2); tablerow["Forced"] = payment.Forced == 0 ? false : true; tablerow["Date"] = payment.Date.ToString(); tablerow["Concept"] = payment.Concept; dt.Rows.Add(tablerow); } } Session["dt"] = dt; GV.DataSource = dt; GV.AllowSorting = true; GV.AllowPaging = false; GV.PageSize = 50; //GV.Columns["Money"].ItemStyle.HorizontalAlign = HorizontalAlign.Right; GV.DataBind(); }
protected void LoadTransactions() { DataTable dt; DataClassesAlbertDataContext db; MembershipUser user = Membership.GetUser(); Guid userID = (Guid)user.ProviderUserKey; db = new DataClassesAlbertDataContext(); dt = new DataTable("Transactions"); var transactions = from t in db.Transactions select t; // THIS IS A SELECTED TABLE ACQUISITION var giftcardIDs = from gc in db.GiftCards where gc.EmailTo == user.UserName select gc.GiftCardID; dt.Columns.Add("Gift Card ID", typeof(int)); dt.Columns.Add("Company", typeof(string)); dt.Columns.Add("Concept", typeof(string)); dt.Columns.Add("Value", typeof(string)); dt.Columns.Add("Date", typeof(DateTime)); List<TransactionDetails> transactionDetailList = new List<TransactionDetails>(); foreach (Transaction transaction in transactions) { bool allow_plot = false; foreach (int gcID in giftcardIDs) { if (transaction.GiftCardID == gcID) { allow_plot = true; break; } } if (allow_plot) { transactionDetailList.Add(new TransactionDetails(transaction.Amount.ToString("C"), transaction.Date.ToShortDateString(), transaction.CUser.Company.Name, transaction.Concept)); } } TransactionList.DataSource = transactionDetailList; TransactionList.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { string filterUser = Request.QueryString["cuser"]; if (filterUser == null) { filterUser = ""; } DataClassesAlbertDataContext db; db = new DataClassesAlbertDataContext(); GoDine a = new GoDine(); MembershipUser user = Membership.GetUser(); Guid userID = (Guid)user.ProviderUserKey; } }
///////////////////////////////////////////////////////////// PAYMENT SUCCESS public static void Payment_Success_Case_Global_MoneyAndSend(GiftCard giftCard, decimal fee) { log.Debug("Processing successful payment for GiftCard " + giftCard.GiftCardID); log.Debug("Value=" + giftCard.GCValue + ", fee=" + fee + ", barcode=" + giftCard.BarCode); DataClassesAlbertDataContext db = new DataClassesAlbertDataContext(); string companyName = ""; if (giftCard.CompanyID != "00000000-0000-0000-0000-000000000000" && giftCard.CompanyID != "") { try { companyName = (from c in db.Companies where c.UserID == new Guid(giftCard.CompanyID) select c).Single().Name; } catch { } } GoDine a = new GoDine(); a.Insert_Money_2_GiftCard(giftCard.GCValue, giftCard.GCValue - fee, giftCard.BarCode, "Payment by credit card/paypal: " + giftCard.EmailFrom, 0); //IT IS NOT FORCED sendSuccessEmail(giftCard, companyName); }
protected void Page_Load(object sender, EventArgs e) { DataClassesAlbertDataContext db; db = new DataClassesAlbertDataContext(); GoDine a = new GoDine(); MembershipUser user = Membership.GetUser(); Guid userID = (Guid)user.ProviderUserKey; var company = (from c in db.Companies where c.UserID == userID select c).Single(); LabelTitle.Text = company.Name; DataTable dt; dt = new DataTable("Company Payments"); var Payments = from pmt in db.CompanyPayHists where pmt.CompanyID == company.CompanyID where pmt.IsACompany == true select pmt; dt.Columns.Add("Context", typeof(string)); dt.Columns.Add("Amount($)", typeof(decimal)); dt.Columns.Add("Date of Payment", typeof(DateTime)); foreach (var pmt in Payments) { DataRow tablerow = dt.NewRow(); tablerow["Context"] = pmt.Concept; tablerow["Amount($)"] = pmt.Amount.ToString("0.00"); tablerow["Date of Payment"] = pmt.Date; dt.Rows.Add(tablerow); } Session["dt"] = dt; GV.DataSource = dt; GV.AllowSorting = true; GV.AllowPaging = true; GV.PageSize = 50; GV.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { string filterUser = Request.QueryString["cuser"]; if (filterUser == null) { filterUser = ""; } DataClassesAlbertDataContext db; db = new DataClassesAlbertDataContext(); GoDine a = new GoDine(); MembershipUser user = Membership.GetUser(); Guid userID = (Guid)user.ProviderUserKey; var company = (from c in db.Companies where c.UserID == userID select c).Single(); LabelTitle.Text = company.Name; } }
protected void btnDownAll_Click(object sender, EventArgs e) { DataClassesAlbertDataContext db = new DataClassesAlbertDataContext(); var allGC = db.GiftCards; // THIS IS A FULL TABLE ACQUISITION FROM DATABASE string filename = "Giftcards_DB_All_" + DateTime.Now.ToString("yyyy-MM-dd HH-mm-ss") + ".csv"; string attachment = "attachment; filename=" + filename; HttpContext.Current.Response.Clear(); HttpContext.Current.Response.ClearHeaders(); HttpContext.Current.Response.ClearContent(); HttpContext.Current.Response.AddHeader("content-disposition", attachment); HttpContext.Current.Response.ContentType = "text/csv"; HttpContext.Current.Response.AddHeader("Pragma", "public"); var sb = new StringBuilder(); sb.AppendLine(TransformDataLineIntoCsv_Header()); foreach (GiftCard gcrow in allGC) { sb.AppendLine(TransformDataLineIntoCsv(gcrow)); } HttpContext.Current.Response.Write(sb.ToString()); HttpContext.Current.Response.End(); }
protected void Setup_Sales(Guid user) { DataTable dt; DataClassesAlbertDataContext db; db = new DataClassesAlbertDataContext(); var salesID = (from sid in db.SalesIDs where sid.UserID == user select sid).Single(); Guid sellerID = salesID.SellerID; dt = new DataTable("Sales"); var sales = from gc in db.GiftCards where gc.SellerID == sellerID.ToString() where gc.TotalIn != 0 select gc; dt.Columns.Add("$Amount", typeof(string)); dt.Columns.Add("%DealRate", typeof(string)); dt.Columns.Add("Income", typeof(string)); dt.Columns.Add("Date", typeof(DateTime)); foreach (GiftCard sale in sales) { DataRow tablerow = dt.NewRow(); tablerow["$Amount"] = sale.TotalIn.ToString("0.00"); tablerow["%DealRate"] = sale.SalesDealRate.ToString("0.00"); tablerow["Income"] = Math.Round(sale.TotalIn * sale.SalesDealRate / 100,2).ToString("0.00"); tablerow["Date"] = sale.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(); }
protected void Page_Load(object sender, EventArgs e) { DataClassesAlbertDataContext db; db = new DataClassesAlbertDataContext(); GoDine a = new GoDine(); MembershipUser user = Membership.GetUser(); Guid userID = (Guid)user.ProviderUserKey; var salesID = (from sid in db.SalesIDs where sid.UserID == userID select sid).Single(); decimal dealRate = a.getDealRateForSellerID(salesID.SellerID); SellerStats table = a.SellerSts(salesID.SellerID); decimal paid = a.Paid_FromSalesPaymentHist(salesID.SellerID); LabelTitle.Text = "Your Sales Progress"; lbldealrate.Text = dealRate.ToString("0.00") + "%"; lblincome.Text = "$" + table.owed.ToString("0.00"); lblnumsales.Text = table.numSales.ToString(); lblpaid.Text = "$" + paid.ToString("0.00"); lbltopay.Text = "$" + (table.owed - paid).ToString("0.00"); String salesUrl = Request.Url.GetLeftPart(UriPartial.Authority) + Request.ApplicationPath + "BuyGiftCard.aspx?Sale=" + salesID.SellerID.ToString(); UrlBlurb.Text = "Your sales url: " + salesUrl + "</br> (refer people here when you're selling in order to get credit for your sales)"; }
private CUser getDefaultCompanyUser() { DataClassesAlbertDataContext db; db = new DataClassesAlbertDataContext(); MembershipUser user = Membership.GetUser(); Guid userID = (Guid)user.ProviderUserKey; return (from c in db.CUsers where c.Company.UserID == userID orderby c.CUserID select c).First(); }
protected void Set_Table_Filtered(string filter) { DataTable dt; DataClassesAlbertDataContext db; db = new DataClassesAlbertDataContext(); dt = new DataTable("Customers"); //var companies = db.Companies; // THIS IS A FULL TABLE ACQUISITION FROM DATABASE var companies = from c in db.Companies where c.Name.Contains(filter) select c; // THIS IS A SELECTED TABLE ACQUISITION MembershipUserCollection allUsers = Membership.GetAllUsers(); dt.Columns.Add("UserName", typeof(string)); //dt.Columns.Add("UserEmail", typeof(string)); dt.Columns.Add("GiftCards", typeof(int)); dt.Columns.Add("Payments", typeof(int)); dt.Columns.Add("Transactions", typeof(string)); dt.Columns.Add("Created", typeof(DateTime)); dt.Columns.Add("LastAccess", typeof(DateTime)); foreach (MembershipUser user in allUsers) { //Guid userkey = (Guid) user.ProviderUserKey; string userkey_Email = user.UserName; string email = user.Email; string name = user.UserName; DateTime created = user.CreationDate; DateTime lastaccess = user.LastLoginDate; bool isCustomer = Roles.IsUserInRole(name,"customer"); if (isCustomer && (email.Contains(filter) || name.Contains(filter))) { var giftcards = from gc in db.GiftCards where gc.EmailTo == userkey_Email select gc; var payments = from pm in db.Payments where pm.UserID == userkey_Email select pm; var transactions = from ts in db.Transactions where false select ts; int gcnum = 0; int pmnum = 0; int tsnum = 0; foreach (GiftCard gc in giftcards){ gcnum++; } foreach (Payment pm in payments){ pmnum++; } foreach (Transaction ts in transactions){ tsnum++; } DataRow tablerow = dt.NewRow(); tablerow["UserName"] = name; tablerow["Created"] = created; tablerow["LastAccess"] = lastaccess; //tablerow["UserEmail"] = email; tablerow["GiftCards"] = gcnum; tablerow["Payments"] = pmnum; tablerow["Transactions"] = tsnum; 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(); }
protected Decimal2_int1 Set_Table_Filtered_by_CUsers(int companyID, string filterUser) { DataTable dt; DataClassesAlbertDataContext db; db = new DataClassesAlbertDataContext(); dt = new DataTable("Company Users"); GoDine CS = new GoDine(); CompanyStatus this_company_status = CS.CompanyStatus_from_CompanyID(companyID); decimal expensesTOT = this_company_status.TotalIn; decimal expensesTOTafterdisc = this_company_status.TotalInDiscounted; //var companies = db.Companies; // THIS IS A FULL TABLE ACQUISITION FROM DATABASE var Cusers = from cu in db.CUsers where cu.CompanyID == companyID && cu.UserCode.Contains(filterUser) select cu; ; // THIS IS A SELECTED TABLE ACQUISITION dt.Columns.Add("Employee Name", typeof(string)); dt.Columns.Add("Total Gift $ Redeemed", typeof(decimal)); dt.Columns.Add("Date Employee Added", typeof(DateTime)); int numusers = 0; foreach (var cuser in Cusers) { DataRow tablerow = dt.NewRow(); tablerow["Employee Name"] = cuser.UserCode; tablerow["Total Gift $ Redeemed"] = CS.Cuser_TotalIn_CuserID(cuser.CUserID).ToString("0.00"); tablerow["Date Employee Added"] = cuser.Date; dt.Rows.Add(tablerow); numusers = numusers + 1; } Session["dt"] = dt; GV.DataSource = dt; GV.AllowSorting = true; GV.AllowPaging = true; GV.PageSize = 50; //GV.Columns["Money"].ItemStyle.HorizontalAlign = HorizontalAlign.Right; GV.DataBind(); Company company = (from c in db.Companies where c.CompanyID == companyID select c).Single(); compname.Text = company.Name; var giftcards = (from g in db.GiftCards where g.CompanyID == company.UserID.ToString() select g); decimal totalGiftcardSales = 0; decimal totalGiftcardSalesAfterComish = 0; foreach (var card in giftcards) { totalGiftcardSales += card.TotalIn; totalGiftcardSalesAfterComish += Math.Round((card.TotalIn * ((100 - card.SalesDealRate) / 100)),2); } Decimal2_int1 toreturn = new Decimal2_int1(); toreturn.dec1 = expensesTOT; toreturn.dec2 = expensesTOTafterdisc; toreturn.num = numusers; toreturn.gcsalesDealRate = company.GCSaleDealRate; toreturn.giftcardSales = totalGiftcardSales; toreturn.giftcardSalesAfterComish = totalGiftcardSalesAfterComish; return toreturn; }
/////////////////////////////////////////////////////////////////////////// FOR COMPANY DEAL RATE protected void ddDealRate_SelectedIndexChanged(object sender, EventArgs e) { DataClassesAlbertDataContext db = new DataClassesAlbertDataContext(); string strcompany = ddDealRate.Text; try { Company qry = (from c in db.Companies where c.Name == strcompany select c).Single(); tbDealRate.Text = qry.DealRate.ToString("0.0000"); }catch{ tbDealRate.Text = ""; } }
protected void Set_Table_Filtered(string filter) { DataClassesAlbertDataContext db; db = new DataClassesAlbertDataContext(); ///////////////// FOR COMPANY DEAL RATES AND PAY AMOUNT var companies = from c in db.Companies where c.Name.Contains(filter) select c; // THIS IS A SELECTED TABLE ACQUISITION ddDealRate.Items.Clear(); ddSalesDealRate.Items.Clear(); ddPaidAmount.Items.Clear(); ddcreategc.Items.Clear(); ddpaymentUsr.Items.Clear(); ddSalesPpl.Items.Clear(); ddtransactionUsr.Items.Clear(); ddDealRate.Items.Add("---company---"); ddPaidAmount.Items.Add("---company---"); ddCardDealRate.Items.Add("---company---"); foreach (Company company in companies) { ddDealRate.Items.Add(company.Name); ddPaidAmount.Items.Add(company.Name); ddCardDealRate.Items.Add(company.Name); } /////////////////// Sellers var sellers = from sl in db.SalesIDs select sl; ddSalesPpl.Items.Add("---sellers---"); ddSalesDealRate.Items.Add("---sellers---"); foreach (SalesID slid in sellers){ String username = Membership.GetUser(slid.UserID).UserName; ddSalesPpl.Items.Add(username); ddSalesDealRate.Items.Add(username); } /////////////////// USERS //var customerlist = Roles.GetUsersInRole("customer"); var customerlist = from gc in db.GiftCards where gc.EmailTo.Contains(filter) select gc.EmailTo; ddcreategc.Items.Add("---unknown---"); ddpaymentUsr.Items.Add("---unknown---"); ddtransactionUsr.Items.Add("---unknown---"); foreach (string username in customerlist) { if (username.Contains("@")) { ddcreategc.Items.Add(username); ddpaymentUsr.Items.Add(username); ddtransactionUsr.Items.Add(username); } } ////////////////// Company Users ddtransactionCUser.Items.Clear(); ddtransactionCUser.Items.Add("--- company user ---"); var cusercodelist = from cu in db.CUsers where cu.UserCode.Contains(filter) select cu.UserCode; foreach (string cusercode in cusercodelist) { ddtransactionCUser.Items.Add(cusercode); } /////////////////// Gift cards try // used to supress leading zeros on the left { long filternum = Convert.ToInt64(filter); filter = filternum.ToString(); } catch { } ddpaymentID.Items.Clear(); ddtransactionID.Items.Clear(); var barcodelist = from gc in db.GiftCards where gc.BarCode.ToString().Contains(filter) select gc.BarCode; foreach (long barcode in barcodelist) { string gcstr; gcstr = UTILITIES.appendChecksum(barcode); ddpaymentID.Items.Add(gcstr); ddtransactionID.Items.Add(gcstr); } }
protected void Load_Presets_From_GC(long GCnum) { DataClassesAlbertDataContext db = new DataClassesAlbertDataContext(); try { GiftCard GCqry = (from gc in db.GiftCards where gc.BarCode == GCnum && gc.TotalIn == 0 select gc).Single(); fromName.Text = GCqry.NameFrom; fromEmail.Text = GCqry.EmailFrom; confirmFromEmail.Text = GCqry.EmailFrom; toName.Text = GCqry.NameTo; toEmail.Text = GCqry.EmailTo; confirmToEmail.Text = GCqry.EmailTo; char[] removechars = new char[2] { ' ', '$' }; value.Text = GCqry.GCValue.ToString("0.00"); message.Value = GCqry.GCText; //cbDisplayNames.Checked = true; if (GCqry.DisplayName == 1) { cbDisplayNames.Checked = true; } else { cbDisplayNames.Checked = false; } if (GCqry.MODE.Contains("EMAIL")) { rbChoice.SelectedIndex = 0; } else if (GCqry.MODE.Contains("PRINT")) { rbChoice.SelectedIndex = 1; toEmail.Enabled = false; confirmToEmail.Enabled = false; disableFrom.Style["block"] = "none"; disableFrom.Style["display"] = "none"; } verifyAll(); } catch(Exception e) { log.Error("Error loading Gift Card details on BuyGiftCard", e); } }
protected void btnPaidSalesAmount_Click(object sender, EventArgs e) { DataClassesAlbertDataContext db = new DataClassesAlbertDataContext(); GoDine a = new GoDine(); try { decimal amount = Convert.ToDecimal(tbPaidSalesAmount.Text); Guid userId = a.UserName_2_Guid(ddSalesPpl.SelectedValue); SalesID seller = (from s in db.SalesIDs where s.UserID == userId select s).Single(); string concept = tbPaidSalesAmountConcept.Text; if (a.Pay_Amount_to_Seller(amount, seller.SellerID, concept) == 0) { lblPaidSalesAmount.Text = "OK -> Seller " + ddSalesPpl.SelectedValue + " received " + amount.ToString(); tbPaidSalesAmount.Text = ""; } else { lblPaidSalesAmount.Text = "Error -> Seller " + ddSalesPpl.SelectedValue + " did not 'get paid' Have Lana Check the logs for details :P"; }; } catch { lblPaidSalesAmount.Text = "Error -> Input value must be a number."; } }
protected void ddtransactionID_SelectedIndexChanged(object sender, EventArgs e) { DataClassesAlbertDataContext db = new DataClassesAlbertDataContext(); long barcode = Convert.ToInt64(ddtransactionID.SelectedValue); barcode = UTILITIES.removeCheckSum(barcode); decimal moneyLeft = (from gc in db.GiftCards where gc.BarCode == barcode select gc.Money).Single(); lbltransaction.Text = "The selected gift card has " + moneyLeft.ToString() + " dollars left"; }
/////////////////////////////////////////////////////////////////////////// FOR SELLER DEAL RATE protected void ddSalesDealRate_SelectedIndexChanged(object sender, EventArgs e) { DataClassesAlbertDataContext db = new DataClassesAlbertDataContext(); string Seller = ddSalesDealRate.Text; GoDine a = new GoDine(); if (!(ddSalesDealRate.SelectedValue.Contains("---sellers---"))) { Guid UserID = a.UserName_2_Guid(ddSalesDealRate.SelectedValue); Guid SellerID = a.getSellerFromUser(UserID).SellerID; decimal rate = a.getDealRateForSellerID(SellerID); tbSalesDealRate.Text = rate.ToString("0.00"); } else { tbSalesDealRate.Text = ""; } }
protected void Set_Transactions_Filtered_by_CUsers(int companyID, string filterUser) { DataTable dt; DataClassesAlbertDataContext db; db = new DataClassesAlbertDataContext(); dt = new DataTable("Transactions"); //var companies = db.Companies; // THIS IS A FULL TABLE ACQUISITION FROM DATABASE var transactions = from t in db.Transactions select t; // THIS IS A SELECTED TABLE ACQUISITION var cusers = from cu in db.CUsers where cu.CompanyID == companyID && cu.UserCode.Contains(filterUser) select cu.CUserID; //dt.Columns.Add("CUserID", typeof(int)); dt.Columns.Add("CUserCode", typeof(string)); dt.Columns.Add("$Amount", typeof(string)); //dt.Columns.Add("%DealRate", typeof(decimal)); dt.Columns.Add("Notes", typeof(string)); dt.Columns.Add("Date", typeof(DateTime)); foreach (Transaction transaction in transactions) { bool allow_plot = false; foreach (int cuserID in cusers) { if (transaction.CUserID == cuserID){ allow_plot = true; break; } } if (allow_plot) { DataRow tablerow = dt.NewRow(); tablerow["CUserCode"] = transaction.CUser.UserCode; tablerow["$Amount"] = transaction.Amount.ToString("0.00"); //tablerow["%DealRate"] = transaction.DealRate; tablerow["Notes"] = transaction.Concept; tablerow["Date"] = transaction.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(); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { //Response.Redirect("google.ca"); /*string filterCompany = Request.QueryString["Company"]; string filterUser = Request.QueryString["CUser"]; if (filterCompany == null) { filterCompany = ""; } if (filterUser == null) { filterUser = ""; } TextBox1.Text = filterUser;*/ DataClassesAlbertDataContext db; db = new DataClassesAlbertDataContext(); GoDine a = new GoDine(); MembershipUser user = Membership.GetUser(); Guid userID = (Guid) user.ProviderUserKey; var company = (from c in db.Companies where c.UserID == userID select c).Single(); Decimal2_int1 info = Set_Table_Filtered_by_CUsers(company.CompanyID, ""); decimal paid = a.Paid_FromCompanyPaymentHist(company.CompanyID); LabelTitle.Text = company.Name; lblincome.Text = "$" + info.dec1.ToString("0.00"); lblgcincome.Text = "$" + info.giftcardSales.ToString("0.00"); lblincomeafter.Text = "$" + info.dec2.ToString("0.00"); lblgcincomeafter.Text = "$" + info.giftcardSalesAfterComish.ToString("0.00"); lbldealrate.Text = "% " + company.DealRate.ToString("G29"); lblgcdealrate.Text = "%" + info.gcsalesDealRate.ToString("G29"); lblalreadypaid.Text = "$" + paid.ToString("0.00"); lbltopay.Text = "$" + (info.dec2 + info.giftcardSalesAfterComish - paid).ToString("0.00"); lblnumusers.Text = info.num.ToString(); } }
protected void ExecuteCalculs() { DataTable dt; DataClassesAlbertDataContext db; db = new DataClassesAlbertDataContext(); var companies = db.Companies; var CUsers = db.CUsers; var giftcards = db.GiftCards; var payments = db.Payments; var transactions = db.Transactions; var totalpaidtocompanies = from c in db.CompanyPayHists where c.IsACompany == true select c.Amount; var totalspentbyCustomersB = from tr in db.Transactions join gc in db.GiftCards on tr.GiftCardID equals gc.GiftCardID where (gc.CompanyID == "00000000-0000-0000-0000-000000000000" || gc.CompanyID == "") select tr.Amount; var totalspentbyCustomersAfterDiscountB = from t in db.Transactions join gc in db.GiftCards on t.GiftCardID equals gc.GiftCardID where (gc.CompanyID == "00000000-0000-0000-0000-000000000000" || gc.CompanyID == "") where gc.CompanyID != "" select Math.Round((t.Amount * (1-t.DealRate/100)),2, MidpointRounding.ToEven); var totalLeftOngiftcards = from gc in db.GiftCards where (gc.CompanyID == "00000000-0000-0000-0000-000000000000" || gc.CompanyID == "") where gc.TotalIn != 0 where gc.CompanyID != "" select gc.Money ; var totalPaidbyCustomersA = from p in db.Payments join gc in db.GiftCards on p.GiftCardID equals gc.GiftCardID where (gc.CompanyID == "00000000-0000-0000-0000-000000000000" || gc.CompanyID == "") where gc.TotalIn != 0 where gc.MODE != "IT TYPE" select p.Amount; var totalPaidbyCustomersB = from p in db.Payments join gc in db.GiftCards on p.GiftCardID equals gc.GiftCardID where (gc.CompanyID == "00000000-0000-0000-0000-000000000000" || gc.CompanyID == "") where gc.TotalIn != 0 where gc.MODE != "IT TYPE" select p.AmountReceived; var totalPutOnCompanyCards = from g in db.GiftCards where g.CompanyID != "00000000-0000-0000-0000-000000000000" where g.CompanyID != "" where g.TotalIn != 0 where g.SalesDealRate != 0 select g.TotalIn; var totalMadeOffCompanyCards = from g in db.GiftCards where g.CompanyID != "00000000-0000-0000-0000-000000000000" where g.CompanyID != "" where g.TotalIn != 0 where g.SalesDealRate != 0 select Math.Round((g.TotalIn * (g.SalesDealRate/100)),2,MidpointRounding.ToEven); var paypallTakenFromCompanyCards = from p in db.Payments join gc in db.GiftCards on p.GiftCardID equals gc.GiftCardID where gc.CompanyID != "00000000-0000-0000-0000-000000000000" where gc.CompanyID != "" where gc.TotalIn != 0 where gc.SalesDealRate != 0 select (p.Amount - p.AmountReceived); var totalOwedFromCompanyCards = from g in db.GiftCards where g.CompanyID != "00000000-0000-0000-0000-000000000000" where g.CompanyID != "" where g.TotalIn != 0 where g.SalesDealRate != 0 select Math.Round((g.TotalIn * ((100 - g.SalesDealRate)/100)),2,MidpointRounding.ToEven); decimal CreditCard_Rate = 3; decimal totaltopaytocompany; decimal totalbenefits; decimal totalnotbelongingtogodine; try { totaltopaytocompany = (decimal)totalspentbyCustomersAfterDiscountB.Sum() - (decimal)totalpaidtocompanies.Sum(); } catch { totaltopaytocompany = 0; } try { totalbenefits = (decimal) totalspentbyCustomersB.Sum() * (1 - CreditCard_Rate / 100) - (decimal) totalspentbyCustomersAfterDiscountB.Sum();} catch { totalbenefits = 0; } dt = new DataTable("Companies"); dt.Columns.Add("ID", typeof(string)); dt.Columns.Add("Description", typeof(string)); dt.Columns.Add("Amount", typeof(string)); DataRow tablerow; try { tablerow = dt.NewRow(); tablerow["ID"] = "A"; tablerow["Description"] = "Total money spent by customers (transactions)"; try { tablerow["Amount"] = Math.Round(totalspentbyCustomersB.Sum(), 2) + "(Only from AT giftcards)"; }catch { tablerow["Amount"] = "0.00"; } dt.Rows.Add(tablerow); tablerow = dt.NewRow(); tablerow["ID"] = "B"; tablerow["Description"] = "Total money remaining on AT gift cards"; try{ tablerow["Amount"] = Math.Round(totalLeftOngiftcards.Sum(),2) + "(includes IT types)"; }catch { tablerow["Amount"] ="0.00"; } dt.Rows.Add(tablerow); tablerow = dt.NewRow(); tablerow["ID"] = "C"; tablerow["Description"] = "Total monney put on AT giftcards."; try{ tablerow["Amount"] = Math.Round(totalPaidbyCustomersA.Sum(), 2) + "(" + Math.Round(totalPaidbyCustomersB.Sum(), 2) + " after paypall fees, neither include IT types)"; }catch { tablerow["Amount"] ="0.00"; } dt.Rows.Add(tablerow); tablerow = dt.NewRow(); tablerow["ID"] = "D"; tablerow["Description"] = "Total money Put Onto Company Cards"; try{ tablerow["Amount"] = Math.Round(totalPutOnCompanyCards.Sum(), 2); }catch { tablerow["Amount"] ="0.00"; } dt.Rows.Add(tablerow); tablerow = dt.NewRow(); tablerow["ID"] = "E"; tablerow["Description"] = "Total money Made off of Company Cards"; try { tablerow["Amount"] = Math.Round(totalMadeOffCompanyCards.Sum() - paypallTakenFromCompanyCards.Sum(), 2) + "(Commision - Paypall fees)"; } catch { tablerow["Amount"] = "0.00"; } dt.Rows.Add(tablerow); tablerow = dt.NewRow(); tablerow["ID"] = ""; tablerow["Description"] = "F + G - H = I"; tablerow["Amount"] = ""; dt.Rows.Add(tablerow); } catch(Exception e) { Label2.Text = e.Message; } try { tablerow = dt.NewRow(); tablerow["ID"] = "F"; tablerow["Description"] = "Total made by companies from AT redemptions."; tablerow["Amount"] = Math.Round(totalspentbyCustomersAfterDiscountB.Sum(), 2); dt.Rows.Add(tablerow); }catch{} try{ tablerow = dt.NewRow(); tablerow["ID"] = "G"; tablerow["Description"] = "Total made by companies for company GC"; tablerow["Amount"] = Math.Round(totalOwedFromCompanyCards.Sum(),2); dt.Rows.Add(tablerow); } catch { } try{ tablerow = dt.NewRow(); tablerow["ID"] = "H"; tablerow["Description"] = "Total money paid to companies"; tablerow["Amount"] = Math.Round(totalpaidtocompanies.Sum(),2); dt.Rows.Add(tablerow); } catch{ } try { tablerow = dt.NewRow(); tablerow["ID"] = "I"; tablerow["Description"] = "Remaining to pay companies"; tablerow["Amount"] = (Math.Round(totalspentbyCustomersAfterDiscountB.Sum(), 2) + Math.Round(totalOwedFromCompanyCards.Sum(), 2) - Math.Round(totalpaidtocompanies.Sum(),2)); dt.Rows.Add(tablerow); } catch { } //////////////////// Label1.Text = "Current number of users online " + Membership.GetNumberOfUsersOnline().ToString(); Session["dt"] = dt; GV.DataSource = dt; GV.AllowSorting = false; GV.AllowPaging = false; //GV.PageSize = 50; //GV.Columns["Money"].ItemStyle.HorizontalAlign = HorizontalAlign.Right; GV.DataBind(); }
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(); }
//////////////////////////////////////////////////////////////////////////////////////////// TRANSACTION protected void ddtransactionUsr_SelectedIndexChanged(object sender, EventArgs e) { ddtransactionID.Items.Clear(); DataClassesAlbertDataContext db = new DataClassesAlbertDataContext(); GoDine a = new GoDine(); //Guid idCustomer = a.UserName_2_Guid(ddtransactionUsr.SelectedValue); if (!ddtransactionUsr.SelectedValue.Contains("---")) { string idCustomer_email = ddtransactionUsr.SelectedValue; var barcodes = from gc in db.GiftCards where gc.EmailTo == idCustomer_email select gc.BarCode; int number_of_gc = 0; foreach (long barcode in barcodes) { ddtransactionID.Items.Add(UTILITIES.appendChecksum(barcode)); number_of_gc = number_of_gc + 1; } if (number_of_gc > 0) { ddtransactionID_SelectedIndexChanged(null, null); } else { lbltransaction.Text = "This user has not any gift card"; } } else { string idCustomer_email = ddtransactionUsr.SelectedValue; var barcodes = from gc in db.GiftCards select gc.BarCode; int number_of_gc = 0; foreach (long barcode in barcodes) { ddtransactionID.Items.Add(UTILITIES.appendChecksum(barcode)); number_of_gc = number_of_gc + 1; } if (number_of_gc > 0) { ddtransactionID_SelectedIndexChanged(null, null); } } }
protected void btnSalesDealRate_Click(object sender, EventArgs e) { decimal number = -1; string num = tbSalesDealRate.Text; GoDine a = new GoDine(); string username = ddSalesDealRate.SelectedValue; if (!username.Contains("---sellers---")) { number = Convert.ToDecimal(num); if (number >= 0 && number <= 100) { DataClassesAlbertDataContext db = new DataClassesAlbertDataContext(); SalesID qry = (from s in db.SalesIDs where s.UserID == a.UserName_2_Guid(username) select s).Single(); //Company qry = qry.Single(); // if we do not insert the fist single qry.DealRate = number; db.SubmitChanges(); lblSalesDealRate.Text = "OK -> Deal Rate set to " + number.ToString() + " % for seller " + username; tbSalesDealRate.Text = number.ToString(); } else { lblSalesDealRate.Text = "ERROR -> Entered value must be an integer between 1 and 99 for company " + username; } } else { lblSalesDealRate.Text = "Please select a seller."; } }