private MaterialArrivalViewModel MaterialArrival(string productNo, int[] materialIdArray)
{
List <RawMaterialModel> rawMaterialTypeList = rawMaterialList.Where(r => r.ProductNo == productNo && materialIdArray.Contains(r.MaterialTypeId)).ToList();
rawMaterialTypeList.RemoveAll(r => r.ETD.Date == dtDefault.Date);
MaterialArrivalViewModel materialArrivalView = new MaterialArrivalViewModel();
materialArrivalView.IsMaterialArrivalOk = false;
if (rawMaterialTypeList.Select(r => r.ActualDate).Count() > 0 && rawMaterialTypeList.Select(r => r.ActualDate.Date).Contains(dtDefault.Date) == false)
{
materialArrivalView.Date = rawMaterialTypeList.Select(r => r.ActualDate).Max();
materialArrivalView.IsMaterialArrivalOk = true;
}
else
{
if (rawMaterialTypeList.Select(r => r.ETD).Count() > 0 && rawMaterialTypeList.Where(r => r.ETD.Date != dtDefault.Date).Count() > 0)
{
materialArrivalView.Date = rawMaterialTypeList.Select(r => r.ETD).Max();
}
else
{
materialArrivalView = null;
}
}
return(materialArrivalView);
}
private MaterialArrivalViewModel MaterialArrival(string productNo, int[] materialIdArray)
{
List <RawMaterialModel> rawMaterialTypeList = rawMaterialList.Where(r => r.ProductNo == productNo && materialIdArray.Contains(r.MaterialTypeId)).ToList();
rawMaterialTypeList.RemoveAll(r => r.ETD.Date == dateDefault.Date);
MaterialArrivalViewModel materialArrivalView = new MaterialArrivalViewModel();
if (rawMaterialTypeList.Select(r => r.ActualDate).Count() > 0 && rawMaterialTypeList.Select(r => r.ActualDate.Date).Contains(dateDefault.Date) == false)
{
materialArrivalView.Date = rawMaterialTypeList.Select(r => r.ActualDate).Max();
materialArrivalView.Foreground = Brushes.Blue;
materialArrivalView.Background = Brushes.Transparent;
}
else
{
if (rawMaterialTypeList.Select(r => r.ETD).Count() > 0 && rawMaterialTypeList.Where(r => r.ETD.Date != dateDefault.Date).Count() > 0)
{
materialArrivalView.Date = rawMaterialTypeList.Where(r => r.ActualDate.Date == dateDefault.Date).Select(r => r.ETD).Max();
materialArrivalView.Foreground = Brushes.Black;
materialArrivalView.Background = Brushes.Transparent;
if (materialArrivalView.Date < DateTime.Now.Date)
{
materialArrivalView.Background = Brushes.Red;
}
else
{
if (rawMaterialTypeList.Where(r => String.IsNullOrEmpty(r.Remarks) == false).Count() > 0)
{
materialArrivalView.Background = Brushes.Yellow;
}
}
}
else
{
materialArrivalView = null;
}
}
return(materialArrivalView);
}
private void bwLoad_DoWork(object sender, DoWorkEventArgs e)
{
orderList = OrdersController.Select();
rawMaterialList = RawMaterialController.Select();
sockliningMasterList = SockliningMasterController.Select();
sewingMasterList = SewingMasterController.Select();
outsoleMasterList = OutsoleMasterController.Select();
assemblyMasterList = AssemblyMasterController.Select();
//sewingMasterList.RemoveAll(s => DateTimeHelper.Create(s.SewingBalance) != dtDefault && DateTimeHelper.Create(s.SewingBalance) != dtNothing);
sockliningMasterList = sockliningMasterList.OrderBy(s => s.Sequence).ToList();
int[] materialIdUpperArray = { 1, 2, 3, 4, 10 };
int[] materialIdSewingArray = { 5, 7 };
int[] materialIdOutsoleArray = { 6 };
int[] materialIdAssemblyArray = { 8 };
int[] materialIdSockliningArray = { 9 };
foreach (SockliningMasterModel sockliningMaster in sockliningMasterList)
{
SockliningMasterExportViewModel sockliningMasterExportView = new SockliningMasterExportViewModel();
sockliningMasterExportView.Sequence = sockliningMaster.Sequence;
sockliningMasterExportView.ProductNo = sockliningMaster.ProductNo;
OrdersModel order = orderList.Where(o => o.ProductNo == sockliningMaster.ProductNo).FirstOrDefault();
if (order != null)
{
sockliningMasterExportView.Country = order.Country;
sockliningMasterExportView.ShoeName = order.ShoeName;
sockliningMasterExportView.ArticleNo = order.ArticleNo;
sockliningMasterExportView.PatternNo = order.PatternNo;
sockliningMasterExportView.Quantity = order.Quantity;
sockliningMasterExportView.ETD = order.ETD;
}
MaterialArrivalViewModel materialArrivalSocklining = MaterialArrival(order.ProductNo, materialIdSockliningArray);
sockliningMasterExportView.IsSockliningMatsArrivalOk = false;
if (materialArrivalSocklining != null)
{
sockliningMasterExportView.SockliningMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", materialArrivalSocklining.Date);
sockliningMasterExportView.IsSockliningMatsArrivalOk = materialArrivalSocklining.IsMaterialArrivalOk;
}
sockliningMasterExportView.SockliningLine = sockliningMaster.SockliningLine;
sockliningMasterExportView.SockliningQuota = sockliningMaster.SockliningQuota;
sockliningMasterExportView.SockliningStartDate = sockliningMaster.SockliningStartDate;
sockliningMasterExportView.SockliningFinishDate = sockliningMaster.SockliningFinishDate;
sockliningMasterExportView.InsoleBalance = sockliningMaster.InsoleBalance;
sockliningMasterExportView.InsockBalance = sockliningMaster.InsockBalance;
SewingMasterModel sewingMaster = sewingMasterList.Where(o => o.ProductNo == sockliningMaster.ProductNo).FirstOrDefault();
if (sewingMaster != null)
{
sockliningMasterExportView.SewingStartDate = sewingMaster.SewingStartDate;
sockliningMasterExportView.SewingBalance = sewingMaster.SewingBalance;
}
else
{
sockliningMasterExportView.SewingStartDate = dtDefault;
sockliningMasterExportView.SewingBalance = "";
}
OutsoleMasterModel outsoleMaster = outsoleMasterList.Where(o => o.ProductNo == sockliningMaster.ProductNo).FirstOrDefault();
if (outsoleMaster != null)
{
sockliningMasterExportView.OutsoleStartDate = outsoleMaster.OutsoleStartDate;
sockliningMasterExportView.OutsoleBalance = outsoleMaster.OutsoleBalance;
}
else
{
sockliningMasterExportView.OutsoleStartDate = dtDefault;
sockliningMasterExportView.OutsoleBalance = "";
}
AssemblyMasterModel assemblyMaster = assemblyMasterList.Where(o => o.ProductNo == sockliningMaster.ProductNo).FirstOrDefault();
if (assemblyMaster != null)
{
sockliningMasterExportView.AssemblyStartDate = assemblyMaster.AssemblyStartDate;
}
else
{
sockliningMasterExportView.AssemblyStartDate = dtDefault;
}
sockliningMasterExportViewList.Add(sockliningMasterExportView);
}
}
private void bwLoad_DoWork(object sender, DoWorkEventArgs e)
{
try
{
orderList = OrdersController.Select();
rawMaterialList = RawMaterialController.Select();
sewingMasterList = SewingMasterController.Select();
productionMemoList = ProductionMemoController.Select();
offDayList = OffDayController.Select();
privateDefine = PrivateDefineController.GetDefine();
}
catch (Exception ex)
{
Dispatcher.Invoke(new Action(() => {
MessageBox.Show(ex.Message, this.Title, MessageBoxButton.OK, MessageBoxImage.Error);
}));
return;
}
_SEW_VS_OTHERS_CUT_A = privateDefine.SewingVsOthersCutTypeA;
_SEW_VS_OTHERS_CUT_B = privateDefine.SewingVsOthersCutTypeB;
//sewingMasterList.RemoveAll(s => DateTimeHelper.Create(s.SewingBalance) != dtDefault && DateTimeHelper.Create(s.SewingBalance) != dtNothing);
sewingMasterList = sewingMasterList.OrderBy(s => s.Sequence).ToList();
int[] materialIdUpperArray = { 1, 2, 3, 4, 10 };
int[] materialIdSewingArray = { 5, 7 };
int[] materialIdOutsoleArray = { 6 };
foreach (SewingMasterModel sewingMaster in sewingMasterList)
{
CutprepMasterExportViewModel cutprepMasterExportView = new CutprepMasterExportViewModel();
cutprepMasterExportView.Sequence = sewingMaster.Sequence;
cutprepMasterExportView.ProductNo = sewingMaster.ProductNo;
OrdersModel order = orderList.FirstOrDefault(f => f.ProductNo == sewingMaster.ProductNo);
string memoId = "";
if (order != null)
{
cutprepMasterExportView.Country = order.Country;
cutprepMasterExportView.ShoeName = order.ShoeName;
cutprepMasterExportView.ArticleNo = order.ArticleNo;
cutprepMasterExportView.PatternNo = order.PatternNo;
cutprepMasterExportView.Quantity = order.Quantity;
cutprepMasterExportView.ETD = order.ETD;
List <ProductionMemoModel> productionMemoByProductionNumberList = productionMemoList.Where(p => p.ProductionNumbers.Contains(order.ProductNo) == true).ToList();
for (int p = 0; p <= productionMemoByProductionNumberList.Count - 1; p++)
{
ProductionMemoModel productionMemo = productionMemoByProductionNumberList[p];
memoId += productionMemo.MemoId;
if (p < productionMemoByProductionNumberList.Count - 1)
{
memoId += "\n";
}
}
cutprepMasterExportView.MemoId = memoId;
}
MaterialArrivalViewModel materialArrivalUpper = MaterialArrival(order.ProductNo, materialIdUpperArray);
cutprepMasterExportView.IsUpperMatsArrivalOk = false;
if (materialArrivalUpper != null)
{
cutprepMasterExportView.UpperMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", materialArrivalUpper.Date);
cutprepMasterExportView.IsUpperMatsArrivalOk = materialArrivalUpper.IsMaterialArrivalOk;
}
cutprepMasterExportView.SewingLine = sewingMaster.SewingLine;
cutprepMasterExportView.SewingStartDate = sewingMaster.SewingStartDate;
cutprepMasterExportView.SewingQuota = sewingMaster.SewingQuota;
cutprepMasterExportView.SewingBalance = sewingMaster.SewingBalance;
cutprepMasterExportView.CutAStartDate = sewingMaster.CutAStartDate;
cutprepMasterExportView.CutAFinishDate = sewingMaster.CutAFinishDate;
cutprepMasterExportView.CutAQuota = sewingMaster.CutAQuota;
cutprepMasterExportView.AutoCut = sewingMaster.AutoCut;
cutprepMasterExportView.LaserCut = sewingMaster.LaserCut;
cutprepMasterExportView.HuasenCut = sewingMaster.HuasenCut;
cutprepMasterExportView.CutABalance = sewingMaster.CutABalance;
cutprepMasterExportView.PrintingBalance = sewingMaster.PrintingBalance;
cutprepMasterExportView.H_FBalance = sewingMaster.H_FBalance;
cutprepMasterExportView.EmbroideryBalance = sewingMaster.EmbroideryBalance;
cutprepMasterExportView.CutBBalance = sewingMaster.CutBBalance;
// Cut type A before sewing 18days
var cutTypeABeforeSewing = sewingMaster.SewingStartDate.AddDays(-_SEW_VS_OTHERS_CUT_A);
var dtCheckOffDateCutTypeAList = CheckOffDay(cutTypeABeforeSewing, sewingMaster.SewingStartDate);
// Cut type B before sewing 10days
var cutTypeBBeforeSewing = sewingMaster.SewingStartDate.AddDays(-_SEW_VS_OTHERS_CUT_B);
var dtCheckOffDateCutTypeBList = CheckOffDay(cutTypeBBeforeSewing, sewingMaster.SewingStartDate);
var firstDateCheckOffCutTypeA = String.Format("{0:M/d}", dtCheckOffDateCutTypeAList.FirstOrDefault());
var firstDateCheckOffCutTypeB = String.Format("{0:M/d}", dtCheckOffDateCutTypeBList.FirstOrDefault());
if (!String.IsNullOrEmpty(sewingMaster.CutBStartDate))
{
cutprepMasterExportView.CutBStartDate = sewingMaster.CutBStartDate;
}
else if (sewingMaster.SewingStartDate != dtDefault)
{
cutprepMasterExportView.CutBStartDate = firstDateCheckOffCutTypeB;
}
else
{
cutprepMasterExportView.CutBStartDate = "";
}
if (!String.IsNullOrEmpty(sewingMaster.AtomCutA))
{
cutprepMasterExportView.AtomCutA = sewingMaster.AtomCutA;
}
else if (sewingMaster.SewingStartDate != dtDefault)
{
cutprepMasterExportView.AtomCutA = firstDateCheckOffCutTypeA;
}
else
{
cutprepMasterExportView.AtomCutA = "";
}
if (!String.IsNullOrEmpty(sewingMaster.AtomCutB))
{
cutprepMasterExportView.AtomCutB = sewingMaster.AtomCutB;
}
else if (sewingMaster.SewingStartDate != dtDefault)
{
cutprepMasterExportView.AtomCutB = firstDateCheckOffCutTypeB;
}
else
{
cutprepMasterExportView.AtomCutB = "";
}
if (!String.IsNullOrEmpty(sewingMaster.LaserCutA))
{
cutprepMasterExportView.LaserCutA = sewingMaster.LaserCutA;
}
else if (sewingMaster.SewingStartDate != dtDefault)
{
cutprepMasterExportView.LaserCutA = firstDateCheckOffCutTypeA;
}
else
{
cutprepMasterExportView.LaserCutA = "";
}
if (!String.IsNullOrEmpty(sewingMaster.LaserCutB))
{
cutprepMasterExportView.LaserCutB = sewingMaster.LaserCutB;
}
else if (sewingMaster.SewingStartDate != dtDefault)
{
cutprepMasterExportView.LaserCutB = firstDateCheckOffCutTypeB;
}
else
{
cutprepMasterExportView.LaserCutB = "";
}
if (!String.IsNullOrEmpty(sewingMaster.HuasenCutA))
{
cutprepMasterExportView.HuasenCutA = sewingMaster.HuasenCutA;
}
else if (sewingMaster.SewingStartDate != dtDefault)
{
cutprepMasterExportView.HuasenCutA = firstDateCheckOffCutTypeA;
}
else
{
cutprepMasterExportView.HuasenCutA = "";
}
if (!String.IsNullOrEmpty(sewingMaster.HuasenCutB))
{
cutprepMasterExportView.HuasenCutB = sewingMaster.HuasenCutB;
}
else if (sewingMaster.SewingStartDate != dtDefault)
{
cutprepMasterExportView.HuasenCutB = firstDateCheckOffCutTypeB;
}
else
{
cutprepMasterExportView.HuasenCutB = "";
}
if (!String.IsNullOrEmpty(sewingMaster.ComelzCutA))
{
cutprepMasterExportView.ComelzCutA = sewingMaster.ComelzCutA;
}
else if (sewingMaster.SewingStartDate != dtDefault)
{
cutprepMasterExportView.ComelzCutA = firstDateCheckOffCutTypeA;
}
else
{
cutprepMasterExportView.ComelzCutA = "";
}
if (!String.IsNullOrEmpty(sewingMaster.ComelzCutB))
{
cutprepMasterExportView.ComelzCutB = sewingMaster.ComelzCutB;
}
else if (sewingMaster.SewingStartDate != dtDefault)
{
cutprepMasterExportView.ComelzCutB = firstDateCheckOffCutTypeB;
}
else
{
cutprepMasterExportView.ComelzCutB = "";
}
cutprepMasterExportViewList.Add(cutprepMasterExportView);
}
}
private void bwLoad_DoWork(object sender, DoWorkEventArgs e)
{
orderList = OrdersController.Select();
rawMaterialList = RawMaterialController.Select();
sewingMasterList = SewingMasterController.Select();
outsoleMasterList = OutsoleMasterController.Select();
sockliningMasterList = SockliningMasterController.Select();
assemblyMasterList = AssemblyMasterController.Select();
productionMemoList = ProductionMemoController.Select();
outsoleRawMaterialList = OutsoleRawMaterialController.Select();
rawMaterialViewModelNewList = RawMaterialController.Select_1();
//sewingMasterList.RemoveAll(s => DateTimeHelper.Create(s.SewingBalance) != dtDefault && DateTimeHelper.Create(s.SewingBalance) != dtNothing);
assemblyMasterList = assemblyMasterList.OrderBy(s => s.Sequence).ToList();
int[] materialIdUpperArray = { 1, 2, 3, 4, 10 };
int[] materialIdSewingArray = { 5, 7 };
int[] materialIdOutsoleArray = { 6 };
int[] materialIdAssemblyArray = { 8, 9 };
int[] materialIdCartonArray = { 11 };
foreach (AssemblyMasterModel assemblyMaster in assemblyMasterList)
{
AssemblyMasterExportViewModel assemblyMasterExportView = new AssemblyMasterExportViewModel();
assemblyMasterExportView.Sequence = assemblyMaster.Sequence;
assemblyMasterExportView.ProductNo = assemblyMaster.ProductNo;
OrdersModel order = orderList.Where(o => o.ProductNo == assemblyMaster.ProductNo).FirstOrDefault();
string memoId = "";
if (order != null)
{
assemblyMasterExportView.Country = order.Country;
assemblyMasterExportView.ShoeName = order.ShoeName;
assemblyMasterExportView.ArticleNo = order.ArticleNo;
assemblyMasterExportView.LastCode = order.LastCode;
assemblyMasterExportView.Quantity = order.Quantity;
assemblyMasterExportView.ETD = order.ETD;
List <ProductionMemoModel> productionMemoByProductionNumberList = productionMemoList.Where(p => p.ProductionNumbers.Contains(order.ProductNo) == true).ToList();
for (int p = 0; p <= productionMemoByProductionNumberList.Count - 1; p++)
{
ProductionMemoModel productionMemo = productionMemoByProductionNumberList[p];
memoId += productionMemo.MemoId;
if (p < productionMemoByProductionNumberList.Count - 1)
{
memoId += "\n";
}
}
assemblyMasterExportView.MemoId = memoId;
}
//MaterialArrivalViewModel materialArrivalOutsole = MaterialArrival(order.ProductNo, materialIdOutsoleArray);
//assemblyMasterExportView.IsOutsoleMatsArrivalOk = false;
//if (materialArrivalOutsole != null)
//{
// assemblyMasterExportView.OutsoleMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", materialArrivalOutsole.Date);
// assemblyMasterExportView.IsOutsoleMatsArrivalOk = materialArrivalOutsole.IsMaterialArrivalOk;
//}
//// follow OutsoleRawMaterial
//var osRawMaterial = outsoleRawMaterialList.Where(w => w.ProductNo == order.ProductNo).ToList();
//var actualDateList = osRawMaterial.Select(s => s.ActualDate).ToList();
//assemblyMasterExportView.IsOutsoleMatsArrivalOk = false;
//if (actualDateList.Count() > 0 && actualDateList.Contains(dtDefault) == false)
//{
// assemblyMasterExportView.OutsoleMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", actualDateList.Max());
// assemblyMasterExportView.IsOutsoleMatsArrivalOk = true;
//}
//else
//{
// var etdDateList = osRawMaterial.Select(s => s.ETD).ToList();
// if (etdDateList.Count() > 0)
// {
// assemblyMasterExportView.OutsoleMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", etdDateList.Max());
// }
//}
assemblyMasterExportView.IsOutsoleMatsArrivalOk = false;
var rawMaterialViewModelNew = rawMaterialViewModelNewList.FirstOrDefault(f => f.ProductNo == order.ProductNo);
if (String.IsNullOrEmpty(rawMaterialViewModelNew.OUTSOLE_Remarks) &&
!String.IsNullOrEmpty(rawMaterialViewModelNew.OUTSOLE_ActualDate))
{
assemblyMasterExportView.OutsoleMatsArrival = rawMaterialViewModelNew.OUTSOLE_ActualDate;
assemblyMasterExportView.IsOutsoleMatsArrivalOk = true;
}
else
{
assemblyMasterExportView.OutsoleMatsArrival = rawMaterialViewModelNew.OUTSOLE_ETD;
}
MaterialArrivalViewModel materialArrivalAssembly = MaterialArrival(order.ProductNo, materialIdAssemblyArray);
assemblyMasterExportView.IsAssemblyMatsArrivalOk = false;
if (materialArrivalAssembly != null)
{
assemblyMasterExportView.AssemblyMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", materialArrivalAssembly.Date);
assemblyMasterExportView.IsAssemblyMatsArrivalOk = materialArrivalAssembly.IsMaterialArrivalOk;
}
MaterialArrivalViewModel materialArrivalCarton = MaterialArrival(order.ProductNo, materialIdCartonArray);
if (materialArrivalCarton != null)
{
assemblyMasterExportView.CartonMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", materialArrivalCarton.Date);
}
assemblyMasterExportView.AssemblyLine = assemblyMaster.AssemblyLine;
assemblyMasterExportView.AssemblyStartDate = assemblyMaster.AssemblyStartDate;
assemblyMasterExportView.AssemblyFinishDate = assemblyMaster.AssemblyFinishDate;
assemblyMasterExportView.AssemblyQuota = assemblyMaster.AssemblyQuota;
assemblyMasterExportView.AssemblyBalance = assemblyMaster.AssemblyBalance;
SewingMasterModel sewingMaster = sewingMasterList.Where(o => o.ProductNo == assemblyMaster.ProductNo).FirstOrDefault();
if (sewingMaster != null)
{
assemblyMasterExportView.SewingStartDate = sewingMaster.SewingStartDate;
assemblyMasterExportView.SewingFinishDate = sewingMaster.SewingFinishDate;
assemblyMasterExportView.SewingBalance = sewingMaster.SewingBalance;
}
else
{
assemblyMasterExportView.SewingStartDate = dtDefault;
assemblyMasterExportView.SewingFinishDate = dtDefault;
assemblyMasterExportView.SewingBalance = "";
}
OutsoleMasterModel outsoleMaster = outsoleMasterList.Where(o => o.ProductNo == assemblyMaster.ProductNo).FirstOrDefault();
if (outsoleMaster != null)
{
assemblyMasterExportView.OutsoleBalance = outsoleMaster.OutsoleBalance;
}
else
{
assemblyMasterExportView.OutsoleBalance = "";
}
SockliningMasterModel sockliningMaster = sockliningMasterList.Where(o => o.ProductNo == assemblyMaster.ProductNo).FirstOrDefault();
if (sockliningMaster != null)
{
assemblyMasterExportView.InsoleBalance = sockliningMaster.InsoleBalance;
assemblyMasterExportView.InsockBalance = sockliningMaster.InsockBalance;
}
else
{
assemblyMasterExportView.InsoleBalance = "";
assemblyMasterExportView.InsockBalance = "";
}
assemblyMasterExportViewList.Add(assemblyMasterExportView);
}
}
private void CompareDate(OrdersModel order, DateTime dateFrom, DateTime dateTo, DateTime startDate, DateTime finishDate, ref DataRow dataRow, int[] materialIdArray)
{
if (order == null)
{
return;
}
MaterialArrivalViewModel materialArrival = MaterialArrival(order.ProductNo, materialIdArray);
List <DateTime> dateOffList = offDateList.Where(o => String.IsNullOrEmpty(o.Date.ToString()) == false).Select(p => p.Date).ToList();
//DateTime dateColor = new DateTime(1992, 11, 16);
DateTime dateColor = startDate;
// Green Color
while (dateColor <= finishDate)
{
if (dateColor >= dateFrom && dateColor <= dateTo)
{
if (dataRow[String.Format("Day_{0:d-M}_Background", dateColor)] == Brushes.Red)
{
dataRow[String.Format("Day_{0:d-M}_Background", dateColor)] = Brushes.Red;
}
// addition code
//if (dataRow[String.Format("Day_{0:d-M}_Background", dateColor)] == Brushes.Yellow)
//{
// dataRow[String.Format("Day_{0:d-M}_Background", dateColor)] = Brushes.Yellow;
//}
if (dataRow[String.Format("Day_{0:d-M}_Background", dateColor)] == Brushes.Orange)
{
dataRow[String.Format("Day_{0:d-M}_Background", dateColor)] = Brushes.Orange;
}
if (dataRow[String.Format("Day_{0:d-M}_Background", dateColor)] == Brushes.White)
{
dataRow[String.Format("Day_{0:d-M}_Background", dateColor)] = Brushes.Green;
dataRow[String.Format("Day_{0:d-M}_Tooltip", dateColor)] = string.Format(" ProductNo: {0}\nArticle: {1}\nPM: {2}\nShoe Name: {3}\nEFD: {4:MM/dd/yyyy}\nUpper Mat's Arrival: {5}", order.ProductNo, order.ArticleNo, order.PatternNo, order.ShoeName, order.ETD, materialArrival != null ? materialArrival.Date.ToShortDateString() : "");
}
// Yellow Color
if (materialArrival != null && dateColor > materialArrival.Date && (dateFrom <= dateColor && dateColor <= dateTo))
{
//int range = TimeHelper.CalculateDate(materialArrival.Date, dateColor);
int range = (Int32)(dateColor - materialArrival.Date).TotalDays;
if (range >= 0 && range <= 7)
{
if (dataRow[String.Format("Day_{0:d-M}_Background", dateColor)] == Brushes.Green)
{
dataRow[String.Format("Day_{0:d-M}_Background", dateColor)] = Brushes.Yellow;
dataRow[String.Format("Day_{0:d-M}_Tooltip", dateColor)] =
string.Format("Product No: {0}\nShoe Name: {1}\nMaterial Arrival: {2:MM/dd/yyyy}\nStart Date: {3:MM/dd/yyyy}", order.ProductNo, order.ShoeName, materialArrival.Date, dateColor);
}
}
}
if (dateOffList.Contains(dateColor))
{
dataRow[String.Format("Day_{0:d-M}_Background", dateColor)] = Brushes.White;
dataRow[String.Format("Day_{0:d-M}_Tooltip", dateColor)] = null;
}
}
dateColor = dateColor.AddDays(1);
}
// Orange Color
if (materialArrival != null && startDate < materialArrival.Date && (dateFrom <= startDate && startDate <= dateTo))
{
dataRow[String.Format("Day_{0:d-M}_Background", startDate)] = Brushes.Orange;
if (dateOffList.Contains(startDate))
{
dataRow[String.Format("Day_{0:d-M}_Background", startDate)] = Brushes.White;
}
dataRow[String.Format("Day_{0:d-M}_Tooltip", startDate)] =
string.Format("Product No: {0}\nShoe Name: {1}\nMaterial Arrival: {2:MM/dd/yyyy}\nStart Date: {3:MM/dd/yyyy}", order.ProductNo, order.ShoeName, materialArrival.Date, startDate);
}
// Red Color
if (finishDate > order.ETD && (dateFrom <= finishDate && finishDate <= dateTo))
{
dataRow[String.Format("Day_{0:d-M}_Background", finishDate)] = Brushes.Red;
dataRow[String.Format("Day_{0:d-M}_Tooltip", finishDate)] =
string.Format("Product No: {0}\nShoe Name: {1}\nETD: {2:MM/dd/yyyy}\nFinish Date: {3:MM/dd/yyyy}", order.ProductNo, order.ShoeName, order.ETD, finishDate);
}
}
private void bwLoad_DoWork(object sender, DoWorkEventArgs e)
{
orderList = OrdersController.Select();
rawMaterialList = RawMaterialController.Select();
sewingMasterList = SewingMasterController.Select();
outsoleMasterList = OutsoleMasterController.Select();
productionMemoList = ProductionMemoController.Select();
outsoleRawMaterialList = OutsoleRawMaterialController.Select();
rawMaterialViewModelNewList = RawMaterialController.Select_1();
//sewingMasterList.RemoveAll(s => DateTimeHelper.Create(s.SewingBalance) != dtDefault && DateTimeHelper.Create(s.SewingBalance) != dtNothing);
sewingMasterList = sewingMasterList.OrderBy(s => s.Sequence).ToList();
int[] materialIdUpperArray = { 1, 2, 3, 4, 10 };
int[] materialIdSewingArray = { 5, 7 };
int[] materialIdOutsoleArray = { 6 };
foreach (SewingMasterModel sewingMaster in sewingMasterList)
{
SewingMasterExportViewModel sewingMasterExportView = new SewingMasterExportViewModel();
sewingMasterExportView.Sequence = sewingMaster.Sequence;
sewingMasterExportView.ProductNo = sewingMaster.ProductNo;
OrdersModel order = orderList.Where(o => o.ProductNo == sewingMaster.ProductNo).FirstOrDefault();
string memoId = "";
if (order != null)
{
sewingMasterExportView.Country = order.Country;
sewingMasterExportView.ShoeName = order.ShoeName;
sewingMasterExportView.ArticleNo = order.ArticleNo;
sewingMasterExportView.PatternNo = order.PatternNo;
sewingMasterExportView.Quantity = order.Quantity;
sewingMasterExportView.ETD = order.ETD;
List <ProductionMemoModel> productionMemoByProductionNumberList = productionMemoList.Where(p => p.ProductionNumbers.Contains(order.ProductNo) == true).ToList();
for (int p = 0; p <= productionMemoByProductionNumberList.Count - 1; p++)
{
ProductionMemoModel productionMemo = productionMemoByProductionNumberList[p];
memoId += productionMemo.MemoId;
if (p < productionMemoByProductionNumberList.Count - 1)
{
memoId += "\n";
}
}
sewingMasterExportView.MemoId = memoId;
}
MaterialArrivalViewModel materialArrivalUpper = MaterialArrival(order.ProductNo, materialIdUpperArray);
sewingMasterExportView.IsUpperMatsArrivalOk = false;
if (materialArrivalUpper != null)
{
sewingMasterExportView.UpperMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", materialArrivalUpper.Date);
sewingMasterExportView.IsUpperMatsArrivalOk = materialArrivalUpper.IsMaterialArrivalOk;
}
MaterialArrivalViewModel materialArrivalSewing = MaterialArrival(order.ProductNo, materialIdSewingArray);
sewingMasterExportView.IsSewingMatsArrivalOk = false;
if (materialArrivalSewing != null)
{
sewingMasterExportView.SewingMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", materialArrivalSewing.Date);
sewingMasterExportView.IsSewingMatsArrivalOk = materialArrivalSewing.IsMaterialArrivalOk;
}
//MaterialArrivalViewModel materialArrivalOutsole = MaterialArrival(order.ProductNo, materialIdOutsoleArray);
//sewingMasterExportView.IsOSMatsArrivalOk = false;
//if (materialArrivalOutsole != null)
//{
// sewingMasterExportView.OSMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", materialArrivalOutsole.Date);
// sewingMasterExportView.IsOSMatsArrivalOk = materialArrivalOutsole.IsMaterialArrivalOk;
//}
// For Outsole Material
//var osRawMaterial = outsoleRawMaterialList.Where(w => w.ProductNo == order.ProductNo).ToList();
//var actualDateList = osRawMaterial.Select(s => s.ActualDate).ToList();
//sewingMasterExportView.IsOSMatsArrivalOk = false;
//if (actualDateList.Count() > 0 && actualDateList.Contains(dtDefault) == false)
//{
// sewingMasterExportView.OSMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", actualDateList.Max());
// sewingMasterExportView.IsOSMatsArrivalOk = true;
//}
//else
//{
// var etdDateList = osRawMaterial.Select(s => s.ETD).ToList();
// if (etdDateList.Count() > 0)
// {
// sewingMasterExportView.OSMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", etdDateList.Max());
// }
//}
var rawMaterialViewModelNew = rawMaterialViewModelNewList.FirstOrDefault(f => f.ProductNo == order.ProductNo);
sewingMasterExportView.IsOSMatsArrivalOk = false;
if (String.IsNullOrEmpty(rawMaterialViewModelNew.OUTSOLE_Remarks) &&
!String.IsNullOrEmpty(rawMaterialViewModelNew.OUTSOLE_ActualDate))
{
sewingMasterExportView.OSMatsArrival = rawMaterialViewModelNew.OUTSOLE_ActualDate;
sewingMasterExportView.IsOSMatsArrivalOk = true;
}
else
{
sewingMasterExportView.OSMatsArrival = rawMaterialViewModelNew.OUTSOLE_ETD;
}
sewingMasterExportView.SewingLine = sewingMaster.SewingLine;
sewingMasterExportView.CutAStartDate = sewingMaster.CutAStartDate;
sewingMasterExportView.SewingStartDate = sewingMaster.SewingStartDate;
sewingMasterExportView.SewingFinishDate = sewingMaster.SewingFinishDate;
sewingMasterExportView.SewingQuota = sewingMaster.SewingQuota;
sewingMasterExportView.SewingBalance = sewingMaster.SewingBalance;
sewingMasterExportView.CutABalance = sewingMaster.CutABalance;
sewingMasterExportView.CutBBalance = sewingMaster.CutBBalance;
OutsoleMasterModel outsoleMaster = outsoleMasterList.Where(o => o.ProductNo == sewingMaster.ProductNo).FirstOrDefault();
if (outsoleMaster != null)
{
sewingMasterExportView.OSBalance = outsoleMaster.OutsoleBalance;
}
else
{
sewingMasterExportView.OSBalance = "";
}
sewingMasterExportViewList.Add(sewingMasterExportView);
}
}
private void bwLoad_DoWork(object sender, DoWorkEventArgs e)
{
orderList = OrdersController.Select();
rawMaterialList = RawMaterialController.Select();
sewingMasterList = SewingMasterController.Select();
outsoleMasterList = OutsoleMasterController.Select();
outsoleReleaseMaterialList = OutsoleReleaseMaterialController.SelectByOutsoleMaster();
productionMemoList = ProductionMemoController.Select();
//sewingMasterList.RemoveAll(s => DateTimeHelper.Create(s.SewingBalance) != dtDefault && DateTimeHelper.Create(s.SewingBalance) != dtNothing);
outsoleMasterList = outsoleMasterList.OrderBy(s => s.Sequence).ToList();
int[] materialIdUpperArray = { 1, 2, 3, 4, 10 };
int[] materialIdSewingArray = { 5, 7 };
int[] materialIdOutsoleArray = { 6 };
foreach (OutsoleMasterModel outsoleMaster in outsoleMasterList)
{
OutsoleMasterExportViewModel outsoleMasterExportView = new OutsoleMasterExportViewModel();
outsoleMasterExportView.Sequence = outsoleMaster.Sequence;
outsoleMasterExportView.ProductNo = outsoleMaster.ProductNo;
OrdersModel order = orderList.Where(o => o.ProductNo == outsoleMaster.ProductNo).FirstOrDefault();
string memoId = "";
if (order != null)
{
outsoleMasterExportView.Country = order.Country;
outsoleMasterExportView.ShoeName = order.ShoeName;
outsoleMasterExportView.ArticleNo = order.ArticleNo;
outsoleMasterExportView.OutsoleCode = order.OutsoleCode;
outsoleMasterExportView.Quantity = order.Quantity;
outsoleMasterExportView.ETD = order.ETD;
List <ProductionMemoModel> productionMemoByProductionNumberList = productionMemoList.Where(p => p.ProductionNumbers.Contains(order.ProductNo) == true).ToList();
for (int p = 0; p <= productionMemoByProductionNumberList.Count - 1; p++)
{
ProductionMemoModel productionMemo = productionMemoByProductionNumberList[p];
memoId += productionMemo.MemoId;
if (p < productionMemoByProductionNumberList.Count - 1)
{
memoId += "\n";
}
}
outsoleMasterExportView.MemoId = memoId;
}
MaterialArrivalViewModel materialArrivalOutsole = MaterialArrival(order.ProductNo, materialIdOutsoleArray);
outsoleMasterExportView.IsOutsoleMatsArrivalOk = false;
if (materialArrivalOutsole != null)
{
outsoleMasterExportView.OutsoleMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", materialArrivalOutsole.Date);
outsoleMasterExportView.IsOutsoleMatsArrivalOk = materialArrivalOutsole.IsMaterialArrivalOk;
}
outsoleMasterExportView.OutsoleLine = outsoleMaster.OutsoleLine;
outsoleMasterExportView.OutsoleStartDate = outsoleMaster.OutsoleStartDate;
outsoleMasterExportView.OutsoleFinishDate = outsoleMaster.OutsoleFinishDate;
outsoleMasterExportView.OutsoleQuota = outsoleMaster.OutsoleQuota;
outsoleMasterExportView.OutsoleBalance = outsoleMaster.OutsoleBalance;
RawMaterialModel outsoleRawMaterial = rawMaterialList.Where(r => r.ProductNo == outsoleMaster.ProductNo && materialIdOutsoleArray.Contains(r.MaterialTypeId)).FirstOrDefault();
if (outsoleRawMaterial != null)
{
outsoleMasterExportView.OutsoleWHBalance = outsoleRawMaterial.Remarks;
}
else
{
outsoleMasterExportView.OutsoleWHBalance = "";
}
SewingMasterModel sewingMaster = sewingMasterList.Where(o => o.ProductNo == outsoleMaster.ProductNo).FirstOrDefault();
if (sewingMaster != null)
{
outsoleMasterExportView.SewingStartDate = sewingMaster.SewingStartDate;
outsoleMasterExportView.SewingFinishDate = sewingMaster.SewingFinishDate;
outsoleMasterExportView.SewingQuota = sewingMaster.SewingQuota;
outsoleMasterExportView.SewingBalance = sewingMaster.SewingBalance;
}
else
{
outsoleMasterExportView.SewingStartDate = dtDefault;
outsoleMasterExportView.SewingFinishDate = dtDefault;
outsoleMasterExportView.SewingQuota = 0;
outsoleMasterExportView.SewingBalance = "";
}
List <OutsoleReleaseMaterialModel> outsoleReleaseMaterialList_D1 = outsoleReleaseMaterialList.Where(o => o.ProductNo == outsoleMaster.ProductNo).ToList();
int qtyReleased = outsoleReleaseMaterialList_D1.Sum(o => o.Quantity);
outsoleMasterExportView.ReleasedQuantity = qtyReleased.ToString();
if (qtyReleased <= 0)
{
outsoleMasterExportView.ReleasedQuantity = "";
}
if (qtyReleased >= outsoleMasterExportView.Quantity && outsoleReleaseMaterialList_D1.Count > 0)
{
DateTime releasedDate = outsoleReleaseMaterialList_D1.FirstOrDefault().ModifiedTime;
outsoleMasterExportView.ReleasedQuantity = string.Format("{0:M/d}", releasedDate);
}
outsoleMasterExportViewList.Add(outsoleMasterExportView);
}
}
private void bwLoad_DoWork(object sender, DoWorkEventArgs e)
{
orderList = OrdersController.Select();
rawMaterialList = RawMaterialController.Select();
sewingMasterList = SewingMasterController.Select();
productionMemoList = ProductionMemoController.Select();
//sewingMasterList.RemoveAll(s => DateTimeHelper.Create(s.SewingBalance) != dtDefault && DateTimeHelper.Create(s.SewingBalance) != dtNothing);
sewingMasterList = sewingMasterList.OrderBy(s => s.Sequence).ToList();
int[] materialIdUpperArray = { 1, 2, 3, 4, 10 };
int[] materialIdSewingArray = { 5, 7 };
int[] materialIdOutsoleArray = { 6 };
foreach (SewingMasterModel sewingMaster in sewingMasterList)
{
CutprepMasterExportViewModel cutprepMasterExportView = new CutprepMasterExportViewModel();
cutprepMasterExportView.Sequence = sewingMaster.Sequence;
cutprepMasterExportView.ProductNo = sewingMaster.ProductNo;
OrdersModel order = orderList.Where(o => o.ProductNo == sewingMaster.ProductNo).FirstOrDefault();
string memoId = "";
if (order != null)
{
cutprepMasterExportView.Country = order.Country;
cutprepMasterExportView.ShoeName = order.ShoeName;
cutprepMasterExportView.ArticleNo = order.ArticleNo;
cutprepMasterExportView.PatternNo = order.PatternNo;
cutprepMasterExportView.Quantity = order.Quantity;
cutprepMasterExportView.ETD = order.ETD;
List <ProductionMemoModel> productionMemoByProductionNumberList = productionMemoList.Where(p => p.ProductionNumbers.Contains(order.ProductNo) == true).ToList();
for (int p = 0; p <= productionMemoByProductionNumberList.Count - 1; p++)
{
ProductionMemoModel productionMemo = productionMemoByProductionNumberList[p];
memoId += productionMemo.MemoId;
if (p < productionMemoByProductionNumberList.Count - 1)
{
memoId += "\n";
}
}
cutprepMasterExportView.MemoId = memoId;
}
MaterialArrivalViewModel materialArrivalUpper = MaterialArrival(order.ProductNo, materialIdUpperArray);
cutprepMasterExportView.IsUpperMatsArrivalOk = false;
if (materialArrivalUpper != null)
{
cutprepMasterExportView.UpperMatsArrival = String.Format(new CultureInfo("en-US"), "{0:dd-MMM}", materialArrivalUpper.Date);
cutprepMasterExportView.IsUpperMatsArrivalOk = materialArrivalUpper.IsMaterialArrivalOk;
}
cutprepMasterExportView.SewingLine = sewingMaster.SewingLine;
cutprepMasterExportView.SewingStartDate = sewingMaster.SewingStartDate;
cutprepMasterExportView.SewingQuota = sewingMaster.SewingQuota;
cutprepMasterExportView.SewingBalance = sewingMaster.SewingBalance;
cutprepMasterExportView.CutAStartDate = sewingMaster.CutAStartDate;
cutprepMasterExportView.CutAFinishDate = sewingMaster.CutAFinishDate;
cutprepMasterExportView.CutAQuota = sewingMaster.CutAQuota;
cutprepMasterExportView.AutoCut = sewingMaster.AutoCut;
cutprepMasterExportView.LaserCut = sewingMaster.LaserCut;
cutprepMasterExportView.HuasenCut = sewingMaster.HuasenCut;
cutprepMasterExportView.CutABalance = sewingMaster.CutABalance;
cutprepMasterExportView.PrintingBalance = sewingMaster.PrintingBalance;
cutprepMasterExportView.H_FBalance = sewingMaster.H_FBalance;
cutprepMasterExportView.EmbroideryBalance = sewingMaster.EmbroideryBalance;
cutprepMasterExportView.CutBBalance = sewingMaster.CutBBalance;
cutprepMasterExportViewList.Add(cutprepMasterExportView);
}
}
