private bool CheckScrimRollsForBatch(int lineID)
{
TPOEntities context = new TPOEntities();
var check = (from b in context.TPOBatches
join cs in context.TPOCurrentScrims
on b.ScrimRollID equals cs.Scrim1RollID
where cs.ProdLineID == lineID
select cs).Count() > 0;
if (!check)
{
check = (from b in context.TPOBatches
join cs in context.TPOCurrentScrims
on b.ScrimRollID equals cs.Scrim2RollID
where cs.ProdLineID == lineID
select cs).Count() > 0;
if (!check)
{
check = (from b in context.TPOBatches
join cs in context.TPOCurrentScrims
on b.ScrimRollID equals cs.FleeceRollID
where cs.ProdLineID == lineID
select cs).Count() > 0;
}
}
return(check);
}
private int GetCurrentScrimCountForThisLot(IProductEntryDto tpoCProductRollDto)
{
TPOEntities context = new TPOEntities();
var x = from b in context.TPOBatches
join cs in context.TPOCurrentScrims
on b.ScrimRollID equals cs.Scrim1RollID
select cs;
return(x.Count());
}
private int GetCurrentRawMaterialCountForThisLot(IProductEntryDto tpoCProductRollDto)
{
TPOEntities context = new TPOEntities();
var x = from b in context.TPOBatches
join cr in context.TPOCurrentRawMaterials
on new { l = b.LineID, rr = b.RawMaterialReceivedID.Value }
equals new { l = cr.LineID, rr = cr.RawMaterialReceivedID.Value }
select cr;
return(x.Count());
}
private bool CheckRawMaterialsForBatch(int lineID)
{
TPOEntities context = new TPOEntities();
int rawMats = (from b in context.TPOBatches
join cr in context.TPOCurrentRawMaterials
on new { l = b.LineID, rr = b.RawMaterialReceivedID.Value }
equals new { l = cr.LineID, rr = cr.RawMaterialReceivedID.Value }
where cr.LineID == lineID
select cr).Count();
return(rawMats == 0);
}
public GenericRepository(TPOEntities context)
{
this.context = context;
dbSet = context.Set <TEntity>();
}
/// <summary>
///
/// </summary>
public UnitOfWork()
{
_dbContext = new TPOEntities();
_repositories = new Dictionary <Type, object>();
AutoMapperConfig.Initialize();
}
