public bool addItems(int itemCatID, string itemdesp, int quant, int itemReO, int itemReOQ, string uom, string BNom, int Supplier1ID, int Supplier2ID, int Supplier3ID, int SPrice1, int SPrice2, int SPrice3)
{
itemsupplier its1 = new itemsupplier();
itemsupplier its2 = new itemsupplier();
itemsupplier its3 = new itemsupplier();
supplier s1 = new supplier();
supplier s2 = new supplier();
supplier s3 = new supplier();
s1 = se.suppliers.Find(Supplier1ID);
s2 = se.suppliers.Find(Supplier2ID);
s3 = se.suppliers.Find(Supplier3ID);
bin newbin = new bin();
var q = from b in se.bins
where b.BinNumber == BNom
select b;
newbin = q.FirstOrDefault();
bool ans = false;
item Item = new item();
Item.ItemCatID = itemCatID;
Item.ItemDescription = itemdesp;
Item.ItemQuant = quant;
Item.ItemReOrderLvl = itemReO;
Item.ItemReOrderQuant = itemReOQ;
Item.ItemUOM = uom;
Item.bin = newbin;
try
{
se.items.Add(Item);
se.SaveChanges();
}
catch (Exception)
{
//dos something
}
//adding for Supplier1
its1.item = Item;
its1.Price = SPrice1;
its1.supplier = s1;
its1.SupplierRank = 1;
se.itemsuppliers.Add(its1);
//adding for Supplier2
its2.item = Item;
its2.Price = SPrice2;
its2.supplier = s2;
its2.SupplierRank = 2;
se.itemsuppliers.Add(its2);
//adding for Supplier3
its3.item = Item;
its3.Price = SPrice3;
its3.supplier = s3;
its3.SupplierRank = 3;
se.itemsuppliers.Add(its3);
try
{
se.SaveChanges();
ans = true;
}
catch (Exception ex)
{
ans = false;
}
//Adding to Transsaction Tables
transaction it = new transaction();
it.TransactionType = "in";
it.TransCode = "NEWITEM"; //yet to decide
it.TransDate = DateTime.Today;
it.TransItemBalance = Item.ItemQuant ?? default(int);
it.TransItemQuant = Item.ItemQuant ?? default(int);
it.TransReason = "Added new Item: " + Item.ItemDescription;
it.TranUserID = Convert.ToInt32(System.Web.HttpContext.Current.Session["userid"]);
it.TransItemID = Item.ItemID;
se.transactions.Add(it);
se.SaveChanges();
return ans;
}
public bool UpdateInventoryList(int itemID, string itemdesp, int itemReO, int itemReOQ, string uom, string BNo)
{
// se = new stationeryEntities();
bool ans = false;
bool test;
bin bin = new bin();
bin replacebin = new bin();
item it = new item();
//it.ItemDescription = itemdesp;
//it.ItemQuant = quant;
//it.ItemReOrderLvl = itemReO;
//it.ItemReOrderQuant = itemReOQ;
//it.ItemUOM = uom;
//it.bin = bin;
//category ca = Getcategory(cname);
//ca.CategoryName = cname;
//var p = from upitem in se.items
// join upca in se.categories on upitem.ItemCatID equals upca.CategoryID
// join upBin in se.bins on it.ItemBinID equals upBin.BinID
// // where it.ItemDescription==itemdesp || it.ItemReOrderLvl==itemReO ||it.ItemReOrderQuant==itemReOQ ||it.ItemUOM==uom ||bin.BinNumber==BNo
// where it.ItemID==itemID
// select new { upitem.ItemDescription, upitem.ItemReOrderLvl, upitem.ItemReOrderQuant, upitem.ItemUOM, upBin.BinNumber };
var q = from upitem in se.items
where upitem.ItemID == itemID
select upitem;
it = q.FirstOrDefault();
bin = GetBin(it.ItemBinID);
test = checknewbin(BNo);
if (test == true)
{
if (bin.BinNumber != BNo)
{
var m = from b in se.bins
where b.BinNumber == BNo
select b;
try
{
replacebin = m.First();
it.bin = replacebin;
}
catch (Exception ex)
{
return ans;
}
}
}
it.ItemDescription = itemdesp;
it.ItemReOrderLvl = itemReO;
it.ItemReOrderQuant = itemReOQ;
it.ItemUOM = uom;
try
{
se.SaveChanges();
ans = true;
}
catch (Exception ex)
{
ans = false;
}
return ans;
}
public bin GetBin(int ItemBinbID)
{
bin bin = new bin();
var q = from b in se.bins
where b.BinID == ItemBinbID
select b;
bin = q.First();
return bin;
}
