private List <StackBLL> MergeWithCommodityGrade(List <StackBLL> list)
{
List <StackBLL> mergedListComplete = new List <StackBLL>();
List <CommodityGradeBLL> CommodityGradeList = new List <CommodityGradeBLL>();
CommodityGradeList = CommodityGradeBLL.GetAllCommodityDetail();
List <ShedBLL> listShed = new List <ShedBLL>();
listShed = ShedBLL.GetAllShed();
List <WarehouseBLL> listWarehouse = new List <WarehouseBLL>();
listWarehouse = WarehouseBLL.GetAllActiveWarehouse();
if (CommodityGradeList == null)
{
throw new Exception("Can not get Commodity Grade list.");
}
if (listShed == null)
{
throw new Exception("Can not get Shed list.");
}
if (listWarehouse == null)
{
throw new Exception("Can not get Warehouse list.");
}
var q = from stack in list
join CommGrade in CommodityGradeList on stack.CommodityGradeid equals CommGrade.CommodityGradeId
join Shed in listShed on stack.ShedId equals Shed.Id
join warehouse in listWarehouse on Shed.WarehouseId equals warehouse.WarehouseId
select new { stack.Id, stack.ShedId, stack.StackNumber, stack.Status, stack.DateStarted, stack.CommodityGradeid, Shed.ShedNumber, warehouse.WarehouseName, CommGrade.GradeName };
foreach (var i in q)
{
StackBLL obj = new StackBLL();
obj.Id = i.Id;
obj.ShedId = i.ShedId;
obj.ShedName = i.ShedNumber;
obj.CommodityGradeName = i.GradeName;
obj.StackNumber = i.StackNumber;
obj.Status = i.Status;
obj.DateStarted = DateTime.Parse(i.DateStarted.ToShortDateString());
obj.WarehouseName = i.WarehouseName;
mergedListComplete.Add(obj);
}
return(mergedListComplete);
}
public List <StackBLL> GetActiveStackbyShedId(Guid shedId)
{
List <StackBLL> list = new List <StackBLL>();
StackBLL obj = new StackBLL();
try
{
List <StackBLL> dalList = StackDAL.GetActiveStackByShed(shedId);
if (dalList != null)
{
list.AddRange(dalList);
}
}
catch (Exception ex)
{
throw new Exception("Unable to get Stack", ex);
}
return(list);
}
public List <StackBLL> GetActiveStackbyShedId(Guid shedId, Guid CommodityGrade,
int productionYear)
{
List <StackBLL> list = new List <StackBLL>();
StackBLL obj = new StackBLL();
try
{
List <StackBLL> dalList = StackDAL.GetActiveStackByShed(shedId);
if (dalList != null)
{
list = (from s in dalList where s.CommodityGradeid == CommodityGrade && s.ProductionYear == productionYear select s).ToList();
//list.AddRange(dalList);
}
}
catch (Exception ex)
{
throw new Exception("Unable to get Stack", ex);
}
return(list);
}
