private void fillBalesProductionDataTable(SqlConnection sqlConn, DataSet dataSet, ReportParameters reportParameters,
BaleStatus baleStatus = BaleStatus.NONE)
{
var query = String.Empty;
var efQuery = dbContext.Bales.Include(a => a.BaleInventoryView)
.Where(a => a.DT.Date >= reportParameters.DTFrom.Date && a.DT.Date <= reportParameters.DTTo.Date);
switch (baleStatus)
{
case BaleStatus.DELIVERED:
query = efQuery.Where(a => a.BaleInventoryView.InStock == false && a.IsReject == false).ToQueryString();
break;
case BaleStatus.INSTOCK:
query = efQuery.Where(a => a.BaleInventoryView.InStock == true).ToQueryString();
break;
case BaleStatus.REJECT:
query = efQuery.Where(a => a.IsReject == true).ToQueryString();
break;
default:
query = efQuery.ToQueryString();
break;
}
;
var sa = new SqlDataAdapter(query.ToString(), sqlConn);
sa.Fill(dataSet, nameof(dbContext.Bales));
sa.Dispose();
query = null;
}
private void fillBalesActualInventoryDataTable(SqlConnection sqlConn, DataSet dataSet, ReportParameters reportParameters,
BaleStatus baleStatus = BaleStatus.NONE)
{
var efQuery = dbContext.Bales.Include(a => a.BaleInventoryView)
.Where(a => a.DT.Date <= reportParameters.DTFrom &&
((a.BaleInventoryView.InStock == true && a.IsReject == false) ||
(a.BaleInventoryView.DTDelivered.Value.Date > reportParameters.DTFrom))).ToQueryString();
var sa = new SqlDataAdapter(efQuery.ToString(), sqlConn);
sa.Fill(dataSet, nameof(dbContext.Bales));
sa.Dispose();
efQuery = null;
}
