//get crew
public Crew GetCrew(Guid jobid, int crewid)
{
if (jobid != Guid.Empty)
{
using (var context = new CloudbassContext())
{
var crew = context.Crews.AsNoTracking()
.Where(x => x.JobId == jobid && x.crewId == crewid)
.Single();
if (crew != null)
{
var crewVm = new Crew()
{
JobId = crew.JobId.ToString("D"),
// has_RoleId = crew.has_RoleId,
has_RoleId = crew.Has_Role.Role.Id,
start_date = crew.start_date,
end_date = crew.end_date,
totalDays = crew.totalDays,
};
return(crewVm);
}
}
}
return(null);
}
//Save Crew
public CrewEdit SaveCrew(CrewEdit model)
{
if (model != null && Guid.TryParse(model.JobId, out Guid jobid))
{
using (var context = new CloudbassContext())
{
var crew = new Models.Crew()
{
JobId = jobid,
has_RoleId = model.has_RoleId,
start_date = model.start_date,
end_date = model.end_date,
totalDays = model.totalDays,
};
context.Crews.Add(crew);
context.SaveChanges();
return(model);
}
}
// Return false if customeredit == null or CustomerID is not a guid
return(null);
}
//execute save
public ScheduleEdit SaveSchedule(ScheduleEdit model)
{
if (model != null && Guid.TryParse(model.JobId, out Guid jobid))
{
using (var context = new CloudbassContext())
{
var schedule = new Models.Schedule()
{
JobId = jobid,
text = model.text?.Trim(),
start_date = model.start_date,
end_date = model.end_date,
SchType = model.SchType
};
context.Schedules.Add(schedule);
context.SaveChanges();
return(model);
}
}
// Return false if customeredit == null or CustomerID is not a guid
return(null);
}
//get list
public CrewList GetCrewList(Guid jobid)
{
if (jobid != Guid.Empty)
{
using (var context = new CloudbassContext())
{
var crews = context.Crews.AsNoTracking()
.Where(x => x.JobId == jobid)
.OrderBy(x => x.crewId);
if (crews != null)
{
var crewListView = new CrewList();
foreach (var crew in crews)
{
var crewVm = new Crew()
{
JobId = crew.JobId.ToString("D"),
crewId = crew.crewId,
has_RoleId = crew.Has_Role.Role.Id,
totalDays = crew.totalDays,
start_date = crew.start_date,
end_date = crew.end_date,
};
}
return(crewListView);
}
}
}
return(null);
}
//get schedule
public Schedule GetSchedule(Guid jobid, int scheduleid)
{
if (jobid != Guid.Empty)
{
using (var context = new CloudbassContext())
{
var schedule = context.Schedules.AsNoTracking()
.Where(x => x.JobId == jobid && x.Id == scheduleid)
.Single();
if (schedule != null)
{
var scheduleVm = new Schedule()
{
JobId = schedule.JobId.ToString("D"),
SchType = schedule.SchType,
text = schedule.text?.Trim(),
start_date = schedule.start_date,
end_date = schedule.end_date,
};
return(scheduleVm);
}
}
}
return(null);
}
// START SCHEDULE LIST
public ScheduleList GetScheduleList(Guid jobid)
{
if (jobid != Guid.Empty)
{
using (var context = new CloudbassContext())
{
var schedules = context.Schedules.AsNoTracking()
.Where(x => x.JobId == jobid)
.OrderBy(x => x.Id);
if (schedules != null)
{
var scheduleListView = new ScheduleList();
foreach (var schedule in schedules)
{
var scheduleVm = new Schedule()
{
JobId = schedule.JobId.ToString("D"),
Id = schedule.Id,
text = schedule.text,
SchType = schedule.SchType,
//SchTypeId = schedule.SchTypeId,
//SchTypName = schedule.SchType.name,
start_date = schedule.start_date,
end_date = schedule.end_date,
//StatusName = schedule.ScheduleStatu.title
};
}
return(scheduleListView);
}
}
}
return(null);
}
public IEnumerable <SelectListItem> GetBookingTypes()
{
using (var context = new CloudbassContext())
{
List <SelectListItem> bookingtypes = context.BookingTypes.AsNoTracking()
.OrderBy(x => x.BookingTypeID)
.Select(x =>
new SelectListItem
{
Value = x.BookingTypeID,
Text = x.BookingTypeID
}).ToList();
return(new SelectList(bookingtypes, "Value", "Text"));
}
}
//this include here is to add Linq to find a job with jobId that matches the data about other objects
//in the data's being returned the the db
public JobEdit GetJob(Guid id)
{
if (id != Guid.Empty)
{
using (var context = new CloudbassContext())
{
var job = context.Jobs.AsNoTracking()
.Where(j => j.JobId == id)
//.Include(j => j.Crews)
//.FirstOrDefault();
.Single();
if (job != null)
{
var jobEditVm = new JobEdit()
{
JobId = job.JobId.ToString("D"),
text = job.text.Trim(),
Description = job.Description,
//NameConcatenateLocation = j.
DateCreated = job.DateCreated,
Location = job.Location,
Coordinator = job.Coordinator,
// ClientName = j.Client.Name,
start_date = job.start_date,
TXDate = job.TXDate,
end_date = job.end_date,
CommercialLead = job.CommercialLead,
SelectedClientId = job.Client.Id,
//JobRef = job.JobRef,
Status = job.Status
};
var clientsRepo = new ClientRepository();
jobEditVm.Clients = clientsRepo.GetClients();
//var jobStatuRepo = new JobStatuRepository();
//jobEditVm.JobStatu = jobStatuRepo.GetJobStatus();
return(jobEditVm);
}
}
}
return(null);
}
public bool SaveJob(JobEdit jobedit)
{
if (jobedit != null)
{
using (var context = new CloudbassContext())
{
if (Guid.TryParse(jobedit.JobId, out Guid newGuid))
{
var job = new Models.Jobs()
{
JobId = newGuid,
text = jobedit.text,
Description = jobedit.Description,
Location = jobedit.Location,
Coordinator = jobedit.Coordinator,
DateCreated = jobedit.DateCreated,
//NameConcatenateLocation = jobEdit.Name,
start_date = jobedit.start_date,
TXDate = jobedit.TXDate,
end_date = jobedit.end_date,
ClientId = jobedit.SelectedClientId,
// statusId = jobedit.SelectedStatus,
CommercialLead = jobedit.CommercialLead,
// JobRef = jobedit.JobRef,
Status = jobedit.Status
};
job.Client = context.Clients.Find(jobedit.SelectedClientId);
//job.JobStatu = context.JobStatus.Find(jobedit.SelectedStatus);
context.Jobs.Add(job);
context.SaveChanges();
return(true);
}
}
}
// Return false if customeredit == null or CustomerID is not a guid
return(false);
}
public List <Jobs> GetJobs()
{
using (var context = new CloudbassContext())
{
List <Models.Jobs> jobs = new List <Models.Jobs>();
jobs = context.Jobs.AsNoTracking()
// .Include(x => x.Client)
.ToList();
if (jobs != null)
{
List <Jobs> jobsDisplay = new List <Jobs>();
foreach (var j in jobs)
{
var jobDisplay = new Jobs()
{
JobId = j.JobId,
text = j.text,
Description = j.Description,
DateCreated = j.DateCreated,
Location = j.Location,
Coordinator = j.Coordinator,
Client = j.ClientId,
start_date = j.start_date,
TXDate = j.TXDate,
end_date = j.end_date,
CommercialLead = j.CommercialLead,
// JobRef =j.JobRef,
Status = j.Status
};
jobsDisplay.Add(jobDisplay);
}
return(jobsDisplay);
}
return(null);
}
}
public IEnumerable <SelectListItem> GetClients()
{
using (var context = new CloudbassContext())
{
List <SelectListItem> clients = context.Clients.AsNoTracking()
.OrderBy(cl => cl.name)
.Select(cl =>
new SelectListItem
{
Value = cl.Id.ToString(),
Text = cl.name
}
).ToList();
var clienttip = new SelectListItem()
{
Value = null,
Text = "---select client---"
};
clients.Insert(0, clienttip);
return(new SelectList(clients, "Value", "Text"));
}
}
