public void delete(tblQuote item) { if (item == null) { throw new InvalidOperationException("invalid entity"); } uow.QuoteRepo.Delete(item); }
public void insert(tblQuote item) { if (item == null) { throw new InvalidOperationException("invalid entity"); } uow.QuoteRepo.Insert(item); }
public void update(int id, tblQuote item) { var entry = GetbyID(id); if (entry == null) { throw new InvalidOperationException("Quote ID doesnt exist"); } item.QuoteID = id; uow.QuoteRepo.Update(id, item); }
//check if the entity is valid or not public void update(int id, tblQuote item) { var entry = GetbyID(id); if (entry == null) { throw new InvalidOperationException("Quote ID doesnt exist"); } //assemble the id correctly and send down item.QuoteID = id; uow.QuoteRepo.Update(id, item); }
// POST api/values public IHttpActionResult Post([FromBody] Quote item) { if (!ModelState.IsValid) { return(BadRequest("Invalid data input")); } tblQuote quote = new tblQuote { QuoteType = item.QuoteType, Contact = item.Contact, Task = item.Task, DueDate = item.DueDate, TaskType = item.TaskType }; qs.insert(quote); return(Ok()); }
// DELETE api/values/5 public void Delete(int id) { tblQuote item = Get(id); qs.delete(item); }
public override void Synchronize(Func <SyncSalesQuoteParameters> getInput) { var parameters = getInput(); var key = parameters.SalesQuoteKey; var salesQuote = UnitOfWork.SalesQuoteRepository.FindByKey(key, q => q.SourceFacility, q => q.Customer.Company, q => q.Broker, q => q.ShipmentInformation, q => q.Items.Select(i => i.Product), q => q.Items.Select(i => i.PackagingProduct.Product), q => q.Items.Select(i => i.Treatment)); if (salesQuote == null) { throw new Exception(string.Format("Could not find SalesQuote[{0}].", key)); } var commitNewContext = false; tblQuote tblQuote; if (salesQuote.QuoteNum == null || parameters.New) { var quoteNum = (salesQuote.TimeStamp.Year * 100) - 1; quoteNum = OldContext.tblQuotes.Select(q => q.QuoteNum) .Where(q => q > quoteNum) .DefaultIfEmpty(quoteNum) .Max() + 1; tblQuote = new tblQuote { QuoteNum = quoteNum, TTypeID = 19, Status = 1, PreSample = false, s_GUID = Guid.NewGuid(), EmployeeID = salesQuote.EmployeeId, EntryDate = salesQuote.TimeStamp.ConvertUTCToLocal().RoundMillisecondsForSQL() }; OldContext.tblQuotes.AddObject(tblQuote); salesQuote.QuoteNum = quoteNum; commitNewContext = true; } else { tblQuote = OldContext.tblQuotes .Include(q => q.tblQuoteDetails) .FirstOrDefault(q => q.QuoteNum == salesQuote.QuoteNum); if (tblQuote == null) { throw new Exception(string.Format("Could not find tblQuote[{0}]", salesQuote.QuoteNum)); } } tblQuote.Date = salesQuote.QuoteDate; tblQuote.DateRecd = salesQuote.DateReceived; tblQuote.From = salesQuote.CalledBy; tblQuote.TakenBy = salesQuote.TakenBy; tblQuote.WHID = salesQuote.SourceFacility == null ? null : salesQuote.SourceFacility.WHID; tblQuote.Company_IA = salesQuote.Customer == null ? null : salesQuote.Customer.Company.Name; tblQuote.Broker = salesQuote.Broker == null ? null : salesQuote.Broker.Name; tblQuote.PalletOR = (decimal?)salesQuote.ShipmentInformation.PalletWeight; tblQuote.PalletQty = salesQuote.ShipmentInformation.PalletQuantity; tblQuote.FreightBillType = salesQuote.ShipmentInformation.FreightBillType; tblQuote.ShipVia = salesQuote.ShipmentInformation.ShipmentMethod; tblQuote.Driver = salesQuote.ShipmentInformation.DriverName; tblQuote.Carrier = salesQuote.ShipmentInformation.CarrierName; tblQuote.TrlNbr = salesQuote.ShipmentInformation.TrailerLicenseNumber; tblQuote.ContSeal = salesQuote.ShipmentInformation.ContainerSeal; tblQuote.DelDueDate = salesQuote.ShipmentInformation.RequiredDeliveryDate.ConvertUTCToLocal().RoundMillisecondsForSQL(); tblQuote.SchdShipDate = salesQuote.ShipmentInformation.ShipmentDate.ConvertUTCToLocal().RoundMillisecondsForSQL(); tblQuote.CCompany = salesQuote.SoldTo.Name; tblQuote.CAddress1 = salesQuote.SoldTo.Address.AddressLine1; tblQuote.CAddress2 = salesQuote.SoldTo.Address.AddressLine2; tblQuote.CAddress3 = salesQuote.SoldTo.Address.AddressLine3; tblQuote.CCity = salesQuote.SoldTo.Address.City; tblQuote.CState = salesQuote.SoldTo.Address.State; tblQuote.CZip = salesQuote.SoldTo.Address.PostalCode; tblQuote.CCountry = salesQuote.SoldTo.Address.Country; tblQuote.SCompany = salesQuote.ShipmentInformation.ShipTo.Name; tblQuote.SPhone = salesQuote.ShipmentInformation.ShipTo.Phone; tblQuote.SAddress1 = salesQuote.ShipmentInformation.ShipTo.Address.AddressLine1; tblQuote.SAddress2 = salesQuote.ShipmentInformation.ShipTo.Address.AddressLine2; tblQuote.SAddress3 = salesQuote.ShipmentInformation.ShipTo.Address.AddressLine3; tblQuote.SCity = salesQuote.ShipmentInformation.ShipTo.Address.City; tblQuote.SState = salesQuote.ShipmentInformation.ShipTo.Address.State; tblQuote.SZip = salesQuote.ShipmentInformation.ShipTo.Address.PostalCode; tblQuote.SCountry = salesQuote.ShipmentInformation.ShipTo.Address.Country; tblQuote.Company = salesQuote.ShipmentInformation.FreightBill.Name; tblQuote.Phone = salesQuote.ShipmentInformation.FreightBill.Phone; tblQuote.Email = salesQuote.ShipmentInformation.FreightBill.EMail; tblQuote.Address1 = salesQuote.ShipmentInformation.FreightBill.Address.AddressLine1; tblQuote.Address2 = salesQuote.ShipmentInformation.FreightBill.Address.AddressLine2; tblQuote.Address3 = salesQuote.ShipmentInformation.FreightBill.Address.AddressLine3; tblQuote.City = salesQuote.ShipmentInformation.FreightBill.Address.City; tblQuote.State = salesQuote.ShipmentInformation.FreightBill.Address.State; tblQuote.Zip = salesQuote.ShipmentInformation.FreightBill.Address.PostalCode; tblQuote.Country = salesQuote.ShipmentInformation.FreightBill.Address.Country; var QDetail = OldContext.tblQuoteDetails.Select(d => d.QDetail).DefaultIfEmpty(DateTime.Now).Max(); var detailsToRemove = tblQuote.tblQuoteDetails.ToDictionary(d => d.QDetail); foreach (var item in salesQuote.Items) { tblQuoteDetail detail; if (item.QDetailID != null) { if (detailsToRemove.TryGetValue(item.QDetailID.Value, out detail)) { detailsToRemove.Remove(item.QDetailID.Value); } else { throw new Exception(string.Format("Could not find tblQuoteDetail[{0}]", item.QDetailID)); } } else { QDetail = QDetail.AddSeconds(1).RoundMillisecondsForSQL(); detail = new tblQuoteDetail { QDetail = QDetail, QuoteNum = tblQuote.QuoteNum, s_GUID = Guid.NewGuid() }; OldContext.tblQuoteDetails.AddObject(detail); item.QDetailID = detail.QDetail; commitNewContext = true; } var product = OldContextHelper.GetProduct(item.Product.ProductCode); var packaging = OldContextHelper.GetPackaging(item.PackagingProduct); var treatment = OldContextHelper.GetTreatment(item.Treatment); detail.ProdID = product.ProdID; detail.PkgID = packaging.PkgID; detail.TrtmtID = treatment.TrtmtID; detail.Quantity = item.Quantity; detail.Price = (decimal?)item.PriceBase; detail.FreightP = (decimal?)item.PriceFreight; detail.TrtnmntP = (decimal?)item.PriceTreatment; detail.WHCostP = (decimal?)item.PriceWarehouse; detail.Rebate = (decimal?)item.PriceRebate; detail.CustProductCode = item.CustomerProductCode; } foreach (var detail in detailsToRemove.Values) { OldContext.tblQuoteDetails.DeleteObject(detail); } OldContext.SaveChanges(); if (commitNewContext) { UnitOfWork.Commit(); } Console.WriteLine(ConsoleOutput.SyncTblQuote, tblQuote.QuoteNum); }
//Quote public static QuoteModel ToModel(this tblQuote entity) { return(Mapper.Map <tblQuote, QuoteModel>(entity)); }