public JourneyModel(tblJourney journey) { this.ID = journey.ID; this.CustomerId = journey.CustomerId; this.Journey = journey.Journey; this.Base = journey.Base; this.Gen_Journey = journey.Gen_Journey; }
public DBResult SaveCustomer(CustomerModel model) { tblCustomer customer = model.Id == 0 ? new tblCustomer() : db.tblCustomers.FirstOrDefault(d => d.CustID == model.Id); customer.Colour = model.Colour; customer.DeliveryAddress = model.DeliveryAddress; customer.Name = model.Name; try { if (model.Id == 0) { db.tblCustomers.Add(customer); db.SaveChanges(); foreach (var journey in model.Journeys) { tblJourney dbJourney = db.tblJourneys.FirstOrDefault(j => j.ID == journey.ID); dbJourney.CustomerId = customer.CustID; } } else { var customerJourneys = db.tblJourneys.Where(j => j.CustomerId == model.Id).ToList(); customerJourneys.ForEach(cj => cj.CustomerId = null); db.SaveChanges(); foreach (var journey in model.Journeys) { tblJourney dbJourney = db.tblJourneys.FirstOrDefault(j => j.ID == journey.ID); dbJourney.CustomerId = model.Id; } } db.SaveChanges(); return(new DBResult { ReturnCode = ReturnCode.Success }); } catch (Exception ex) { return(new DBResult { Message = ex.Message, ReturnCode = ReturnCode.Failed }); } }
public bool SaveJourney(JourneyModel journey) { if (journey != null) { tblJourney dbJourney = journey.ID == 0 ? new tblJourney() : db.tblJourneys.FirstOrDefault(j => j.ID == journey.ID); dbJourney.Journey = journey.Journey; dbJourney.CustomerId = journey.CustomerId; dbJourney.Base = journey.Base; if (dbJourney.ID == 0) { db.tblJourneys.Add(dbJourney); } db.SaveChanges(); } return(false); }