private void Button_Click_DelPro(object sender, RoutedEventArgs e)
{
db = new managementdbEntities();
if (selectedPro == null)
{
return;
}
if (selectedPro.BARCODE == null)
{
return;
}
PRODUCT delPro = db.PRODUCTs.Where(x => x.BARCODE == selectedPro.BARCODE).Select(x => x).SingleOrDefault();
string message = "Do you surely want to delete this product? ";
string caption = "Delete Product";
var result = MessageBox.Show(message, caption, MessageBoxButton.YesNo);
if (result == MessageBoxResult.Yes)
{
delPro.PSTATUS = 0;
db.SaveChanges();
MessageBox.Show("Deleted category");
this.Page_Loaded(sender, e);
}
else
{
}
db.SaveChanges();
this.Page_Loaded(sender, e);
selectedPro = null;
}
// Add new category
private void Button_Click_Add(object sender, RoutedEventArgs e)
{
addform = new CAdd();
addform.DatabaseChanged += addform_DatabaseChanged;
addform.ShowDialog();
if (newCate == null)
{
return;
}
db = new managementdbEntities();
CATEGORY newCategory = db.CATEGORies.Where(x => x.CNAME == newCate).Select(x => x).FirstOrDefault();
if (newCategory == null)
{
newCategory = new CATEGORY();
newCategory.CNAME = newCate;
newCategory.CSTATUS = 1;
db.CATEGORies.Add(newCategory);
}
else
{
newCategory.CSTATUS = 1;
}
db.SaveChanges();
this.Page_Loaded(sender, e);
newCate = null;
}
private void Button_Click_UpdPro(object sender, RoutedEventArgs e)
{
if (selectedPro == null)
{
return;
}
if (selectedPro.BARCODE == null)
{
return;
}
pupdform = new PUpdate(selectedPro);
pupdform.DatabaseChanged += pupdform_DatabaseChanged;
pupdform.ShowDialog();
if (updPro == "" || updPro == null)
{
return;
}
var result = updPro.ToString();
//MessageBox.Show(result);
var tokens = updPro.Split(new string[] { "," },
StringSplitOptions.RemoveEmptyEntries)
.Select(token => token.Trim())
.ToArray();
PRODUCT updProduct = db.PRODUCTs.Where(x => x.BARCODE == selectedPro.BARCODE).Select(x => x).FirstOrDefault();
// update = add + delete
if (updProduct != null)
{
// Not edit Barcode
if (updProduct.BARCODE != tokens[0])
{
PRODUCT newProduct = new PRODUCT();
newProduct.BARCODE = tokens[0];
newProduct.PNAME = tokens[1];
newProduct.PRICE = int.Parse(tokens[2]);
newProduct.QTY = int.Parse(tokens[3]);
newProduct.CATE = tokens[4];
newProduct.PSTATUS = 1;
updProduct.PSTATUS = 0;
db.PRODUCTs.Add(newProduct);
}
else
{
updProduct.PNAME = tokens[1];
updProduct.PRICE = int.Parse(tokens[2]);
updProduct.QTY = int.Parse(tokens[3]);
updProduct.CATE = tokens[4];
updProduct.PSTATUS = 1;
}
}
db.SaveChanges();
this.Page_Loaded(sender, e);
selectedPro = null;
}
private void Button_Click_Delete(object sender, RoutedEventArgs e)
{
db = new managementdbEntities();
if (selectedCate == null)
{
return;
}
if (selectedCate.CNAME == null)
{
return;
}
CATEGORY delEntry = db.CATEGORies.Where(x => x.CNAME == selectedCate.CNAME).Select(x => x).FirstOrDefault();
bool productOfCate = db.PRODUCTs.Where(x => x.CATE == selectedCate.CNAME).Any();
if (productOfCate)
{
string message = selectedCate.CNAME + " has already contained product(s). Do you still want to delete this category? ";
string caption = "Delete Category";
var result = MessageBox.Show(message, caption, MessageBoxButton.YesNo);
if (result == MessageBoxResult.Yes)
{
delEntry.CSTATUS = 0;
db.SaveChanges();
MessageBox.Show("Deleted product");
this.Page_Loaded(sender, e);
}
else
{
}
}
else
{
delEntry.CSTATUS = 0;
db.SaveChanges();
MessageBox.Show("Deleted product");
this.Page_Loaded(sender, e);
}
selectedCate = null;
}
private void Button_Click_AddOrder(object sender, RoutedEventArgs e)
{
oaddform = new OAdd();
oaddform.DatabaseChanged += oadddform_DatabaseChanged;
oaddform.ShowDialog();
if (newOrd == null)
{
return;
}
var result = newOrd.ToString();
var tokens = newOrd.Split(new string[] { "," },
StringSplitOptions.RemoveEmptyEntries)
.Select(token => token.Trim())
.ToArray();
// BARCODE, QUANTITY, DATE, TOTAL, COUPON
db = new managementdbEntities();
// add to transaction data
ORDER newOrder = new ORDER();
newOrder.BARCODE = tokens[0];
newOrder.QTY = int.Parse(tokens[1]);
newOrder.DATE = DateTime.Parse(tokens[2]);
newOrder.TOTAL = int.Parse(tokens[3]);
db.ORDERs.Add(newOrder);
// modify master data
PRODUCT updProduct = db.PRODUCTs.Where(x => x.BARCODE == newOrder.BARCODE).Select(x => x).SingleOrDefault();
if (updProduct != null)
{
updProduct.QTY = updProduct.QTY - newOrder.QTY;
}
//db.SaveChanges();
// modify coupon date
string couponCode = tokens[4].ToString();
COUPON updCoupon = db.COUPONs.Where(x => x.CODE == couponCode).Select(x => x).SingleOrDefault();
if (updCoupon != null)
{
updCoupon.AVAILABLE = updCoupon.AVAILABLE - 1;
}
//db.SaveChanges();
db.SaveChanges();
this.Page_Loaded(sender, e);
}
private void Button_Click_AddPro(object sender, RoutedEventArgs e)
{
paddform = new PAdd();
paddform.DatabaseChanged += paddform_DatabaseChanged;
paddform.ShowDialog();
db = new managementdbEntities();
if (newPro == null)
{
return;
}
//MessageBox.Show(newPro.ToString());
var result = newPro.ToString();
var tokens = newPro.Split(new string[] { "," },
StringSplitOptions.RemoveEmptyEntries)
.Select(token => token.Trim())
.ToArray();
string barcode = tokens[0].ToString();
PRODUCT newProduct = db.PRODUCTs.Where(x => x.BARCODE == barcode).Select(x => x).FirstOrDefault();
if (newProduct == null)
{
newProduct = new PRODUCT();
newProduct.BARCODE = tokens[0];
newProduct.PNAME = tokens[1];
newProduct.PRICE = int.Parse(tokens[2]);
newProduct.QTY = int.Parse(tokens[3]);
newProduct.CATE = tokens[4];
newProduct.PSTATUS = 1;
db.PRODUCTs.Add(newProduct);
}
else if (newProduct.PSTATUS == 0)
{
newProduct.PNAME = tokens[1];
newProduct.PRICE = int.Parse(tokens[2]);
newProduct.QTY = int.Parse(tokens[3]);
newProduct.CATE = tokens[4];
newProduct.PSTATUS = 1;
}
db.SaveChanges();
this.Page_Loaded(sender, e);
newPro = null;
}
