private void bwLoadData_DoWork(object sender, DoWorkEventArgs e)
{
materialTypeList = MaterialTypeController.Select().Where(w => w.MaterialGroup.Contains("UPPER")).ToList();
orderList = OrdersController.Select();
rawMaterialList = RawMaterialController.Select();
sewingMasterList = SewingMasterController.SelectByProductNo();
DataTable dt = new DelayDataSet().Tables["DelayTable"];
List <String> productNoList = rawMaterialList.Select(r => r.ProductNo).Distinct().ToList();
var materialUpperIdList = materialTypeList.Select(s => s.MaterialTypeId).Distinct().ToList();
foreach (string productNo in productNoList)
{
OrdersModel order = orderList.Where(o => o.ProductNo == productNo).FirstOrDefault();
List <Int32> materialTypeIdList = rawMaterialList.Where(w => materialUpperIdList.Contains(w.MaterialTypeId)).Select(r => r.MaterialTypeId).Distinct().ToList();
// get assemblyline from productNo
//AssemblyMasterModel assemblyMaster = assemblyMasterList.Where(o => o.ProductNo == productNo).FirstOrDefault();
// get sewingLing from productNo
SewingMasterModel sewingMaster = sewingMasterList.Where(o => o.ProductNo == productNo).FirstOrDefault();
//materialTypeIdList.Remove(6);
//materialTypeIdList.Remove(11);
//materialTypeIdList.Remove(12);
//materialTypeIdList.Remove(13);
//materialTypeIdList.Remove(14);
foreach (int materialTypeId in materialTypeIdList)
{
RawMaterialModel rawMaterial = rawMaterialList.Where(r => r.ProductNo == productNo && r.MaterialTypeId == materialTypeId).FirstOrDefault();
if (rawMaterial != null && rawMaterial.ETD.Date != new DateTime(2000, 1, 1) && rawMaterial.ETD.Date < DateTime.Now.Date &&
rawMaterial.ActualDate.Date == new DateTime(2000, 1, 1))
{
DataRow dr = dt.NewRow();
// binding data to reportviewer
dr["SewingLine"] = sewingMaster.SewingLine;
dr["ProductNo"] = productNo;
if (order != null)
{
dr["ArticleNo"] = order.ArticleNo;
dr["ShoeName"] = order.ShoeName;
dr["Quantity"] = order.Quantity;
dr["ETD"] = order.ETD;
}
dr["SupplierETD"] = rawMaterial.ETD;
dr["Remarks"] = rawMaterial.Remarks;
MaterialTypeModel materialType = materialTypeList.Where(m => m.MaterialTypeId == rawMaterial.MaterialTypeId).FirstOrDefault();
if (materialType != null)
{
dr["Supplier"] = materialType.Name;
}
dt.Rows.Add(dr);
}
}
}
e.Result = dt;
}
public ActionResult RawMaterial(RawMaterialModel rawMaterialModel)
{
if (!ModelState.IsValid)
{
string errorString = this.ValidationRawMaterial(rawMaterialModel);
if (!string.IsNullOrEmpty(errorString))
{
ViewBag.Validate = errorString;
return(View(rawMaterialModel));
}
}
if (rawMaterialModel.Id > 0)
{
var result = _iRawMaterialService.UpdateRawMaterial(rawMaterialModel);
if (result == -1)
{
ModelState.AddModelError("RawMaterialName", "Raw Material already exists");
return(View(rawMaterialModel));
}
ViewBag.Result = _locService.GetLocalizedHtmlString("EditSuccss");
}
else
{
var result = _iRawMaterialService.InsertRawMaterial(rawMaterialModel);
if (result == -1)
{
ModelState.AddModelError("RawMaterialName", "Raw Material already exists");
return(View(rawMaterialModel));
}
ViewBag.Result = _locService.GetLocalizedHtmlString("SaveSuccess");
}
return(RedirectToAction("Index", "RawMaterial"));
}
public int UpdateRawMaterial(RawMaterialModel rawMaterialModel)
{
int result = 0;
using (SqlConnection con = new SqlConnection(_ConnectionString.Value.ConnectionString))
{
CommonRepository commonRepository = new CommonRepository(_ConnectionString);
result = commonRepository.GetValidateUnique("RawMaterial", "RawMaterialName", rawMaterialModel.RawMaterialName, rawMaterialModel.Id.ToString());
if (result > 0)
{
return(-1);
}
con.Open();
SqlTransaction sqltrans = con.BeginTransaction();
var query = "UPDATE RawMaterial SET RawMaterialName =@RawMaterialName," +
"Notes = @Notes, " +
"IsActive = @IsActive, " +
"UserIdUpdated = " + LoginInfo.Userid +
",DateUpdated = GetUtcDate() " +
"WHERE Id = @Id;";
result = con.Execute(query, rawMaterialModel, sqltrans, 0, System.Data.CommandType.Text);
if (result > 0)
{
sqltrans.Commit();
string output = commonRepository.SyncTableStatus("RawMaterial");
}
else
{
sqltrans.Rollback();
}
}
return(result);
}
public OutsoleRawMaterialWindow(string productNo)
{
InitializeComponent();
this.productNo = productNo;
bwLoadData = new BackgroundWorker();
bwLoadData.WorkerSupportsCancellation = true;
bwLoadData.DoWork += new DoWorkEventHandler(bwLoadData_DoWork);
bwLoadData.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bwLoadData_RunWorkerCompleted);
outsoleSupplierList = new List <OutsoleSuppliersModel>();
outsoleRawMaterialList = new List <OutsoleRawMaterialModel>();
outsoleRawMaterialViewList = new List <OutsoleRawMaterialViewModel>();
dtNothing = new DateTime(1999, 12, 31);
dtDefault = new DateTime(2000, 1, 1);
bwInsert = new BackgroundWorker();
bwInsert.DoWork += new DoWorkEventHandler(bwInsert_DoWork);
bwInsert.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bwInsert_RunWorkerCompleted);
outsoleRawMaterialViewToInsertList = new List <OutsoleRawMaterialViewModel>();
outsoleRawMaterialViewToDeleteList = new List <OutsoleRawMaterialViewModel>();
rawMaterial = new RawMaterialModel
{
ProductNo = productNo,
MaterialTypeId = 6,
ETD = dtDefault,
ActualDate = dtDefault,
Remarks = "",
IsETDUpdate = false,
IsActualDateUpdate = false,
IsRemarksUpdate = false,
};
}
void threadLoad_DoWork(object sender, DoWorkEventArgs e)
{
materialTypeList = MaterialTypeController.Select();
orderList = OrdersController.Select();
rawMaterialList = RawMaterialController.Select();
List <String> productNoList = rawMaterialList.Select(r => r.ProductNo).Distinct().ToList();
foreach (string productNo in productNoList)
{
OrdersModel order = orderList.Where(o => o.ProductNo == productNo).FirstOrDefault();
List <Int32> materialTypeIdList = rawMaterialList.Select(r => r.MaterialTypeId).Distinct().ToList();
//Red!
materialTypeIdList.Remove(6);
materialTypeIdList.Remove(11);
materialTypeIdList.Remove(12);
materialTypeIdList.Remove(13);
foreach (int materialTypeId in materialTypeIdList)
{
RawMaterialModel rawMaterial = rawMaterialList.Where(r => r.ProductNo == productNo && r.MaterialTypeId == materialTypeId).FirstOrDefault();
if (rawMaterial != null && rawMaterial.ETD.Date != dtDefault
//&& rawMaterial.ActualDate.Date == dtDefault
)
{
DeliveryStatusViewModel deliveryStatusView = new DeliveryStatusViewModel();
deliveryStatusView.ProductNo = productNo;
if (order != null)
{
deliveryStatusView.Country = order.Country;
deliveryStatusView.ArticleNo = order.ArticleNo;
deliveryStatusView.ShoeName = order.ShoeName;
deliveryStatusView.Quantity = order.Quantity;
deliveryStatusView.ETD = order.ETD;
}
MaterialTypeModel materialType = materialTypeList.Where(m => m.MaterialTypeId == rawMaterial.MaterialTypeId).FirstOrDefault();
if (materialType != null)
{
deliveryStatusView.Supplier = materialType.Name;
}
deliveryStatusView.SupplierETD = rawMaterial.ETD;
if (rawMaterial.ActualDate != dtDefault)
{
deliveryStatusView.Actual = string.Format("{0:MM/dd/yyyy}", rawMaterial.ActualDate);
deliveryStatusView.IsFinished = true;
}
else
{
deliveryStatusView.Actual = rawMaterial.Remarks;
deliveryStatusView.IsFinished = false;
}
deliveryStatusViewList.Add(deliveryStatusView);
}
}
}
}
private string ValidationRawMaterial(RawMaterialModel rawMaterialModel)
{
string ErrorString = string.Empty;
if (string.IsNullOrEmpty(rawMaterialModel.RawMaterialName))
{
ErrorString = _locService.GetLocalizedHtmlString("ValidAddOnesName");
return(ErrorString);
}
return(ErrorString);
}
public static bool Insert(RawMaterialModel model)
{
var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo);
var @MaterialTypeId = new SqlParameter("@MaterialTypeId", model.MaterialTypeId);
var @ETD = new SqlParameter("@ETD", model.ETD);
var @ActualDate = new SqlParameter("@ActualDate", model.ActualDate);
var @Remarks = new SqlParameter("@Remarks", model.Remarks);
SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities();
if (db.ExecuteStoreCommand("EXEC spm_InsertRawMaterial @ProductNo,@MaterialTypeId,@ETD,@ActualDate,@Remarks", @ProductNo, @MaterialTypeId, @ETD, @ActualDate, @Remarks) > 0)
{
return(true);
}
return(false);
}
public static bool InsertFromExcel(RawMaterialModel model)
{
var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo);
var @MaterialTypeId = new SqlParameter("@MaterialTypeId", model.MaterialTypeId);
var @ETD = new SqlParameter("@ETD", model.ETD);
var @ActualDate = new SqlParameter("@ActualDate", model.ActualDate);
using (var db = new SaovietMasterScheduleEntities())
{
if (db.ExecuteStoreCommand("EXEC spm_InsertRawMaterialFromExcel @ProductNo, @MaterialTypeId, @ETD, @ActualDate",
@ProductNo, @MaterialTypeId, @ETD, @ActualDate) > 0)
{
return(true);
}
return(false);
}
}
private void bwReport_DoWork(object sender, DoWorkEventArgs e)
{
DataTable dt = new DeliveryDataSet().Tables["DeliveryTable"];
List <String> productNoList = rawMaterialList.Select(r => r.ProductNo).Distinct().ToList();
var materialUpperIdList = materialTypeList.Select(s => s.MaterialTypeId).Distinct().ToList();
foreach (string productNo in productNoList)
{
OrdersModel order = orderList.Where(o => o.ProductNo == productNo).FirstOrDefault();
//List<Int32> materialTypeIdList = rawMaterialList.Select(r => r.MaterialTypeId).Distinct().ToList();
List <Int32> materialTypeIdList = rawMaterialList.Where(w => materialUpperIdList.Contains(w.MaterialTypeId)).Select(r => r.MaterialTypeId).Distinct().ToList();
//Red!
//materialTypeIdList.Remove(11);
//materialTypeIdList.Remove(6);
//materialTypeIdList.Remove(12);
//materialTypeIdList.Remove(13);
//materialTypeIdList.Remove(14);
foreach (int materialTypeId in materialTypeIdList)
{
RawMaterialModel rawMaterial = rawMaterialList.Where(r => r.ProductNo == productNo && r.MaterialTypeId == materialTypeId).FirstOrDefault();
if (rawMaterial != null && rawMaterial.ETD.Date != new DateTime(2000, 1, 1) && rawMaterial.ETD.Date == dateSearch.Date &&
rawMaterial.ActualDate.Date == new DateTime(2000, 1, 1))
{
DataRow dr = dt.NewRow();
dr["ProductNo"] = productNo;
if (order != null)
{
dr["ArticleNo"] = order.ArticleNo;
dr["ShoeName"] = order.ShoeName;
dr["Quantity"] = order.Quantity;
dr["ETD"] = order.ETD;
}
dr["SupplierETD"] = rawMaterial.ETD;
dr["Remarks"] = rawMaterial.Remarks;
MaterialTypeModel materialType = materialTypeList.Where(m => m.MaterialTypeId == rawMaterial.MaterialTypeId).FirstOrDefault();
if (materialType != null)
{
dr["Supplier"] = materialType.Name;
}
dt.Rows.Add(dr);
}
}
}
e.Result = dt;
}
public ActionResult RawMaterial(int?id)
{
RawMaterialModel rawMaterialModel = new RawMaterialModel();
if (UserRolePermissionForPage.Add == true || UserRolePermissionForPage.Edit == true)
{
if (id > 0)
{
rawMaterialModel = _iRawMaterialService.GetRawMaterialById(Convert.ToInt32(id));
}
return(View(rawMaterialModel));
}
else
{
return(RedirectToAction("NotFound", "Error"));
}
}
public OutsoleInputMaterialWindow(string productNo, AccountModel account)
{
InitializeComponent();
this.productNo = productNo;
this.account = account;
threadLoadData = new BackgroundWorker();
threadLoadData.WorkerSupportsCancellation = true;
threadLoadData.DoWork += new DoWorkEventHandler(bwLoadData_DoWork);
threadLoadData.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bwLoadData_RunWorkerCompleted);
outsoleSupplierList = new List <OutsoleSuppliersModel>();
sizeRunList = new List <SizeRunModel>();
dt = new DataTable();
outsoleMaterialToInsertList = new List <OutsoleMaterialModel>();
threadInsert = new BackgroundWorker();
threadInsert.DoWork += new DoWorkEventHandler(bwInsert_DoWork);
threadInsert.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bwInsert_RunWorkerCompleted);
outsoleMaterialList = new List <OutsoleMaterialModel>();
dtDefault = new DateTime(2000, 1, 1);
dtNothing = new DateTime(1999, 12, 31);
rawMaterial = new RawMaterialModel
{
ProductNo = productNo,
MaterialTypeId = 6,
ETD = dtNothing,
ActualDate = dtNothing,
Remarks = "",
};
outsoleRawMaterialList = new List <OutsoleRawMaterialModel>();
outsoleSupplierModifiedList = new List <OutsoleSuppliersModel>();
outsoleRawMaterialToInsertList = new List <OutsoleRawMaterialModel>();
outsoleMaterialRackPositionList = new List <OutsoleMaterialRackPositionModel>();
outsoleMaterialRackPositionToInsertList = new List <OutsoleMaterialRackPositionModel>();
outsoleMaterialRackPositionToDeleteList = new List <OutsoleMaterialRackPositionModel>();
threadUpdateRawMaterial = new BackgroundWorker();
threadUpdateRawMaterial.RunWorkerCompleted += new RunWorkerCompletedEventHandler(threadUpdateRawMaterial_RunWorkerCompleted);
threadUpdateRawMaterial.DoWork += new DoWorkEventHandler(threadUpdateRawMaterial_DoWork);
}
public UpperComponentInputMaterialWindow(string productNo)
{
this.productNo = productNo;
sizeRunList = new List <SizeRunModel>();
upperComponentList = new List <UpperComponentModel>();
upperComponentModifiedList = new List <UpperComponentModel>();
upperComponentMaterialList = new List <UpperComponentMaterialModel>();
upperComponentRawMaterialList = new List <UpperComponentRawMaterialModel>();
upperComponentRawMaterialToInsertList = new List <UpperComponentRawMaterialModel>();
upperComponentMaterialToInsertList = new List <UpperComponentMaterialModel>();
threadLoadData = new BackgroundWorker();
threadLoadData.WorkerSupportsCancellation = true;
threadLoadData.DoWork += new DoWorkEventHandler(bwLoadData_DoWork);
threadLoadData.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bwLoadData_RunWorkerCompleted);
threadInsert = new BackgroundWorker();
threadInsert.DoWork += new DoWorkEventHandler(threadInsert_DoWork);
threadInsert.RunWorkerCompleted += new RunWorkerCompletedEventHandler(threadInsert_RunWorkerCompleted);
threadUpdateRawMaterial = new BackgroundWorker();
threadUpdateRawMaterial.DoWork += new DoWorkEventHandler(threadUpdateRawMaterial_DoWork);
threadUpdateRawMaterial.RunWorkerCompleted += new RunWorkerCompletedEventHandler(threadUpdateRawMaterial_RunWorkerCompleted);
dt = new DataTable();
dtDefault = new DateTime(2000, 1, 1);
dtNothing = new DateTime(1999, 12, 31);
rawMaterial = new RawMaterialModel
{
ProductNo = productNo,
MaterialTypeId = 12,
ETD = dtNothing,
ActualDate = dtNothing,
Remarks = "",
};
InitializeComponent();
}
public int InsertRawMaterial(RawMaterialModel rawMaterialModel)
{
int result = 0;
using (SqlConnection con = new SqlConnection(_ConnectionString.Value.ConnectionString))
{
CommonRepository commonRepository = new CommonRepository(_ConnectionString);
result = commonRepository.GetValidateUnique("RawMaterial", "RawMaterialName", rawMaterialModel.RawMaterialName, rawMaterialModel.Id.ToString());
if (result > 0)
{
return(-1);
}
int MaxId = commonRepository.GetMaxId("RawMaterial");
con.Open();
SqlTransaction sqltrans = con.BeginTransaction();
var query = "INSERT INTO RawMaterial (Id,RawMaterialName," +
"Notes, " +
"IsActive,UserIdInserted,DateInserted,IsDeleted)" +
"VALUES (" + MaxId + ",@RawMaterialName," +
"@Notes," +
"@IsActive," + LoginInfo.Userid + ",GetUtcDate(),0); SELECT CAST(SCOPE_IDENTITY() as INT);";
result = con.Execute(query, rawMaterialModel, sqltrans, 0, System.Data.CommandType.Text);
if (result > 0)
{
sqltrans.Commit();
string output = commonRepository.SyncTableStatus("RawMaterial");
}
else
{
sqltrans.Rollback();
}
return(result);
}
}
public int UpdateRawMaterial(RawMaterialModel rawMaterialModel)
{
return(_iRawMaterialRepository.UpdateRawMaterial(rawMaterialModel));
}
public int InsertRawMaterial(RawMaterialModel rawMaterialModel)
{
return(_iRawMaterialRepository.InsertRawMaterial(rawMaterialModel));
}
private void bwLoad_DoWork(object sender, DoWorkEventArgs e)
{
materialTypeList = MaterialTypeController.Select();
Excel.Application excelApplication = new Excel.Application();
Excel.Workbook excelWorkbook = excelApplication.Workbooks.Open(filePath);
//excelApplication.Visible = true;
Excel.Worksheet excelWorksheet;
Excel.Range excelRange;
try
{
excelWorksheet = (Excel.Worksheet)excelWorkbook.Worksheets[1];
excelRange = excelWorksheet.UsedRange;
progressBar.Dispatcher.Invoke((Action)(() => progressBar.Maximum = excelRange.Rows.Count));
for (int i = 3; i <= excelRange.Rows.Count; i++)
{
var productNoValue = (excelRange.Cells[i, 1] as Excel.Range).Value2;
if (productNoValue != null)
{
// column 2,3 = TAIWAN (10)
var taiwanMaterial = new RawMaterialModel();
taiwanMaterial.ProductNo = productNoValue.ToString();
taiwanMaterial.MaterialTypeId = 10;
taiwanMaterial.MaterialTypeName = materialTypeList.FirstOrDefault(w => w.MaterialTypeId == 10) != null?materialTypeList.FirstOrDefault(w => w.MaterialTypeId == 10).Name : "";
taiwanMaterial.ETD = dtDefault;
taiwanMaterial.ActualDate = dtDefault;
var efdTaiwan = (excelRange.Cells[i, 2] as Excel.Range).Value2;
if (efdTaiwan != null)
{
double efd = 0;
Double.TryParse(efdTaiwan.ToString(), out efd);
taiwanMaterial.ETD = DateTime.FromOADate(efd);
}
var actualTaiwan = (excelRange.Cells[i, 3] as Excel.Range).Value2;
if (actualTaiwan != null)
{
double actual = 0;
Double.TryParse(actualTaiwan.ToString(), out actual);
taiwanMaterial.ActualDate = DateTime.FromOADate(actual);
}
if (efdTaiwan != null || actualTaiwan != null)
{
upperMaterialFromExcelList.Add(taiwanMaterial);
}
// Column 4,5 = LAMINATION (1)
var laminationMaterial = new RawMaterialModel();
laminationMaterial.ProductNo = productNoValue.ToString();
laminationMaterial.MaterialTypeId = 1;
laminationMaterial.MaterialTypeName = materialTypeList.FirstOrDefault(w => w.MaterialTypeId == 1) != null?materialTypeList.FirstOrDefault(w => w.MaterialTypeId == 1).Name : "";
laminationMaterial.ETD = dtDefault;
laminationMaterial.ActualDate = dtDefault;
var efdLamination = (excelRange.Cells[i, 4] as Excel.Range).Value2;
if (efdLamination != null)
{
double efd = 0;
Double.TryParse(efdLamination.ToString(), out efd);
laminationMaterial.ETD = DateTime.FromOADate(efd);
}
var actualLamination = (excelRange.Cells[i, 5] as Excel.Range).Value2;
if (actualLamination != null)
{
double actual = 0;
Double.TryParse(actualLamination.ToString(), out actual);
laminationMaterial.ActualDate = DateTime.FromOADate(actual);
}
if (efdLamination != null || actualLamination != null)
{
upperMaterialFromExcelList.Add(laminationMaterial);
}
// Column 6,7 = CUTTING (1)
var cuttingMaterial = new RawMaterialModel();
cuttingMaterial.ProductNo = productNoValue.ToString();
cuttingMaterial.MaterialTypeId = 2;
cuttingMaterial.MaterialTypeName = materialTypeList.FirstOrDefault(w => w.MaterialTypeId == 2) != null?materialTypeList.FirstOrDefault(w => w.MaterialTypeId == 2).Name : "";
cuttingMaterial.ETD = dtDefault;
cuttingMaterial.ActualDate = dtDefault;
var efdCutting = (excelRange.Cells[i, 6] as Excel.Range).Value2;
if (efdCutting != null)
{
double efd = 0;
Double.TryParse(efdCutting.ToString(), out efd);
cuttingMaterial.ETD = DateTime.FromOADate(efd);
}
var actualCutting = (excelRange.Cells[i, 7] as Excel.Range).Value2;
if (actualCutting != null)
{
double actual = 0;
Double.TryParse(actualCutting.ToString(), out actual);
cuttingMaterial.ActualDate = DateTime.FromOADate(actual);
}
if (efdCutting != null || actualCutting != null)
{
upperMaterialFromExcelList.Add(cuttingMaterial);
}
// Column 8,9 = LEATHER (1)
var leatherMaterial = new RawMaterialModel();
leatherMaterial.ProductNo = productNoValue.ToString();
leatherMaterial.MaterialTypeId = 3;
leatherMaterial.MaterialTypeName = materialTypeList.FirstOrDefault(w => w.MaterialTypeId == 3) != null?materialTypeList.FirstOrDefault(w => w.MaterialTypeId == 3).Name : "";
leatherMaterial.ETD = dtDefault;
leatherMaterial.ActualDate = dtDefault;
var efdLeather = (excelRange.Cells[i, 8] as Excel.Range).Value2;
if (efdLeather != null)
{
double efd = 0;
Double.TryParse(efdLeather.ToString(), out efd);
leatherMaterial.ETD = DateTime.FromOADate(efd);
}
var actualLeather = (excelRange.Cells[i, 9] as Excel.Range).Value2;
if (actualLeather != null)
{
double actual = 0;
Double.TryParse(actualLeather.ToString(), out actual);
leatherMaterial.ActualDate = DateTime.FromOADate(actual);
}
if (efdLeather != null || actualLeather != null)
{
upperMaterialFromExcelList.Add(leatherMaterial);
}
// Column 10, 11 = SEMIPROCESS (1)
var semiprocessMaterial = new RawMaterialModel();
semiprocessMaterial.ProductNo = productNoValue.ToString();
semiprocessMaterial.MaterialTypeId = 4;
semiprocessMaterial.MaterialTypeName = materialTypeList.FirstOrDefault(w => w.MaterialTypeId == 4) != null?materialTypeList.FirstOrDefault(w => w.MaterialTypeId == 4).Name : "";
semiprocessMaterial.ETD = dtDefault;
semiprocessMaterial.ActualDate = dtDefault;
var efdSemiprocess = (excelRange.Cells[i, 10] as Excel.Range).Value2;
if (efdSemiprocess != null)
{
double efd = 0;
Double.TryParse(efdSemiprocess.ToString(), out efd);
semiprocessMaterial.ETD = DateTime.FromOADate(efd);
}
var actualSemiprocess = (excelRange.Cells[i, 11] as Excel.Range).Value2;
if (actualSemiprocess != null)
{
double actual = 0;
Double.TryParse(actualSemiprocess.ToString(), out actual);
semiprocessMaterial.ActualDate = DateTime.FromOADate(actual);
}
if (efdSemiprocess != null || actualSemiprocess != null)
{
upperMaterialFromExcelList.Add(semiprocessMaterial);
}
// Column 12, 13 = SEWING (1)
var sewingMaterial = new RawMaterialModel();
sewingMaterial.ProductNo = productNoValue.ToString();
sewingMaterial.MaterialTypeId = 5;
sewingMaterial.MaterialTypeName = materialTypeList.FirstOrDefault(w => w.MaterialTypeId == 5) != null?materialTypeList.FirstOrDefault(w => w.MaterialTypeId == 5).Name : "";
sewingMaterial.ETD = dtDefault;
sewingMaterial.ActualDate = dtDefault;
var efdSewing = (excelRange.Cells[i, 12] as Excel.Range).Value2;
if (efdSewing != null)
{
double efd = 0;
Double.TryParse(efdSewing.ToString(), out efd);
sewingMaterial.ETD = DateTime.FromOADate(efd);
}
var actualSewing = (excelRange.Cells[i, 13] as Excel.Range).Value2;
if (actualSewing != null)
{
double actual = 0;
Double.TryParse(actualSewing.ToString(), out actual);
sewingMaterial.ActualDate = DateTime.FromOADate(actual);
}
if (efdSewing != null || actualSewing != null)
{
upperMaterialFromExcelList.Add(sewingMaterial);
}
// Column 14,15 = SECURITY LABEL (1)
var securitylabelMaterial = new RawMaterialModel();
securitylabelMaterial.ProductNo = productNoValue.ToString();
securitylabelMaterial.MaterialTypeId = 7;
securitylabelMaterial.MaterialTypeName = materialTypeList.FirstOrDefault(w => w.MaterialTypeId == 7) != null?materialTypeList.FirstOrDefault(w => w.MaterialTypeId == 7).Name : "";
securitylabelMaterial.ETD = dtDefault;
securitylabelMaterial.ActualDate = dtDefault;
var efdSecuritylabel = (excelRange.Cells[i, 14] as Excel.Range).Value2;
if (efdSecuritylabel != null)
{
double efd = 0;
Double.TryParse(efdSecuritylabel.ToString(), out efd);
securitylabelMaterial.ETD = DateTime.FromOADate(efd);
}
var actualSecuritylabel = (excelRange.Cells[i, 15] as Excel.Range).Value2;
if (actualSecuritylabel != null)
{
double actual = 0;
Double.TryParse(actualSecuritylabel.ToString(), out actual);
securitylabelMaterial.ActualDate = DateTime.FromOADate(actual);
}
if (efdSecuritylabel != null || actualSecuritylabel != null)
{
upperMaterialFromExcelList.Add(securitylabelMaterial);
}
// Column 16,17 = ASSEMBLY (1)
var assemblyMaterial = new RawMaterialModel();
assemblyMaterial.ProductNo = productNoValue.ToString();
assemblyMaterial.MaterialTypeId = 8;
assemblyMaterial.MaterialTypeName = materialTypeList.FirstOrDefault(w => w.MaterialTypeId == 8) != null?materialTypeList.FirstOrDefault(w => w.MaterialTypeId == 8).Name : "";
assemblyMaterial.ETD = dtDefault;
assemblyMaterial.ActualDate = dtDefault;
var efdAssembly = (excelRange.Cells[i, 16] as Excel.Range).Value2;
if (efdAssembly != null)
{
double efd = 0;
Double.TryParse(efdAssembly.ToString(), out efd);
assemblyMaterial.ETD = DateTime.FromOADate(efd);
}
var actualAssembly = (excelRange.Cells[i, 17] as Excel.Range).Value2;
if (actualAssembly != null)
{
double actual = 0;
Double.TryParse(actualAssembly.ToString(), out actual);
assemblyMaterial.ActualDate = DateTime.FromOADate(actual);
}
if (efdAssembly != null || actualAssembly != null)
{
upperMaterialFromExcelList.Add(assemblyMaterial);
}
// Column 18,19 = SOCKLINING (1)
var sockliningMaterial = new RawMaterialModel();
sockliningMaterial.ProductNo = productNoValue.ToString();
sockliningMaterial.MaterialTypeId = 9;
sockliningMaterial.MaterialTypeName = materialTypeList.FirstOrDefault(w => w.MaterialTypeId == 9) != null?materialTypeList.FirstOrDefault(w => w.MaterialTypeId == 9).Name : "";
sockliningMaterial.ETD = dtDefault;
sockliningMaterial.ActualDate = dtDefault;
var efdSocklining = (excelRange.Cells[i, 18] as Excel.Range).Value2;
if (efdSocklining != null)
{
double efd = 0;
Double.TryParse(efdSocklining.ToString(), out efd);
sockliningMaterial.ETD = DateTime.FromOADate(efd);
}
var actualSocklining = (excelRange.Cells[i, 19] as Excel.Range).Value2;
if (actualSocklining != null)
{
double actual = 0;
Double.TryParse(actualSocklining.ToString(), out actual);
sockliningMaterial.ActualDate = DateTime.FromOADate(actual);
}
if (efdSocklining != null || actualSocklining != null)
{
upperMaterialFromExcelList.Add(sockliningMaterial);
}
//upperMaterialFromExcelList.Add(taiwanMaterial);
//upperMaterialFromExcelList.Add(laminationMaterial);
//upperMaterialFromExcelList.Add(cuttingMaterial);
//upperMaterialFromExcelList.Add(leatherMaterial);
//upperMaterialFromExcelList.Add(semiprocessMaterial);
//upperMaterialFromExcelList.Add(sewingMaterial);
//upperMaterialFromExcelList.Add(securitylabelMaterial);
//upperMaterialFromExcelList.Add(assemblyMaterial);
//upperMaterialFromExcelList.Add(sockliningMaterial);
progressBar.Dispatcher.Invoke((Action)(() => progressBar.Value = i - 2));
}
}
}
catch
{
upperMaterialFromExcelList.Clear();
}
finally
{
excelWorkbook.Close(false, Missing.Value, Missing.Value);
excelApplication.Quit();
}
}
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);
}
}
