public override bool Equals(object obj) { if (GetType() != obj.GetType()) { return(false); } SerialNumber sn = obj as SerialNumber; return(this.orderID == sn.orderID && this.productID == sn.productID && this.closedLoop == sn.closedLoop && this.extIO == sn.extIO && this.rigidTap == sn.rigidTap && this.thc == sn.thc && this.macroProg == sn.macroProg && this.threading == sn.threading && this.anaInputs == sn.anaInputs && this.serialNum == sn.serialNum); }
private void btnSNAdd_Click(object sender, EventArgs e) { string result = ""; bool isTwelveChars = txtSerialNumber.TextLength == 12 ? true : false; bool isHex = System.Text.RegularExpressions.Regex.IsMatch(txtSerialNumber.Text, @"\A\b[0-9a-fA-F]+\b\Z"); if (!(isTwelveChars && isHex)) { result = "serial number"; } else if ((cboSNParts.SelectedItem == null) || (!snProduct.Exists(product => product.name == cboSNParts.SelectedItem.ToString()))) { result = "part name"; } else if (cboSNOrderID.Text == "") { result = "order id/po number"; } int orderID = 0; Int32.TryParse(cboSNOrderID.Text, out orderID); if (result != "") { MessageBox.Show(" Error: " + result + " entry not valid. \n Re-enter information and try again.", "Failed", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } selectedProduct = snProduct.Find(product => product.name == cboSNParts.SelectedItem.ToString()); SerialNumber snNum = new SerialNumber(txtSerialNumber.Text, orderID, selectedProduct.productID, chkClosedLoop.Checked, chkAnaInp.Checked, chkRigidTap.Checked, chkTHC.Checked, chkMacroProg.Checked, chkThreading.Checked); dbMngr.insertSN(snNum); txtSerialNumber.Text = ""; cboSNParts.SelectedIndex = 0; chkAnaInp.Checked = chkClosedLoop.Checked = chkExtIO.Checked = chkMacroProg.Checked = chkRigidTap.Checked = chkTHC.Checked = chkThreading.Checked = false; int selectedIndex = cboSNOrderID.SelectedIndex; cboSNOrderID.SelectedIndex = 0; cboSNOrderID.SelectedIndex = selectedIndex; }
public void insertSN(SerialNumber serialNumber) { using (var context = new dbContext()) { if (snExists(serialNumber)) { var sNumber = context.SerialNumbers.FirstOrDefault(sn => sn.serialNum == serialNumber.serialNum); if (!sNumber.Equals(serialNumber)) { sNumber.serialNum = serialNumber.serialNum; sNumber.orderID = serialNumber.orderID; sNumber.productID = serialNumber.productID; sNumber.closedLoop = serialNumber.closedLoop; sNumber.extIO = serialNumber.extIO; sNumber.anaInputs = serialNumber.anaInputs; sNumber.rigidTap = serialNumber.rigidTap; sNumber.thc = serialNumber.thc; sNumber.macroProg = serialNumber.macroProg; sNumber.threading = serialNumber.threading; } } else { context.SerialNumbers.Add(serialNumber); } try { context.SaveChanges(); } catch { throw new SQLiteException(); } } }
private bool snExists(SerialNumber serialNumber) { using (var context = new dbContext()) return(context.SerialNumbers.Where(sn => sn.serialNum == serialNumber.serialNum).Any()); }