public T Create(T entity) { context = new LUSSISContext(); T newEntity = context.Set <T>().Add(entity); Save(); return(newEntity); }
public void UpdateAll(IEnumerable <StationerySupplier> newList) { IEnumerable <StationerySupplier> oldList = GetAll(); LUSSISContext.StationerySuppliers.RemoveRange(oldList); LUSSISContext.StationerySuppliers.AddRange(newList); LUSSISContext.SaveChanges(); }
public void DeleteStationerySupplier(string itemNum) { List <StationerySupplier> ss = LUSSISContext.StationerySuppliers.Where(x => x.ItemNum == itemNum).ToList(); foreach (StationerySupplier stationsupllier in ss) { LUSSISContext.StationerySuppliers.Remove(stationsupllier); } LUSSISContext.SaveChanges(); }
public T FindOneBy(Expression <Func <T, bool> > predicate) { if (typeof(T) == typeof(CartDetail)) { context.CartDetail_releaseCartData();//Note:release cart detail which are more than 1hour existed by last item of an employee context = new LUSSISContext(); } context = new LUSSISContext(); return(context.Set <T>().Where(predicate).SingleOrDefault()); }
public T FindById(ID id) { context = new LUSSISContext(); if (typeof(T) == typeof(CartDetail)) { context.CartDetail_releaseCartData();//Note:release cart detail which are more than 1hour existed by last item of an employee context = new LUSSISContext(); } return(context.Set <T>().Find(id)); }
public IEnumerable <T> FindAll() { context = new LUSSISContext(); if (typeof(T) == typeof(CartDetail)) { context.CartDetail_releaseCartData();//Note:release cart detail which are more than 1hour existed by last item of an employee context = new LUSSISContext(); } return(context.Set <T>().ToList <T>()); }
public void Acknowledge(Disbursement disbursement) { var isFulfilled = disbursement.DisbursementDetails.All(item => item.ActualQty == item.RequestedQty); disbursement.Status = isFulfilled ? Fulfilled : Unfulfilled; disbursement.AcknowledgeEmpNum = disbursement.Department.RepEmpNum; Update(disbursement); LUSSISContext.SaveChanges(); }
public Stationery AddStockAdjustment(AdjVoucher adjVoucher) { LUSSISContext.Set <AdjVoucher>().Add(adjVoucher); LUSSISContext.SaveChanges(); return(LUSSISContext.Set <Stationery>().Find(adjVoucher.ItemNum)); }
public Stationery AddRequisitionDetail(RequisitionDetail requisitionDetail) { LUSSISContext.Set <RequisitionDetail>().Add(requisitionDetail); LUSSISContext.SaveChanges(); return(LUSSISContext.Stationeries.Find(requisitionDetail.ItemNum)); }
public Repository() { LUSSISContext = new LUSSISContext(); }
public void UpdateRequisition(Requisition requisition) { LUSSISContext.Entry(requisition).State = EntityState.Modified; LUSSISContext.SaveChanges(); }
public void UpdateDisbursementDetail(DisbursementDetail detail) { LUSSISContext.Entry(detail).State = EntityState.Modified; LUSSISContext.SaveChanges(); }