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