public static List <LockerCollectionPointModel> GetLockerCPByLockersize(string lockersize, out string error)
{
error = "";
// entites used only by Get Methods
LUSSISEntities entities = new LUSSISEntities();
List <lockercollectionpoint> lcps = new List <lockercollectionpoint>();
LockerCollectionPointModel lcpm = new LockerCollectionPointModel();
List <LockerCollectionPointModel> lcplm = new List <LockerCollectionPointModel>();
try
{
// get lockercollectionpoint list from database by LockerSize
lcps = entities.lockercollectionpoints.Where(p => p.lockersize == lockersize).ToList <lockercollectionpoint>();
// convert the DB Model list to API Model list
foreach (lockercollectionpoint lcp in lcps)
{
lcplm.Add(ConvertBDLockerCPToAPILockerCP(lcp));
}
}
// 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;
}
//returning the Lockercollectionpoint List
return(lcplm);
}
public static LockerCollectionPointModel GetLockerCPByLockerid(int lockerid, out string error)
{
error = "";
LUSSISEntities entities = new LUSSISEntities();
lockercollectionpoint lcp = new lockercollectionpoint();
LockerCollectionPointModel lcpm = new LockerCollectionPointModel();
try
{
lcp = entities.lockercollectionpoints.Where(p => p.lockerid == lockerid).FirstOrDefault <lockercollectionpoint>();
lcpm = ConvertBDLockerCPToAPILockerCP(lcp);
}
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(lcpm);
}
public static List <LockerCollectionPointModel> GetLockerCPByCPName(string cpname, out string error)
{
error = "";
LUSSISEntities entities = new LUSSISEntities();
List <lockercollectionpoint> lcps = new List <lockercollectionpoint>();
LockerCollectionPointModel lcpm = new LockerCollectionPointModel();
List <LockerCollectionPointModel> lcplm = new List <LockerCollectionPointModel>();
try
{
lcps = entities.lockercollectionpoints.Where(p => p.collectionpoint.cpname == cpname).ToList <lockercollectionpoint>();
foreach (lockercollectionpoint Lcp in lcps)
{
lcplm.Add(ConvertBDLockerCPToAPILockerCP(Lcp));
}
}
// 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 locker collection point list
return(lcplm);
}
public static LockerCollectionPointModel CreateLockerCP(LockerCollectionPointModel lcp, string token, out string error)
{
string url = APIHelper.Baseurl + "/api/lockercollectionpoint/create/";
LockerCollectionPointModel lpc = APIHelper.Execute <LockerCollectionPointModel>(token, url, out error);
return(lcp);
}
public static LockerCollectionPointModel GetLockerCPByLockername(string lockername, string token, out string error)
{
string url = APIHelper.Baseurl + "/lockercollectionpoint/lockername" + lockername;
LockerCollectionPointModel lcp = APIHelper.Execute <LockerCollectionPointModel>(token, url, out error);
return(lcp);
}
// 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 CreateLockerCP(LockerCollectionPointModel lcp)
{
string error = "";
LockerCollectionPointModel lcpm = LockerCollectionPointRepo.CreateLockerCP(lcp, out error);
if (error != "" || lcpm == null)
{
return(Content(HttpStatusCode.BadRequest, error));
}
return(Ok(lcpm));
}
public IHttpActionResult GetLockerCPByLockername(string lockername)
{
string error = "";
LockerCollectionPointModel lcpm = LockerCollectionPointRepo.GetLockerCPByLockername(lockername, out error);
if (error != "" || lcpm == null)
{
if (error == ConError.Status.NOTFOUND)
{
return(Content(HttpStatusCode.NotFound, "Locker Not Found"));
}
return(Content(HttpStatusCode.BadRequest, error));
}
return(Ok(lcpm));
}
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 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);
}
public static LockerCollectionPointModel UpdateLockerCP(LockerCollectionPointModel lcpm, out string error)
{
// Initializing the error variable to return only blank if there is no error
error = "";
// declare and initialize new LUSSISEntities to perform update
LUSSISEntities entities = new LUSSISEntities();
lockercollectionpoint lcp = new lockercollectionpoint();
try
{
// finding the lockercollectionpoint by lockerid
lcp = entities.lockercollectionpoints.Where(p => p.lockerid == lcpm.Lockerid).First <lockercollectionpoint>();
// transfering data from API model to DB Model
lcp.lockername = lcpm.Lockername;
lcp.lockersize = lcpm.Lockersize;
lcp.cpid = lcpm.Cpid;
lcp.status = lcpm.Status;
// saving the update
entities.SaveChanges();
// return the updated model
lcpm = ConvertBDLockerCPToAPILockerCP(lcp);
}
// 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;
}
//returning the lockercollectionpoint object
return(lcpm);
}
public static LockerCollectionPointModel GetLockerCPByLockername(string lockername, out string error)
{
error = "";
// declare and initialize new LUSSISEntities to get LockerCollectionPoint By LockerName
LUSSISEntities entities = new LUSSISEntities();
lockercollectionpoint lcp = new lockercollectionpoint();
LockerCollectionPointModel lcpm = new LockerCollectionPointModel();
try
{
lcp = entities.lockercollectionpoints.Where(p => p.lockername == lockername).FirstOrDefault <lockercollectionpoint>();
lcpm = ConvertBDLockerCPToAPILockerCP(lcp);
}
catch (NullReferenceException)
{
error = ConError.Status.NOTFOUND;
}
catch (Exception e)
{
error = e.Message;
}
return(lcpm);
}
public static LockerCollectionPointModel CreateLockerCP(LockerCollectionPointModel lcpm, out string error)
{
error = "";
// entites used only by Get Methods
LUSSISEntities entities = new LUSSISEntities();
lockercollectionpoint lcp = new lockercollectionpoint();
try
{
// transfering data from API model to DB Model
lcp.lockername = lcpm.Lockername;
lcp.lockersize = lcpm.Lockersize;
lcp.cpid = lcpm.Cpid;
lcp.status = lcpm.Status;
//Add the updated data to DB Model
lcp = entities.lockercollectionpoints.Add(lcp);
// saving the update
entities.SaveChanges();
//retrieving the LockerColletionPoint By Lockerid
lcpm = GetLockerCPByLockerid(lcp.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(lcpm);
}
// Convert From Auto Generated DB Model to APIModel
private static LockerCollectionPointModel ConvertBDLockerCPToAPILockerCP(lockercollectionpoint lcp)
{
LockerCollectionPointModel lcpm = new LockerCollectionPointModel(lcp.lockerid, lcp.lockername, lcp.lockersize, lcp.cpid, lcp.status, lcp.collectionpoint.cpname);
return(lcpm);
}