private void SelectDataRowNewPart() { if (this.SelectedRowNewPart != null) { if (SelectedRowNewPart.IsNotNullOrEmpty()) { NewPartNo = this.SelectedRowNewPart["PART_NO"].ToString(); } if (NewPartNo.IsNotNullOrEmpty()) { NewRouteNoDetails = cpyBll.GetRouteNoDetailsByPartNo(NewRouteNoDetails, NewPartNo); } } }
public void DataValidation() { try { DataTable dtRecordCount; int estcount = 0; int actcount = 0; bool dataCopied = false; IsNewPartNoReadonly = false; ButtonVisibleNewPartNumber = Visibility.Collapsed; imgPrdMaster = Visibility.Hidden; ImgProcessSheetHeader = Visibility.Hidden; ImgProcessSheet = Visibility.Hidden; ImgProcessSheetCC = Visibility.Hidden; ImgToolScheduleHeader = Visibility.Hidden; ImgToolScheduleDetails = Visibility.Hidden; imgControlPlan = Visibility.Hidden; imgProductDrawing = Visibility.Hidden; imgSequenceDrawing = Visibility.Hidden; if (OldPartNo.Trim() == "") { ShowInformationMessage(PDMsg.NotEmpty("Old PartNo")); return; } else { dtRecordCount = cpyBll.GetRecordCount("part_no", "prd_mast", OldPartNo); if (dtRecordCount.Rows.Count == 0) { ShowInformationMessage(PDMsg.EnterValid("Old PartNo")); return; } } if (NewPartNo.Trim() == "") { ShowInformationMessage(PDMsg.NotEmpty("New PartNo")); return; } else { if (IschkPrdMast == false) { dtRecordCount = cpyBll.GetRecordCount("part_no", "prd_mast", NewPartNo); if (dtRecordCount.Rows.Count == 0) { ShowInformationMessage(PDMsg.EnterValid("New PartNo")); return; } } } //if (newPartNo.Trim() == oldPartNo.Trim()) //{ // ShowInformationMessage("Old Part No. and New Part No. Should not be Same!"); // return; //} if (IschkProcessSheet == true) { if (cpyProcess.RecordsCountProcessSheet(OldPartNo, OldRouteNo.ToIntValue(), OldSeqNo.ToDecimalValue(), OldCCSno.ToDecimalValue(), OldShNo.ToDecimalValue()) == 0) { ShowInformationMessage("Process sheet Data not available to Copy."); return; } } if (IschkToolSchedule == true) { if (cpyProcess.RecordsCountToolSched(OldPartNo, OldRouteNo.ToIntValue(), OldSeqNo.ToDecimalValue(), OldCCSno.ToDecimalValue(), OldShNo.ToDecimalValue()) == 0) { IschkToolSchedule = false; ShowInformationMessage("Tool schedule Data not available to Copy."); //return; } } if (IschkControlPlan == true) { if (VarProcess == "ProductMaster" && NewRouteNo.Trim() == "" && OldRouteNo.Trim() == "") { newRouteNo = oldRouteNo = Convert.ToString(cpyProcess.GetCurrentProcessByPartNumber(new PROCESS_MAIN() { PART_NO = oldPartNo.Trim() }).ROUTE_NO); if (NewRouteNo.Trim() == "" && OldRouteNo.Trim() == "" || (NewRouteNo.Trim() == "-999999" && OldRouteNo.Trim() == "-999999")) { ShowInformationMessage(PDMsg.DoesNotExists("Current Process")); return; } } if (NewRouteNo.Trim() == "" && OldRouteNo.Trim() == "") { ShowInformationMessage(PDMsg.NormalString("Enter New Process No and Old Process No")); return; } if (NewRouteNo.Trim() == "" && OldRouteNo.Trim() != "") { ShowInformationMessage(PDMsg.NormalString("Enter New Process No")); return; } if (NewRouteNo.Trim() != "" && OldRouteNo.Trim() == "") { ShowInformationMessage(PDMsg.NormalString("Enter Old Process No")); return; } } else { if (NewRouteNo.Trim() == "" && OldRouteNo.Trim() != "") { ShowInformationMessage(PDMsg.NormalString("Enter New Process No or remove Old Process No")); return; } } if (NewSeqNo.Trim() == "" && OldSeqNo.Trim() != "") { ShowInformationMessage(PDMsg.NormalString("Enter New Sequence No or remove Old Sequence No")); return; } if (NewCCSno.Trim() == "" && OldCCSno.Trim() != "") { ShowInformationMessage(PDMsg.NormalString("Enter New Cost Centre no or remove Old Cost Centre No")); return; } if (NewCCSno.Trim() == "" && OldCCSno.Trim() != "") { ShowInformationMessage(PDMsg.NormalString("Enter New Cost Centre no or remove Old Cost Centre No")); return; } int x = 0; if (IschkPrdMast == true) { estcount = estcount + 1; x = cpyProcess.CopyProductData_prdMaster(OldPartNo, NewPartNo); if (x == 1) { imgPrdMaster = Visibility.Visible; dataCopied = true; actcount = actcount + 1; } } if (IschkProcessSheet == true) { estcount = estcount + 1; x = cpyProcess.CopyProductData_Process_main(OldPartNo, NewPartNo, OldRouteNo, NewRouteNo); if (x == 1) { ImgProcessSheetHeader = Visibility.Visible; dataCopied = true; actcount = actcount + 1; } estcount = estcount + 1; x = cpyProcess.CopyProductData_Process_sheet(OldPartNo, NewPartNo, OldRouteNo, NewRouteNo, OldSeqNo, NewSeqNo); if (x == 1) { ImgProcessSheet = Visibility.Visible; dataCopied = true; actcount = actcount + 1; } estcount = estcount + 1; x = cpyProcess.CopyProcessCostCenter(OldPartNo, NewPartNo, OldRouteNo.ToIntValue(), NewRouteNo.ToIntValue(), OldSeqNo.ToDecimalValue(), NewSeqNo.ToDecimalValue(), OldCCSno.ToIntValue(), NewCCSno.ToIntValue()); if (x == 1) { ImgProcessSheetCC = Visibility.Visible; dataCopied = true; actcount = actcount + 1; } } if (IschkToolSchedule == true) { estcount = estcount + 1; x = cpyProcess.CopyProductData_Tool_Sched_Main(oldPartNo, NewPartNo, OldRouteNo, NewRouteNo, OldSeqNo, NewSeqNo, OldCCSno, NewCCSno, OldShNo, NewShNo); if (x == 1) { ImgToolScheduleHeader = Visibility.Visible; dataCopied = true; actcount = actcount + 1; } estcount = estcount + 1; x = cpyProcess.CopyProductData_Tool_Sched_Sub(oldPartNo, NewPartNo, OldRouteNo, NewRouteNo, OldSeqNo, NewSeqNo, OldCCSno, NewCCSno, OldShNo, NewShNo); if (x == 1) { ImgToolScheduleDetails = Visibility.Visible; dataCopied = true; actcount = actcount + 1; } } if (IschkControlPlan == true) { // x = cpyProcess.CopyProcessSheet(OldPartNo, NewPartNo, OldRouteNo.ToIntValue(), NewRouteNo.ToIntValue(), OldSeqNo.ToDecimalValue(), NewSeqNo.ToDecimalValue()); estcount = estcount + 1; x = cpyProcess.CopyProductData_PCCS(OldPartNo, NewPartNo, OldRouteNo, NewRouteNo, OldSeqNo, NewSeqNo); ButtonVisibleNewPartNumber = Visibility.Collapsed; if (x == 1) { imgControlPlan = Visibility.Visible; dataCopied = true; actcount = actcount + 1; } else if (x == -1) { cpyProcess = new CopyProcess(userinformation); // ShowInformationMessage("Matching Sequence No is not available in Process Sheet"); } } if (ischkDrawings == true) { // x = cpyProcess.CopyProductData_PROD_DRAWING(OldPartNo, NewPartNo); estcount = estcount + 1; x = cpyProcess.CopyProductData_PRD_DRAWING(OldPartNo, NewPartNo, 0); if (x == 1) { imgProductDrawing = Visibility.Visible; dataCopied = true; actcount = actcount + 1; } estcount = estcount + 1; x = cpyProcess.CopyProductData_PRD_DRAWING(OldPartNo, NewPartNo, 1); if (x == 1) { imgSequenceDrawing = Visibility.Visible; dataCopied = true; actcount = actcount + 1; } } if (estcount > 0) { if (estcount == actcount) { ShowInformationMessage("Data successfully copied!"); } else if (actcount > 0) { ShowInformationMessage("Partial data successfully copied!"); } else { ShowInformationMessage("Data not copied!"); } } else { ShowInformationMessage("Data not copied!"); } //if (dataCopied == true) //{ // ShowInformationMessage("Data successfully copied!"); //} // private PCCS _activeEntity = null; //public PCCS ActiveEntity //{ // get // { // return _activeEntity; // } // set // { // _activeEntity = value; // NotifyPropertyChanged("ActiveEntity"); // } //} } catch (Exception ex) { throw ex.LogException(); } }