public bool createTransaction(Disbursement_M disbl, item newitem,int userid)
{
bool ans = false;
//Save In transaction
transaction t = new transaction();
t.TransDate = DateTime.Now;
t.TransItemID = disbl.ItemID;
t.TransItemQuant = disbl.RequiredQuant;
t.TransItemBalance = newitem.ItemQuant ?? default (int);
t.TransReason = "Retrived For Department " + disbl.DepID;
t.TransactionType = "out";
t.TranUserID = userid;
t.TransCode = "RTR";
try
{
se.transactions.Add(t);
se.SaveChanges();
ans = true;
}
catch
{
ans = false;
}
return ans;
}
public bool UpdateItem(String itemID, String quantity, String userID)
{
try
{
int id = Convert.ToInt32(itemID);
int updateqty = Convert.ToInt32(quantity);
var query = from p in entities.items
where p.ItemID == id
select p;
item _item = query.SingleOrDefault();
//Get original quantity
int originalqty = _item.ItemQuant ?? default(int);
//Update the quantity
_item.ItemQuant = updateqty;
entities.SaveChanges();
//Save In Transaction if original qty < update quantity transtype is in
if (originalqty < updateqty)
{
transaction t = new transaction();
// t.TransID = 1;
t.TransCode = "ADJ";
t.TransactionType = "in";
t.TransDate = DateTime.Today.Date;
t.TransItemQuant =updateqty - originalqty;
t.TransItemBalance = updateqty;
t.TransItemID = _item.ItemID;
t.TransReason = "Monthly Adjustment run";
t.TranUserID = Convert.ToInt32(userID);
entities.transactions.Add(t);
entities.SaveChanges();
}
else
{
transaction t = new transaction();
//t.TransID = 1;
t.TransCode = "ADJ";
t.TransactionType = "out";
t.TransDate = DateTime.Today.Date;
t.TransItemQuant = originalqty-updateqty;
t.TransItemBalance = updateqty;
t.TransItemID = _item.ItemID;
t.TransReason = "Monthly Adjustment run";
t.TranUserID = Convert.ToInt32(userID);
entities.transactions.Add(t);
}
entities.SaveChanges();
}
catch (Exception ex)
{
String aa = ex.ToString();
}
return true;
}
//By Seint San Thandar bo
public bool UpdatePurchaseOrder(String poID, String approveEmpID)
{
try
{
int id = Convert.ToInt32(poID);
var query = from p in se.purchaseorders
where p.POID == id
select p;
purchaseorder po = query.SingleOrDefault();
// po.POApprovedByEmpID = Convert.ToInt32(approveEmpID);
po.PORecieveDate = DateTime.Today.Date;
//Save In Transaction
var podetail = from pd in se.purchaseorderdetails
where pd.POID == id
select pd;
List<purchaseorderdetail> details = podetail.ToList<purchaseorderdetail>();
foreach (purchaseorderdetail d in details)
{
transaction t = new transaction();
t.TransCode = "PO";
t.TransactionType = "in";
t.TransDate = DateTime.Today.Date;
t.TransItemBalance = d.POItemQuant;
t.TransItemID = d.POItemID;
t.TransReason = "PO Received";
t.TranUserID = Convert.ToInt32(approveEmpID);
se.transactions.Add(t);
//Update Item balance
var q = from i in se.items
where i.ItemID == d.POItemID
select i;
item iTem = q.SingleOrDefault();
iTem.ItemQuant = iTem.ItemQuant + d.POItemQuant;
se.SaveChanges();
}
return true;
}
catch (Exception ex)
{
return false;
}
}
public bool UpdatePurchaseOrderDetailStatusApprove(int poid)
{
purchaseorder p = new purchaseorder();
List<purchaseorderdetail> pd = new List<purchaseorderdetail>();
item itm = new item();
try
{
p = cntx.purchaseorders.Find(poid);
p.PORecieveDate = DateTime.Now;
pd = (from f in cntx.purchaseorderdetails where f.POID==poid select f).ToList();
foreach (purchaseorderdetail dd in pd)
{
int poQty = dd.POItemQuant;
dd.POStatus = "approved";
//increase item quantity
itm = (from it in cntx.items where it.ItemID == dd.POItemID select it).FirstOrDefault();
int itmQty = int.Parse(itm.ItemQuant.ToString());
int total = poQty + itmQty;
itm.ItemQuant = total;
//increase item quantity
//Include Tranaction Table
transaction tnew = new transaction();
tnew.TransItemID = itm.ItemID;
tnew.TransDate = DateTime.Now;
tnew.TransItemBalance = total;
tnew.TransItemQuant = poQty;
tnew.TransReason = "Recieved Purchase Order from Supplier";
tnew.TransactionType = "in";
tnew.TranUserID = Convert.ToInt32(System.Web.HttpContext.Current.Session["userid"]);
tnew.TransCode = "Purchase";
cntx.transactions.Add(tnew);
}
cntx.SaveChanges();
return true;
}
catch (Exception ex)
{
throw ex;
}
}
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;
}
