public static DisbursementLockerModel UpdateDisbursementLocker(DisbursementLockerModel lislm, out string error)
{
error = "";
// entites used only by Get Methods
LUSSISEntities entities = new LUSSISEntities();
disbursementlocker disl = new disbursementlocker();
DisbursementLockerModel dislm = new DisbursementLockerModel();
try
{
disl = entities.disbursementlockers.Where(p => p.reqid == lislm.ReqID && p.lockerid == lislm.LockerID).FirstOrDefault();
disl.collecteddate = DateTime.Now;
disl.status = lislm.Status;
entities.SaveChanges();
dislm = GetDisbursementLockerByReqIDAndLockerID(disl.reqid, disl.lockerid, out error);
}
// if locker not found, will throw NOTFOUND exception
catch (NullReferenceException)
{
// if there is NULL Exception error, error will be 404
error = ConError.Status.NOTFOUND;
}
catch (Exception e)
{
// for other exceptions
error = e.Message;
}
//retuning the lockercollectionpoint object
return(dislm);
}
public static DisbursementLockerModel GetDisbursementLockerByReqIDAndLockerID(int ReqID, int LockerID, out string error)
{
error = "";
LUSSISEntities entities = new LUSSISEntities();
disbursementlocker disl = new disbursementlocker();
DisbursementLockerModel dislm = new DisbursementLockerModel();
try
{
disl = entities.disbursementlockers.Where(p => p.reqid == ReqID && p.lockerid == LockerID).FirstOrDefault();
dislm = CovertDisLockertoModel(disl);
}
catch (NullReferenceException)
{
// if there is NULL Exception error, error will be 404
error = ConError.Status.NOTFOUND;
}
catch (Exception e)
{
// for other exceptions
error = e.Message;
}
return(dislm);
}
// update the Requisition Pending to Preparing
public static List <RequisitionWithDisbursementModel> UpdateAllRequestStatusToPreparing(out string error)
{
error = "";
// declare and initialize new LUSSISEntities to perform update
LUSSISEntities entities = new LUSSISEntities();
List <requisition> reqs = new List <requisition>();
List <RequisitionWithDisbursementModel> reqdisms = new List <RequisitionWithDisbursementModel>();
try
{
reqs = entities.requisitions.Where(p => p.status == ConRequisition.Status.REQUESTPENDING).ToList();
foreach (requisition req in reqs)
{
req.status = ConRequisition.Status.PREPARING;
entities.SaveChanges();
DisbursementLockerModel dislm = new DisbursementLockerModel();
dislm.DisID = req.disbursements.First().disid;
dislm.ReqID = req.reqid;
dislm.DeptID = req.deptid;
List <LockerCollectionPointModel> lcpms = LockerCollectionPointRepo.GetAllLockerCP(out error);
LockerCollectionPointModel lcpm = lcpms.Where(p => p.Cpid == req.cpid && p.Status == ConLockerCollectionPoint.Active.AVAILABLE).FirstOrDefault();
if (lcpm == null)
{
List <DisbursementLockerModel> Currentdislms = new List <DisbursementLockerModel>();
Currentdislms = LockerCollectionPointRepo.GetDisbursementLockersByDeptIDAndStatus(req.deptid, 1, out error);
if (Currentdislms.Count > 0)
{
dislm = Currentdislms.First();
}
else
{
lcpm = new LockerCollectionPointModel();
lcpm = lcpms.Where(p => p.Cpid == req.cpid).FirstOrDefault();
}
}
else
{
dislm.LockerID = lcpm.Lockerid;
}
dislm = LockerCollectionPointRepo.CreateDisbursementLocker(dislm, out error);
reqdisms.Add(CovertDBRequisitionDistoAPIRequisitionDiswithDetails(req));
}
}
catch (NullReferenceException)
{
error = ConError.Status.NOTFOUND;
}
catch (Exception e)
{
error = e.Message;
}
return(reqdisms);
}
public IHttpActionResult UpdateDisbursementLocker(DisbursementLockerModel disl)
{
string error = "";
DisbursementLockerModel dislm = LockerCollectionPointRepo.UpdateDisbursementLocker(disl, out error);
if (error != "" || dislm == null)
{
return(Content(HttpStatusCode.BadRequest, error));
}
return(Ok(dislm));
}
public IHttpActionResult GetDisbursementLockerByLockerIDAndReqID(int lockerid, int reqid)
{
string error = "";
DisbursementLockerModel dislm = LockerCollectionPointRepo.GetDisbursementLockerByReqIDAndLockerID(reqid, lockerid, out error);
if (error != "" || dislm == null)
{
if (error == ConError.Status.NOTFOUND)
{
return(Content(HttpStatusCode.NotFound, "Locker Disbursement Not Found"));
}
return(Content(HttpStatusCode.BadRequest, error));
}
return(Ok(dislm));
}
public IHttpActionResult UpdateDisbursementLockerToCollected(DisbursementLockerModel disl)
{
string error = "";
DisbursementLockerModel dislm = LockerCollectionPointRepo.UpdateDisbursementLocker(disl, out error);
LockerCollectionPointModel lcpm = LockerCollectionPointRepo.GetLockerCPByLockerid(dislm.LockerID, out error);
lcpm.Status = ConLockerCollectionPoint.Active.AVAILABLE;
lcpm = LockerCollectionPointRepo.UpdateLockerCP(lcpm, out error);
if (error != "" || dislm == null)
{
return(Content(HttpStatusCode.BadRequest, error));
}
return(Ok(dislm));
}
public IHttpActionResult UpdateRequisitionCompleted(RequisitionModel po)
{
string error = "";
po = RequisitionRepo.GetRequisitionByRequisitionId(po.Reqid, out error);
// if the staff has already updated the status to "preparing"
if (po.Status == ConRequisition.Status.COMPLETED)
{
return(Ok(po));
}
po.Status = ConRequisition.Status.COMPLETED;
OutstandingReqModel outreqm;
outreqm = OutstandingReqRepo.GetOutstandingReqByReqId(po.Reqid, out error);
if (outreqm.ReqId != 0)
{
po.Status = ConRequisition.Status.OUTSTANDINGREQUISITION;
}
// updating the status
RequisitionModel pom = RequisitionRepo.UpdateRequisition(po, out error);
// update the locker disburement to collected
DisbursementLockerModel dislm = LockerCollectionPointRepo.GetDisbursementLockerByReqID(po.Reqid, out error);
dislm = LockerCollectionPointRepo.UpdateDisbursementLockerToCollected(dislm, out error);
if (error != "" || pom == null)
{
if (error == ConError.Status.NOTFOUND)
{
return(Content(HttpStatusCode.NotFound, "PO Not Found"));
}
return(Content(HttpStatusCode.BadRequest, error));
}
return(Ok(pom));
}
public static DisbursementLockerModel CreateDisbursementLocker(DisbursementLockerModel lislm, out string error)
{
error = "";
// entites used only by Get Methods
LUSSISEntities entities = new LUSSISEntities();
disbursementlocker disl = new disbursementlocker();
DisbursementLockerModel dislm = new DisbursementLockerModel();
try
{
disl.disid = lislm.DisID;
disl.reqid = lislm.ReqID;
disl.lockerid = lislm.LockerID;
disl.deptid = lislm.DeptID;
disl.delivereddate = DateTime.Now.AddDays(2);
disl.collecteddate = DateTime.Now.AddDays(9);
disl.status = 1;
entities.disbursementlockers.Add(disl);
entities.SaveChanges();
LockerCollectionPointModel lcpm = GetLockerCPByLockerid(disl.lockerid, out error);
lcpm.Status = ConLockerCollectionPoint.Active.NOTAVAILABLE;
lcpm = UpdateLockerCP(lcpm, out error);
dislm = GetDisbursementLockerByReqIDAndLockerID(disl.reqid, disl.lockerid, out error);
}
// if locker not found, will throw NOTFOUND exception
catch (NullReferenceException)
{
// if there is NULL Exception error, error will be 404
error = ConError.Status.NOTFOUND;
}
catch (Exception e)
{
// for other exceptions
error = e.Message;
}
//retuning the lockercollectionpoint object
return(dislm);
}
private static DisbursementLockerModel CovertDisLockertoModel(disbursementlocker disl)
{
DisbursementLockerModel dislm = new DisbursementLockerModel(disl.disid, disl.reqid, disl.lockerid, disl.delivereddate, disl.collecteddate, disl.status, disl.requisition.deptid);
return(dislm);
}
