// 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 ItemModel GetItemBySupid(int supid, out string error)
{
LUSSISEntities entities = new LUSSISEntities();
error = "";
item item = new item();
supplieritem supdet = new supplieritem();
ItemModel im = new ItemModel();
try
{
supdet = entities.supplieritems.Where(p => p.supid == supid).FirstOrDefault <supplieritem>();
item = supdet.item;
im = CovertDBItemtoAPIItem(item);
}
catch (NullReferenceException)
{
error = ConError.Status.NOTFOUND;
}
catch (Exception e)
{
error = e.Message;
}
return(im);
}
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);
}
// Convert From Auto Generated DB Model to APIModel
private static SupplierItemModel ConvertDBSupItemToAPISupItem(supplieritem supitem)
{
return(new SupplierItemModel(
supitem.supid,
supitem.supplier.supname,
supitem.itemid,
supitem.item.description,
supitem.price,
supitem.item.uom,
supitem.item.category.name
));
}
// Update item by specific supplier
public static SupplierItemModel UpdateSupplierItem
(SupplierItemModel sim, out string error)
{
LUSSISEntities entities = new LUSSISEntities();
error = "";
try
{
supplieritem supitem = entities.supplieritems
.Where(x => x.supid == sim.SupId &&
x.itemid == sim.ItemId).First();
supitem.price = sim.Price;
entities.SaveChanges();
}
catch (Exception ex)
{
error = ex.Message;
}
return(sim);
}
// Add item by specific supplier
public static SupplierItemModel AddItemOfSupplier
(SupplierItemModel sim, out string error)
{
LUSSISEntities entities = new LUSSISEntities();
error = "";
supplieritem supitem = new supplieritem();
try
{
supitem.supid = sim.SupId;
supitem.itemid = sim.ItemId;
supitem.price = sim.Price;
entities.supplieritems.Add(supitem);
entities.SaveChanges();
}
catch (Exception ex) {
error = ex.Message;
}
return(sim);
}
public static List <SupplierItemModel> ImportfromItemlistExcel(List <ImportSupplierItem> csp, out string error)
{
LUSSISEntities entities = new LUSSISEntities();
List <SupplierItemModel> createdsupitemlist = new List <SupplierItemModel>();
error = "";
try
{
foreach (ImportSupplierItem sm in csp)
{
SupplierModel spm = SupplierRepo.GetSupplierBySupname(sm.SupName, out string error1);
if (spm.SupName != "")
{
ItemModel im1 = ItemRepo.GetItemByItemDescription(sm.Description, out string error3);
if (im1.Description != "")
{
SupplierItemModel sim = GetSupplierItemListByItemIdandSupid(im1.Itemid, spm.SupId, out string error5);
if (sim.SupId != 0)
{
supplieritem supitem = entities.supplieritems
.Where(x => x.supid == spm.SupId &&
x.itemid == sim.ItemId).First();
supitem.price = sm.Price;
entities.SaveChanges();
createdsupitemlist.Add(GetSupplierItemListByItemIdandSupid(im1.Itemid, sim.SupId, out string error7));
}
else
{
supplieritem supitem = new supplieritem();
supitem.supid = spm.SupId;
supitem.itemid = im1.Itemid;
supitem.price = sm.Price;
entities.supplieritems.Add(supitem);
entities.SaveChanges();
createdsupitemlist.Add(GetSupplierItemListByItemIdandSupid(im1.Itemid, spm.SupId, out string error8));
}
}
else
{
item item = new item();
item.catid = 21;
item.description = sm.Description;
item.uom = sm.Uom;
item = entities.items.Add(item);
entities.SaveChanges();
ItemModel im = ItemRepo.GetItemByItemid(item.itemid, out error);
inventory ivm = new inventory();
ivm.itemid = im.Itemid;
ivm.stock = 0;
ivm.reorderqty = 0;
ivm.reorderlevel = 0;
ivm = entities.inventories.Add(ivm);
entities.SaveChanges();
supplieritem supitem = new supplieritem();
supitem.supid = spm.SupId;
supitem.itemid = im.Itemid;
supitem.price = sm.Price;
entities.supplieritems.Add(supitem);
entities.SaveChanges();
createdsupitemlist.Add(GetSupplierItemListByItemIdandSupid(im.Itemid, spm.SupId, out string error5));
}
}
}
}
catch (Exception ex) {
error = ex.Message;
}
return(createdsupitemlist);
}
