public UpdateStatus Update(Call call)
{
UpdateStatus status = UpdateStatus.Failed;
HelpdeskRepository repo = new HelpdeskRepository(new DbContext());
if (!(repo.Exists <Call>(call.GetIdAsString())))
{
return(status);
}
try
{
var filter = Builders <Call> .Filter.Eq("Id", call.Id) & Builders <Call> .Filter.Eq("Version", call.Version);
var update = Builders <Call> .Update
.Set("DateClosed", call.DateClosed)
.Set("DateOpened", call.DateOpened)
.Set("EmployeeId", call.EmployeeId)
.Set("TechId", call.TechId)
.Set("Id", call.Id)
.Set("ProblemId", call.ProblemId)
.Set("Notes", call.Notes)
.Set("OpenStatus", call.OpenStatus)
.Inc("Version", 1);
status = repo.Update(call.GetIdAsString(), filter, update);
}
catch (Exception ex)
{
DALUtils.ErrorRoutine(ex, "CallDAO", "Update");
}
return(status);
}
public UpdateStatus Update(Employee emp)
{
UpdateStatus status = UpdateStatus.Failed;
HelpdeskRepository repo = new HelpdeskRepository(new DbContext());
try
{
var filter = Builders <Employee> .Filter.Eq("Id", emp.Id) & Builders <Employee> .Filter.Eq("Version", emp.Version);
var update = Builders <Employee> .Update
.Set("DepartmentId", emp.DepartmentId)
.Set("Email", emp.Email)
.Set("Firstname", emp.Firstname)
.Set("Lastname", emp.Lastname)
.Set("Phoneno", emp.Phoneno)
.Set("Title", emp.Title)
.Inc("Version", 1);
status = repo.Update(emp.GetIdAsString(), filter, update);
}
catch (Exception ex)
{
DALUtils.ErrorRoutine(ex, "EmployeeDAO", "Update");
}
return(status);
}
//End UpdateWithRepo
//Create - add an Department document to the Departments collection
public Department Create(Department dept)
{
HelpdeskRepository repo = new HelpdeskRepository(new DbContext());
try
{
dept = repo.Create(dept);
}
catch (Exception ex)
{
DALUtilsV2.ErrorRoutine(ex, "DepartmentDAO", "Create");
}
return(dept);
}
//End UpdateWithRepo
//Create - add an Problem document to the Problems collection
public Problem Create(Problem prob)
{
HelpdeskRepository repo = new HelpdeskRepository(new DbContext());
try
{
prob = repo.Create(prob);
}
catch (Exception ex)
{
DALUtilsV2.ErrorRoutine(ex, "ProblemDAO", "Create");
}
return(prob);
}
//End UpdateWithRepo
//Create - add an Employee document to the employees collection
public Employee Create(Employee emp)
{
HelpdeskRepository repo = new HelpdeskRepository(new DbContext());
try
{
emp = repo.Create(emp);
}
catch (Exception ex)
{
DALUtilsV2.ErrorRoutine(ex, "EmployeeDAO", "Create");
}
return(emp);
}
public int Update(Problem prob)
{
int status = -1;
HelpdeskRepository repo = new HelpdeskRepository(new DbContext());
try
{
var filter = Builders <Problem> .Filter.Eq("Id", prob.Id) & Builders <Problem> .Filter.Eq("Version", prob.Version);
var update = Builders <Problem> .Update
.Set("Description", prob.Description)
.Set("Id", prob.Id)
.Inc("Version", 1);
status = Convert.ToInt16(repo.Update(prob.GetIdAsString(), filter, update));
}
catch (Exception ex)
{
DALUtils.ErrorRoutine(ex, "ProblemDAO", "Update");
}
return(Convert.ToInt16(status));
}
public UpdateStatus Update(Department dep)
{
UpdateStatus status = UpdateStatus.Failed;
HelpdeskRepository repo = new HelpdeskRepository(new DbContext());
try
{
var filter = Builders <Department> .Filter.Eq("Id", dep.Id) & Builders <Department> .Filter.Eq("Version", dep.Version);
var update = Builders <Department> .Update
.Set("ManagerId", dep.ManagerId)
.Set("DepartmentName", dep.DepartmentName)
.Set("Id", dep.Id)
.Inc("Version", 1);
status = repo.Update(dep.GetIdAsString(), filter, update);
}
catch (Exception ex)
{
DALUtils.ErrorRoutine(ex, "DepartmentDAO", "Update");
}
return(status);
}