private void InsertPiano(PianoVm vm, Guid orderId) { if (string.IsNullOrEmpty(vm.PianoCategoryType)) { return; } Piano obj = new Piano(); obj.Id = Guid.NewGuid(); obj.OrderId = orderId; obj.CreatedAt = DateTime.Now; obj.CreatedBy = LoggedInUser?.UserName; //TypeID from table obj.PianoTypeId = string.IsNullOrEmpty(vm.PianoTypeId) ? (Guid?)null : Guid.Parse(vm.PianoTypeId); obj.PianoFinishId = vm.PianoFinish == null ? (Guid?)null : Guid.Parse(vm.PianoFinish); obj.Model = vm.PianoModel; obj.PianoCategoryType = int.Parse(vm.PianoCategoryType); //make entity guid obj.PianoMakeId = vm.PianoMake == null ? (Guid?)null : Guid.Parse(vm.PianoMake); //size guid obj.PianoSizeId = vm.PianoSize == null ? (Guid?)null : Guid.Parse(vm.PianoSize); obj.Notes = vm.Notes; //Need add piano category obj.SerialNumber = vm.SerialNumber; obj.IsBench = vm.IsBench; obj.IsBoxed = vm.IsBoxed; obj.IsPlayer = vm.IsPlayer; Db.Pianos.Add(obj); }
public ActionResult Edit(Guid?id) { var order = Db.Orders .Include(x => x.Client) .Include(x => x.Pianos) .Include(x => x.Legs) .Include(x => x.PickupAddress) .Include(x => x.DeliveryAddress) .Include(x => x.OrderCharges) .FirstOrDefault(x => x.Id == id); var pickupAddress = OrderVm.PopulateAddress(order.PickupAddress); var deliveryAddress = OrderVm.PopulateAddress(order.DeliveryAddress); pickupAddress.Notes = order.PickUpNotes; deliveryAddress.Notes = order.DeliveryNotes; pickupAddress.PickUpDate = order.PickupDate; deliveryAddress.PickUpDate = order.DeliveryDate; var orderVm = new OrderVm() { Id = order.Id.ToString(), OrderPlacementType = order.OrderType, OrderNumber = order.OrderNumber, PaymentOption = order.PaymentOption.ToString(), CallerFirstName = order.CallerFirstName, CallerLastName = order.CallerLastName, CallerPhoneNumber = order.CallerPhoneNumber, CallerEmail = order.CallerEmail, CallerAlternatePhone = order.CallerAlternatePhone, CollectableAmount = order.CodAmount, CarriedBy = order.CarriedBy, SalesOrderNumber = order.SalesOrderNumber, IsBilledThirdParty = order.BillToDifferent, OfficeStaffDetails = order.OfficeStaff, OnlinePaymentDetails = order.OnlinePayment, ThirdParty = order.InvoiceBillingPartyId.ToString(), Dealer = order.InvoiceClientId.ToString(), DeliverForm = order.DeliveryForm, PickupAddress = pickupAddress, DeliveryAddress = deliveryAddress, Shuttle = order.Client != null?order.ClientId.ToString() : "" }; foreach (var piano in order.Pianos) { PianoVm pianoVm = new PianoVm(); pianoVm.SerialNumber = string.IsNullOrEmpty(piano.SerialNumber) ? string.Empty : piano.SerialNumber; pianoVm.IsBench = piano.IsBench; pianoVm.IsBoxed = piano.IsBoxed; pianoVm.IsPlayer = piano.IsPlayer; pianoVm.PianoMake = piano.PianoMakeId.ToString(); pianoVm.PianoModel = piano.Model; pianoVm.PianoTypeId = piano.PianoTypeId.ToString(); pianoVm.PianoCategoryType = piano.PianoCategoryType.ToString(); pianoVm.Notes = piano.Notes; pianoVm.PianoFinish = piano.PianoFinishId.ToString(); pianoVm.PianoSize = piano.PianoSizeId.ToString(); // pianoVm.PianoCategoryType = piano.PianoType.ToString(); orderVm.Pianos.Add(pianoVm); } foreach (var leg in order.Legs) { LegVm legVm = new LegVm(); legVm.Id = leg.Id; legVm.OrderId = leg.OrderId.Value; legVm.LegNumber = leg.LegNumber; legVm.LegTypeId = leg.LegType.ToString(); legVm.FromLocationId = leg.FromLocationId?.ToString(); legVm.ToLocationId = leg.ToLocationId?.ToString(); legVm.DriverId = leg.DriverId?.ToString(); legVm.LegDate = leg.LegDate; orderVm.Legs.Add(legVm); } foreach (var service in order.OrderCharges) { orderVm.Charges.Add(new PianoChargesVm { Amount = service.Amount.ToString(), ChargesCode = service.PianoChargesId.ToString(), }); } PopulateViewData(); return(View("Private", orderVm)); }