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);
}