public ActionResult Create(IFormCollection collection)
{
try
{
// TODO: Add insert logic here
int departmentId = 0;
if (int.TryParse(collection["DepartmentId"], out departmentId))
{
var findDepartment = departmentRepository.FindById(departmentId);
if (findDepartment != null)
{
var newEmployee = new SmartIT.Employee.MockDB.Employee()
{
Name = collection["Name"], Gender = collection["Gender"], DepartmentId = departmentId
};
employeeRepository.Add(newEmployee);
}
}
return(RedirectToAction(nameof(Index)));
}
catch
{
return(View());
}
}
public void ConfirmRetrieval_AlreadyRetrieved_ThrowsException()
{
// Arrange
var requisitionRepository = new RequisitionRepository(context);
var departmentRepository = new DepartmentRepository(context);
var requisition = requisitionRepository.Save(new Requisition()
{
RequisitionId = "RSERVICETEST",
CollectionPoint = departmentRepository.FindById("ENGL").CollectionPoint,
Department = departmentRepository.FindById("ENGL"),
CreatedDateTime = DateTime.Now,
RequisitionDetails = new List <RequisitionDetail>()
{
new RequisitionDetail()
{
RequisitionId = "RSERVICETEST",
ItemCode = "E030",
Item = new ItemService(context).FindItemByItemCode("E030"),
Quantity = 30,
}
}
});
var retrieval = retrievalRepository.Save(new Retrieval()
{
RetrievalId = "RSERVICETEST",
Requisitions = new List <Requisition>()
{
requisition
},
CreatedDateTime = DateTime.Now,
Status = new StatusService(context).FindStatusByStatusId(20),
});
var disbursement = disbursementRepository.Save(new Disbursement()
{
DisbursementId = "RSERVICETEST",
Department = departmentRepository.FindById("ENGL"),
DisbursementDetails = new List <DisbursementDetail>()
{
new DisbursementDetail()
{
DisbursementId = "RSERVICETEST",
ItemCode = "E030",
Item = new ItemService(context).FindItemByItemCode("E030"),
PlanQuantity = 30,
ActualQuantity = 20,
Status = new StatusService(context).FindStatusByStatusId(18),
}
},
Retrieval = retrieval,
Status = new StatusService(context).FindStatusByStatusId(7),
CreatedDateTime = DateTime.Now,
});
var expectedStatus = new StatusService(context).FindStatusByStatusId(20);
// Act
new RetrievalService(context).ConfirmRetrieval("RSERVICETEST", "*****@*****.**");
// Assert
}
public void FindByIdTestNotNull()
{
// Act
var result = departmentRepository.FindById("ENGL");
// Assert
Assert.IsInstanceOfType(result, typeof(Department));
}
public void UpdateActualQuantity_Valid()
{
// Arrange
var requisitionRepository = new RequisitionRepository(context);
var departmentRepository = new DepartmentRepository(context);
var requisition = requisitionRepository.Save(new Requisition()
{
RequisitionId = "RSERVICETEST",
CollectionPoint = departmentRepository.FindById("ENGL").CollectionPoint,
Department = departmentRepository.FindById("ENGL"),
CreatedDateTime = DateTime.Now,
});
var retrieval = retrievalRepository.Save(new Retrieval()
{
RetrievalId = "RSERVICETEST",
Requisitions = new List <Requisition>()
{
requisition
},
CreatedDateTime = DateTime.Now,
});
var disbursement = disbursementRepository.Save(new Disbursement()
{
DisbursementId = "RSERVICETEST",
Department = departmentRepository.FindById("ENGL"),
DisbursementDetails = new List <DisbursementDetail>()
{
new DisbursementDetail()
{
DisbursementId = "RSERVICETEST",
ItemCode = "E030",
PlanQuantity = 20,
ActualQuantity = 20,
Status = new StatusService(context).FindStatusByStatusId(17),
}
},
Retrieval = retrieval,
Status = new StatusService(context).FindStatusByStatusId(1),
CreatedDateTime = DateTime.Now,
});
// Act
new RetrievalService(context).UpdateActualQuantity("RSERVICETEST", "*****@*****.**", "E030", new List <BreakdownByDepartment>()
{
new BreakdownByDepartment()
{
DeptId = "ENGL",
Actual = 10,
}
});
// Assert
Assert.AreEqual(10, new DisbursementDetailRepository(context).FindById("RSERVICETEST", "E030").ActualQuantity);
}
// GET: Departments/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var department = _db.FindById(id);
if (department == null)
{
return(HttpNotFound());
}
return(View(department));
}
public void RetrieveItem_Valid()
{
// Arrange
var requisitionRepository = new RequisitionRepository(context);
var departmentRepository = new DepartmentRepository(context);
var requisition = requisitionRepository.Save(new Requisition()
{
RequisitionId = "RSERVICETEST",
CollectionPoint = departmentRepository.FindById("ENGL").CollectionPoint,
Department = departmentRepository.FindById("ENGL"),
CreatedDateTime = DateTime.Now,
});
var retrieval = retrievalRepository.Save(new Retrieval()
{
RetrievalId = "RSERVICETEST",
Requisitions = new List <Requisition>()
{
requisition
},
CreatedDateTime = DateTime.Now,
});
var disbursement = disbursementRepository.Save(new Disbursement()
{
DisbursementId = "RSERVICETEST",
Department = departmentRepository.FindById("ENGL"),
DisbursementDetails = new List <DisbursementDetail>()
{
new DisbursementDetail()
{
DisbursementId = "RSERVICETEST",
Item = new ItemService(context).FindItemByItemCode("E030"),
ItemCode = "E030",
ActualQuantity = 1,
Status = new StatusService(context).FindStatusByStatusId(17),
}
},
Retrieval = retrieval,
Status = new StatusService(context).FindStatusByStatusId(1),
CreatedDateTime = DateTime.Now,
});
var expected = new StatusService(context).FindStatusByStatusId(18);
// Act
new RetrievalService(context).RetrieveItem(retrieval.RetrievalId, "*****@*****.**", "E030");
// Assert
Assert.AreEqual(expected.StatusId, new DisbursementDetailRepository(context).FindById(disbursement.DisbursementId, "E030").Status.StatusId);
}
public void TestInitialize()
{
var requisition = requisitionRepository.Save(new Requisition()
{
RequisitionId = "DAPICONTROLTEST",
CollectionPoint = departmentRepository.FindById("ENGL").CollectionPoint,
Department = departmentRepository.FindById("ENGL"),
CreatedDateTime = DateTime.Now,
Status = new StatusRepository(context).FindById(7),
RequisitionDetails = new List <RequisitionDetail>()
{
new RequisitionDetail()
{
RequisitionId = "DAPICONTROLTEST",
ItemCode = "E030",
Item = new ItemService(context).FindItemByItemCode("E030"),
Quantity = 30,
Status = new StatusRepository(context).FindById(7),
}
}
});
var retrieval = retrievalRepository.Save(new Retrieval()
{
RetrievalId = "DAPICONTROLTEST",
Requisitions = new List <Requisition>()
{
requisition
},
CreatedDateTime = DateTime.Now,
});
var disbursement = disbursementRepository.Save(new Disbursement()
{
DisbursementId = "DAPICONTROLTEST",
Department = departmentRepository.FindById("ENGL"),
DisbursementDetails = new List <DisbursementDetail>()
{
new DisbursementDetail()
{
DisbursementId = "DAPICONTROLTEST",
ItemCode = "E030",
ActualQuantity = 1,
}
},
Retrieval = retrieval,
Status = new StatusService(context).FindStatusByStatusId(1),
CreatedDateTime = DateTime.Now,
});
}
static void Main(string[] args)
{
List <Employee> lEmp = new List <Employee>();
var eRep = new EmployeeRepository();
var dRep = new DepartmentRepository();
var dep = new Department();
dep = dRep.FindById(2);
//Méthode findAll
lEmp = eRep.FindAll();
foreach (Employee emp in lEmp)
{
Console.WriteLine(emp.Firstname.ToString());
}
//Méthode Add
var _emp = new Employee()
{
Firstname = "Damien",
LastName = "Bonnefoy",
Gender = "Male",
Salary = 2454,
Department = dep
};
_emp = eRep.AddEmployee(_emp);
Console.WriteLine(_emp.Id);
}
public void UpdateActualQuantityForDisbursementDetail_ActualQuantityMore_ThrowsException()
{
// Arrange
var requisitionRepository = new RequisitionRepository(context);
var departmentRepository = new DepartmentRepository(context);
var requisition = requisitionRepository.Save(new Requisition()
{
RequisitionId = "DSERVICETEST",
CollectionPoint = departmentRepository.FindById("ENGL").CollectionPoint,
Department = departmentRepository.FindById("ENGL"),
CreatedDateTime = DateTime.Now,
});
var retrieval = retrievalRepository.Save(new Retrieval()
{
RetrievalId = "DSERVICETEST",
Requisitions = new List <Requisition>()
{
requisition
},
CreatedDateTime = DateTime.Now,
});
var disbursement = disbursementRepository.Save(new Disbursement()
{
DisbursementId = "DSERVICETEST",
Department = departmentRepository.FindById("ENGL"),
DisbursementDetails = new List <DisbursementDetail>()
{
new DisbursementDetail()
{
DisbursementId = "DSERVICETEST",
ItemCode = "E030",
PlanQuantity = 30,
ActualQuantity = 30,
Status = new StatusService(context).FindStatusByStatusId(18),
}
},
Retrieval = retrieval,
Status = new StatusService(context).FindStatusByStatusId(1),
CreatedDateTime = DateTime.Now,
});
// Act
new DisbursementService(context).UpdateActualQuantityForDisbursementDetail("DSERVICETEST", "E030", 40, "*****@*****.**");
}
public void ConfirmCollectionTest()
{
int expected = 10; //status id of Items Collected
//get retrieval object
Retrieval retrieval = context.Retrieval.Where(x => x.RetrievalId == "TEST").First();
retrieval.Requisitions.FirstOrDefault().RequisitionDetails = new List <RequisitionDetail>()
{
new RequisitionDetail()
{
RequisitionId = retrieval.Requisitions.FirstOrDefault().RequisitionId,
Item = new ItemService(context).FindItemByItemCode("E030"),
Status = new StatusService(context).FindStatusByStatusId(8),
}
};
//create disbursement and save it into database
Disbursement a = new Disbursement();
a.DisbursementId = IdService.GetNewDisbursementId(context);
a.Department = departmentRepository.FindById("COMM");
retrieval.Requisitions.Add(context.Requisition.First());
a.Retrieval = retrieval;
a.CreatedDateTime = DateTime.Now;
disbursementService.Save(a);
//include Disbursement detail object and save it
DisbursementDetail detail = new DisbursementDetail()
{
Disbursement = a,
Item = context.Item.First(),
PlanQuantity = 1,
ActualQuantity = 1
};
disbursementdetailRepository.Save(detail);
Disbursement result = disbursementService.ConfirmCollection(a.DisbursementId);
//Asert
Assert.AreEqual(expected, result.Status.StatusId);
}
public void ConfirmRetrieval_MoreThanOneRequisitionDiffDeptOutstanding_Valid()
{
// Arrange
var requisitionRepository = new RequisitionRepository(context);
var departmentRepository = new DepartmentRepository(context);
var requisition1 = requisitionRepository.Save(new Requisition()
{
RequisitionId = "RSERVICETEST1",
CollectionPoint = departmentRepository.FindById("ENGL").CollectionPoint,
Department = departmentRepository.FindById("ENGL"),
CreatedDateTime = DateTime.Now,
Status = statusRepository.FindById(7),
RequisitionDetails = new List <RequisitionDetail>()
{
new RequisitionDetail()
{
RequisitionId = "RSERVICETEST1",
ItemCode = "E030",
Item = new ItemService(context).FindItemByItemCode("E030"),
Status = statusRepository.FindById(7),
Quantity = 30,
}
}
});
var requisition2 = requisitionRepository.Save(new Requisition()
{
RequisitionId = "RSERVICETEST2",
CollectionPoint = departmentRepository.FindById("COMM").CollectionPoint,
Department = departmentRepository.FindById("COMM"),
CreatedDateTime = DateTime.Now,
Status = statusRepository.FindById(7),
RequisitionDetails = new List <RequisitionDetail>()
{
new RequisitionDetail()
{
RequisitionId = "RSERVICETEST2",
ItemCode = "E030",
Item = new ItemService(context).FindItemByItemCode("E030"),
Status = statusRepository.FindById(7),
Quantity = 30,
}
}
});
var retrieval = retrievalRepository.Save(new Retrieval()
{
RetrievalId = "RSERVICETEST",
Requisitions = new List <Requisition>()
{
requisition1, requisition2
},
CreatedDateTime = DateTime.Now,
Status = new StatusService(context).FindStatusByStatusId(19),
});
var disbursement1 = disbursementRepository.Save(new Disbursement()
{
DisbursementId = "RSERVICETEST1",
Department = departmentRepository.FindById("ENGL"),
DisbursementDetails = new List <DisbursementDetail>()
{
new DisbursementDetail()
{
DisbursementId = "RSERVICETEST1",
ItemCode = "E030",
Item = new ItemService(context).FindItemByItemCode("E030"),
PlanQuantity = 30,
ActualQuantity = 20,
Status = new StatusService(context).FindStatusByStatusId(18),
},
},
Retrieval = retrieval,
Status = new StatusService(context).FindStatusByStatusId(7),
CreatedDateTime = DateTime.Now,
});
var disbursement2 = disbursementRepository.Save(new Disbursement()
{
DisbursementId = "RSERVICETEST2",
Department = departmentRepository.FindById("ENGL"),
DisbursementDetails = new List <DisbursementDetail>()
{
new DisbursementDetail()
{
DisbursementId = "RSERVICETEST2",
ItemCode = "E030",
Item = new ItemService(context).FindItemByItemCode("E030"),
PlanQuantity = 30,
ActualQuantity = 20,
Status = new StatusService(context).FindStatusByStatusId(18),
},
},
Retrieval = retrieval,
Status = new StatusService(context).FindStatusByStatusId(7),
CreatedDateTime = DateTime.Now,
});
var expectedStatus = new StatusService(context).FindStatusByStatusId(20);
var expectedRemarks = "Automatically generated by system based on outstanding quantity - RSERVICETEST";
// Act
new RetrievalService(context).ConfirmRetrieval("RSERVICETEST", "*****@*****.**");
// Assert
Assert.AreEqual(expectedStatus.StatusId, new RetrievalService(context).FindRetrievalById("RSERVICETEST").Status.StatusId);
Assert.IsTrue(new RequisitionService(context).FindAllRequisitions().Select(r => r.EmployeeRemarks).Contains(expectedRemarks));
var result = new RequisitionService(context).FindAllRequisitions().Where(r => r.EmployeeRemarks == expectedRemarks).FirstOrDefault();
Assert.AreEqual(10, result.RequisitionDetails.Sum(rr => rr.Quantity));
}
public void ConfirmRetrieval_AlreadyConfirmed_BadRequest()
{
// Arrange
var requisitionRepository = new RequisitionRepository(context);
var departmentRepository = new DepartmentRepository(context);
var requisition = requisitionRepository.Save(new Requisition()
{
RequisitionId = "RETCONTROLTEST",
CollectionPoint = departmentRepository.FindById("ENGL").CollectionPoint,
Department = departmentRepository.FindById("ENGL"),
CreatedDateTime = DateTime.Now,
RequisitionDetails = new List <RequisitionDetail>()
{
new RequisitionDetail()
{
RequisitionId = "RETCONTROLTEST",
ItemCode = "E030",
Item = new ItemService(context).FindItemByItemCode("E030"),
Quantity = 30,
}
}
});
var retrieval = retrievalRepository.Save(new Retrieval()
{
RetrievalId = "RETCONTROLTEST",
Requisitions = new List <Requisition>()
{
requisition
},
CreatedDateTime = DateTime.Now,
Status = new StatusService(context).FindStatusByStatusId(20),
});
var disbursement = disbursementRepository.Save(new Disbursement()
{
DisbursementId = "RETCONTROLTEST",
Department = departmentRepository.FindById("ENGL"),
DisbursementDetails = new List <DisbursementDetail>()
{
new DisbursementDetail()
{
DisbursementId = "RETCONTROLTEST",
ItemCode = "E030",
Item = new ItemService(context).FindItemByItemCode("E030"),
PlanQuantity = 30,
ActualQuantity = 30,
Status = new StatusService(context).FindStatusByStatusId(18),
}
},
Retrieval = retrieval,
Status = new StatusService(context).FindStatusByStatusId(7),
CreatedDateTime = DateTime.Now,
});
var expectedStatus = new StatusService(context).FindStatusByStatusId(20);
var controller = new RetrievalAPIController()
{
Request = new HttpRequestMessage(),
Configuration = new HttpConfiguration(),
Context = context,
};
// Act
IHttpActionResult actionResult = controller.ConfirmRetrieval(new ConfirmRetrievalViewModel()
{
RetrievalId = "RETCONTROLTEST",
Email = "*****@*****.**",
});
BadRequestErrorMessageResult badRequest = actionResult as BadRequestErrorMessageResult;
// Assert
Assert.IsInstanceOfType(actionResult, typeof(BadRequestErrorMessageResult));
Assert.AreEqual("Retrieval already confirmed", badRequest.Message);
}
public void ConfirmRetrieval_Valid()
{
// Arrange
var requisitionRepository = new RequisitionRepository(context);
var departmentRepository = new DepartmentRepository(context);
var requisition = requisitionRepository.Save(new Requisition()
{
RequisitionId = "RETCONTROLTEST",
CollectionPoint = departmentRepository.FindById("ENGL").CollectionPoint,
Department = departmentRepository.FindById("ENGL"),
CreatedDateTime = DateTime.Now,
Status = new StatusRepository(context).FindById(7),
RequisitionDetails = new List <RequisitionDetail>()
{
new RequisitionDetail()
{
RequisitionId = "RETCONTROLTEST",
ItemCode = "E030",
Item = new ItemService(context).FindItemByItemCode("E030"),
Quantity = 30,
Status = new StatusRepository(context).FindById(7),
}
}
});
var retrieval = retrievalRepository.Save(new Retrieval()
{
RetrievalId = "RETCONTROLTEST",
Requisitions = new List <Requisition>()
{
requisition
},
CreatedDateTime = DateTime.Now,
Status = new StatusService(context).FindStatusByStatusId(19),
});
var disbursement = disbursementRepository.Save(new Disbursement()
{
DisbursementId = "RETCONTROLTEST",
Department = departmentRepository.FindById("ENGL"),
DisbursementDetails = new List <DisbursementDetail>()
{
new DisbursementDetail()
{
DisbursementId = "RETCONTROLTEST",
ItemCode = "E030",
Item = new ItemService(context).FindItemByItemCode("E030"),
PlanQuantity = 30,
ActualQuantity = 30,
Status = new StatusService(context).FindStatusByStatusId(18),
}
},
Retrieval = retrieval,
Status = new StatusService(context).FindStatusByStatusId(7),
CreatedDateTime = DateTime.Now,
});
var expectedStatus = new StatusService(context).FindStatusByStatusId(20);
var controller = new RetrievalAPIController()
{
Request = new HttpRequestMessage(),
Configuration = new HttpConfiguration(),
Context = context,
};
// Act
IHttpActionResult actionResult = controller.ConfirmRetrieval(new ConfirmRetrievalViewModel()
{
RetrievalId = "RETCONTROLTEST",
Email = "*****@*****.**",
});
var contentResult = actionResult as OkNegotiatedContentResult <MessageViewModel>;
// Assert
Assert.IsNotNull(contentResult);
Assert.IsNotNull(contentResult.Content);
Assert.AreEqual(contentResult.Content.Message, "Successfully confirmed");
var result = new RetrievalRepository(context).FindById("RETCONTROLTEST");
Assert.AreEqual(expectedStatus.Name, result.Status.Name);
}
public Department FindDepartmentByDepartmentCode(string departmentCode)
{
return(departmentRepository.FindById(departmentCode));
}
public IHttpActionResult CreateRequisition(UpdateRequisitionJSONViewModel json)
{
ApplicationUser user = userRepository.FindById(RequestContext.Principal.Identity.GetUserId());
// update the collection point
Department d = departmentRepository.FindById(user.Department.DepartmentCode);
d.CollectionPoint = collectionPointRepository.FindById(json.CollectionPointId);
departmentRepository.Save(d);
if (json.ItemList.Count < 1)
{
return(BadRequest("An unexpected error occured."));
}
// create the requisition
Requisition r = new Requisition();
r.RequisitionId = IdService.GetNewRequisitionId(context);
r.RequisitionDetails = new List <RequisitionDetail>();
r.EmployeeRemarks = json.Remarks;
if (json.IsDraft == true)
{
r.Status = statusService.FindStatusByStatusId(3);
}
else
{
r.Status = statusService.FindStatusByStatusId(4);
}
r.CreatedDateTime = DateTime.Now;
r.Department = user.Department;
r.CollectionPoint = collectionPointRepository.FindById(json.CollectionPointId);
r.CreatedBy = user;
// create requisition details
foreach (UpdateRequisitionTableJSONViewModel dd in json.ItemList)
{
r.RequisitionDetails.Add(new RequisitionDetail
{
ItemCode = dd.ItemCode,
Item = itemService.FindItemByItemCode(dd.ItemCode),
Quantity = dd.Qty,
Status = statusService.FindStatusByStatusId(4)
});
}
try
{
requisitionService.Save(r);
}
catch
{
return(BadRequest("An unexpected error occured."));
}
// Create Notification
Notification n = new NotificationService(context).CreateNotification(r, user.Department.Head);
new NotificationApiController()
{
context = context
}.SendNotification(n.NotificationId.ToString());
new NotificationApiController()
{
context = context
}.SendEmail(n.NotificationId.ToString());
return(Ok(r.RequisitionId));
}
