private void bwReport_DoWork(object sender, DoWorkEventArgs e)
{
outsoleRawMaterialList = OutsoleRawMaterialController.Select();
outsoleMaterialList = OutsoleMaterialController.SelectByOutsoleRawMaterial();
sizeRunList = SizeRunController.SelectByOutsoleRawMaterial();
outsoleSupplierList = OutsoleSuppliersController.Select();
ordersList = OrdersController.SelectByOutsoleRawMaterial();
DataTable dt = new OutsoleDeliveryDataSet().Tables["OutsoleDeliveryTable"];
List <String> productNoList = outsoleRawMaterialList.Select(r => r.ProductNo).Distinct().ToList();
foreach (string productNo in productNoList)
{
OrdersModel order = ordersList.Where(o => o.ProductNo == productNo).FirstOrDefault();
List <OutsoleRawMaterialModel> outsoleRawMaterialOfProductNoList = outsoleRawMaterialList.Where(o => o.ProductNo == productNo).ToList();
List <SizeRunModel> sizeRunOfProductNoList = sizeRunList.Where(s => s.ProductNo == productNo).ToList();
List <OutsoleMaterialModel> outsoleMaterialOfProductNoList = outsoleMaterialList.Where(o => o.ProductNo == productNo).ToList();
foreach (OutsoleRawMaterialModel outsoleRawMaterial in outsoleRawMaterialOfProductNoList)
{
DateTime etd = outsoleRawMaterial.ETD.Date;
bool isFull = OutsoleRawMaterialController.IsFull(sizeRunOfProductNoList, new List <OutsoleRawMaterialModel>()
{
outsoleRawMaterial,
}, outsoleMaterialOfProductNoList);
if (etd != new DateTime(2000, 1, 1) && etd == dateSearch.Date && isFull == false)
{
DataRow dr = dt.NewRow();
dr["ProductNo"] = productNo;
if (order != null)
{
dr["ArticleNo"] = order.ArticleNo;
dr["OutsoleCode"] = order.OutsoleCode;
dr["Quantity"] = order.Quantity;
dr["ETD"] = order.ETD;
}
dr["SupplierETD"] = etd;
dr["Remarks"] = sizeRunOfProductNoList.Sum(s => (s.Quantity - outsoleMaterialOfProductNoList.Where(o => o.OutsoleSupplierId == outsoleRawMaterial.OutsoleSupplierId && o.SizeNo == s.SizeNo).Sum(o => (o.Quantity - o.QuantityReject)))).ToString();
OutsoleSuppliersModel outsoleSupplier = outsoleSupplierList.Where(o => o.OutsoleSupplierId == outsoleRawMaterial.OutsoleSupplierId).FirstOrDefault();
if (outsoleSupplier != null)
{
dr["Supplier"] = outsoleSupplier.Name;
}
dt.Rows.Add(dr);
}
}
}
e.Result = dt;
}
private void bwLoadData_DoWork(object sender, DoWorkEventArgs e)
{
var regex = new Regex(@"[a-z]|[A-Z]");
outsoleRawMaterialList = OutsoleRawMaterialController.Select();
outsoleMaterialList = OutsoleMaterialController.SelectByOutsoleRawMaterial();
sizeRunList = SizeRunController.SelectByOutsoleRawMaterial();
outsoleSupplierList = OutsoleSuppliersController.Select();
ordersList = OrdersController.SelectByOutsoleRawMaterial();
DataTable dt = new OutsoleDelayDataSet().Tables["OutsoleDelayTable"];
List <String> productNoList = outsoleRawMaterialList.Select(r => r.ProductNo).Distinct().ToList();
foreach (string productNo in productNoList)
{
OrdersModel order = ordersList.Where(o => o.ProductNo == productNo).FirstOrDefault();
List <OutsoleRawMaterialModel> outsoleRawMaterialList_D1 = outsoleRawMaterialList.Where(o => o.ProductNo == productNo).ToList();
List <SizeRunModel> sizeRunList_D1 = sizeRunList.Where(s => s.ProductNo == productNo).OrderBy(o => Double.Parse(regex.IsMatch(o.SizeNo) ? regex.Replace(o.SizeNo, "") : o.SizeNo)).ToList();
List <OutsoleMaterialModel> outsoleMaterialList_D1 = outsoleMaterialList.Where(o => o.ProductNo == productNo).ToList();
foreach (OutsoleRawMaterialModel outsoleRawMaterial in outsoleRawMaterialList_D1)
{
List <OutsoleMaterialModel> outsoleMaterialList_D2 = outsoleMaterialList_D1.Where(o => o.OutsoleSupplierId == outsoleRawMaterial.OutsoleSupplierId).ToList();
OutsoleSuppliersModel outsoleSupplier = outsoleSupplierList.Where(o => o.OutsoleSupplierId == outsoleRawMaterial.OutsoleSupplierId).FirstOrDefault();
DateTime etd = outsoleRawMaterial.ETD.Date;
//bool isFull = OutsoleRawMaterialController.IsFull(sizeRunList_D1, new List<OutsoleRawMaterialModel>() { outsoleRawMaterial }, outsoleMaterialList_D1);
//if (etd != new DateTime(2000, 1, 1) && etd < DateTime.Now.Date && isFull == false)
if (etd != new DateTime(2000, 1, 1) && etd < DateTime.Now.Date)
{
foreach (SizeRunModel sizeRun in sizeRunList_D1)
{
int qtyDelay = sizeRun.Quantity -
outsoleMaterialList_D2.Where(o => o.SizeNo == sizeRun.SizeNo).Sum(o => o.Quantity);
if (qtyDelay > 0)
{
DataRow dr = dt.NewRow();
dr["ProductNo"] = productNo;
string sizeNoString = regex.IsMatch(sizeRun.SizeNo) == true?regex.Replace(sizeRun.SizeNo, "") : sizeRun.SizeNo;
double sizeNoDouble = 0;
Double.TryParse(sizeNoString, out sizeNoDouble);
dr["SizeNoDouble"] = sizeNoDouble;
dr["SizeNo"] = sizeRun.SizeNo;
dr["SupplierETD"] = outsoleRawMaterial.ETD;
if (order != null)
{
dr["OutsoleCode"] = order.OutsoleCode;
dr["ArticleNo"] = order.ArticleNo;
dr["ETD"] = order.ETD;
}
if (outsoleSupplier != null)
{
dr["OutsoleSupplier"] = outsoleSupplier.Name;
}
dr["QuantityDelay"] = qtyDelay;
dt.Rows.Add(dr);
}
}
}
}
}
e.Result = dt;
}
void threadLoad_DoWork(object sender, DoWorkEventArgs e)
{
//outsoleRawMaterialList = OutsoleRawMaterialController.Select();
outsoleRawMaterialList = OutsoleRawMaterialController.Select();
outsoleMaterialList = OutsoleMaterialController.SelectByOutsoleRawMaterial();
sizeRunList = SizeRunController.SelectByOutsoleRawMaterial();
outsoleSupplierList = OutsoleSuppliersController.Select();
orderList = OrdersController.SelectByOutsoleRawMaterial();
sewingMasterList = SewingMasterController.Select();
List <String> productNoList = outsoleRawMaterialList.Select(r => r.ProductNo).Distinct().ToList();
foreach (string productNo in productNoList)
{
OrdersModel order = orderList.Where(o => o.ProductNo == productNo).FirstOrDefault();
List <OutsoleRawMaterialModel> outsoleRawMaterialList_D1 = outsoleRawMaterialList.Where(o => o.ProductNo == productNo).ToList();
List <SizeRunModel> sizeRunList_D1 = sizeRunList.Where(s => s.ProductNo == productNo).ToList();
List <OutsoleMaterialModel> outsoleMaterialList_D1 = outsoleMaterialList.Where(o => o.ProductNo == productNo).ToList();
var sewingMasterList_D1 = sewingMasterList.Where(w => w.ProductNo == productNo).ToList();
foreach (OutsoleRawMaterialModel outsoleRawMaterial in outsoleRawMaterialList_D1)
{
//bool isFull = OutsoleRawMaterialController.IsFull(sizeRunList_D1, new List<OutsoleRawMaterialModel>() { outsoleRawMaterial, }, outsoleMaterialList_D1);
if (
//isFull == false &&
outsoleRawMaterial.ETD.Date != dtDefault
//&& outsoleRawMaterial.ActualDate.Date == dtDefault
)
{
OutsoleDeliveryStatusViewModel outsoleDeliveryStatusView = new OutsoleDeliveryStatusViewModel();
outsoleDeliveryStatusView.ProductNo = productNo;
if (order != null)
{
outsoleDeliveryStatusView.Country = order.Country;
outsoleDeliveryStatusView.ShoeName = order.ShoeName;
outsoleDeliveryStatusView.ArticleNo = order.ArticleNo;
outsoleDeliveryStatusView.OutsoleCode = order.OutsoleCode;
outsoleDeliveryStatusView.Quantity = order.Quantity;
outsoleDeliveryStatusView.ETD = order.ETD;
}
OutsoleSuppliersModel outsoleSupplier = outsoleSupplierList.Where(o => o.OutsoleSupplierId == outsoleRawMaterial.OutsoleSupplierId).FirstOrDefault();
if (outsoleSupplier != null)
{
outsoleDeliveryStatusView.Supplier = outsoleSupplier.Name;
}
outsoleDeliveryStatusView.SupplierETD = outsoleRawMaterial.ETD;
//outsoleDeliveryStatusView.Actual = sizeRunList_D1.Sum(s => (s.Quantity - outsoleMaterialList_D1.Where(o => o.OutsoleSupplierId == outsoleRawMaterial.OutsoleSupplierId && o.SizeNo == s.SizeNo).Sum(o => (o.Quantity - o.QuantityReject)))).ToString();
int actualQty = sizeRunList_D1.Sum(s => (outsoleMaterialList_D1.Where(o => o.OutsoleSupplierId == outsoleRawMaterial.OutsoleSupplierId && o.SizeNo == s.SizeNo).Sum(o => (o.Quantity - o.QuantityReject))));
outsoleDeliveryStatusView.ActualQuantity = actualQty.ToString();
if (outsoleRawMaterial.ActualDate != dtDefault)
{
outsoleDeliveryStatusView.Actual = string.Format("{0:M/d}", outsoleRawMaterial.ActualDate);
}
outsoleDeliveryStatusView.IsFinished = false;
if (actualQty >= order.Quantity) // && outsoleRawMaterial.ActualDate != dtDefault
{
outsoleDeliveryStatusView.IsFinished = true;
}
outsoleDeliveryStatusView.SewingStartDate = dtDefault;
var sewingMasterModel = sewingMasterList_D1.FirstOrDefault();
if (sewingMasterModel != null)
{
outsoleDeliveryStatusView.SewingStartDate = sewingMasterModel.SewingStartDate;
}
outsoleDeliveryStatusViewList.Add(outsoleDeliveryStatusView);
}
}
}
}