private void my_Cancel_Click(object sender, EventArgs e)
{
InputsForm fd = new InputsForm(controler);
this.Hide();
fd.setLabel(mail.Text);
fd.Show();
}
private void button1_Click(object sender, EventArgs e)
{
string mail = (id.Text) + "@" + maskedTextBox1.Text;
string pass = password.Text;
string dbprovider = controler.m.getDBprovider();
String strSql = "SELECT * FROM users WHERE email= '" + mail + "'";
OleDbConnection conn = new OleDbConnection(dbprovider);
if (id.Text == "" || maskedTextBox1.Text == "")
{
MessageBox.Show("you must add your mail");
id.Clear();
maskedTextBox1.Clear();
id.Focus();
}
else
{
try
{
conn.Open();
OleDbCommand cmd = new OleDbCommand(strSql, conn);
OleDbDataReader reader = cmd.ExecuteReader();
reader.Read();
string passw = reader.GetString(9);
if (passw != pass)
{
MessageBox.Show("wrong password");
password.Clear();
password.Focus();
}
else
{
InputsForm fi = new InputsForm(controler);
this.Hide();
fi.Show();
fi.setLabel(mail);
}
}
catch (Exception ex)
{
MessageBox.Show("user didn't exist or wrong mail try again");
id.Clear();
maskedTextBox1.Clear();
id.Focus();
password.Clear();
}
finally
{
conn.Close();
}
}
}
private void Ok_Click(object sender, EventArgs e)
{
String t1, t2, t3, t5, t6, t4;
t4 = id.Text;
t1 = desc.Text;
t2 = num.Text;
t3 = max.Text;
t5 = date.Text;
t6 = name.Text;
string strSql = "INSERT INTO domain (domaim_id,description,partnersNum,maxNumOfPartners,date,name) VALUES (?,?,?,?,?,?)";
string dbprovider = @"Provider=Microsoft.Jet.OLEDB.4.0;" +
@"Data source= C:\Users\USER\Documents\Visual Studio 2015\Projects\myIS\myIS\db\" + @"partners.mdb";
OleDbConnection conn = new OleDbConnection(dbprovider);
try
{
OleDbCommand dbCmd = new OleDbCommand(strSql, conn);
dbCmd.Parameters.AddWithValue("domaim_id", t4);
dbCmd.Parameters.AddWithValue("description", t1);
dbCmd.Parameters.AddWithValue("partnersNum", t2);
dbCmd.Parameters.AddWithValue("maxNumOfPartners", t3);
dbCmd.Parameters.AddWithValue("date", t5);
dbCmd.Parameters.AddWithValue("name", t6);
conn.Open();
dbCmd.ExecuteNonQuery();
}
catch
{
MessageBox.Show("domain exist choose another");
id.Clear();
id.Focus();
}
finally
{
conn.Close();
}
MessageBox.Show("Domain Data saved successfuly...!");
InputsForm fi = new InputsForm();
fi.Show();
}
