public override void update(object obj)
{
try
{
BillEntity entity = obj as BillEntity;
using (StoreManagementEntities context = new StoreManagementEntities())
{
BillHistory billHistory = context.BillHistories.Find(entity.BillID);
context.Entry(billHistory).CurrentValues.SetValues(entity);
billHistory.TotalPrice = CalculateTotalPrice(entity.ListProduct);
Dictionary <int, int> listProduct = entity.ListProduct;
foreach (KeyValuePair <int, int> product in listProduct)
{
BillDetail billDetail = context.BillDetails.Find(entity.BillID, product.Key);
if (billDetail != null && billDetail.Quantity != product.Value)
{
Product pro = context.Products.Find(product.Key);
pro.Quantity = pro.Quantity + billDetail.Quantity - product.Value;
context.Entry(billDetail)
.CurrentValues.SetValues(new
{
BillID = billDetail.BillID,
ProductID = product.Key,
Quantity = product.Value
});
}
else if (billDetail == null)
{
Product pro = context.Products.Find(product.Key);
pro.Quantity = pro.Quantity - product.Value;
BillDetail detail = new BillDetail()
{
BillID = entity.BillID,
ProductID = product.Key,
Quantity = product.Value
};
context.BillDetails.Add(detail);
}
}
context.SaveChanges();
}
}
catch (Exception e)
{
CustomException ex = new CustomException(GetType().Name + " : Update " + obj.ToString() + "\n" + e.Message);
ex.showPopupError();
}
}
public override void update(object obj)
{
try
{
GoodsImportEntity entity = obj as GoodsImportEntity;
using (StoreManagementEntities context = new StoreManagementEntities())
{
GoodsImportHistory old = context.GoodsImportHistories.Find(entity.ImportDate, entity.ProductID);
int oldQuantity = old.Quantity;
context.Entry(old).CurrentValues.SetValues(entity);
Product product = context.Products.Find(entity.ProductID);
product.Quantity = product.Quantity - oldQuantity + entity.Quantity;
context.SaveChanges();
}
}
catch (Exception e)
{
CustomException ex = new CustomException(GetType().Name + " : Update " + obj.ToString() + "\n" + e.Message);
ex.showPopupError();
}
}
public override void update(object obj)
{
try
{
UserEntity user = obj as UserEntity;
using (StoreManagementEntities context = new StoreManagementEntities())
{
User oldUser = context.Users.Find(user.UserID);
context.Entry(oldUser).CurrentValues.SetValues(user);
context.SaveChanges();
}
}
catch (Exception e)
{
CustomException ex = new CustomException(GetType().Name + " : Update " + obj.ToString() + "\n" + e.Message);
ex.showPopupError();
}
}
public override void update(object obj)
{
try
{
ProductEntity product = obj as ProductEntity;
using (StoreManagementEntities context = new StoreManagementEntities())
{
Product oldProduct = context.Products.Find(product.ProductID);
context.Entry(oldProduct).CurrentValues.SetValues(product);
context.SaveChanges();
}
}
catch (Exception e)
{
CustomException ex = new CustomException(GetType().Name + " : Update " + obj.ToString() + "\n" + e.Message);
ex.showPopupError();
}
}
