public void UpdateErrandDepartment(Errand errand) { Errand dbEntry = context.Errands.FirstOrDefault(e => e.RefNumber == errand.RefNumber); dbEntry.DepartmentId = errand.DepartmentId; context.SaveChanges(); }
public void UploadPicture(Errand errand, string pictureName) { Errand dbEntry = context.Errands.FirstOrDefault(e => e.RefNumber == errand.RefNumber); context.Pictures.Add(new Picture { ErrandId = dbEntry, PictureName = pictureName }); context.SaveChanges(); }
public void UploadSample(Errand errand, string sampleName) { Errand dbEntry = context.Errands.FirstOrDefault(e => e.RefNumber == errand.RefNumber); context.Samples.Add(new Sample { ErrandId = dbEntry, SampleName = sampleName }); context.SaveChanges(); }
public void UpdateErrandInfo(Errand errand) { Errand dbEntry = context.Errands.FirstOrDefault(e => e.RefNumber == errand.RefNumber); dbEntry.InvestigatorAction += errand.InvestigatorAction; dbEntry.InvestigatorInfo += errand.InvestigatorInfo; dbEntry.StatusId = errand.StatusId; context.SaveChanges(); }
public void UpdateErrandEmployee(Errand errand) { Errand dbEntry = context.Errands.FirstOrDefault(e => e.RefNumber == errand.RefNumber); if (errand.NoAction == true) { dbEntry.StatusId = "S_B"; } else { dbEntry.EmployeeId = errand.EmployeeId; dbEntry.StatusId = "S_A"; } context.SaveChanges(); }
public string SaveErrand(Errand errand) { if (errand.ErrandID == 0) { var cValue = Sequences.Where(cv => cv.Id == 1).First(); int refNumber = cValue.CurrentValue; errand.RefNumber = "2018-45-" + refNumber; errand.StatusId = "S_A"; UpdateRefNumber(cValue); context.Errands.Add(errand); } context.SaveChanges(); return(errand.RefNumber); }