private void filterByPrice()
{
decimal hiVal, lowVal;
if (txtPriceHi.Text == "")
{
hiVal = (decimal)int.MaxValue;
}
else
{
hiVal = Decimal.Parse(txtPriceHi.Text);
}
if (txtPriceLow.Text == "")
{
lowVal = 0;
}
else
{
lowVal = Decimal.Parse(txtPriceLow.Text);
}
using (StoreDataDataContext context = new StoreDataDataContext())
{
grdInvoices.DataSource = context.Invoices.Where(i => i.CustID == customerID && i.TotalBal >= lowVal && i.TotalBal <= hiVal).Select(i => new { Date = i.orderDate, Invoice = i.InvoiceID, Product = i.Product.Descr, i.Qty, UnitPrice = i.Product.PricePerUnit, Total = i.TotalBal });
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
string usernm = txtUsrnm.Text;
string pwd = txtPwd.Text;
if (usernm == "" || pwd == "")
{
lblError.Text = "Invalid Username or Password.";
}
else
{
using (StoreDataDataContext context = new StoreDataDataContext())
{
var u = context.Customers.Where(c => c.userid == usernm && c.pword == pwd);
if (u.Count() == 1)
{
var user = u.First();
// lblError.Text = "Successful!";
customerID = user.CustID;
this.Close();
}
else
{
lblError.Text = "User not found.\nWrong username/password combination.";
}
}
}
}
private void filterByDate()
{
using (StoreDataDataContext context = new StoreDataDataContext())
{
grdInvoices.DataSource = context.Invoices.Where(i => i.CustID == customerID && i.orderDate >= dpLow.Value && i.orderDate <= dpHi.Value).Select(i => new { Date = i.orderDate, Invoice = i.InvoiceID, Product = i.Product.Descr, i.Qty, UnitPrice = i.Product.PricePerUnit, Total = i.TotalBal });
}
}
private void frmAccount_Load(object sender, EventArgs e)
{
using (StoreDataDataContext context = new StoreDataDataContext())
{
grdInvoices.DataSource = context.Invoices.Where(i => i.CustID == customerID).Select(i => new { Date = i.orderDate, Invoice = i.InvoiceID, Product = i.Product.Descr, i.Qty, UnitPrice = i.Product.PricePerUnit, Total = i.TotalBal });
Customer cstmr = context.Customers.Where(c => c.CustID == customerID).First();
setFields(cstmr);
}
}
private void refreshData()
{
using (StoreDataDataContext context = new StoreDataDataContext())
{
var products = context.Products.Where(p => p.totAvail > 0).Select(p => new { p.ProdID, Description = p.Descr, p.PricePerUnit, InStock = p.totAvail });
grdProducts.DataSource = products;
foreach (DataGridViewColumn c in grdProducts.Columns)
{
c.Width = 115;
}
}
}
private void btnPurchase_Click(object sender, EventArgs e)
{
using (StoreDataDataContext context = new StoreDataDataContext())
{
if (c.CreditLimit >= c.Balance + Decimal.Parse(txtTotPrice.Text))
{
//create Invoice (1 product per purchase)
Invoice i = new Invoice();
i.CustID = c.CustID;
i.ProdID = p.ProdID;
i.Qty = (int)numQty.Value;
i.orderDate = DateTime.Today;
i.TotalBal = Decimal.Parse(txtTotPrice.Text);
context.Invoices.InsertOnSubmit(i);
var cstmr = context.Customers.Where(c => c.CustID == this.c.CustID).First();
Customer customer = (Customer)cstmr;
//bill customer
customer.Balance += i.TotalBal;
var prdct = context.Products.Where(p => p.ProdID == this.p.ProdID).First();
Product product = (Product)prdct;
// reduce number in stock
product.totAvail -= (int)numQty.Value;
context.SubmitChanges();
this.Hide();
MessageBox.Show("Order successfully Placed.", "Purchase Successful", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
else
{
MessageBox.Show("Insufficient credit balance to allow for this purchase.", "Purchase Canceled", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void btnPay_Click(object sender, EventArgs e)
{
if (txtAmt.Text == "")
{
MessageBox.Show("Dollar Amount Must Be Entered.", "No Amount Specified", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
decimal amt = decimal.Parse(txtAmt.Text);
using (StoreDataDataContext context = new StoreDataDataContext())
{
Customer cstmr = context.Customers.Where(c => c.CustID == customerID).First();
cstmr.Balance -= amt;
context.SubmitChanges();
setFields(cstmr);
}
}
}
private void grdProducts_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e)
{
//select prod id, but hide it.
//grdProducts.CurrentRow.Cells["ProdID"]
int prodID = Int32.Parse(grdProducts.CurrentRow.Cells["ProdID"].Value.ToString());
using (StoreDataDataContext context = new StoreDataDataContext()) {
var cstmr = context.Customers.Where(c => c.CustID == customerID).First();
var prdct = context.Products.Where(o => o.ProdID == prodID).First();
Customer cstmr2 = (Customer)cstmr;
Product prdct2 = (Product)prdct;
frmPurchase p = new frmPurchase(prdct2, cstmr2);
this.Hide();
p.ShowDialog();
refreshData();
this.Show();
}
}