public List<ViewAllStocksViewModel> Get(int MaterialTypeId, int UserId)
{
List<ViewAllStocksViewModel> result;
if (MaterialTypeId == 2)
{
List<ViewAllStocksViewModel> list = new List<ViewAllStocksViewModel>();
List<Stock> list2 = (
from a in this.db.Stocks
where a.MaterialTypeId == (int?)MaterialTypeId && a.UserId == (int?)UserId
select a).ToList<Stock>();
if (list2 != null)
{
using (List<Stock>.Enumerator enumerator = list2.GetEnumerator())
{
while (enumerator.MoveNext())
{
Stock item = enumerator.Current;
ViewAllStocksViewModel viewAllStocksViewModel = new ViewAllStocksViewModel();
viewAllStocksViewModel.Stock = item.Nos_Of_Piece + " piece";
viewAllStocksViewModel.LastAddedStock = item.LastAddedStock + " piece";
viewAllStocksViewModel.UpdatedDateTime = item.UpdatedDatetime.Value.ToLongDateString();
AllMaterial allMaterial = (
from a in this.db.AllMaterials
where (int?)a.MaterialId == item.MaterialId
select a).FirstOrDefault<AllMaterial>();
viewAllStocksViewModel.MaterialCode = allMaterial.MaterialCode;
viewAllStocksViewModel.MaterialImage = allMaterial.MaterialImagePath;
list.Add(viewAllStocksViewModel);
}
}
result = list;
}
else
{
result = null;
}
}
else
{
List<ViewAllStocksViewModel> list = new List<ViewAllStocksViewModel>();
List<Stock> list2 = (
from a in this.db.Stocks
where a.MaterialTypeId == (int?)MaterialTypeId && a.UserId == (int?)UserId
select a).ToList<Stock>();
if (list2 != null)
{
using (List<Stock>.Enumerator enumerator = list2.GetEnumerator())
{
while (enumerator.MoveNext())
{
Stock item = enumerator.Current;
ViewAllStocksViewModel viewAllStocksViewModel = new ViewAllStocksViewModel();
ViewAllStocksViewModel arg_3E2_0 = viewAllStocksViewModel;
float? tot_Weight_in_Gram_ = item.Tot_Weight_in_Gram_;
arg_3E2_0.Stock = (tot_Weight_in_Gram_.HasValue ? new float?(tot_Weight_in_Gram_.GetValueOrDefault()) : null) + " Kilogram";
viewAllStocksViewModel.LastAddedStock = float.Parse(item.LastAddedStock) + " Kilogram";
viewAllStocksViewModel.UpdatedDateTime = item.UpdatedDatetime.Value.ToLongDateString();
AllMaterial allMaterial = (
from a in this.db.AllMaterials
where (int?)a.MaterialId == item.MaterialId
select a).FirstOrDefault<AllMaterial>();
viewAllStocksViewModel.MaterialCode = allMaterial.MaterialCode;
viewAllStocksViewModel.MaterialImage = allMaterial.MaterialImagePath;
list.Add(viewAllStocksViewModel);
}
}
result = list;
}
else
{
result = null;
}
}
return result;
}
public List<ViewAllStocksViewModel> Get(int MaterialTypeId, int SubMaterialId, string spd, int UserId)
{
List<ViewAllStocksViewModel> list = new List<ViewAllStocksViewModel>();
List<ViewAllStocksViewModel> result;
if (MaterialTypeId == 3)
{
List<Stock> list2 = (
from a in this.db.Stocks
where a.MaterialTypeId == (int?)MaterialTypeId && a.UserId == (int?)UserId && a.Sub_KasabId == SubMaterialId
select a).ToList<Stock>();
if (list2 != null)
{
using (List<Stock>.Enumerator enumerator = list2.GetEnumerator())
{
while (enumerator.MoveNext())
{
Stock item = enumerator.Current;
ViewAllStocksViewModel viewAllStocksViewModel = new ViewAllStocksViewModel();
viewAllStocksViewModel.Stock = item.Nos_Of_Piece + " piece";
viewAllStocksViewModel.LastAddedStock = item.LastAddedStock + " piece";
viewAllStocksViewModel.UpdatedDateTime = item.UpdatedDatetime.Value.ToLongDateString();
AllMaterial allMaterial = (
from a in this.db.AllMaterials
where (int?)a.MaterialId == item.MaterialId
select a).FirstOrDefault<AllMaterial>();
viewAllStocksViewModel.MaterialCode = allMaterial.MaterialCode;
viewAllStocksViewModel.MaterialImage = allMaterial.MaterialImagePath;
list.Add(viewAllStocksViewModel);
}
}
result = list;
}
else
{
result = null;
}
}
else
{
List<Stock> list2 = (
from a in this.db.Stocks
where a.MaterialTypeId == (int?)MaterialTypeId && a.SubMaterialTypeId == (int?)SubMaterialId && a.UserId == (int?)UserId
select a).ToList<Stock>();
if (list2 != null)
{
using (List<Stock>.Enumerator enumerator = list2.GetEnumerator())
{
while (enumerator.MoveNext())
{
Stock item = enumerator.Current;
ViewAllStocksViewModel viewAllStocksViewModel = new ViewAllStocksViewModel();
viewAllStocksViewModel.Stock = item.Nos_Of_Piece + " piece";
viewAllStocksViewModel.LastAddedStock = item.LastAddedStock + " piece";
viewAllStocksViewModel.UpdatedDateTime = item.UpdatedDatetime.Value.ToLongDateString();
AllMaterial allMaterial = (
from a in this.db.AllMaterials
where (int?)a.MaterialId == item.MaterialId
select a).FirstOrDefault<AllMaterial>();
viewAllStocksViewModel.MaterialCode = allMaterial.MaterialCode;
viewAllStocksViewModel.MaterialImage = allMaterial.MaterialImagePath;
list.Add(viewAllStocksViewModel);
}
}
result = list;
}
else
{
result = null;
}
}
return result;
}
