public bool insertAllCategory(string itemNo, string category, string description, int reorderLevel, int reorderQty, string unitOfMeasurement, int balance)
{
try
{
using (TransactionScope ts = new TransactionScope())
{
var ca = from cate in ctx.Categories
where cate.CategoryName == category
select cate;
Category c = ca.First();
ADTeam4EF.Item item = new ADTeam4EF.Item();
item.ItemID = itemNo;
item.CategoryID = c.CategoryID;
item.Description = description;
item.ReorderLevel = reorderLevel;
item.ReorderQuantity = reorderQty;
item.UnitOfMeasurement = unitOfMeasurement;
item.Balance = balance;
item.SuggestedQuantity = reorderQty;
ctx.Items.Add(item);
ctx.SaveChanges();
ts.Complete();
return(true);
}
}
catch (Exception ex)
{
return(false);
throw ex;
}
}
public bool deleteItem(string itemid)
{
try
{
using (TransactionScope ts = new TransactionScope())
{
var i = from item in ctx.Items
where item.ItemID == itemid
select item;
ADTeam4EF.Item it = i.First();
if (it != null)
{
ctx.Items.Remove(it);
ctx.SaveChanges();
ts.Complete();
return(true);
}
else
{
return(false);
}
}
}
catch (Exception ex)
{
return(false);
throw ex;
}
}
public bool updateSuggestedQty(string itemid, DateTime todayDate)
{
try
{
var lowStock = from items in ctx.Items
join reqDetail in ctx.RequestDetails on items.ItemID equals reqDetail.RequestedItem
join req in ctx.Requests on reqDetail.RequestID equals req.RequestID
where reqDetail.RequestedItem == itemid && req.RequestDate <= todayDate
select items;
var count = lowStock.Count();
if (count > 20)
{
using (TransactionScope ts = new TransactionScope())
{
var item = from items in ctx.Items
where items.ItemID == itemid
select items;
ADTeam4EF.Item i = item.First();
i.SuggestedQuantity = i.ReorderQuantity * 2;
ctx.SaveChanges();
ts.Complete();
}
}
return(true);
}
catch
{
return(false);
}
}
public bool updateItem(string itemNo, string category, string description, int reorderLevel, int reorderQty, string unitOfMeasurement, int balance)
{
try
{
var cat = from c in ctx.Categories
where c.CategoryName == category
select c;
ADTeam4EF.Category cate = cat.First();
var item = from i in ctx.Items
where i.ItemID == itemNo
select i;
ADTeam4EF.Item it = item.First();
if (item != null)
{
using (TransactionScope ts = new TransactionScope())
{
it.Description = description;
it.ReorderLevel = reorderLevel;
it.ReorderQuantity = reorderQty;
it.UnitOfMeasurement = unitOfMeasurement;
it.Balance = balance;
it.CategoryID = cate.CategoryID;
ctx.SaveChanges();
ts.Complete();
return(true);
}
}
else
{
return(false);
}
}
catch (Exception ex)
{
return(false);
throw ex;
}
}
