public bool Delete(long orderHeaderId) { Order_Purechase order_Purechase = _context.Order_Purechases.FirstOrDefault(x => x.OrderHeaderId == orderHeaderId); _order_purechaseEntity.Remove(order_Purechase); _context.SaveChanges(); return(true); }
public void DeleteRelatedPurechase(long orderHeaderId, EntitiesDbContext context) { Order_Purechase order_Purechase = _context.Order_Purechases.FirstOrDefault(x => x.OrderHeaderId == orderHeaderId); if (order_Purechase != null && order_Purechase.PurechasesHeaderId != 0) { PurechasesHeader purechasesHeader = _context.PurechasesHeaders.FirstOrDefault(x => x.Id == order_Purechase.PurechasesHeaderId); Delete(purechasesHeader.Id, context); } }
public bool Update(Order_Purechase entity) { Order_Purechase order_Purechase = _context.Order_Purechases.FirstOrDefault(x => x.OrderHeaderId == entity.OrderHeaderId); if (order_Purechase != null) { order_Purechase.PurechasesHeaderId = entity.PurechasesHeaderId; } _context.SaveChanges(); return(true); }
public bool Add(OrderDTO entity) { var options = GetOptions(); using (var context = new EntitiesDbContext(options)) { using (var transaction = context.Database.BeginTransaction()) { try { //[1] Save Order (Header and Details) _orderHeaderOperationsRepo.Add(entity.OrderHeader, context); //Save in OrderHeader Table (Master Table) entity.OrderDetails = SetOrderHeaderId(entity.OrderHeader.Id, entity.OrderDetails); //set OrderHeaderId to OrderDetails table _orderDetailsOperationsRepo.AddRange(entity.OrderDetails, context); //Save in OrderDetails table (details for master table) //[2] Save Purecchase pill PurechasesHeader purechasesHeader = PreparePurechasesEntity(entity); //Prepare PurchaseEntity(Header and details for Cleint) _purechasesOperationsRepo.Add(purechasesHeader, context); //Add Purchase(Header and Details) //[3] Save farmer safe in Safe Entity as hidden rows Safe farmerSafe = PrepareFarmerSafeEntity(purechasesHeader, entity.OrderHeader.Id); //Prepare Safe for Client _safeOperationsRepo.Add(farmerSafe, context); //Add Client Safe row //[4]Save Order_Purechase Order_Purechase order_Purechase = PrepareOrder_Purechase(entity.OrderHeader.Id, purechasesHeader.Id); _order_PurechaseOperationsRepo.Add(order_Purechase, context); //[5] Save Salesinvoice pill var salesinvoicesHeaderList = PrepareSalesinvoicesEntity(entity);//Prepare Salesinvoice(Header and Details) foreach (var salesinvoicesHeader in salesinvoicesHeaderList) { SalesinvoicesHeader updatedSalesinvoicesHeader = _salesinvoicesOperationsRepo.Add(salesinvoicesHeader, entity.OrderHeader.Id, context); //Save in Salesinvoice(Header and Details) and update Total _safeOperationsRepo.DeleteByHeaderId(updatedSalesinvoicesHeader.Id, AccountTypesEnum.Sellers, context); //Delete old record in safe related to this Seller var sellerSafe = PrepareSellerSafeEntity(updatedSalesinvoicesHeader, updatedSalesinvoicesHeader.Total, entity.OrderHeader.Id); _safeOperationsRepo.Add(sellerSafe, context); } transaction.Commit(); return(true); } catch (Exception ex) { transaction.Rollback(); return(false); } } } }
public bool Update(OrderDTO entity) { var options = GetOptions(); using (var context = new EntitiesDbContext(options)) { using (var transaction = context.Database.BeginTransaction()) { try { //[1] Update Order (Master and Details) _orderHeaderOperationsRepo.Update(entity.OrderHeader, context); //Update Order table(Master) _orderHeaderOperationsRepo.DeleteRelatedOrderDetials(entity.OrderHeader.Id, context); //Delete order details related to this order header SetOrderHeaderId(entity.OrderHeader.Id, entity.OrderDetails); _orderDetailsOperationsRepo.AddRange(entity.OrderDetails, context); //Adding of new Order Details //[2] Update Purechase (Master and Details) PurechasesHeader purechasesHeader = PreparePurechasesEntity(entity); var orderHeader = _order_PurechaseOperationsRepo.GetByOrderHeaderId(entity.OrderHeader.Id); if (orderHeader != null && orderHeader.PurechasesHeaderId != 0) { purechasesHeader.Id = orderHeader.PurechasesHeaderId; _purechasesOperationsRepo.Update(purechasesHeader, context); } else { _purechasesOperationsRepo.Add(purechasesHeader, context); } //[3] Update Client Safe _safeOperationsRepo.DeleteByOrderId(entity.OrderHeader.Id, context); var safe = PrepareFarmerSafeEntity(purechasesHeader, entity.OrderHeader.Id); _safeOperationsRepo.Add(safe, context); //[4]Update Order_Purechase Order_Purechase order_Purechase = PrepareOrder_Purechase(entity.OrderHeader.Id, purechasesHeader.Id); _order_PurechaseOperationsRepo.Update(order_Purechase); //[5] Update Salesinvoice List <SalesinvoicesDetials> deletedSalesinvoicesDetials = _salesinvoicesOperationsRepo.DeleteSalesinvoiceDetails(entity.OrderHeader, context); //Delete SalesinvoiceDetails UpdateSalesInvoicTotal(deletedSalesinvoicesDetials, context); _salesinvoicesOperationsRepo.DeleteSalesinvoiceHeader(entity.OrderHeader.Created, context); //Delete Old Salesinvoice related to this Order var salesinvoicesHeaderList = PrepareSalesinvoicesEntity(entity); //Prepare Salesinvoice(Header and Details) foreach (var salesinvoicesHeader in salesinvoicesHeaderList) { SalesinvoicesHeader updatedSalesinvoicesHeader = _salesinvoicesOperationsRepo.Add(salesinvoicesHeader, entity.OrderHeader.Id, context); //Save in Salesinvoice(Header and Details) and update Total _safeOperationsRepo.DeleteByHeaderId(salesinvoicesHeader.Id, AccountTypesEnum.Sellers, context); //Delete old record in safe related to this Seller var sellerSafe = PrepareSellerSafeEntity(updatedSalesinvoicesHeader, updatedSalesinvoicesHeader.Total, entity.OrderHeader.Id); _safeOperationsRepo.Add(sellerSafe, context); } transaction.Commit(); return(true); } catch (Exception ex) { LogFile.WriteLog(ex.Message); transaction.Rollback(); return(false); } } } }
public bool Add(Order_Purechase entity, EntitiesDbContext context) { context.Order_Purechases.Add(entity); context.SaveChanges(); return(true); }