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 Jobs SaveNewJob(JobRequestModel data) { var lastJob = context.Jobs.Where(a => a.JobName.Contains(data.Prefix) && DbFunctions.TruncateTime(a.CreatedDate) == DbFunctions.TruncateTime(DateTime.Now))?.OrderByDescending(a => a.CreatedDate).FirstOrDefault(); int lastRunningNo = 1; if (lastJob != null) { lastRunningNo = Convert.ToInt32(lastJob.JobName.Substring(lastJob.JobName.Length - 3)); lastRunningNo++; } var job = new Models.Jobs { CreatedById = data.RequesterUserId, CreatedDate = DateTime.Now, WarehouseType = data.Prefix == "WHD" ? 1 : 2, Id = 0, JobName = data.Prefix + "-" + DateTime.Now.ToString("yyyyMMdd") + "-" + lastRunningNo.ToString().PadLeft(2, '0') }; context.Jobs.Add(job); context.SaveChanges(); return(job); }