public bool IsGIVEdited(Model.GoodsIssuedVoucher giventity)
{
using (var context = new SCMSEntities())
{
using (TransactionScope scope = new TransactionScope())
{
try
{
var existing = context.GoodsIssuedVouchers.FirstOrDefault(p => p.Id == giventity.Id);
context.Entry(existing).CurrentValues.SetValues(giventity);
foreach (var item in giventity.ROItems)
{
GoodsIssuedVoucherItem mm;
var existingItem = mm = context.GoodsIssuedVoucherItems.FirstOrDefault(p => p.Id == item.GIVItemId);
mm.Remarks = item.Remarks;
mm.QTYDelivered = item.QTYReceived;
context.Entry(existingItem).CurrentValues.SetValues(mm);
}
int affectedRecords = context.SaveChanges();
scope.Complete();
SessionData.CurrentSession.GIVList = null;
SessionData.CurrentSession.ReleaseOrderList = null;
return(affectedRecords > 0);
}
catch (Exception ex) { scope.Dispose(); throw ex; }
}
}
}
public async Task <IHttpActionResult> PutCM_Machine(int id, CM_Machine cM_Machine)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != cM_Machine.id)
{
return(BadRequest());
}
db.Entry(cM_Machine).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CM_MachineExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public bool SaveProcurementPlan(Model.ProcurementPlan pp)
{
ClearPPSessionData();
using (var context = new SCMSEntities())
{
if (pp.Id.Equals(Guid.Empty))
{
var ppEntity = context.ProcurementPlans.FirstOrDefault(p => p.ProjectDonorId == pp.ProjectDonorId);
var pd = context.ProjectDonors.FirstOrDefault(p => p.Id == pp.ProjectDonorId);
pp.RefNumber = "PP/DRC/" + pd.Project.CountryProgramme.Country.ShortName + "/" + pd.ProjectNumber;
if (ppEntity != null)
{
ppEntity.PreparedBy = pp.PreparedBy;
ppEntity.PreparedOn = pp.PreparedOn;
ppEntity.PreparingOfficeId = pp.PreparingOfficeId;
//let the object reference point to the existing entity from the db
pp.Id = ppEntity.Id;
}
else
{
pp.Id = Guid.NewGuid();
context.ProcurementPlans.Add(pp);
}
}
else
{
var existing = context.ProcurementPlans.FirstOrDefault(p => p.Id == pp.Id);
context.Entry(existing).CurrentValues.SetValues(pp);
}
return(context.SaveChanges() > 0);
}
}
public bool UpdateOrderRequestItem(Model.OrderRequestItem entity)
{
using (var context = new SCMSEntities())
{
var existing = context.OrderRequestItems.FirstOrDefault(o => o.Id == entity.Id);
context.Entry(existing).CurrentValues.SetValues(entity);
return((context.SaveChanges() > 0) ? true : false);
}
}
public bool IsGarageInfoEdited(GarageInfo entity)
{
using (var db = new SCMSEntities())
{
clearSession();
var existing = db.GarageInfoes.FirstOrDefault(p => p.Id == entity.Id);
db.Entry(existing).CurrentValues.SetValues(entity);
return db.SaveChanges() > 0 ? true : false;
}
}
public bool SaveReviewedPO(Model.PurchaseOrder po)
{
using (var context = new SCMSEntities())
{
var pOrder = context.PurchaseOrders.FirstOrDefault(p => p.Id == po.Id);
context.Entry(pOrder).CurrentValues.SetValues(po);
ClearPOSessionData();
ClearORSessionData();
return(context.SaveChanges() > 0);
}
}
public bool SaveReviewedPOItem(Model.PurchaseOrderItem poItem)
{
using (var context = new SCMSEntities())
{
var item = context.PurchaseOrderItems.FirstOrDefault(p => p.Id == poItem.Id);
context.Entry(item).CurrentValues.SetValues(poItem);
ClearPOSessionData();
ClearORSessionData();
return((context.SaveChanges() > 0) ? true : false);
}
}
public bool IsGIVSubmited(Model.GoodsIssuedVoucher giventity)
{
using (var context = new SCMSEntities())
{
var existing = context.GoodsIssuedVouchers.FirstOrDefault(p => p.Id == giventity.Id);
context.Entry(existing).CurrentValues.SetValues(giventity);
int affectedRecords = context.SaveChanges();
SessionData.CurrentSession.GIVList = null;
return(affectedRecords > 0);
}
}
public void UpdateGRN(GoodsReceivedNote grn)
{
using (var context = new SCMSEntities())
{
var existing = context.GoodsReceivedNotes.FirstOrDefault(p => p.Id == grn.Id);
context.Entry(existing).CurrentValues.SetValues(grn);
context.SaveChanges();
SessionData.CurrentSession.PurchaseOrderList = null;
SessionData.CurrentSession.GoodsReceivedNoteList = null;
SessionData.CurrentSession.GoodsReceivedNoteItemList = null;
}
}
public bool EditRO(WarehouseRelease RO)
{
using (var context = new SCMSEntities())
{
var existing = context.WarehouseReleases.FirstOrDefault(p => p.Id == RO.Id);
context.Entry(existing).CurrentValues.SetValues(RO);
int affectedRecords = context.SaveChanges();
SessionData.CurrentSession.ReleaseOrderList = null;
SessionData.CurrentSession.ReleaseOrderItemList = null;
return(affectedRecords > 0);
}
}
public void UpdateTenderingType(TenderingType entity)
{
using (var context = new SCMSEntities())
{
var existing = context.TenderingTypes.FirstOrDefault(t => t.Id == entity.Id);
if (existing != null)
{
context.Entry(existing).CurrentValues.SetValues(entity);
context.SaveChanges();
ClearTTSessionData();
}
}
}
public bool UpdateOrderRequest(Model.OrderRequest entity)
{
using (var context = new SCMSEntities())
{
var existing = context.OrderRequests.FirstOrDefault(o => o.Id == entity.Id);
context.Entry(existing).CurrentValues.SetValues(entity);
if (context.SaveChanges() > 0)
{
//Clear session data
ClearORSessionData();
return(true);
}
return(false);
}
}
public bool SaveProcurementPlanItem(Model.ProcurementPlanItem ppItem)
{
ClearPPItemSessionData();
ClearPPSessionData();
using (var context = new SCMSEntities())
{
if (ppItem.Id.Equals(Guid.Empty))
{
ppItem.Id = Guid.NewGuid();
context.ProcurementPlanItems.Add(ppItem);
}
else
{
var existing = context.ProcurementPlanItems.FirstOrDefault(p => p.Id == ppItem.Id);
context.Entry(existing).CurrentValues.SetValues(ppItem);
}
return(context.SaveChanges() > 0);
}
}
public bool UpdateORWithPossibleProjectChange(Model.OrderRequest or, bool projectChanged)
{
ClearORSessionData();
if (!projectChanged)
{
return(this.UpdateOrderRequest(or));
}
using (var context = new SCMSEntities())
{
var entity = context.OrderRequests.FirstOrDefault(o => o.Id == or.Id);
var defaultBLId = SessionData.CurrentSession.ProjectDonorList.FirstOrDefault(p => p.Id == or.ProjectDonorId).BudgetCategories.FirstOrDefault().ProjectBudgets.FirstOrDefault();
if (defaultBLId == null)
{
return(false);
}
foreach (var orItem in entity.OrderRequestItems)
{
orItem.BudgetLineId = defaultBLId.Id;
}
context.Entry(entity).CurrentValues.SetValues(or);
return(context.SaveChanges() > 0);
}
}
