public static CollectionPointModel CreateCollectionPoint(CollectionPointModel cpm, out string error)
{
error = "";
LUSSISEntities entities = new LUSSISEntities();
collectionpoint cp = new collectionpoint();
try
{
cp.cpname = cpm.Cpname;
cp.cplocation = cpm.Cplocation;
cp.latitude = cpm.Latitude;
cpm.Longitude = cpm.Longitude;
cp = entities.collectionpoints.Add(cp);
entities.SaveChanges();
cpm = GetCollectionPointByCpid(cp.cpid, out error);
}
catch (NullReferenceException)
{
error = ConError.Status.NOTFOUND;
}
catch (Exception e)
{
error = e.Message;
}
return(cpm);
}
public static InventoryModel CreateInventory(InventoryModel invm, out string error)
{
error = "";
LUSSISEntities entities = new LUSSISEntities();
inventory inv = new inventory();
try
{
inv.itemid = invm.Itemid;
inv.stock = invm.Stock;
inv.reorderlevel = invm.ReorderLevel;
inv.reorderqty = invm.ReorderQty;
inv = entities.inventories.Add(inv);
entities.SaveChanges();
// retrieving the inserted inventory model by using the GetInventory method
invm = GetInventoryByInventoryid(inv.invid, out error);
}
catch (NullReferenceException)
{
error = ConError.Status.NOTFOUND;
}
catch (Exception e)
{
error = e.Message;
}
return(invm);
}
public static NotificationModel CreatNotification(NotificationModel nm, out string error)
{
error = "";
LUSSISEntities entities = new LUSSISEntities();
notification n = new notification();
try
{
n.datetime = DateTime.Now;
n.deptid = nm.Deptid;
n.role = nm.Role;
n.title = nm.Title;
n.remark = nm.Remark;
n.isread = false;
n.resid = nm.ResID;
n.notitype = nm.NotiType;
n = entities.notifications.Add(n);
entities.SaveChanges();
nm = GetNotiBynotiid(n.notiid, out error);
}
catch (NullReferenceException)
{
error = ConError.Status.NOTFOUND;
}
catch (Exception e)
{
error = e.Message;
}
return(nm);
}
// Get item price by itemid
public static SupplierItemModel GetSupplierItemByItemId(int itemid, out string error)
{
LUSSISEntities entities = new LUSSISEntities();
error = "";
supplieritem supitem = new supplieritem();
SupplierItemModel sim = new SupplierItemModel();
try
{
double min = 0.0;
min = entities.supplieritems
.Where(x => x.itemid == itemid)
.Min(x => x.price);
supitem = entities.supplieritems
.Where(x => x.price == min && x.itemid == itemid)
.FirstOrDefault();
sim = ConvertDBSupItemToAPISupItem(supitem);
}
catch (NullReferenceException)
{
error = ConError.Status.NOTFOUND;
}
catch (InvalidOperationException)
{
error = ConError.Status.BADREQUEST;
}
catch (Exception e)
{
error = e.Message;
}
return(sim);
}
public static InventoryDetailModel GetInventoryDetailByItemid(int itemid, out string error)
{
LUSSISEntities entities = new LUSSISEntities();
error = "";
inventory inventory = new inventory();
InventoryDetailModel invdm = new InventoryDetailModel();
try
{
staticpoms = PurchaseOrderRepo.GetPurchaseOrderByStatus(ConPurchaseOrder.Status.PENDING, out error);
staticcount = 1;
inventory = entities.inventories.Where(p => p.itemid == itemid).FirstOrDefault <inventory>();
invdm = CovertDBInventorytoAPIInventoryDet(inventory);
}
catch (NullReferenceException)
{
error = ConError.Status.NOTFOUND;
}
catch (Exception e)
{
error = e.Message;
}
return(invdm);
}
// Get item price by itemid
public static List <SupplierItemModel> GetSupplierItemListByItemId(int itemid, out string error)
{
LUSSISEntities entities = new LUSSISEntities();
error = "";
List <supplieritem> supitems = new List <supplieritem>();
List <SupplierItemModel> sims = new List <SupplierItemModel>();
try
{
supitems = entities.supplieritems
.Where(x => x.itemid == itemid).ToList();
foreach (supplieritem si in supitems)
{
sims.Add(ConvertDBSupItemToAPISupItem(si));
}
}
catch (NullReferenceException)
{
error = ConError.Status.NOTFOUND;
}
catch (InvalidOperationException)
{
error = ConError.Status.BADREQUEST;
}
catch (Exception e)
{
error = e.Message;
}
return(sims);
}
// Get all items of all suppliers
public static List <SupplierItemModel> GetAllSupplierItem(out string error)
{
LUSSISEntities entities = new LUSSISEntities();
error = "";
List <SupplierItemModel> sims = new List <SupplierItemModel>();
try
{
List <supplieritem> supplieritems = entities.supplieritems.Where(x => x.supplier.active == ConSupplier.Active.ACTIVE).ToList();
sims = new List <SupplierItemModel>();
foreach (supplieritem si in supplieritems)
{
sims.Add(ConvertDBSupItemToAPISupItem(si));
}
}
catch (NullReferenceException)
{
error = ConError.Status.NOTFOUND;
}
catch (Exception e)
{
error = e.Message;
}
return(sims);
}
public static DepartmentModel CreateDepartment(DepartmentModel dm, out string error)
{
error = "";
LUSSISEntities entities = new LUSSISEntities();
department d = new department();
try
{
d.deptname = dm.Deptname;
d.deptcontactname = dm.Deptcontactname;
d.deptphone = dm.Deptphone;
d.deptemail = dm.Deptemail;
d = entities.departments.Add(d);
entities.SaveChanges();
dm = CovertDBDepttoAPIDept(d);
}
catch (NullReferenceException)
{
error = ConError.Status.NOTFOUND;
}
catch (Exception e)
{
error = e.Message;
}
return(dm);
}
public static List <DepartmentCollectionPointModel> GetDepartmentCollectionPointsByStatus(int status, out string error)
{
error = "";
// declare and initialize new LUSSISEntities to perform update
LUSSISEntities entities = new LUSSISEntities();
List <departmentcollectionpoint> dcps = new List <departmentcollectionpoint>();
List <DepartmentCollectionPointModel> dcpms = new List <DepartmentCollectionPointModel>();
try
{
dcps = entities.departmentcollectionpoints.Where(p => p.status == status).ToList <departmentcollectionpoint>();
// return the updated model
foreach (departmentcollectionpoint dcp in dcps)
{
dcpms.Add(CovertDBDCPtoAPIDCP(dcp));
}
}
catch (NullReferenceException)
{
error = ConError.Status.NOTFOUND;
}
catch (Exception e)
{
error = e.Message;
}
return(dcpms);
}
public static DepartmentModel GetDepartmentByReqid(int reqid, out string error)
{
LUSSISEntities entities = new LUSSISEntities();
error = "";
department dept = new department();
requisition req = new requisition();
DepartmentModel dm = new DepartmentModel();
try
{
req = entities.requisitions.Where(p => p.reqid == reqid).FirstOrDefault <requisition>();
dept = req.department;
dm = CovertDBDepttoAPIDept(dept);
}
catch (NullReferenceException)
{
error = ConError.Status.NOTFOUND;
}
catch (Exception e)
{
error = e.Message;
}
return(dm);
}
public static DepartmentModel UpdateDepartment(DepartmentModel dm, out string error)
{
error = "";
// declare and initialize new LUSSISEntities to perform update
LUSSISEntities entities = new LUSSISEntities();
department d = new department();
try
{
// finding the department object using Department API model
d = entities.departments.Where(p => p.deptid == dm.Deptid).First <department>();
// transfering data from API model to DB Model
d.deptname = dm.Deptname;
d.deptcontactname = dm.Deptcontactname;
d.deptphone = dm.Deptphone;
d.deptemail = dm.Deptemail;
// saving the update
entities.SaveChanges();
// return the updated model
dm = CovertDBDepttoAPIDept(d);
}
catch (NullReferenceException)
{
error = ConError.Status.NOTFOUND;
}
catch (Exception e)
{
error = e.Message;
}
return(dm);
}
public static List <DepartmentModel> GetDepartmentsByCpid(int cpid, out string error)
{
LUSSISEntities entities = new LUSSISEntities();
error = "";
List <departmentcollectionpoint> cps = new List <departmentcollectionpoint>();
List <DepartmentModel> dms = new List <DepartmentModel>();
try
{
cps = entities.departmentcollectionpoints.Where(p => p.cpid == cpid).ToList <departmentcollectionpoint>();
foreach (departmentcollectionpoint cp in cps)
{
dms.Add(CovertDBDepttoAPIDept(cp.department));
}
}
catch (NullReferenceException)
{
error = ConError.Status.NOTFOUND;
}
catch (Exception e)
{
error = e.Message;
}
return(dms);
}
public static List <CollectionPointModel> GetCollectionPointByReqid(int reqid, out string error)
{
LUSSISEntities entities = new LUSSISEntities();
error = "";
List <requisition> req = new List <requisition>();
List <CollectionPointModel> cpm = new List <CollectionPointModel>();
try
{
req = entities.requisitions.Where(p => p.reqid == reqid).ToList <requisition>();
foreach (requisition r in req)
{
cpm.Add(CovertDBCptoAPICp(r.collectionpoint));
}
}
catch (NullReferenceException)
{
error = ConError.Status.NOTFOUND;
}
catch (Exception e)
{
error = e.Message;
}
return(cpm);
}
public static CollectionPointModel GetCollectionPointByCpid(int cpid, out string error)
{
LUSSISEntities entities = new LUSSISEntities();
error = "";
collectionpoint cp = new collectionpoint();
CollectionPointModel cpm = new CollectionPointModel();
try
{
cp = entities.collectionpoints.Where(p => p.cpid == cpid).FirstOrDefault <collectionpoint>();
cpm = CovertDBCptoAPICp(cp);
}
catch (NullReferenceException)
{
error = ConError.Status.NOTFOUND;
}
catch (Exception e)
{
error = e.Message;
}
return(cpm);
}
public static List <SupplierModel> importsupplier(List <SupplierModel> spm, out string error)
{
LUSSISEntities entities = new LUSSISEntities();
error = "";
try
{
foreach (SupplierModel nsm in spm)
{
SupplierModel spm1 = GetSupplierBySupname(nsm.SupName, out string error1);
if (spm1.SupName == "")
{
CreateSupplier(nsm, out string error2);
spm1 = null;
}
else
{
UpdateSupplier(nsm, out string error3);
}
}
}
catch (Exception e)
{
error = e.Message;
}
List <SupplierModel> sm = GetSupplierByStatus(ConSupplier.Active.ACTIVE, out string error4);
return(sm);
}
public static DepartmentModel GetDepartmentByUserid(int userid, out string error)
{
LUSSISEntities entities = new LUSSISEntities();
error = "";
department dept = new department();
user u = new user();
DepartmentModel dm = new DepartmentModel();
try
{
// get the user first
u = entities.users.Where(p => p.userid == userid).FirstOrDefault <user>();
// get the department object from user model
dept = u.department;
// convert DB Model to API Model
dm = CovertDBDepttoAPIDept(dept);
}
catch (NullReferenceException)
{
error = ConError.Status.NOTFOUND;
}
catch (Exception e)
{
error = e.Message;
}
return(dm);
}
public static SupplierModel GetSupplierBySupname(String name, out string error)
{
LUSSISEntities entities = new LUSSISEntities();
error = "";
supplier sup = new supplier();
SupplierModel sm = new SupplierModel();
try
{
sup = entities.suppliers
.Where(x => x.supname == name)
.First();
sm = ConvertDBSupToAPISup(sup);
}
catch (NullReferenceException)
{
error = ConError.Status.NOTFOUND;
}
catch (Exception e)
{
error = e.Message;
}
return(sm);
}
public static List <InventoryTransactionModel> GetInventoryTransactionsByTransDateRange(DateTime startdate, DateTime enddate, out string error)
{
LUSSISEntities entities = new LUSSISEntities();
error = "";
List <inventorytransaction> invts = new List <inventorytransaction>();
List <InventoryTransactionModel> invtms = new List <InventoryTransactionModel>();
try
{
invts = entities.inventorytransactions.Where(p => p.datetime >= startdate && p.datetime <= enddate).ToList <inventorytransaction>();
foreach (inventorytransaction invt in invts)
{
invtms.Add(ConvertDBModeltoAPIModel(invt));
}
}
catch (NullReferenceException)
{
error = ConError.Status.NOTFOUND;
}
catch (Exception e)
{
error = e.Message;
}
return(invtms);
}
public static SupplierItemModel GetSupplierItemListByItemIdandSupid(int itemid, int supid, out string error)
{
LUSSISEntities entities = new LUSSISEntities();
error = "";
supplieritem supitems = new supplieritem();
SupplierItemModel supim = new SupplierItemModel();
try
{
supitems = entities.supplieritems
.Where(x => x.itemid == itemid && x.supid == supid).First();
supim = ConvertDBSupItemToAPISupItem(supitems);
}
catch (NullReferenceException)
{
error = ConError.Status.NOTFOUND;
}
catch (InvalidOperationException)
{
error = ConError.Status.BADREQUEST;
}
catch (Exception e)
{
error = e.Message;
}
return(supim);
}
public static InventoryTransactionModel CreateInventoryTransaction(InventoryTransactionModel invtm, out string error)
{
error = "";
LUSSISEntities entities = new LUSSISEntities();
inventorytransaction d = new inventorytransaction();
try
{
d.datetime = DateTime.Now;
d.invid = invtm.InvID;
d.itemid = invtm.ItemID;
d.trantype = invtm.TransType;
d.qty = invtm.Qty;
d.remark = invtm.Remark;
d = entities.inventorytransactions.Add(d);
entities.SaveChanges();
invtm = GetInventoryTransactionByTransID(d.tranid, out error);
}
catch (NullReferenceException)
{
error = ConError.Status.NOTFOUND;
}
catch (Exception e)
{
error = e.Message;
}
return(invtm);
}
// Get all items from by specific supplier
public static List <SupplierItemModel> GetItemsBySupplier(int supid, out string error)
{
LUSSISEntities entities = new LUSSISEntities();
error = "";
supplier sup = new supplier();
List <SupplierItemModel> sims = new List <SupplierItemModel>();
try
{
sup = entities.suppliers
.Where(x => x.supid == supid)
.First();
foreach (supplieritem supitem in sup.supplieritems)
{
sims.Add(ConvertDBSupItemToAPISupItem(supitem));
}
}
catch (NullReferenceException)
{
error = ConError.Status.NOTFOUND;
}
catch (Exception e)
{
error = e.Message;
}
return(sims);
}
public static List <InventoryTransactionModel> GetInventoryTransactionsByInvID(int invid, out string error)
{
LUSSISEntities entities = new LUSSISEntities();
error = "";
List <inventorytransaction> invts = new List <inventorytransaction>();
List <InventoryTransactionModel> invtms = new List <InventoryTransactionModel>();
try
{
invts = entities.inventorytransactions.Where(p => p.invid == invid).ToList <inventorytransaction>();
foreach (inventorytransaction invt in invts)
{
invtms.Add(ConvertDBModeltoAPIModel(invt));
}
}
catch (NullReferenceException)
{
error = ConError.Status.NOTFOUND;
}
catch (Exception e)
{
error = e.Message;
}
return(invtms);
}
//find Adjustment by raisedby id
public static List <AdjustmentModel> GetAdjustmentByRaisedById(int raisedby, out string error)
{
LUSSISEntities entities = new LUSSISEntities();
error = "";
List <adjustment> adj = new List <adjustment>();
List <AdjustmentModel> adjm = new List <AdjustmentModel>();
try
{
adj = entities.adjustments.Where(a => a.raisedby == raisedby).ToList <adjustment>();
foreach (adjustment ad in adj)
{
adjm.Add(ConvertDBtoAPIAdjust(ad));
}
}
catch (NullReferenceException)
{
error = ConError.Status.NOTFOUND;
}
catch (Exception e)
{
error = e.Message;
}
return(adjm);
}
public static List <SupplierModel> GetSupplierByStatus(int status, out string error)
{
LUSSISEntities entities = new LUSSISEntities();
error = "";
List <supplier> sups = new List <supplier>();
List <SupplierModel> sm = new List <SupplierModel>();
try
{
sups = entities.suppliers
.Where(x => x.active == status)
.ToList();
foreach (supplier s in sups)
{
sm.Add(ConvertDBSupToAPISup(s));
}
}
catch (NullReferenceException)
{
error = ConError.Status.NOTFOUND;
}
catch (Exception e)
{
error = e.Message;
}
return(sm);
}
public static InventoryModel UpdateInventory(InventoryModel invm, out string error)
{
error = "";
// declare and initialize new LUSSISEntities to perform update
LUSSISEntities entities = new LUSSISEntities();
inventory inv = new inventory();
try
{
// finding the inventory object using Inventory API model
inv = entities.inventories.Where(p => p.invid == invm.Invid).First <inventory>();
// transfering data from API model to DB Model
inv.itemid = invm.Itemid;
inv.stock = invm.Stock;
inv.reorderlevel = invm.ReorderLevel;
inv.reorderqty = invm.ReorderQty;
// saving the update
entities.SaveChanges();
// return the updated model
invm = CovertDBInventorytoAPIInventory(inv);
}
catch (NullReferenceException)
{
error = ConError.Status.NOTFOUND;
}
catch (Exception e)
{
error = e.Message;
}
return(invm);
}
public static SupplierModel CreateSupplier(SupplierModel sm, out string error)
{
LUSSISEntities entities = new LUSSISEntities();
error = "";
supplier sup = new supplier();
try
{
sup.supname = sm.SupName;
sup.supemail = sm.SupEmail;
sup.supphone = sm.SupPhone;
sup.contactname = sm.ContactName;
sup.gstregno = sm.GstRegNo;
sup.active = ConSupplier.Active.ACTIVE;
entities.suppliers.Add(sup);
entities.SaveChanges();
sm = ConvertDBSupToAPISup(sup);
}
catch (NullReferenceException)
{
error = ConError.Status.NOTFOUND;
}
catch (Exception e)
{
error = e.Message;
}
return(sm);
}
public static Boolean RemoveInventory(InventoryModel invm, out string error)
{
error = "";
LUSSISEntities entities = new LUSSISEntities();
inventory inv = new inventory();
try
{
if (entities.inventories.Where(p => p.itemid == invm.Itemid).Count() > 0)
{
inv = entities.inventories.Where(p => p.invid == invm.Itemid).First <inventory>();
entities.inventories.Remove(inv);
entities.SaveChanges();
}
}
catch (NullReferenceException)
{
error = ConError.Status.NOTFOUND;
return(false);
}
catch (Exception e)
{
error = e.Message;
return(false);
}
return(true);
}
public static SupplierModel ActivateSupplier(SupplierModel sm, out string error)
{
LUSSISEntities entities = new LUSSISEntities();
supplier sup = new supplier();
error = "";
try
{
sup = entities.suppliers
.Where(x => x.supid == sm.SupId)
.First();
sup.active = ConSupplier.Active.ACTIVE;
entities.SaveChanges();
sm = ConvertDBSupToAPISup(sup);
}
catch (NullReferenceException)
{
error = ConError.Status.NOTFOUND;
}
catch (Exception e)
{
error = e.Message;
}
return(sm);
}
public static NotificationModel UpdateNotiRead(int id, out string error)
{
error = "";
LUSSISEntities entities = new LUSSISEntities();
notification n = new notification();
NotificationModel nm = new NotificationModel();
try
{
n = entities.notifications.Where(x => x.notiid == id).FirstOrDefault();
n.isread = true;
entities.SaveChanges();
nm = GetNotiBynotiid(n.notiid, out error);
}
catch (NullReferenceException)
{
error = ConError.Status.NOTFOUND;
}
catch (Exception e)
{
error = e.Message;
}
return(nm);
}
public static List <CollectionPointModel> GetCollectionPointByLockerid(int lockerid, out string error)
{
LUSSISEntities entities = new LUSSISEntities();
error = "";
List <lockercollectionpoint> lcp = new List <lockercollectionpoint>();
List <CollectionPointModel> cpm = new List <CollectionPointModel>();
try
{
lcp = entities.lockercollectionpoints.Where(p => p.lockerid == lockerid).ToList <lockercollectionpoint>();
foreach (lockercollectionpoint l in lcp)
{
cpm.Add(CovertDBCptoAPICp(l.collectionpoint));
}
}
catch (NullReferenceException)
{
error = ConError.Status.NOTFOUND;
}
catch (Exception e)
{
error = e.Message;
}
return(cpm);
}
