private void button3_Click(object sender, EventArgs e)
{
this.Hide();
Supplier display = new Supplier();
display.ShowDialog();
}
private void Form1_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyData == Keys.F1)
{
string add = txtaddress.Text;
string inp = txtsupname.Text;
string contact = txttel.Text;
////TXTNAME CONSTRAINTS
bool error = true;
foreach (char c in inp)
{
if (Char.IsNumber(c))
{
error = false;
break;
}
}
char ch = ' ';
for (int a = 0; a < inp.Length; a++)
{
ch = inp[a];
if (ch == ',' || ch == '<' || ch == '.' || ch == '>' || ch == '?' || ch == '/' || ch == ';' || ch == ':' || ch == '"' || ch == '|' || ch == ']' || ch == '}' || ch == '[' || ch == '{' || ch == '+' || ch == '=' || ch == '-' || ch == '_' || ch == ')' || ch == '(' || ch == '*' || ch == '&' || ch == '^' || ch == '%' || ch == '$' || ch == '#' || ch == '@' || ch == '!' || ch == '`' || ch == '~' || ch == '\\' || ch == '\'')
{
error = false;
}
}
////end of TXTNAME CONSTRAINTS
///
//// START TXTADDRES CONSTRAINTS
for (int a = 0; a < add.Length; a++)
{
ch = add[a];
if (ch == '-' || ch == '<' || ch == '>' || ch == '?' || ch == '/' || ch == ';' || ch == ':' || ch == '"' || ch == '|' || ch == ']' || ch == '}' || ch == '[' || ch == '{' || ch == '+' || ch == '=' || ch == '_' || ch == ')' || ch == '(' || ch == '*' || ch == '&' || ch == '^' || ch == '%' || ch == '$' || ch == '#' || ch == '@' || ch == '!' || ch == '`' || ch == '~' || ch == '\\' || ch == '\'')
{
error = false;
}
}
////end of TXTADDRESS CONSTRAINTS
///
//// START TXTCONTACT CONSTRAINTS
for (int a = 0; a < contact.Length; a++)
{
ch = contact[a];
if (ch == '<' || ch == '>' || ch == '?' || ch == '/' || ch == ';' || ch == ':' || ch == '"' || ch == '|' || ch == ']' || ch == '}' || ch == '[' || ch == '{' || ch == '+' || ch == '=' || ch == '_' || ch == ')' || ch == '(' || ch == '*' || ch == '&' || ch == '^' || ch == '%' || ch == '$' || ch == '#' || ch == '@' || ch == '!' || ch == '`' || ch == '~' || ch == '\\' || ch == '\'')
{
error = false;
}
if (ch == '0' || ch == '1' || ch == '2' || ch == '3' || ch == '4' || ch == '5' || ch == '6' || ch == '7' || ch == '8' || ch == '9')
{
error = true;
}
else
{
error = false;
}
}
////end of TXTCONTACT CONSTRAINTS
if (contact.Length > 13)
{
MessageBox.Show("Invalid Contact Number", "Error");
return;
}
if (error == false)
{
MessageBox.Show("Invalid input! Please Check all Fields for INCORRECT input", "Error");
return;
}
if (txtsupname.Text == "" || txtaddress.Text == "" || txttel.Text == "")
{
MessageBox.Show("Firstname, Lastname and Telephone # cannot be EMPTY", "Error");
return;
}
try
{
conn.dbcon();
SqlCommand com = new SqlCommand("INSERT INTO Suppliers (Supplier_Name, Telephone_No, Address) " + "Values ('" + txtsupname.Text + "', '" + txttel.Text + "','" + txtaddress.Text + "' )");
com.Connection = Connectionclass.con;
com.ExecuteNonQuery();
MessageBox.Show("Saved Successfully", "Saving");
txtaddress.Clear();
txtsupname.Clear();
txttel.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
conn.Closecon();
}
}
//back
if (e.KeyData == Keys.Escape)
{
this.Hide();
Supplier display = new Supplier();
display.ShowDialog();
this.Close();
}
}