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();
}
