/// <summary> /// Updates / Inserts new Job /// </summary> /// <param name="job"></param> /// <returns></returns> public int UpsertJob(tblJob job) { if (job.JobID == 0) //new record { try { dc.tblJobs.InsertOnSubmit(job); dc.SubmitChanges(); return(job.JobID); } catch (Exception ex) { throw ex; } } else // update { try { var record = dc.tblJobs.FirstOrDefault(x => x.JobID == job.JobID); record = job; dc.SubmitChanges(); return(record.JobID); } catch (Exception ex) { throw ex; } } }
public DaybookModel(tblJob job) { this.JobID = job.JobID; this.CustomerName = job.CustomerName; this.CustomerID = job.CustomerID; this.dtTo = job.dtTo; this.dtFrom = job.dtFrom; this.DriverName = job.DriverName; this.DriverTimeStamp = job.DriverTimeStamp; this.DriverID = job.DriverID; this.MiscCode = job.MiscCode; this.Type = job.Type; this.JobRef = job.JobRef; this.CustRef = job.CustRef; this.Area = job.Area; this.Journey = job.Journey; this.BasePrice = job.BasePrice; this.Time = job.Time; this.InvoiceNo = job.InvoiceNo; this.Notes = job.Notes; this.Address = job.Address; this.Address = job.Address; this.TruckId = job.TruckId; this.TrailerId = job.TrailerId; this.PinNumber = job.PinNumber; this.UseReturn = Convert.ToBoolean(job.UseReturn); this.TimeString = job.Time == null?DateTime.Now.TimeOfDay.ToString() : Convert.ToDateTime(job.Time).TimeOfDay.ToString(); }
public JobModel AddAndUpdateJob(JobModel model) { try { if (model.ID > 0) { var record = _db.tblJobs.OrderByDescending(x => x.ID).Where(x => x.ID == model.ID).FirstOrDefault(); record.Job = model.Job; record.MinSalary = model.MinSalary; record.MaxSalary = model.MaxSalary; _db.SaveChanges(); } else { tblJob _job = new tblJob(); _job.Job = model.Job; _job.MinSalary = model.MinSalary; _job.MaxSalary = model.MaxSalary; _db.tblJobs.Add(_job); _db.SaveChanges(); model.ID = _job.ID; } } catch (Exception ex) { } return(model); }
public ActionResult PostJob(JobViewModel jvm) { string user = User.Identity.Name; tblUser tb = _db.tblUsers.Where(a => a.Username == user).FirstOrDefault(); tblEmployer tbe = _db.tblEmployers.Where(b => b.UserId == tb.UserId).FirstOrDefault(); tblJob tbj = new tblJob(); tbj.CategoryId = jvm.CategoryId; tbj.EmployerId = tbe.EmployerId; tbj.SalaryRange = jvm.SalaryRange; tbj.JobType = jvm.JobType; tbj.JobDetails = jvm.JobDetails; tbj.isFeaturedJob = jvm.isFeaturedJob; tbj.PostedDate = DateTime.Now; tbj.ExpiryDate = jvm.ExpiryDate; _db.tblJobs.Add(tbj); _db.SaveChanges(); return(RedirectToAction("Index", "Home")); }
public DBResult SaveDaybook(DaybookModel job) { tblJob tblJob = job.JobID != 0 ? db.tblJobs.FirstOrDefault(j => j.JobID == job.JobID) : new tblJob(); try { tblJob.Address = job.Address; tblJob.Area = job.Area; tblJob.BasePrice = job.BasePrice; tblJob.CustomerID = job.CustomerID; tblJob.CustRef = job.CustRef; tblJob.CustomerName = job.CustomerName; tblJob.DriverName = job.DriverName; tblJob.dtFrom = job.dtFrom; tblJob.dtTo = job.dtTo; tblJob.Notes = job.Notes; tblJob.Time = job.Time; tblJob.Journey = job.Journey; tblJob.Type = job.Type; tblJob.MiscCode = job.MiscCode; tblJob.TruckId = job.TruckId; tblJob.PinNumber = job.PinNumber; tblJob.TrailerId = job.TrailerId; tblJob.UseReturn = job.UseReturn; tblJob.JobRef = job.JobRef; tblJob.InvoiceNo = job.InvoiceNo; if (job.JobID == 0) { tblJob.DriverID = job.DriverID; db.tblJobs.Add(tblJob); if (job.UseReturn) { var dateFrom = Convert.ToDateTime(tblJob.dtFrom).AddDays(1); var dateTo = Convert.ToDateTime(tblJob.dtTo).AddDays(1); var currentDateUsed = dateFrom; while (currentDateUsed < dateTo) { tblJob retJob = new tblJob(); retJob.DriverID = job.DriverID; retJob.Address = job.Address; retJob.Area = job.Area; retJob.BasePrice = job.BasePrice; retJob.CustomerID = job.CustomerID; retJob.CustRef = job.CustRef; retJob.CustomerName = job.CustomerName; retJob.DriverName = job.DriverName; retJob.dtFrom = currentDateUsed; retJob.dtTo = job.dtTo; retJob.Notes = job.Notes; retJob.Time = job.Time; retJob.Journey = job.Journey; retJob.Type = job.Type; retJob.MiscCode = dateFrom == dateTo.AddDays(-2) ? string.Format("{0}-RETURNED", job.MiscCode) : job.MiscCode; retJob.TruckId = job.TruckId; retJob.PinNumber = job.PinNumber; retJob.TrailerId = job.TrailerId; retJob.UseReturn = job.UseReturn; retJob.JobRef = job.JobRef; retJob.dtFrom = currentDateUsed; db.tblJobs.Add(retJob); currentDateUsed = currentDateUsed.AddDays(1); } } } else { if (job.IsDuplicate) { if (tblJob.DriverID == job.DriverID) { tblJob.DuplicateOf = job.JobID; var duplicatesFound = db.tblJobs.Count(j => j.DuplicateOf == job.JobID); tblJob.DriverName = string.Format("{0} ({1})", job.DriverName, (duplicatesFound + 2)); } tblJob.DriverID = job.DriverID; db.tblJobs.Add(tblJob); } } db.SaveChanges(); return(new DBResult { ReturnCode = ReturnCode.Success }); } catch (Exception ex) { return(new DBResult { ReturnCode = ReturnCode.Failed, Message = ex.Message }); } }