/// <summary> /// Check if the project name already exists. If it does, then use the existing project instead of creating a new one /// The check is made at country programme level /// </summary> /// <param name="project"></param> /// <returns></returns> private void SaveProject(Project project) { List<Project> existingProjects; using (var context = new SCMSEntities()) { existingProjects = context.Projects.Where(p => p.Name.Trim().Equals(project.Name.Trim(), StringComparison.CurrentCultureIgnoreCase) && p.CountryProgrammeId == project.CountryProgrammeId).ToList<Project>(); if (existingProjects.Count > 0) { existingProjects[0].Name = project.Name; existingProjects[0].ShortName = project.ShortName; context.SaveChanges(); project.Id = existingProjects[0].Id; } else { Project proj = new Project(); proj.Name = project.Name; proj.ShortName = project.ShortName; proj.ProjectNumber = project.ProjectNumber; proj.CountryProgrammeId = project.CountryProgrammeId; proj.Id = project.Id = Guid.NewGuid(); context.Projects.Add(proj); context.SaveChanges(); } } }
public bool IsGRNVerified(GoodsReceivedNote GRNentity) { using (var context = new SCMSEntities()) { using (TransactionScope scope = new TransactionScope()) { foreach (GoodsReceivedNoteItem item in GRNentity.ItemColl) { GoodsReceivedNoteItem grit = context.GoodsReceivedNoteItems.FirstOrDefault(p => p.Id == item.Id); if (context.Inventories.Count(p => p.ItemId == grit.PurchaseOrderItem.Item.Id && p.WareHouseId == grit.GoodsReceivedNote.WareHouseId) > 0) { if (grit.PurchaseOrderItem.Item.ItemCategory.CategoryCode == "C") { Model.Inventory invt = context.Inventories.FirstOrDefault(p => p.ItemId == grit.PurchaseOrderItem.Item.Id && p.WareHouseId == grit.GoodsReceivedNote.WareHouseId); invt.Quantity += (long)item.QuantityDelivered; ((IObjectContextAdapter)context).ObjectContext.ObjectStateManager.ChangeObjectState(invt, System.Data.EntityState.Modified); } } else { long qty = 0; if (grit.PurchaseOrderItem.Item.ItemCategory.CategoryCode == "C") { qty = (long)item.QuantityDelivered; } Model.Inventory newinvetoryEntity = new Model.Inventory() { Id = Guid.NewGuid(), ItemId = grit.PurchaseOrderItem.Item.Id, Quantity = qty, CountryProgrammeId = GRNentity.CountryProgrammeId, WareHouseId = (Guid)grit.GoodsReceivedNote.WareHouseId }; context.Inventories.Add(newinvetoryEntity); } Model.GoodsReceivedNoteItem grnitm = context.GoodsReceivedNoteItems.FirstOrDefault(p => p.Id == item.Id); grnitm.QuantityDamaged = item.QuantityDamaged; grnitm.QuantityDelivered = item.QuantityDelivered; ((IObjectContextAdapter)context).ObjectContext.ObjectStateManager.ChangeObjectState(grnitm, System.Data.EntityState.Modified); context.SaveChanges(); } Model.GoodsReceivedNote grn = context.GoodsReceivedNotes.FirstOrDefault(p => p.Id == GRNentity.Id); grn.Verified = true; grn.ApprovedOn = DateTime.Now; grn.ReceptionApprovedBy = GRNentity.ReceptionApprovedBy; ((IObjectContextAdapter)context).ObjectContext.ObjectStateManager.ChangeObjectState(grn, System.Data.EntityState.Modified); if (context.SaveChanges() > 0) { scope.Complete(); return(true); } else { scope.Dispose(); return(false); } } } }
public void UndoAuthorization(Model.OrderRequest or) { try { decimal?amount; decimal?currAmount; //Amount in ProjectBudget currency using (var context = new SCMSEntities()) { var orItems = context.OrderRequestItems.Where(i => i.OrderRequestId == or.Id).ToList(); foreach (var orItem in orItems) { amount = orItem.EstimatedPrice; currAmount = exchangeRateService.GetForeignCurrencyValue(orItem.ProjectBudget.BudgetCategory.ProjectDonor.Currency, orItem.OrderRequest.Currency, amount, (Guid)or.CountryProgrammeId); orItem.ProjectBudget.TotalCommitted -= currAmount; var budgetCommitmentList = context.BudgetCommitments.Where(b => b.OrderRequestItemId == orItem.Id).ToList(); foreach (var budgetCommitment in budgetCommitmentList) { context.BudgetCommitments.Remove(budgetCommitment); } } context.SaveChanges(); } } catch (Exception ex) { } }
public void AuthorizeOrderRequest(Model.OrderRequest or) { try { decimal?amount; decimal?currAmount; //Amount in ProjectBudget currency using (var context = new SCMSEntities()) { var orItems = context.OrderRequestItems.Where(i => i.OrderRequestId == or.Id).ToList(); foreach (var orItem in orItems) { amount = orItem.EstimatedPrice; currAmount = exchangeRateService.GetForeignCurrencyValue(orItem.ProjectBudget.BudgetCategory.ProjectDonor.Currency, orItem.OrderRequest.Currency, amount, (Guid)or.CountryProgrammeId); orItem.ProjectBudget.TotalCommitted += currAmount; //Add to BudgetCommitment var budgetCommitment = new BudgetCommitment(); budgetCommitment.Id = Guid.NewGuid(); budgetCommitment.OrderRequestItemId = orItem.Id; budgetCommitment.AmountCommitted = (decimal)currAmount; budgetCommitment.DateCommitted = DateTime.Now; budgetCommitment.BudgetLineId = orItem.ProjectBudget.Id; context.BudgetCommitments.Add(budgetCommitment); } context.SaveChanges(); } } catch (Exception ex) { } }
public void RejectWRO(Guid wroId) { using (var context = new SCMSEntities()) { using (TransactionScope scope = new TransactionScope()) { try { var wrnItems = context.WarehouseReleaseItems.Where(w => w.WarehouseReleaseId == wroId).ToList(); foreach (var wrnItem in wrnItems) { string itemCategory = context.Inventories.FirstOrDefault(p => p.Id == wrnItem.InventoryId).Item.ItemCategory.CategoryCode; if (itemCategory.Equals("A")) { wrnItem.Quantity = 1; Model.Asset ass = context.Assets.FirstOrDefault(p => p.Id == wrnItem.AssetId); ass.IsReleased = false; ass.CurrentOwnerId = null; ((IObjectContextAdapter)context).ObjectContext.ObjectStateManager.ChangeObjectState(ass, System.Data.EntityState.Modified); } Model.Inventory inv = context.Inventories.First(p => p.Id == wrnItem.InventoryId); inv.Quantity += (Int64)wrnItem.Quantity; ((IObjectContextAdapter)context).ObjectContext.ObjectStateManager.ChangeObjectState(inv, System.Data.EntityState.Modified); } context.SaveChanges(); SessionData.CurrentSession.ReleaseOrderList = null; SessionData.CurrentSession.ReleaseOrderItemList = null; SessionData.CurrentSession.AssetList = null; SessionData.CurrentSession.InventoryList = null; scope.Complete(); } catch (Exception ex) { scope.Dispose(); throw ex; } } } }
public bool IsWRNItemDeleted(Guid wrnItemId) { using (var context = new SCMSEntities()) { Model.WarehouseReleaseItem wrnitm = context.WarehouseReleaseItems.FirstOrDefault(p => p.Id == wrnItemId); string itemCategory = context.Inventories.FirstOrDefault(p => p.Id == wrnitm.InventoryId).Item.ItemCategory.CategoryCode; if (itemCategory.Equals("A")) { wrnitm.Quantity = 1; Model.Asset ass = context.Assets.FirstOrDefault(p => p.Id == wrnitm.AssetId); ass.IsReleased = false; ass.CurrentOwnerId = null; ((IObjectContextAdapter)context).ObjectContext.ObjectStateManager.ChangeObjectState(ass, System.Data.EntityState.Modified); } Model.Inventory inv = context.Inventories.First(p => p.Id == wrnitm.InventoryId); inv.Quantity += (Int64)wrnitm.Quantity; ((IObjectContextAdapter)context).ObjectContext.ObjectStateManager.ChangeObjectState(inv, System.Data.EntityState.Modified); context.WarehouseReleaseItems.Remove(wrnitm); int affectedColumns = context.SaveChanges(); SessionData.CurrentSession.ReleaseOrderList = null; SessionData.CurrentSession.ReleaseOrderItemList = null; SessionData.CurrentSession.AssetList = null; SessionData.CurrentSession.InventoryList = null; return(affectedColumns > 0 ? true : false); } }
public bool IsROrderDeleted(Guid ROId) { using (var context = new SCMSEntities()) { var RO = context.WarehouseReleases.FirstOrDefault(p => p.Id == ROId); foreach (var item in RO.WarehouseReleaseItems) { string itemCategory = context.Inventories.FirstOrDefault(p => p.Id == item.InventoryId).Item.ItemCategory.CategoryCode; if (itemCategory.Equals("A")) { item.Quantity = 1; Model.Asset ass = context.Assets.FirstOrDefault(p => p.Id == item.AssetId); ass.IsReleased = false; ass.CurrentOwnerId = null; ((IObjectContextAdapter)context).ObjectContext.ObjectStateManager.ChangeObjectState(ass, System.Data.EntityState.Modified); } Model.Inventory inv = context.Inventories.First(p => p.Id == item.InventoryId); inv.Quantity += (Int64)item.Quantity; ((IObjectContextAdapter)context).ObjectContext.ObjectStateManager.ChangeObjectState(inv, System.Data.EntityState.Modified); } context.WarehouseReleases.Remove(RO); int affectedRecords = context.SaveChanges(); SessionData.CurrentSession.ReleaseOrderList = null; SessionData.CurrentSession.ReleaseOrderItemList = null; SessionData.CurrentSession.AssetList = null; SessionData.CurrentSession.InventoryList = null; return(affectedRecords > 0 ? true : false); } }
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 SaveRequest4Payment(Model.PaymentRequest entity, EntityCollection <PaymentRequestBudgetLine> collection) { using (var context = new SCMSEntities()) { using (TransactionScope scope = new TransactionScope()) { try { context.PaymentRequests.Add(entity); //if (context.SaveChanges() > 0) //{ foreach (PaymentRequestBudgetLine item in collection) { context.PaymentRequestBudgetLines.Add(item); if (!(context.SaveChanges() > 0)) { scope.Complete(); return(false); } } //Send notification to Finance notificationService.SendToAppropriateApprover(NotificationHelper.rfpCode, NotificationHelper.reviewCode, entity.Id); scope.Complete(); return(true); //} //else { scope.Dispose(); return false; } } catch (Exception ex) { scope.Dispose(); throw new Exception(ex.Message); } } } }
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 void BackDateOR(Model.OrderRequest or) { using (var context = new SCMSEntities()) { using (TransactionScope scope = new TransactionScope()) { try { //Get Current OR from DB var currentOR = context.OrderRequests.FirstOrDefault(o => o.Id == or.Id); //Initialize BackDate object var backDate = new DocumentBackDating(); backDate.Id = Guid.NewGuid(); backDate.BackDatedBy = or.BackDatedBy; backDate.BackDatedOn = DateTime.Now; backDate.NewDate = or.OrderDate.Value; backDate.OrderRequestId = or.Id; backDate.PreviousDate = currentOR.OrderDate.Value; backDate.Reason = or.BackDatingReason; //Insert BackDate details into db context.DocumentBackDatings.Add(backDate); //Update date on OR in db currentOR.OrderDate = or.OrderDate; context.SaveChanges(); scope.Complete(); ClearORSessionData(); } catch (Exception ex) { scope.Dispose(); throw ex; } } } }
public void CreateBudgetLine(ProjectBudget bsl) { try { using (var context = new SCMSEntities()) { var newBsl = new ProjectBudget(); newBsl.Id = Guid.NewGuid(); newBsl.LineNumber = bsl.LineNumber; newBsl.Description = bsl.Description; newBsl.BudgetCategoryId = bsl.BudgetCategoryId; newBsl.TotalBudget = bsl.TotalBudget; newBsl.TotalCommitted = newBsl.TotalPosted = 0; //Save Overrun Adjustment Percentage var bc = context.BudgetCategories.IncludeProjectDonor().FirstOrDefault(b => b.Id == bsl.BudgetCategoryId.Value); if (!bsl.OverrunAdjustment.HasValue) { newBsl.OverrunAdjustment = bc.ProjectDonor.OverrunAdjustment; } context.ProjectBudgets.Add(newBsl); context.SaveChanges(); ClearProjectBudgetList(); } } catch (Exception ex) { } }
public bool IsGIVItemAdded(Model.GoodsIssuedVoucher giventity) { using (var context = new SCMSEntities()) { foreach (var item in giventity.ROItems) { if (item.IsRemoved) { continue; } var givitem = new GoodsIssuedVoucherItem() { Id = Guid.NewGuid(), QTYDelivered = item.QTYReceived, GoodsIssuedVoucherId = giventity.Id, WarehouseReleaseItemId = item.ROItemId, Remarks = item.Remarks }; context.GoodsIssuedVoucherItems.Add(givitem); } int affectedRecords = context.SaveChanges(); SessionData.CurrentSession.GIVList = null; SessionData.CurrentSession.ReleaseOrderList = null; return(affectedRecords > 0); } }
public bool SavePuchaseOrder(Model.PurchaseOrder entity) { using (var context = new SCMSEntities()) { if (entity.Id.Equals(Guid.Empty)) { entity.Id = Guid.NewGuid(); context.PurchaseOrders.Add(entity); } else { var po = context.PurchaseOrders.FirstOrDefault(p => p.Id == entity.Id); po.CurrencyId = entity.CurrencyId; po.DeliveryAddress = entity.DeliveryAddress; po.LatestDeliveryDate = entity.LatestDeliveryDate; po.PaymentTermId = entity.PaymentTermId; po.PODate = entity.PODate; po.ProjectDonorId = entity.ProjectDonorId; po.QuotationRef = entity.QuotationRef; po.Remarks = entity.Remarks; po.ShippingTermId = entity.ShippingTermId; po.SupplierId = entity.SupplierId; po.IsInternational = entity.IsInternational; } ClearPOSessionData(); return(context.SaveChanges() > 0); } }
public void UpdateProjectDonor(string projectDonorId, string projectNumber, DateTime startDate, DateTime endDate, Guid projectManagerId, string donorId, string currencyId, double? overrunAdjustment, ref string pdId) { if (ProjectNumberExits(projectNumber, projectDonorId)) { pdId = null; return; } using (var context = new SCMSEntities()) { var pd = context.ProjectDonors.FirstOrDefault(p => p.Id == new Guid(projectDonorId)); pd.StartDate = startDate; pd.EndDate = endDate; pd.ProjectManagerId = projectManagerId; pd.DonorId = new Guid(donorId); pd.CurrencyId = new Guid(currencyId); pd.ProjectNumber = projectNumber; var blList = context.ProjectBudgets.Where(b => b.BudgetCategory.ProjectDonor.Id == pd.Id).ToList(); foreach (var bl in blList) { if (bl.OverrunAdjustment == pd.OverrunAdjustment) bl.OverrunAdjustment = overrunAdjustment; } pd.OverrunAdjustment = overrunAdjustment; context.SaveChanges(); pdId = projectDonorId; } }
private bool IsDepreciationComputed(SCMSEntities db, TransactionScope scope, Asset assetEntity) { //var firstdateinMonth = new DateTime(DateTime.Today.Year, DateTime.Today.Month, 1).AddMonths(-1); //var lastdateinMonth = new DateTime(DateTime.Today.Year, DateTime.Today.Month, 1).AddDays(-1); //float purchasePrc = (float)gitm.PurchaseOrderItem.UnitPrice Model.Depreciation deprEntity = null; Model.GoodsReceivedNoteItem gitm = db.GoodsReceivedNoteItems.FirstOrDefault(p => p.Id == assetEntity.GoodsReceivedNoteItemId); float purchasePrc = (float)assetEntity.PurchaseValue, percentageDepr = (float)assetEntity.PercentageDepr, accAnnualDepr = 0; float annualDepr = 0, monthlyDepr, netbookValue = purchasePrc, accumulatedDepr = 0, salvagevalue = (float)assetEntity.SalvageValue; int periodcount = 0, monthcount = 0, numberOfYears = 0; if (assetEntity.DepreciationType == "Reducing Balance") { monthlyDepr = ReducingBalance(db, assetEntity, ref deprEntity, percentageDepr, ref accAnnualDepr, ref annualDepr, ref netbookValue, ref accumulatedDepr, salvagevalue, ref periodcount, ref monthcount, ref numberOfYears); } else { monthlyDepr = StraightLine(db, assetEntity, ref deprEntity, purchasePrc, percentageDepr, ref accAnnualDepr, ref annualDepr, ref netbookValue, ref accumulatedDepr, salvagevalue, ref periodcount, ref monthcount); } if (!(db.SaveChanges() > 0)) { scope.Dispose(); SessionData.CurrentSession.DepreciationList = null; return(false); } scope.Complete(); return(true); }
/// <summary> /// /// </summary> /// <param name="item"></param> /// <returns></returns> public bool AddItem(Item item) { bool isSaved = false; if (item.Id.Equals(Guid.Empty)) { item.Id = Guid.NewGuid(); } using (var context = new SCMSEntities()) { UnitOfMeasure u = context.UnitOfMeasures.FirstOrDefault(p => p.Id == item.UnitOfMessureId); context.Items.Add(item); context.ItemPackages.Add(new ItemPackage() { Id = Guid.NewGuid(), ItemId = item.Id, PackSize = 1, shortName = u.Code, Name = u.Description }); if (context.SaveChanges() > 0) { isSaved = true; ClearItemSessionData(); } } return(isSaved); }
public bool IsGIVSaved(Model.GoodsIssuedVoucher giventity) { using (var context = new SCMSEntities()) { using (TransactionScope scope = new TransactionScope()) { try { context.GoodsIssuedVouchers.Add(giventity); foreach (var item in giventity.ROItems) { if (item.IsRemoved) { continue; } var givitem = new GoodsIssuedVoucherItem() { Id = Guid.NewGuid(), QTYDelivered = item.QTYReceived, GoodsIssuedVoucherId = giventity.Id, WarehouseReleaseItemId = item.ROItemId, Remarks = item.Remarks }; context.GoodsIssuedVoucherItems.Add(givitem); } 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 void BackDatePO(Model.PurchaseOrder po) { using (var context = new SCMSEntities()) { using (TransactionScope scope = new TransactionScope()) { try { //Get Current OR from DB var currentPO = context.PurchaseOrders.FirstOrDefault(o => o.Id == po.Id); //Initialize BackDate object var backDate = new DocumentBackDating(); backDate.Id = Guid.NewGuid(); backDate.BackDatedBy = po.BackDatedBy; backDate.BackDatedOn = DateTime.Now; backDate.NewDate = po.PODate; backDate.PurchaseOrderId = po.Id; backDate.PreviousDate = currentPO.PODate; backDate.Reason = po.BackDatingReason; //Insert BackDate details into db context.DocumentBackDatings.Add(backDate); //Update date on OR in db currentPO.PODate = po.PODate; context.SaveChanges(); scope.Complete(); } catch (Exception ex) { scope.Dispose(); throw ex; } } } }
public void DeletePO(Guid PoId) { using (var context = new SCMSEntities()) { using (TransactionScope scope = new TransactionScope()) { try { var po = context.PurchaseOrders.FirstOrDefault(p => p.Id == PoId); po.PurchaseOrderItems.ToArray().ForEach(p => context.PurchaseOrderItems.Remove(p)); context.PurchaseOrders.Remove(po); context.AttachedDocuments.Where(d => d.DocumentId == po.Id && d.DocumentType == NotificationHelper.poCode).ToArray().ForEach(d => context.AttachedDocuments.Remove(d)); if (context.SaveChanges() > 0) { scope.Complete(); } else { scope.Dispose(); } } catch (Exception ex) { scope.Dispose(); throw ex; } ClearPOSessionData(); ClearORSessionData(); } } }
public bool DeletePack(Guid pkgId) { using (var db = new SCMSEntities()) { db.ItemPackages.Remove(db.ItemPackages.FirstOrDefault(p => p.Id == pkgId)); return(db.SaveChanges() > 0 ? true : false); } }
public bool AddPackage(ItemPackage pack) { using (var db = new SCMSEntities()) { db.ItemPackages.Add(pack); return(db.SaveChanges() > 0 ? true : false); } }
public bool SaveWB(Model.WayBill entity) { using (var db = new SCMSEntities()) { db.WayBills.Add(entity); return(db.SaveChanges() > 0 ? true : false); } }
public bool IsFleetDetailsSaved(FleetDetail Entity) { using (var db = new SCMSEntities()) { db.FleetDetails.Add(Entity); return db.SaveChanges() > 0 ? true : false; } }
public bool IsAssetRegistered(Model.Asset assetEntity) { using (var context = new SCMSEntities()) { using (TransactionScope scope = new TransactionScope()) { try { assetEntity.IsAssigned = false; assetEntity.Id = Guid.NewGuid(); //if (assetEntity.UseLifeSpan) // assetEntity.DepreciationType = "Straight Line"; context.Assets.Add(assetEntity); if (context.Inventories.Count(p => p.ItemId == assetEntity.ItemId && p.WareHouseId == assetEntity.CurrentWareHouseId) > 0) { Model.Inventory invt = context.Inventories.FirstOrDefault(p => p.ItemId == assetEntity.ItemId && p.WareHouseId == assetEntity.CurrentWareHouseId); invt.Quantity += 1; ((IObjectContextAdapter)context).ObjectContext.ObjectStateManager.ChangeObjectState(invt, System.Data.EntityState.Modified); } else { Model.Inventory newinvetoryEntity = new Model.Inventory() { Id = Guid.NewGuid(), ItemId = (Guid)assetEntity.ItemId, Quantity = 1, CountryProgrammeId = assetEntity.CountryProgramId, WareHouseId = (Guid)assetEntity.CurrentWareHouseId }; context.Inventories.Add(newinvetoryEntity); } if (assetEntity.IsFleet) { SessionData.CurrentSession.FleetDetailsList = null; context.FleetDetails.Add(new FleetDetail() { Id = Guid.NewGuid(), CountryProgrammeId = assetEntity.CountryProgramId, AssetId = assetEntity.Id, IssueDate = DateTime.Now }); } if (assetEntity.DepreciationType == "Zero Percentage") { if (!(context.SaveChanges() > 0)) { scope.Dispose(); return(false); } else { scope.Complete(); return(true); } } else { assetEntity.DepreciationPeriods = assetEntity.Lifespan * 12; } return(this.IsDepreciationComputed(context, scope, assetEntity)); } catch (Exception ex) { scope.Dispose(); throw ex; } } } }
// // GET: /ShippingTerm/Delete/5 public ActionResult Delete(Guid id) { using (var db = new SCMSEntities()) { db.ShippingTerms.Remove(db.ShippingTerms.SingleOrDefault(p => p.Id == id)); db.SaveChanges(); } return(ListView()); }
public void DeleteGeneralLedgerById(Guid id) { using (var context = new SCMSEntities()) { var gl = context.GeneralLedgers.FirstOrDefault(g => g.Id == id); context.GeneralLedgers.Remove(gl); context.SaveChanges(); } }
public bool EditPackage(ItemPackage pack) { using (var context = new SCMSEntities()) { context.ItemPackages.Attach(pack); ((IObjectContextAdapter)context).ObjectContext.ObjectStateManager.ChangeObjectState(pack, System.Data.EntityState.Modified); return(context.SaveChanges() > 0 ? true : false); } }
public bool Delete <T>(T entity) where T : AttachedDocument { using (var context = new SCMSEntities()) { ClearAttachedDocSession(); ((IObjectContextAdapter)context).ObjectContext.CreateObjectSet <T>().DeleteObject(entity); return(context.SaveChanges() > 0 ? true : false); } }
public void InsertTenderingType(TenderingType entity) { using (var context = new SCMSEntities()) { context.TenderingTypes.Add(entity); context.SaveChanges(); ClearTTSessionData(); } }