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