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;
}
