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