public JsonResult Save(Models.DTO.Job record) { Job entity; using (CBDBEntities context = new CBDBEntities()) { if (record.Id.Length == 0) { entity = context.Jobs.First(p => p.Id == record.Id); entity.text = record.text; entity.Description = record.Description; entity.Location = record.Location; entity.ClientId = record.ClientId; //entity.Country = context.Locations.FirstOrDefault(l => l.ID == record.CountryID); // entity.statusId = record.statusId; entity.DateCreated = record.DateCreated; entity.TXDate = record.TXDate; entity.start_date = record.start_date; entity.end_date = record.end_date; entity.Coordinator = record.Coordinator; entity.CommercialLead = record.CommercialLead; } else { context.Jobs.Add(new Job { Id = record.Id, text = record.text, Description = record.Description, Location = record.Location, start_date = record.start_date, DateCreated = record.DateCreated, end_date = record.end_date, TXDate = record.TXDate, Coordinator = record.Coordinator, CommercialLead = record.CommercialLead, ClientId = record.ClientId, // statusId = record.statusId, }); } context.SaveChanges(); } return(Json(new { result = true })); }
public List <Models.DTO.Job> GetJobs() { using (var context = new CBDBEntities()) { List <Models.Job> jobs = new List <Models.Job>(); jobs = context.Jobs.AsNoTracking() // .Include(j => j.Client) .ToList(); if (jobs != null) { List <Models.DTO.Job> jobsDisplay = new List <Models.DTO.Job>(); foreach (var j in jobs) { var jobDisplay = new Models.DTO.Job() { Id = j.Id, text = j.text, //NameConcatenateLocation = j. DateCreated = j.DateCreated, Location = j.Location, Coordinator = j.Coordinator, // ClientId = j.Client.Name, ClientId = j.ClientId, start_date = j.start_date, TXDate = j.TXDate, end_date = j.end_date, CommercialLead = j.CommercialLead // Status = j.Status }; jobsDisplay.Add(jobDisplay); } return(jobsDisplay); } return(null); } }