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