public void AssignEmployee(string employeeID, int errandID)
{
Errand dbEntry = context.Errands.FirstOrDefault(e => e.ErrandID == errandID);
dbEntry.EmployeeId = employeeID;
context.SaveChanges();
}
//Save or update errand
public string SaveErrand(Errand errand)
{
if (errand.ErrandID == 0)
{
//Create new ID
var sequenceObject = Sequence.First();
int sequenceValue = sequenceObject.CurrentValue;
errand.RefNumber = "2020-45-" + sequenceValue;
errand.StatusId = "S_D";
//Add errand to database
context.Errands.Add(errand);
//Update Sequence count
sequenceValue++;
sequenceObject.CurrentValue = sequenceValue;
context.Sequences.Update(sequenceObject);
}
else
{
Errand dbEntry = context.Errands.FirstOrDefault(er => er.ErrandID == errand.ErrandID);
if (dbEntry != null)
{
//code to update here
}
}
context.SaveChanges();
return(errand.RefNumber);
}
//Add department to errand
public void AssignDepartment(Department department, int errandID)
{
Errand dbEntry = context.Errands.FirstOrDefault(er => er.ErrandID == errandID);
dbEntry.DepartmentId = department.DepartmentId;
context.SaveChanges();
}
public void CloseCase(int errandID, string reason)
{
Errand dbEntry = context.Errands.FirstOrDefault(e => e.ErrandID == errandID);
dbEntry.StatusId = "S_B";
dbEntry.InvestigatorInfo = string.Format("{0} {1}",
dbEntry.InvestigatorInfo, reason);
context.SaveChanges();
}
/// <summary>
/// Method to add the errand object data to database if no similar ID exists.
/// </summary>
/// <param name="errand">object of errand to be added to to DB</param>
/// <returns>Created errand's ref number to be shown in view.</returns>
public string SaveErrand(Errand errand)
{
if (errand.ErrandId == 0)
{
context.Errands.Add(errand);
}
context.SaveChanges();
return(errand.RefNumber);
}
/// <summary>
/// Methods to update information of an errand.
/// </summary>
/// <param name="errand"></param>
/// <returns>The updated errand Id</returns>
public int UpdateDepartment(Errand errand)
{
Errand dbEntry = context.Errands.FirstOrDefault(s => s.ErrandId == errand.ErrandId); //This Can be put in a different method which is called by each update method.
if (dbEntry != null)
{
dbEntry.DepartmentId = errand.DepartmentId;
}
context.SaveChanges();
return(errand.ErrandId);
}
public int UpdateStatusId(Errand errand)
{
Errand dbEntry = context.Errands.FirstOrDefault(s => s.ErrandId == errand.ErrandId);
if (dbEntry != null)
{
dbEntry.StatusId = errand.StatusId;
}
context.SaveChanges();
return(errand.ErrandId);
}
public int UpdateAction(Errand errand)
{
Errand dbEntry = context.Errands.FirstOrDefault(s => s.ErrandId == errand.ErrandId);
if (dbEntry != null)
{
dbEntry.StatusId = "S_B";
dbEntry.InvestigatorInfo = errand.InvestigatorInfo;
dbEntry.EmployeeId = null;
}
context.SaveChanges();
return(errand.ErrandId);
}
public void UpdateStatus(int errandID, string errandStatusID, string events, string information)
{
Errand dbEntry = context.Errands.FirstOrDefault(e => e.ErrandID == errandID);
dbEntry.StatusId = errandStatusID;
if (events != null)
{
dbEntry.InvestigatorAction += events;
}
if (information != null)
{
dbEntry.InvestigatorInfo += information;
}
context.SaveChanges();
}
public int UpdateInvestigatorInfo(Errand errand)
{
Errand dbEntry = context.Errands.FirstOrDefault(s => s.ErrandId == errand.ErrandId);
if (dbEntry != null)
{
if (dbEntry.InvestigatorInfo == null)
{
dbEntry.InvestigatorInfo = errand.InvestigatorInfo;
}
else
{
dbEntry.InvestigatorInfo += "\n" + errand.InvestigatorInfo;
}
}
context.SaveChanges();
return(errand.ErrandId);
}
public string SaveErrand(Errand errand)
{
throw new NotImplementedException();
}