public static decimal GetItemQuantityforSale(int itemId)
{
decimal qty = 0;
using (AprosysAccountingEntities db = new AprosysAccountingEntities())
{
var obj = db.GetStockList(itemId).FirstOrDefault();
if (obj != null)
{
qty = obj.QTY ?? 0;
}
}
return(qty);
}
public static IList <BO_Inventory> LoadInventory(JQueryDataTableParamModel Param)
{
List <BO_Inventory> lst_inventory = new List <BO_Inventory>();
using (AprosysAccountingEntities db_aa = new AprosysAccountingEntities())
{
BO_Inventory obj;
var lst = db_aa.GetStockList(0).ToList();
foreach (var item in lst.ToList())
{
obj = new BO_Inventory();
obj.itemId = item.ItemId ?? 0;
obj.itemCode = item.ItemCode;
obj.itemName = item.Name;
obj.itemquantity = item.QTY ?? 0;
lst_inventory.Add(obj);
}
//if (Param.SearchType != 0)
//{
// if (Param.SearchType == 1 && Param.SearchValue != null && Param.SearchValue != "")// && Param.SearchValue != null && Param.SearchValue != " ")
// {
// List = List.Where(x => x.name.ToLower().Contains(Param.SearchValue.Trim().ToLower())).ToList();
// }
// else if (Param.SearchType == 2)// && Param.SearchValue != null && Param.SearchValue != " ")
// {
// List = List.Where(x => x.itemCode.ToLower().Contains(Param.SearchValue.Trim().ToLower())).ToList();
// }
//}
//List<BO_Inventory> ListtoReturn = new List<BO_Inventory>();
//ListtoReturn = lst;
return(lst_inventory);
}
}
public static IList <BO_Item> LoadItems(JQueryDataTableParamModel Param)
{
using (AprosysAccountingEntities db_aa = new AprosysAccountingEntities())
{
List <BO_Item> List = (from _item in db_aa.Items
//join og in db_aa.OilGrades on _item.OilGradeId equals og.Id
where _item.IsActive == true
orderby _item.Id descending
select new BO_Item
{
id = _item.Id,
name = _item.Name ?? "",
itemCode = _item.ItemCode ?? "",
unit = _item.Unit ?? "",
description = _item.Description ?? "",
purchasePrice = _item.PurchasePrice ?? 0,
sellPrice = _item.SellPrice ?? 0,
taxPercent = _item.TaxPercent ?? 0,
minQuantity = _item.MinQty ?? 0,
//oilGrade = og.OilGade,
oilGradeId = _item.OilGradeId ?? 0,
quantityInCarton = _item.QuantityInCarton ?? 0,
packingInLitre = _item.PackingInLitre ?? 0
}).OrderByDescending(x => x.id).ToList();
IDictionary <int, string> oilGradesDict = db_aa.OilGrades.Select(z => new { z.Id, z.OilGade }).ToDictionary(z => Convert.ToInt32(z.Id), q => q.OilGade);
var itemStock = db_aa.GetStockList(0).ToList();
foreach (var item in List)
{
var stock = itemStock.Where(x => x.ItemId == item.id).FirstOrDefault();
item.stock = stock == null ? 0 : stock.QTY;
if (item.oilGradeId > 0)
{
item.oilGrade = oilGradesDict[item.oilGradeId];
}
// Stock in Amount by Fifo based
decimal?amount = 0;
var itemPurchased = db_aa.Acc_GL.Where(x => x.ItemId == item.id && (x.TranTypeId == 1 || x.TranTypeId == 7) && x.IsActive == true).ToList();
foreach (var objpurchase in itemPurchased)
{
amount = amount + (objpurchase.QuantityBalance * objpurchase.UnitPrice);
}
item.stockInAmount = amount;
}
if (Param.SearchType != 0)
{
if (Param.SearchType == 1 && Param.SearchValue != null && Param.SearchValue != "")// && Param.SearchValue != null && Param.SearchValue != " ")
{
List = List.Where(x => x.name.ToLower().Contains(Param.SearchValue.Trim().ToLower())).ToList();
}
else if (Param.SearchType == 2)// && Param.SearchValue != null && Param.SearchValue != " ")
{
List = List.Where(x => x.itemCode.ToLower().Contains(Param.SearchValue.Trim().ToLower())).ToList();
}
}
List <BO_Item> ListtoReturn = new List <BO_Item>();
ListtoReturn = List;
return(ListtoReturn);
}
}
