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 saveDisblist(Disbursement_M disbl,int userid)
{
bool ans = false;
List<requisitiondetail> rdlist = new List<requisitiondetail>();
//requisitiondetail rd =new requisitiondetail();
disbursementdetail disbdet = new disbursementdetail();
disbursement disb = new disbursement();
checkdate = DateTime.Today;
string status = "Ready";
//checking whether the disb-list already exists
var q = from d in se.disbursements
where d.DisbDepID == disbl.DepID &&
d.DisbStatus == status
select d;
disb = q.FirstOrDefault();
//if disb-list already exits
if (disb != null)
{
item newitem = new item();
newitem = se.items.Find(disbl.ItemID);
disbursementdetail ddetail = new disbursementdetail();
var a = from dd in se.disbursementdetails
where dd.DisbID == disb.DisbID &&
dd.DisbItemID == disbl.ItemID
select dd;
ddetail = a.FirstOrDefault();
if (ddetail != null)
{
//if (disbl.RequiredQuant >= ddetail.DisbItemQuantReq)
//{
// ddetail.DisbItemQuantReq = ddetail.DisbItemQuantReq + disbl.RequiredQuant;
// ddetail.DisbItemQuantDelivered = ddetail.DisbItemQuantDelivered + disbl.QuantinHand;
//}
//else
//{
// ddetail.DisbItemQuantDelivered = ddetail.DisbItemQuantDelivered + disbl.QuantinHand;
//}
if (ddetail.DisbItemQuantReq == ddetail.DisbItemQuantDelivered)
{
ddetail.DisbItemQuantReq = ddetail.DisbItemQuantReq + disbl.RequiredQuant;
ddetail.DisbItemQuantDelivered = ddetail.DisbItemQuantDelivered + disbl.QuantinHand;
}
else if(ddetail.DisbItemQuantReq>ddetail.DisbItemQuantDelivered)
{
if (ddetail.DisbItemQuantReq > (ddetail.DisbItemQuantDelivered + disbl.QuantinHand))
{
int toadd = (disbl.RequiredQuant - (ddetail.DisbItemQuantReq - ddetail.DisbItemQuantDelivered)) ?? default(int);
ddetail.DisbItemQuantReq = ddetail.DisbItemQuantReq + toadd;
ddetail.DisbItemQuantDelivered = ddetail.DisbItemQuantDelivered + disbl.QuantinHand;
}
else
{
ddetail.DisbItemQuantDelivered = ddetail.DisbItemQuantDelivered + disbl.QuantinHand;
}
}
try
{
se.SaveChanges();
newitem.ItemQuant = newitem.ItemQuant -disbl.QuantinHand;
createTransaction(disbl, newitem,userid);
CheckForOutStanding(disbl);
ans = true;
}
catch (Exception ex)
{
ans = false;
}
//check for outstanding request
}
else
{
disbursementdetail newdd = new disbursementdetail();
newdd.DisbID = disb.DisbID;
newdd.DisbItemID = disbl.ItemID;
newdd.DisbItemQuantDelivered = disbl.QuantinHand;
newdd.DisbItemQuantReq = disbl.RequiredQuant;
try
{
se.disbursementdetails.Add(newdd);
se.SaveChanges();
newitem.ItemQuant = newitem.ItemQuant - disbl.QuantinHand;
//saving transaction
createTransaction(disbl, newitem,userid);
CheckForOutStanding(disbl);
ans = true;
}
catch (Exception ex)
{
ans = false;
}
}
return ans;
}
else
{
// creating a new disbursement
ans = createDisbursement(disbl,userid);
}
return ans;
}
public bool createDisbursement(Disbursement_M disbl,int userid)
{
bool ans = false;
List<requisitiondetail> rdlist = new List<requisitiondetail>();
//requisitiondetail rd =new requisitiondetail();
disbursementdetail disbdet = new disbursementdetail();
disbursement disb = new disbursement();
item newitem = new item();
//
newitem = se.items.Find(disbl.ItemID);
//creating a new disbursement
disbursement disb1 = new disbursement();
disb1.DisbDepID = disbl.DepID;
disb1.DisbStatus = "Ready";
disb1.DisbReceiveDate = null;
disb1.DisbCreateDate = DateTime.Today;
se.disbursements.Add(disb1);
se.SaveChanges();
//creating a Disbursement details
disbdet.DisbID = disb1.DisbID;
disbdet.DisbItemID = disbl.ItemID;
disbdet.DisbItemQuantDelivered = disbl.QuantinHand;
disbdet.DisbItemQuantReq = disbl.RequiredQuant;
try
{
se.disbursementdetails.Add(disbdet);
se.SaveChanges();
newitem.ItemQuant = newitem.ItemQuant - disbl.QuantinHand;
se.SaveChanges();
createTransaction(disbl, newitem, userid);
ans = true;
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
}
}
}
if (ans == true)
{
CheckForOutStanding(disbl);
ans = true;
}
return ans;
}
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 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 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 item GetItemCatID(int itemid)
{
item item = new item();
item = se.items.Where(i => i.ItemID.Equals(itemid)).FirstOrDefault<item>();
return item;
}
