public void SaveRequestDetails(StationeryRequestDetailsEF details)
{
var existingRequestDet = context.StationeryRequestDetails.Find(details.RequestDetailsId);
if (existingRequestDet != null)
{
existingRequestDet.RetrievedQuantity = details.RetrievedQuantity;
existingRequestDet.FulfilledQuantity = details.FulfilledQuantity;
existingRequestDet.FulfilmentStatus = details.FulfilmentStatus;
context.SaveChanges();
}
}
public void CreateRequest(StaffEF staff, RequestListDTO requestListDTO)
{
StationeryRequestEF newRequest; string requestId; StationeryRequestDetailsEF requestItem; bool existingItem;
List <StationeryRequestDetailsEF> requestList = new List <StationeryRequestDetailsEF>();
long unixTimestamp = (long)(DateTime.UtcNow.Subtract(new DateTime(1970, 1, 1))).TotalSeconds;
int year = DateTime.Now.Year;
if (requestListDTO.RequestId != null)
{
requestId = requestListDTO.RequestId;
List <StationeryRequestDetailsEF> currentList = rndEFF.FindAllStationeryRequestDetailsByRequestId(requestId);
for (int i = 0; i < currentList.Count; i++)
{
existingItem = false;
for (int j = 0; j < requestListDTO.ItemDescription.Count; j++)
{
if (currentList[i].Stock.Description == requestListDTO.ItemDescription[j])
{
requestItem = rndEFF.FindRequestDetailsByRequestIdAndItemCode(requestId, currentList[i].Stock.ItemCode);
requestItem.RequestQuantity = requestListDTO.Quantity[j];
requestList.Add(requestItem);
existingItem = true;
requestListDTO.Remove[j] = true;
break;
}
}
if (!existingItem)
{
rndEFF.DropRequestDetails(currentList[i]);
}
}
requestListDTO = RemoveFromRequestListDTO(requestListDTO);
for (int k = 0; k < requestListDTO.ItemDescription.Count; k++)
{
string stockId = stockEFF.FindStockByDescription(requestListDTO.ItemDescription[k]).ItemCode;
requestItem = new StationeryRequestDetailsEF(requestId, stockId, requestListDTO.Quantity[k]);
requestList.Add(requestItem);
}
}
else
{
int num = rndEFF.FindLastRequestNoByYearAndDepartment(staff.DepartmentCode, year) + 1;
requestId = staff.DepartmentCode + "/" + year + "/" + num;
for (int i = 0; i < requestListDTO.ItemDescription.Count; i++)
{
string stockId = stockEFF.FindStockByDescription(requestListDTO.ItemDescription[i]).ItemCode;
requestItem = new StationeryRequestDetailsEF(requestId, stockId, requestListDTO.Quantity[i]);
requestList.Add(requestItem);
}
}
newRequest = new StationeryRequestEF(requestId, staff.StaffId, unixTimestamp);
rndEFF.SaveRequestAndRequestDetails(newRequest, requestList);
StaffEF currentAuthority = staff.Department.Authority;
if (currentAuthority.Email != null)
{
string subject = "Pending Stationery Request";
string body = "Request #" + requestId + " has been submitted by " + staff.Name + " for your approval. Please click " +
"<a href='http://localhost/StationeryStore/ApproveRequest/ViewRequest/?requestId=" + requestId + "'>" + "here</a> to view the details.";
Email.SendEmail(currentAuthority.Email, subject, body);
}
}
public void UpdateRequestDetails(StationeryRequestDetailsEF details)
{
rndEFF.SaveRequestDetails(details);
}
public void DropRequestDetails(StationeryRequestDetailsEF stationeryRequestDetails)
{
context.Entry(stationeryRequestDetails).State = EntityState.Deleted;
context.SaveChanges();
}
