public override object getAll(Type type = null)
{
List <BillEntity> listBillEntities = new List <BillEntity>();
try
{
using (StoreManagementEntities context = new StoreManagementEntities())
{
foreach (BillHistory bill in context.BillHistories)
{
Dictionary <int, int> lstProduct = context.BillDetails.AsParallel()
.Where(temp => temp.BillID == bill.BillID)
.ToDictionary(t => t.ProductID, t => t.Quantity);
BillEntity entity = new BillEntity()
{
BillDate = bill.BillDate,
BillID = bill.BillID,
CashierID = bill.CashierID,
ListProduct = lstProduct,
TotalPrice = bill.TotalPrice
};
listBillEntities.Add(entity);
}
}
}
catch (Exception e)
{
CustomException ex = new CustomException(GetType().Name + " : GetAll \n" + e.Message);
ex.showPopupError();
}
return(listBillEntities);
}
public override int insert(object obj)
{
try
{
GoodsImportEntity newEntity = obj as GoodsImportEntity;
GoodsImportHistory entity = newEntity.Cast <GoodsImportHistory>();
using (StoreManagementEntities context = new StoreManagementEntities())
{
context.GoodsImportHistories.Add(entity);
Product product = context.Products.Find(entity.ProductID);
product.Quantity += entity.Quantity;
context.SaveChanges();
}
return((int)entity.ImportDate.ToBinary());
}
catch (Exception e)
{
CustomException ex = new CustomException(GetType().Name + " : Insert " + obj.ToString() + "\n" + e.Message);
ex.showPopupError();
}
return(-1);
}
public override void delete(object obj)
{
try
{
UserShiftEntity entity = obj as UserShiftEntity;
using (StoreManagementEntities context = new StoreManagementEntities())
{
ShiftRegistration delete = (from u in context.ShiftRegistrations
where entity.Week == u.Week && entity.Shift == u.Shift &&
entity.WeekDay == u.WeekDay
select u).Single();
context.ShiftRegistrations.Remove(delete);
ShiftTime shift = context.ShiftTimes.Find(entity.WeekDay, entity.Shift);
shift.Status = 1;
context.SaveChanges();
}
}
catch (Exception e)
{
CustomException ex = new CustomException(GetType().Name + " : Delete " + obj.ToString() + "\n" + e.Message);
ex.showPopupError();
}
}
public override int insert(object obj)
{
try
{
UserShiftEntity newUserShift = obj as UserShiftEntity;
ShiftRegistration shift = newUserShift.Cast <ShiftRegistration>();
using (StoreManagementEntities context = new StoreManagementEntities())
{
context.ShiftRegistrations.Add(shift);
ShiftTime regShift = context.ShiftTimes.Find(shift.WeekDay, shift.Shift);
regShift.Status = 0;
context.SaveChanges();
}
return(shift.Week);
}
catch (Exception e)
{
CustomException ex = new CustomException(GetType().Name + " : Insert " + obj.ToString() + "\n" + e.Message);
ex.showPopupError();
}
return(-1);
}
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 delete(object obj)
{
try
{
GoodsImportEntity entity = obj as GoodsImportEntity;
using (StoreManagementEntities context = new StoreManagementEntities())
{
GoodsImportHistory delete = (from u in context.GoodsImportHistories
where entity.ImportDate == u.ImportDate && entity.ProductID == u.ProductID
select u).Single();
context.GoodsImportHistories.Remove(delete);
Product product = context.Products.Find(entity.ProductID);
product.Quantity -= entity.Quantity;
context.SaveChanges();
}
}
catch (Exception e)
{
CustomException ex = new CustomException(GetType().Name + " : Delete " + obj.ToString() + "\n" + e.Message);
ex.showPopupError();
}
}
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 static void resetShift()
{
using (var context = new StoreManagementEntities()) {
foreach (var shift in context.ShiftTimes)
{
shift.Status = 1;
}
context.SaveChanges();
}
}
public override int insert(object obj)
{
try
{
if (obj == null)
{
throw new CustomException(GetType().Name + " : Inserting Null Value");
}
BillEntity newBill = obj as BillEntity;
BillHistory billHistory = new BillHistory
{
CashierID = newBill.CashierID,
BillDate = newBill.BillDate,
TotalPrice = CalculateTotalPrice(newBill.ListProduct)
};
using (StoreManagementEntities context = new StoreManagementEntities())
{
context.BillHistories.Add(billHistory);
foreach (KeyValuePair <int, int> product in newBill.ListProduct)
{
BillDetail billDetail = new BillDetail
{
BillID = billHistory.BillID,
ProductID = product.Key,
Quantity = product.Value
};
Product pro = context.Products.Find(product.Key);
pro.Quantity -= product.Value;
context.BillDetails.Add(billDetail);
}
context.SaveChanges();
}
return(billHistory.BillID);
}
catch (Exception e)
{
CustomException ex = new CustomException(GetType().Name + " : Insert " + obj.ToString() + "\n" + e.Message);
ex.showPopupError();
}
return(-1);
}
public override object get(object ID, Type type = null)
{
UserEntity userEntity = null;
try
{
using (StoreManagementEntities context = new StoreManagementEntities())
{
userEntity = context.Users.Find(ID).Cast<UserEntity>();
}
}
catch (Exception e)
{
CustomException ex = new CustomException(GetType().Name + " : Get " + ID + "\n" + e.Message);
ex.showPopupError();
}
return userEntity;
}
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();
}
}
public override object get(object ID, Type type = null)
{
UserShiftEntity entity = null;
try
{
int Week = (int)ID?.GetType().GetProperty("Week")?.GetValue(ID, null);
string WeekDay = (string)ID?.GetType().GetProperty("WeekDay")?.GetValue(ID, null);
int Shift = (int)ID?.GetType().GetProperty("Shift")?.GetValue(ID, null);
using (StoreManagementEntities context = new StoreManagementEntities())
{
entity = context.ShiftRegistrations.Find(Week, WeekDay, Shift).Cast <UserShiftEntity>();
}
}
catch (Exception)
{
}
return(entity);
}
public override int insert(object obj)
{
try
{
Product product = obj.Cast <Product>();
using (StoreManagementEntities context = new StoreManagementEntities())
{
context.Products.Add(product);
context.SaveChanges();
}
return(product.ProductID);
}
catch (Exception e)
{
CustomException ex = new CustomException(GetType().Name + " : Insert " + obj.ToString() + "\n" + e.Message);
ex.showPopupError();
}
return(-1);
}
public override void delete(object obj)
{
try
{
ProductEntity product = obj as ProductEntity;
using (StoreManagementEntities context = new StoreManagementEntities())
{
Product delete = (from p in context.Products
where product.ProductID == p.ProductID
select p).Single();
context.Products.Remove(delete);
context.SaveChanges();
}
}
catch (Exception e)
{
CustomException ex = new CustomException(GetType().Name + " : Delete " + obj.ToString() + "\n" + e.Message);
ex.showPopupError();
}
}
public override object get(object ID, Type type = null)
{
GoodsImportEntity entity = null;
try
{
DateTime ImportDate = (DateTime)ID?.GetType().GetProperty("ImportDate")?.GetValue(ID, null);
int ProductID = (int)ID?.GetType().GetProperty("ProductID")?.GetValue(ID, null);
using (StoreManagementEntities context = new StoreManagementEntities())
{
entity = context.GoodsImportHistories.Find(ImportDate, ProductID).Cast <GoodsImportEntity>();
}
}
catch (Exception e)
{
CustomException ex = new CustomException(GetType().Name + " : Get " + ID + "\n" + e.Message);
ex.showPopupError();
}
return(entity);
}
public override void delete(object obj)
{
try
{
UserEntity user = obj as UserEntity;
using (StoreManagementEntities context = new StoreManagementEntities())
{
User delete = (from u in context.Users
where user.UserID == u.UserID
select u).Single();
context.Users.Remove(delete);
context.SaveChanges();
}
}
catch (Exception e)
{
CustomException ex = new CustomException(GetType().Name + " : Delete " + obj.ToString() + "\n" + e.Message);
ex.showPopupError();
}
}
public override object getAll(Type type = null)
{
List<UserEntity> listUserEntities = new List<UserEntity>();
try
{
using (StoreManagementEntities context = new StoreManagementEntities())
{
foreach (User user in context.Users)
{
UserEntity entity = user.Cast<UserEntity>();
listUserEntities.Add(entity);
}
}
}
catch (Exception e)
{
CustomException ex = new CustomException(GetType().Name + " : GetAll \n" + e.Message);
ex.showPopupError();
}
return listUserEntities;
}
public override object getAll(Type type = null)
{
List <UserShiftEntity> listShift = new List <UserShiftEntity>();
try
{
using (StoreManagementEntities context = new StoreManagementEntities())
{
foreach (ShiftRegistration shift in context.ShiftRegistrations)
{
UserShiftEntity entity = shift.Cast <UserShiftEntity>();
listShift.Add(entity);
}
}
}
catch (Exception e)
{
CustomException ex = new CustomException(GetType().Name + " : GetAll \n" + e.Message);
ex.showPopupError();
}
return(listShift);
}
public override object getAll(Type type = null)
{
List <ProductEntity> listProductEntities = new List <ProductEntity>();
try
{
using (StoreManagementEntities context = new StoreManagementEntities())
{
foreach (Product product in context.Products)
{
ProductEntity entity = product.Cast <ProductEntity>();
listProductEntities.Add(entity);
}
}
}
catch (Exception e)
{
CustomException ex = new CustomException(GetType().Name + " : GetAll \n" + e.Message);
ex.showPopupError();
}
return(listProductEntities);
}
public override object getAll(Type type = null)
{
List <GoodsImportEntity> listGoodsImportEntities = new List <GoodsImportEntity>();
try
{
using (StoreManagementEntities context = new StoreManagementEntities())
{
foreach (GoodsImportHistory obj in context.GoodsImportHistories)
{
GoodsImportEntity entity = obj.Cast <GoodsImportEntity>();
listGoodsImportEntities.Add(entity);
}
}
}
catch (Exception e)
{
CustomException ex = new CustomException(GetType().Name + " : GetAll \n" + e.Message);
ex.showPopupError();
}
return(listGoodsImportEntities);
}
public override int insert(object obj)
{
try
{
UserEntity newUser = obj as UserEntity;
User user = newUser.Cast<User>();
using (StoreManagementEntities context = new StoreManagementEntities())
{
context.Users.Add(user);
context.SaveChanges();
}
return user.UserID;
}
catch (Exception e)
{
CustomException ex = new CustomException(GetType().Name + " : Insert " + obj.ToString() + "\n" + e.Message);
ex.showPopupError();
}
return -1;
}
public override void delete(object obj)
{
try
{
BillEntity entity = obj as BillEntity;
using (StoreManagementEntities context = new StoreManagementEntities())
{
foreach (KeyValuePair <int, int> product in entity.ListProduct)
{
BillDetail detail = (from bill in context.BillDetails
where bill.BillID == entity.BillID &&
bill.ProductID == product.Key
select bill)
.Single();
context.BillDetails.Remove(detail);
Product pro = context.Products.Find(product.Key);
pro.Quantity += product.Value;
}
BillHistory history = (from bill in context.BillHistories
where bill.BillID == entity.BillID
select bill)
.Single();
context.BillHistories.Remove(history);
context.SaveChanges();
}
}
catch (Exception e)
{
CustomException ex = new CustomException(GetType().Name + " : Delete " + obj.ToString() + "\n" + e.Message);
ex.showPopupError();
}
}
public override object get(object ID, Type type = null)
{
try
{
using (StoreManagementEntities context = new StoreManagementEntities())
{
BillHistory bill = context.BillHistories.Find(ID);
if (bill == null)
{
throw new Exception();
}
Dictionary <int, int> lstProduct = context.BillDetails.AsParallel()
.Where(temp => temp.BillID == bill.BillID)
.ToDictionary(t => t.ProductID, t => t.Quantity);
BillEntity entity = new BillEntity()
{
BillDate = bill.BillDate,
BillID = bill.BillID,
CashierID = bill.CashierID,
ListProduct = lstProduct,
TotalPrice = bill.TotalPrice
};
return(entity);
}
}
catch (Exception e)
{
CustomException ex = new CustomException(GetType().Name + " : Get " + ID + "\n" + e.Message);
ex.showPopupError();
}
return(null);
}
public static List <ShiftTime> getAllShift()
{
using (var context = new StoreManagementEntities()) {
return(context.ShiftTimes.ToList());
}
}
