private void PopulateCustomers() { if (cboPurpose.SelectedIndex > -1) { cboCustomer.ItemsSource = null; if (cboPurpose.SelectedValue.ToString().Trim() == "SC" || cboPurpose.SelectedValue.ToString().Trim() == "XX") { cboCustomer.ItemsSource = ClsPEZAData.GetSubContractorListFromCustomerMaster().DefaultView; cboCustomer.SelectedIndex = 0; int id = Convert.ToInt32(cboCustomer.SelectedValue.ToString().Trim()); foreach (DataRow dr in ClsCantierDB.GetVendorAddress(id).Rows) { tbCustomerAddress.Text = dr["Address"].ToString().Trim(); } } else { cboCustomer.ItemsSource = ClsCantierDB.GetCustomerList().DefaultView; cboCustomer.SelectedIndex = 0; int id = Convert.ToInt32(cboCustomer.SelectedValue.ToString().Trim()); foreach (DataRow dr1 in ClsCantierDB.GetCustomerAddress(id).Rows) { tbCustomerAddress.Text = dr1["Address"].ToString().Trim(); } } } }
private void ShowTRC_Sample() { foreach (DataRow dr in ClsCantierDB.Sohbi_GetLotCard4PrintingNew(_g_lotno).Rows) { RenderQrCode(dr["OuterLotCardNo"].ToString().Trim(), dr["QRcode"].ToString().Trim()); } LotCardLabel_Report_TRC frm = new LotCardLabel_Report_TRC(); frm._formNos = _g_lotno; frm._reportType = "Sample"; frm.WindowStartupLocation = WindowStartupLocation.CenterScreen; frm.Height = frmSize_Height; frm.Width = frmSize_Width; frm.WindowState = WindowState.Normal; frm.ResizeMode = ResizeMode.CanResize; frm.Show(); }
private void CboCustomer_SelectionChanged(object sender, SelectionChangedEventArgs e) { try { if (cboCustomer.SelectedIndex != -1) { int id = Convert.ToInt32(cboCustomer.SelectedValue.ToString().Trim()); foreach (DataRow dr in ClsCantierDB.GetCustomerAddress(id).Rows) { tbCustomerAddress.Text = dr["Address"].ToString().Trim(); } PopulateLOA(); PopulateAvailableInvoices(); GroupLOA.IsEnabled = true; } } catch { } }
private void PopulateFields(string formNo) { foreach (DataRow dr in ClsPEZAData.Get8106formByNo(formNo).Rows) { _customerid = Convert.ToInt16(dr["8106client"]); foreach (DataRow dr1 in ClsCantierDB.GetCustomerAddress(Convert.ToInt32(dr["8106client"])).Rows) { tbCustomerName.Text = dr1["Name"].ToString().Trim(); } if (!dr.IsNull("8106estQty")) { tbEstimatedQuantity.Text = Convert.ToDecimal(dr["8106estQty"]).ToString("#,##0"); } if (!dr.IsNull("8106estAmt")) { tbEstimatedAmount.Text = Convert.ToDecimal(dr["8106estAmt"]).ToString("#,##0.00"); } if (!dr.IsNull("BoatNote")) { tbBoatNote.Text = dr["BoatNote"].ToString().Trim(); } } }
private void FillDataSources() { PopulateCustomers(); PopulateMonthAndYear(); PopulateSKPIsignatories(); PopulateTypeAndPurpose(); PopulatePEZAsignatories(); cboCurrency.ItemsSource = ClsPEZAData.GetCurrencyList().DefaultView; cbo8106ItemDescription.ItemsSource = ClsPEZAData.GetPEZAitemsList().DefaultView; cboLOAEstimatedUOM.ItemsSource = ClsCantierDB.GetUOM().DefaultView; PopulateList(); grid8106.SelectedItems.Clear(); tbPEZAPermitNo.Text = string.Empty; tbORNo.Text = "0"; tb8106ItemNo.Text = "1"; }
private void ShowEPPI_Replacement() { foreach (DataRow dr in ClsCantierDB.Sohbi_GetLotCard4PrintingNew(_g_lotno).Rows) { RenderQrCode(dr["OuterLotCardNo"].ToString().Trim(), dr["QRcode"].ToString().Trim()); } if (ClsCantierDB.Sohbi_GetEPPIinsideLotCards4Printing(_g_lotno).Rows.Count > 0) { foreach (DataRow dr in ClsCantierDB.Sohbi_GetEPPIinsideLotCards4Printing(_g_lotno).Rows) { RenderQrCode(dr["OuterLotCardNo"].ToString().Trim() + "-" + dr["InnerLotCardNo"].ToString().Trim(), dr["QRcode"].ToString().Trim()); } } LotCardLabel_Report_EPPI frm = new LotCardLabel_Report_EPPI(); frm._formNos = _g_lotno; frm._reportType = "Replacement"; frm.WindowStartupLocation = WindowStartupLocation.CenterScreen; frm.Height = frmSize_Height; frm.Width = frmSize_Width; frm.WindowState = WindowState.Normal; frm.ResizeMode = ResizeMode.CanResize; frm.Show(); }
private void CboCustomer_SelectionChanged(object sender, SelectionChangedEventArgs e) { try { int id = Convert.ToInt32(cboCustomer.SelectedValue.ToString().Trim()); foreach (DataRow dr in ClsCantierDB.GetVendorAddress(id).Rows) { tbAddress.Text = dr["Address"].ToString().Trim(); } DeleteUnSavedItems(); FillRRGrid(Convert.ToInt16(id)); FillItems(tbPEZAFormNumber.Text.Trim()); } catch (Exception ex) { } }
private void PopulateFilterCustomer() { if (cboFilterPurpose.SelectedIndex > -1) { cboFilterCustomer.ItemsSource = null; if (cboFilterPurpose.SelectedValue.ToString().Trim() == "SC" || cboFilterPurpose.SelectedValue.ToString().Trim() == "XX") { cboFilterCustomer.ItemsSource = ClsPEZAData.GetSubContractorListFromCustomerMaster().DefaultView; cboFilterCustomer.SelectedIndex = 0; } else { cboFilterCustomer.ItemsSource = ClsCantierDB.GetCustomerList().DefaultView; cboFilterCustomer.SelectedIndex = 0; } } }
private void CboCustomer_SelectionChanged(object sender, SelectionChangedEventArgs e) { if (cboCustomer.SelectedIndex != -1) { int id = Convert.ToInt32(cboCustomer.SelectedValue.ToString().Trim()); if (ClsCantierDB.GetVendorAddress(id).Rows.Count == 0) { foreach (DataRow dr1 in ClsCantierDB.GetCustomerAddress(id).Rows) { tbCustomerAddress.Text = dr1["Address"].ToString().Trim(); } } else { foreach (DataRow dr in ClsCantierDB.GetVendorAddress(id).Rows) { tbCustomerAddress.Text = dr["Address"].ToString().Trim(); } } } }
private void BtnSave_Click(object sender, RoutedEventArgs e) { Int32 _CustID = Convert.ToInt32(ClsCantierDB.GetCustomerByCode(customercode).Rows[0][0].ToString().Trim()); SqlCommand cmd = new SqlCommand("ChangeFGLocation"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@RackNo", location); cmd.Parameters.AddWithValue("@NewRackNo", cboNewRack.SelectedValue.ToString().Trim()); cmd.Parameters.AddWithValue("@Cust_ID", _CustID); cmd.Parameters.AddWithValue("@PartCode", partcode); cmd.Parameters.AddWithValue("@LotNo", lotno); SqlHelper.ExecuteNonQuery(ClsConfig.Cantier_LotCardLabelConnectionString, cmd); MessageBox.Show("Location Successfully Changed."); this.Close(); }
private void Window_Loaded(object sender, RoutedEventArgs e) { PopulateCustomers(); gridNGDetails.ItemsSource = ClsCantierDB.GetFGInventory(Convert.ToInt16(cboCustomer.SelectedValue.ToString().Trim())).DefaultView; }
private void PopulateCustomers() { cboCustomer.ItemsSource = ClsCantierDB.GetCustomerList().DefaultView; cboCustomer.SelectedIndex = 0; }
private void CboCustomer_SelectionChanged(object sender, SelectionChangedEventArgs e) { gridNGDetails.ItemsSource = ClsCantierDB.GetFGInventory(Convert.ToInt16(cboCustomer.SelectedValue.ToString().Trim())).DefaultView; }
private Boolean _validateIfPrinted() { SqlCommand cmd = new SqlCommand("SELECT ISNULL(count(*),0) FROM tblLotCardGroup WHERE LotCardGroupNo=@LotCardNo AND IsPrinted = 1"); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@LotCardNo", _formNos.ToString().Trim()); if (Convert.ToInt32(SqlHelper.ExecuteScalar(ClsConfig.Cantier_LotCardLabelConnectionString, cmd)) > 0) { MessageBoxResult messageBoxResult = MessageBox.Show("This lot card was already printed. Are you sure you want to print it again?" , "Confirmation", MessageBoxButton.YesNo); if (messageBoxResult == MessageBoxResult.Yes) { //reportViewer.ViewerCore.PrintReport(); if (ClsCantierDB.Sohbi_GetInsideLotCards4PrintingNew(_formNos.ToString().Trim()).Rows.Count > 0) { //PrinterSettings settings = new PrinterSettings(); //string defaultPrinterName = settings.PrinterName; //MessageBox.Show(defaultPrinterName); PrintData(docA, docB, 1, 0, 0); MessageBox.Show("Record Successfully Printed"); this.Close(); } else { //PrinterSettings settings = new PrinterSettings(); //string defaultPrinterName = settings.PrinterName; //MessageBox.Show(defaultPrinterName); PrintData2(docA, 1, 0, 0); MessageBox.Show("Record Successfully Printed"); this.Close(); } } else { } } else { SqlCommand cmd2 = new SqlCommand( "UPDATE [dbo].[tblLotCardGroup] SET IsPrinted = 1 WHERE LotCardGroupNo=@LotCardNo"); cmd2.CommandType = CommandType.Text; cmd2.Parameters.AddWithValue("@LotCardNo", _formNos.ToString().Trim()); SqlHelper.ExecuteNonQuery(ClsConfig.Cantier_LotCardLabelConnectionString, cmd2); //reportViewer.ViewerCore.PrintReport(); if (ClsCantierDB.Sohbi_GetInsideLotCards4PrintingNew(_formNos.ToString().Trim()).Rows.Count > 0) { //PrinterSettings settings = new PrinterSettings(); //string defaultPrinterName = settings.PrinterName; PrintData(docA, docB, 1, 0, 0); MessageBox.Show("Record Successfully Printed"); this.Close(); //MessageBox.Show(defaultPrinterName); } else { //PrinterSettings settings = new PrinterSettings(); //string defaultPrinterName = settings.PrinterName; //MessageBox.Show(defaultPrinterName); PrintData2(docA, 1, 0, 0); MessageBox.Show("Record Successfully Printed"); this.Close(); } } return(true); }
private void PopulateUOM() { cboUOM.ItemsSource = ClsCantierDB.GetUOM().DefaultView; cboUOM.SelectedIndex = 0; }
private void BtnGenerate_Click(object sender, RoutedEventArgs e) { gridNGDetails.ItemsSource = ClsCantierDB.GetFGInventory(Convert.ToInt16(cboCustomer.SelectedValue.ToString().Trim())).DefaultView; MessageBox.Show("Records successfully refreshed"); }
private Boolean _SaveFG() { string value = string.Empty; Boolean _validateFields = false; _validateFields = ValidateFields(); if (!_validateFields) { return(false); } value = tbLotCardNo.Text.Trim(); tbLotCardNo.Clear(); tbLotCardNo.Focus(); //if (!string.IsNullOrEmpty(lotGroupNo.ToUpper())) //{ // Boolean _CheckIfSameGroupNo = false; // _CheckIfSameGroupNo = CheckIfSameGroupNo(value.ToUpper()); // if (!_CheckIfSameGroupNo) // return false; //} string data = string.Empty; string data2 = string.Empty; if (value.ToUpper().Replace(@"\", "|").Contains("|Z6") && value.Replace(@"\", "|").ToUpper().Contains("EPPI")) { DataTable table = new DataTable(); table.Clear(); foreach (var column in table.Columns.Cast <DataColumn>().ToArray()) { if (table.AsEnumerable().All(dr => dr.IsNull(column))) { table.Columns.Remove(column); } } DataColumn colID = table.Columns.Add("LotCardNo", typeof(string)); string[] list = value.ToUpper().Replace(@"\", "|").Split('|'); foreach (string author in list) { DataRow row = table.NewRow(); row[0] = author; table.Rows.Add(row); } tbLastScannedLotCard.Text = table.Rows[6][0].ToString().ToUpper().Replace("Z6", ""); sLotCardRefNo = tbLastScannedLotCard.Text.Trim().ToUpper(); } else if (!value.ToUpper().Replace(@"\", "|").Contains("|Z6") && value.Contains("EPPI-")) { tbLastScannedLotCard.Text = value.ToUpper(); sLotCardRefNo = tbLastScannedLotCard.Text.ToUpper(); tbLotCardNo.Focus(); } else { tbLastScannedLotCard.Text = value.ToUpper(); sLotCardRefNo = tbLastScannedLotCard.Text.ToUpper(); tbLotCardNo.Focus(); var count = sLotCardRefNo.Count(x => x == '-'); if (count > 4) { MessageBox.Show("Invalid Barcode Format. Please try again.", "Invalid Barcode"); sLotCardRefNo = string.Empty; tbLotCardNo.Focus(); return(false); } } var count2 = sLotCardRefNo.Count(x => x == '-'); if (count2 == 4) { var input = sLotCardRefNo.Trim(); var outerlot = SplitForward(input, '-', 3).ToArray(); var innerlot = SplitForward(input, '-', 4).ToArray(); foreach (string author in outerlot) { data = author; } foreach (string author in innerlot) { data2 = author; } lotGroupNo = sLotCardRefNo.Replace("-" + data + "-" + data2, "").Replace("Z6", "").ToUpper(); } else { data2 = string.Empty; var input = sLotCardRefNo.Trim(); var forwards = SplitForward(input, '-', 3).ToArray(); string[] ssd = forwards; foreach (string author in ssd) { data = author; } lotGroupNo = sLotCardRefNo.Replace("-" + data, "").Replace("Z6", "").ToUpper(); } Boolean _CheckIfScannedByQC = false; _CheckIfScannedByQC = CheckIfScannedByQC(sLotCardRefNo); if (!_CheckIfScannedByQC) { return(false); } Boolean _CheckIfReceivedByPMC = false; _CheckIfReceivedByPMC = CheckIfReceivedByPMC(sLotCardRefNo); if (!_CheckIfReceivedByPMC) { return(false); } Boolean _CheckIfDelivered = false; _CheckIfDelivered = CheckIfDelivered(sLotCardRefNo); if (!_CheckIfDelivered) { return(false); } Boolean _CheckIfLotcardControlNoReturned2ProductionAndReinspected = false; _CheckIfLotcardControlNoReturned2ProductionAndReinspected = CheckIfLotcardControlNoReturned2ProductionAndReinspected(sLotCardRefNo); if (!_CheckIfLotcardControlNoReturned2ProductionAndReinspected) { return(false); } DataTable dt; if (count2 == 4) { dt = ClsCantierDB.Sohbi_GetInnerLotCardBarcodeDetails(lotGroupNo, data, data2); } else { dt = ClsCantierDB.Sohbi_GetLotCardGroupBarcodeDetails(lotGroupNo, data); } string lmonth = string.Empty, lyear = string.Empty, lday = string.Empty; foreach (DataRow dr in dt.Rows) { lCust_ID = Convert.ToInt32(dr["CustomerID"]); sCustName = dr["CustomerName"].ToString().Trim(); sPartCode = dr["ItemCode"].ToString().Trim(); sPartRevNo = dr["ItemRevNo"].ToString().Trim(); sPartName = dr["ItemDescription"].ToString().Trim(); sJONumber = dr["JobOrderNo"].ToString().Trim(); lQtyPerBox = count2 == 4 ? Convert.ToInt32(dr["InsideBoxQty"]) : Convert.ToInt32(dr["SPQ"]); sdestination = dr["Destination"].ToString().Trim(); if (dr.IsNull("SohbiLotNo") || string.IsNullOrEmpty(dr["SohbiLotNo"].ToString().Trim())) { lyear = Convert.ToDateTime(dr["ManufactureDate"]).Year.ToString() .Substring(Convert.ToDateTime(dr["ManufactureDate"]).Year.ToString().Length - 1); if (Convert.ToDateTime(dr["ManufactureDate"]).Month >= 1 && Convert.ToDateTime(dr["ManufactureDate"]).Month <= 9) { lmonth = Convert.ToDateTime(dr["ManufactureDate"]).Month.ToString() .Substring(Convert.ToDateTime(dr["ManufactureDate"]).Month.ToString().Length - 1); } else if (Convert.ToDateTime(dr["ManufactureDate"]).Month == 10) { lmonth = "X"; } else if (Convert.ToDateTime(dr["ManufactureDate"]).Month == 11) { lmonth = "Y"; } else if (Convert.ToDateTime(dr["ManufactureDate"]).Month == 12) { lmonth = "Z"; } if (Convert.ToDateTime(dr["ManufactureDate"]).Day >= 1 && Convert.ToDateTime(dr["ManufactureDate"]).Day <= 9) { lday = "0" + Convert.ToDateTime(dr["ManufactureDate"]).Day.ToString() .Substring(Convert.ToDateTime(dr["ManufactureDate"]).Day.ToString().Length - 1); } else { lday = Convert.ToDateTime(dr["ManufactureDate"]).Day.ToString().Substring(0, 1) + Convert.ToDateTime(dr["ManufactureDate"]).Day.ToString() .Substring(Convert.ToDateTime(dr["ManufactureDate"]).Day.ToString().Length - 1); } sLotNumber = lyear + lmonth + lday + "A"; } else { sLotNumber = dr["SohbiLotNo"].ToString().Trim(); } sHistoryNo = dr["HistoryNo"].ToString().Trim(); } SaveFG(); FillGrid(lotGroupNo); //MessageBox.Show(sLotCardRefNo); return(true); }
private void LoadLists() { gridEmployee.ItemsSource = ClsCantierDB.GetUserAccounts().DefaultView; }
private void PopulateFields(string _loaNo) { ClearFields(); foreach (DataRow dr in ClsPEZAData.GetLOArequestByNumber(_loaNo).Rows) { tbLOANo.Text = dr["LOAno"].ToString().Trim(); dateEncoded.SelectedDate = Convert.ToDateTime(dr["LOAdate"]); cboPurpose.SelectedValue = dr["LOAtype"].ToString().Trim(); if (cboPurpose.SelectedValue.ToString().Trim() == "SC" || cboPurpose.SelectedValue.ToString().Trim() == "XX") { cboCustomer.ItemsSource = null; cboCustomer.ItemsSource = ClsPEZAData.GetSubContractorListFromCustomerMaster().DefaultView; int id = Convert.ToInt32(dr["LOAclient"]); cboCustomer.SelectedValue = id.ToString(); foreach (DataRow dr2 in ClsCantierDB.GetVendorAddress(id).Rows) { tbCustomerAddress.Text = dr2["Address"].ToString().Trim(); } } else { cboCustomer.ItemsSource = null; cboCustomer.ItemsSource = ClsCantierDB.GetCustomerList().DefaultView; cboCustomer.SelectedIndex = 0; int id = Convert.ToInt32(dr["LOAclient"]); cboCustomer.SelectedValue = id.ToString(); foreach (DataRow dr1 in ClsCantierDB.GetCustomerAddress(id).Rows) { tbCustomerAddress.Text = dr1["Address"].ToString().Trim(); } } tbSuretyBondNo.Text = dr["LoaBondNo"].ToString(); tbORNo.Text = dr["LOA_ORno"].ToString().Trim(); if (dr.IsNull("LOAdatePaid")) { datePayment.SelectedDate = null; } else { datePayment.SelectedDate = Convert.ToDateTime(dr["LOAdatePaid"]); } tbAmount.Text = dr["LOAamt"].ToString().Trim(); if (dr.IsNull("LOAexp")) { dateLOAExpire.SelectedDate = null; } else { dateLOAExpire.SelectedDate = Convert.ToDateTime(dr["LOAexp"]); } if (dr.IsNull("LOAbondExpDate")) { dateBondExp.SelectedDate = null; } else { dateBondExp.SelectedDate = Convert.ToDateTime(dr["LOAbondExpDate"]); } if (dr["LOAstatus"].ToString().Trim() == "A") { cboStatus.SelectedIndex = 0; } else if (dr["LOAstatus"].ToString().Trim() == "C") { cboStatus.SelectedIndex = 1; } else { cboStatus.SelectedIndex = -1; } PopulateLOAItemLists(_loaNo.Trim()); } PopulateCurrency(); ComputeTotalAmount(); }
private void BtnExport_Click(object sender, RoutedEventArgs e) { DataTable dataTable = ClsCantierDB.GetFGInventory(Convert.ToInt16(cboCustomer.SelectedValue.ToString().Trim())); var excelApplication = new Excel.Application(); var excelWorkBook = excelApplication.Application.Workbooks.Add(Type.Missing); SaveFileDialog saveFileDialog = new SaveFileDialog(); saveFileDialog.Filter = "Excel files (*.xlsx)|*.xlsx"; saveFileDialog.FilterIndex = 0; saveFileDialog.RestoreDirectory = true; saveFileDialog.CreatePrompt = true; saveFileDialog.FileName = "Inventory Result As Of " + DateTime.Now.Date.ToString("yyyy-MMM-dd"); saveFileDialog.Title = "Export Excel File To"; DataColumnCollection dataColumnCollection = dataTable.Columns; for (int i = 1; i <= dataTable.Rows.Count + 1; i++) { for (int j = 1; j <= dataTable.Columns.Count; j++) { if (i == 1) { excelApplication.Cells[i, j] = dataColumnCollection[j - 1].ToString(); } else { excelApplication.Cells[i, j] = dataTable.Rows[i - 2][j - 1].ToString(); } } } //Excel.Range rg = (Excel.Range)excelApplication.Range["G:G"]; //rg.NumberFormat = "yyyy/MM/dd"; //Save the excel file at desired location Nullable <bool> result = saveFileDialog.ShowDialog(); // Process save file dialog box results if (result == true) { string fullpath = saveFileDialog.FileName; excelApplication.ActiveWorkbook.SaveCopyAs(fullpath); excelApplication.ActiveWorkbook.Saved = true; // Close the Excel Application excelApplication.Quit(); //connection.Close(); //Release or clear the COM object releaseObject(excelWorkBook); releaseObject(excelApplication); MessageBox.Show("Your data is exported Successfully into Excel File."); if (!File.Exists(fullpath)) { return; } // combine the arguments together //it doesn't matter if there is a space after ',' string argument = "/select, \"" + fullpath + "\""; Process.Start("explorer.exe", argument); } }
private void PopulateFields(string formNo) { foreach (DataRow dr in ClsPEZAData.Get8112formByNo(formNo).Rows) { tbPEZAFormNumber.Text = dr["8112formNo"].ToString().Trim(); datePEZA.SelectedDate = Convert.ToDateTime(dr["8112date"]); PopulateTypeAndPurpose(); cboType.SelectedValue = dr["8112LOAtype"].ToString().Trim(); tbPEZAPermitNo.Text = dr["8112controlNo"].ToString().Trim(); PopulateCustomers(); cboCustomer.SelectedValue = dr["8112client"].ToString().Trim(); int id = Convert.ToInt32(dr["8112client"].ToString().Trim()); foreach (DataRow dr1 in ClsCantierDB.GetCustomerAddress(id).Rows) { tbCustomerAddress.Text = dr1["Address"].ToString().Trim(); } PopulateAvailableInvoices(); PopulateUsedInvoices(); PopulateSKPIsignatories(); PopulatePEZAsignatories(); cboCurrency.ItemsSource = ClsPEZAData.GetCurrencyList().DefaultView; cbo8106ItemDescription.ItemsSource = ClsPEZAData.GetPEZAitemsList().DefaultView; cboLOAEstimatedUOM.ItemsSource = ClsCantierDB.GetUOM().DefaultView; GroupLOA.IsEnabled = true; cboAuthorizedOfficial1.SelectedValue = dr["8112PEZAauthorizedOfficial1"].ToString().Trim(); cboAuthorizedOfficial2.SelectedValue = dr["8112PEZAauthorizedOfficial2"].ToString().Trim(); cboSKPIAuthorizedSignatory.SelectedValue = dr["8112SKPIauthorizedOfficial"].ToString().Trim(); tb8106ItemNo.Text = dr["8112itemNo"].ToString(); tbORNo.Text = dr["8112PEZApermitOR"].ToString().Trim(); //if (!dr.IsNull("BoatNote")) //{ // tbBoatNoteNo.Text = dr["BoatNote"].ToString().Trim(); //} if (!dr.IsNull("8112deliveryDate")) { dateDelivered.SelectedDate = Convert.ToDateTime(dr["8112deliveryDate"]); } cboCurrency.SelectedValue = dr["8112currency"].ToString().Trim(); if (!dr.IsNull("8112partCode")) { cbo8106ItemDescription.SelectedValue = dr["8112partCode"].ToString(); } Int16 client = Convert.ToInt16(dr["8112client"].ToString().Trim()); cboPEZALOANo.ItemsSource = ClsPEZAData.GetClientLOAlist(client, dr["8112LOAtype"].ToString().Trim()).DefaultView; if (!dr.IsNull("8112LOA")) { cboPEZALOANo.SelectedValue = dr["8112LOA"].ToString().Trim(); GetLOADetails(dr["8112LOA"].ToString().Trim()); } if (!dr.IsNull("8112unit")) { cboLOAEstimatedUOM.SelectedValue = dr["8112unit"].ToString().Trim(); } if (!dr.IsNull("8112estQty")) { tbLOAEstimatedQty.Text = string.Format("{0:#,###0.#}", Convert.ToInt32(dr["8112estQty"])); } if (!dr.IsNull("8112estAmt")) { tbLOATotalEstimatedAmount.Text = string.Format("{0:#,###0.#}", Convert.ToInt32(dr["8112estAmt"])); } ComputeActualQtyNamt(); } }
private Boolean _SaveData() { string value = string.Empty; Boolean _validate1 = false; _validate1 = _validateFields(); if (!_validate1) { return(false); } value = tbLotCardNo.Text.Trim(); tbLotCardNo.Clear(); tbLotCardNo.Focus(); if (!string.IsNullOrEmpty(lotGroupNo.ToUpper())) { //Boolean _CheckIfSameGroupNo = false; //_CheckIfSameGroupNo = CheckIfSameGroupNo(value.ToUpper()); //if (!_CheckIfSameGroupNo) // return false; } if (value.ToUpper().Trim() == "N/A") { return(false); } string data = string.Empty; string data2 = string.Empty; if (value.ToUpper().Replace(@"\", "|").Contains("|Z6") && value.Replace(@"\", "|").ToUpper().Contains("EPPI")) { DataTable table = new DataTable(); table.Clear(); foreach (var column in table.Columns.Cast <DataColumn>().ToArray()) { if (table.AsEnumerable().All(dr => dr.IsNull(column))) { table.Columns.Remove(column); } } DataColumn colID = table.Columns.Add("LotCardNo", typeof(string)); string[] list = value.ToUpper().Replace(@"\", "|").Split('|'); foreach (string author in list) { DataRow row = table.NewRow(); row[0] = author; table.Rows.Add(row); } tbLastScannedLotCard.Text = table.Rows[6][0].ToString().ToUpper().Replace("Z6", ""); sLotCardRefNo = tbLastScannedLotCard.Text.Trim().ToUpper(); } else if (!value.ToUpper().Replace(@"\", "|").Contains("|Z6") && value.Contains("EPPI-")) { tbLastScannedLotCard.Text = value.ToUpper(); sLotCardRefNo = tbLastScannedLotCard.Text.ToUpper(); tbLotCardNo.Focus(); } else { tbLastScannedLotCard.Text = value.ToUpper(); sLotCardRefNo = tbLastScannedLotCard.Text.ToUpper(); tbBQICSNumber.Clear(); tbLotCardNo.Focus(); var count = sLotCardRefNo.Count(x => x == '-'); if (count > 4) { MessageBox.Show("Invalid Barcode Format. Please try again.", "Invalid Barcode"); sLotCardRefNo = string.Empty; tbLotCardNo.Focus(); return(false); } } var count2 = sLotCardRefNo.Count(x => x == '-'); if (count2 == 4) { var input = sLotCardRefNo.Trim(); var outerlot = SplitForward(input, '-', 3).ToArray(); var innerlot = SplitForward(input, '-', 4).ToArray(); foreach (string author in outerlot) { data = author; } foreach (string author in innerlot) { data2 = author; } lotGroupNo = sLotCardRefNo.Replace("-" + data + "-" + data2, "").Replace("Z6", "").ToUpper(); } else { data2 = string.Empty; var input = sLotCardRefNo.Trim(); var forwards = SplitForward(input, '-', 3).ToArray(); string[] ssd = forwards; foreach (string author in ssd) { data = author; } lotGroupNo = sLotCardRefNo.Replace("-" + data, "").Replace("Z6", "").ToUpper(); } Boolean _validate = false; _validate = CheckIfAlreadyScanned(); if (!_validate) { return(false); } Boolean _validate2 = false; _validate2 = CheckIfHasBQICS(sLotCardRefNo); if (!_validate2) { return(false); } Boolean _validate3 = false; _validate3 = CheckIfInnerLotcardControlNoWasScanned(sLotCardRefNo); if (!_validate3) { return(false); } Boolean _validate4 = false; _validate4 = CheckIfLotControlNoWasAlreadySavedInTheDatabase(sLotCardRefNo); if (!_validate4) { return(false); } DataTable dt; if (count2 == 4) { dt = ClsCantierDB.Sohbi_GetInnerLotCardBarcodeDetails(lotGroupNo, data, data2); } else { dt = ClsCantierDB.Sohbi_GetLotCardGroupBarcodeDetails(lotGroupNo, data); } string lmonth = string.Empty, lyear = string.Empty, lday = string.Empty; foreach (DataRow dr in dt.Rows) { Boolean _CheckIfReceivedByPMC = false; _CheckIfReceivedByPMC = CheckIfReceivedByPMC(Convert.ToBoolean(dr["ReceivedByPMC"])); if (!_CheckIfReceivedByPMC) { return(false); } lOQC_ID = 0; lCust_ID = Convert.ToInt32(dr["CustomerID"]); sCustName = dr["CustomerName"].ToString().Trim(); sPartCode = dr["ItemCode"].ToString().Trim(); sPartRevNo = dr["ItemRevNo"].ToString().Trim(); sPartName = dr["ItemDescription"].ToString().Trim(); sJONumber = dr["JobOrderNo"].ToString().Trim(); lQtyPerBox = count2 == 4 ? Convert.ToInt32(dr["InsideBoxQty"]) : Convert.ToInt32(dr["SPQ"]); dInspectionDate = dpInspectionDate.SelectedDate.Value; sInspector = cboInspector.Text.Trim(); if (dr.IsNull("SohbiLotNo") || string.IsNullOrEmpty(dr["SohbiLotNo"].ToString().Trim())) { lyear = Convert.ToDateTime(dr["ManufactureDate"]).Year.ToString().Substring(Convert.ToDateTime(dr["ManufactureDate"]).Year.ToString().Length - 1); if (Convert.ToDateTime(dr["ManufactureDate"]).Month >= 1 && Convert.ToDateTime(dr["ManufactureDate"]).Month <= 9) { lmonth = Convert.ToDateTime(dr["ManufactureDate"]).Month.ToString().Substring(Convert.ToDateTime(dr["ManufactureDate"]).Month.ToString().Length - 1); } else if (Convert.ToDateTime(dr["ManufactureDate"]).Month == 10) { lmonth = "X"; } else if (Convert.ToDateTime(dr["ManufactureDate"]).Month == 11) { lmonth = "Y"; } else if (Convert.ToDateTime(dr["ManufactureDate"]).Month == 12) { lmonth = "Z"; } if (Convert.ToDateTime(dr["ManufactureDate"]).Day >= 1 && Convert.ToDateTime(dr["ManufactureDate"]).Day <= 9) { lday = "0" + Convert.ToDateTime(dr["ManufactureDate"]).Day.ToString().Substring(Convert.ToDateTime(dr["ManufactureDate"]).Day.ToString().Length - 1);; } else { lday = Convert.ToDateTime(dr["ManufactureDate"]).Day.ToString().Substring(0, 1) + Convert.ToDateTime(dr["ManufactureDate"]).Day.ToString().Substring(Convert.ToDateTime(dr["ManufactureDate"]).Day.ToString().Length - 1); } sLotNumber = lyear + lmonth + lday + "A"; } else { sLotNumber = dr["SohbiLotNo"].ToString().Trim(); } bNormalInspection = false; bReinspection = false; bRepacked = true; bSample = false; bReplacement = false; dWorkDate = dpWorkDate.SelectedDate.Value; sWorkShift = cboWorkShift.Text.Trim(); } SaveOQCinspectionDetail(); SaveOQCinspectionSummary(); SaveOQCdailyWorkReport(); FillGrid(lotGroupNo); tbScannedBoxes.Text = (Convert.ToInt32(tbScannedBoxes.Text.Trim()) + 1).ToString(); return(true); }
private Boolean _SaveFG() { if (tbEmpID.Text.Length == 0) { MessageBox.Show("Select person who will release the item."); cboReceiver.Focus(); return(false); } string value = string.Empty; value = tbLotCardNo.Text.Trim(); tbLotCardNo.Clear(); tbLotCardNo.Focus(); string data = string.Empty; string data2 = string.Empty; if (value.ToUpper().Replace(@"\", "|").Contains("|Z6") && value.Replace(@"\", "|").ToUpper().Contains("EPPI")) { DataTable table = new DataTable(); table.Clear(); foreach (var column in table.Columns.Cast <DataColumn>().ToArray()) { if (table.AsEnumerable().All(dr => dr.IsNull(column))) { table.Columns.Remove(column); } } DataColumn colID = table.Columns.Add("LotCardNo", typeof(string)); string[] list = value.ToUpper().Replace(@"\", "|").Split('|'); foreach (string author in list) { DataRow row = table.NewRow(); row[0] = author; table.Rows.Add(row); } sLotCardRefNo = table.Rows[6][0].ToString().ToUpper().Replace("Z6", ""); } else if (!value.ToUpper().Replace(@"\", "|").Contains("|Z6") && value.Contains("EPPI-")) { sLotCardRefNo = value.ToUpper(); tbLotCardNo.Focus(); } else { sLotCardRefNo = value.ToUpper(); tbLotCardNo.Focus(); var count = sLotCardRefNo.Count(x => x == '-'); if (count > 4) { MessageBox.Show("Invalid Barcode Format. Please try again.", "Invalid Barcode"); sLotCardRefNo = string.Empty; tbLotCardNo.Focus(); return(false); } } var count2 = sLotCardRefNo.Count(x => x == '-'); if (count2 == 4) { var input = sLotCardRefNo.Trim(); var outerlot = SplitForward(input, '-', 3).ToArray(); var innerlot = SplitForward(input, '-', 4).ToArray(); foreach (string author in outerlot) { data = author; } foreach (string author in innerlot) { data2 = author; } lotGroupNo = sLotCardRefNo.Replace("-" + data + "-" + data2, "").Replace("Z6", "").ToUpper(); } else { data2 = string.Empty; var input = sLotCardRefNo.Trim(); var forwards = SplitForward(input, '-', 3).ToArray(); string[] ssd = forwards; foreach (string author in ssd) { data = author; } lotGroupNo = sLotCardRefNo.Replace("-" + data, "").Replace("Z6", "").ToUpper(); } Boolean _FGbarcodeScanned = false; _FGbarcodeScanned = FGbarcodeScanned(sLotCardRefNo); if (!_FGbarcodeScanned) { return(false); } DataTable dt = null; string lmonth = string.Empty, lyear = string.Empty, lday = string.Empty; if (count2 == 4) { dt = ClsCantierDB.GetInnerLotCardQty(lotGroupNo, data, data2); if (dt.Rows.Count == 0) { lQtyPerBox = 0; } else { lQtyPerBox = Convert.ToInt32(dt.Rows[0][10].ToString()); dt = ClsCantierDB.GetFGwithBarcode4delivery(sLotCardRefNo); } } else if (count2 == 3) { dt = ClsCantierDB.GetFGwithBarcode4delivery(sLotCardRefNo); if (dt.Rows.Count == 0) { lQtyPerBox = 0; } else { lQtyPerBox = Convert.ToInt32(dt.Rows[0][9].ToString()); } } else { MessageBox.Show("No Records Found"); return(false); } if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { lCust_ID = Convert.ToInt32(dr["Cust_ID"]); sCustName = dr["Cust_Name"].ToString().Trim(); sPartCode = dr["PartCode"].ToString().Trim(); sPartRevNo = dr["RevNo"].ToString().Trim(); sPartName = dr["PartName"].ToString().Trim(); sLocation = dr["RackNo"].ToString().Trim(); sLotNumber = dr["LotNo"].ToString().Trim(); sLotControlNo = dr["LotControlNo"].ToString().Trim(); } } else { MessageBox.Show("There is no more stock for this LotCard Control No."); tbLotCardNo.Clear(); tbLotCardNo.Focus(); return(false); } SaveFG(); FillGrid(); return(true); }
private void PopulateFields(string formNo) { foreach (DataRow dr in ClsPEZAData.Get8106formByNo(formNo).Rows) { tbPEZAFormNumber.Text = dr["8106formNo"].ToString().Trim(); datePEZA.SelectedDate = Convert.ToDateTime(dr["8106date"]); tbPEZAPermitNo.Text = dr["8106controlNo"].ToString().Trim(); PopulateCustomers(); cboCustomer.SelectedValue = dr["8106client"].ToString().Trim(); int id = Convert.ToInt32(dr["8106client"].ToString().Trim()); foreach (DataRow dr1 in ClsCantierDB.GetVendorAddress(id).Rows) { tbCustomerAddress.Text = dr1["Address"].ToString().Trim(); } PopulateLOA(); GroupLOA.IsEnabled = true; cboAuthorizedOfficial1.SelectedValue = dr["8106PEZAauthorizedOfficial1"].ToString().Trim(); cboAuthorizedOfficial2.SelectedValue = dr["8106PEZAauthorizedOfficial2"].ToString().Trim(); cboSKPIAuthorizedSignatory.SelectedValue = dr["8106SKPIauthorizedOfficial"].ToString().Trim(); tb8106ItemNo.Text = dr["8106itemNo"].ToString(); tbORNo.Text = dr["8106PEZApermitOR"].ToString().Trim(); dateDelivered.SelectedDate = Convert.ToDateTime(dr["8106deliveryDate"]); cboCurrency.SelectedValue = dr["8106currency"].ToString().Trim(); cboLOAOwner.SelectedValue = dr["8106LOAowner"].ToString().Trim(); if (!dr.IsNull("8106partCode")) { cbo8106ItemDescription.SelectedValue = dr["8106partCode"].ToString(); } if (!dr.IsNull("8106LOA")) { cboPEZALOANo.SelectedValue = dr["8106LOA"].ToString().Trim(); GetLOADetails(dr["8106LOA"].ToString().Trim()); } if (!dr.IsNull("8106unit")) { cboLOAEstimatedUOM.SelectedValue = dr["8106unit"].ToString().Trim(); } if (!dr.IsNull("8106estQty")) { tbLOAEstimatedQty.Text = string.Format("{0:#,###0.#}", Convert.ToInt32(dr["8106estQty"])); } if (!dr.IsNull("8106estQty")) { tbLOATotalEstimatedAmount.Text = string.Format("{0:#,###0.#}", Convert.ToInt32(dr["8106estAmt"])); } ComputeActualQtyNamt(); } }
private void GetDRNumbers() { gridDRLists.ItemsSource = ClsCantierDB.GetDRNumber().DefaultView; }