private void button1_Click(object sender, EventArgs e)
{
string pass, name;
int? id;
try
{
//id
id = int.Parse(textBox1.Text);
if (id == null)
{
MessageBox.Show("Enter Id !!");
}
Console.WriteLine("id {0}", id);
//password
pass = textBox3.Text;
if (pass == null)
{
MessageBox.Show("Enter Password !!");
}
Console.WriteLine("password {0}", pass);
//name
name = textBox3.Text;
if (name == null)
{
MessageBox.Show("Enter Name !!");
}
Console.WriteLine("name {0}", name);
if (id != null && pass != null && name != null)
{
string cs = @"server=localhost;userid=root;password=1234;database=dairy_mgmt";
Console.WriteLine("inside");
MySqlConnection conn = null;
try
{
conn = new MySqlConnection(cs);
conn.Open();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = conn;
cmd.CommandText = "INSERT INTO admin VALUES (?admin_id, ?name, ?pwd) ;";
cmd.Parameters.AddWithValue("?admin_id", id);
cmd.Parameters.AddWithValue("?name", name);
cmd.Parameters.AddWithValue("?pwd", pass);
Console.WriteLine("in1");
Console.WriteLine("MySQL version : {0}", conn.ServerVersion);
try
{
cmd.ExecuteScalar();
MessageBox.Show("New Admin Added!!");
}
catch (Exception ex) { Console.WriteLine("Exception : {0}", ex); }
}
catch (MySqlException ex)
{
MessageBox.Show("Failed!!");
Console.WriteLine("Error: {0}", ex.ToString());
}
finally
{
if (conn != null)
{
conn.Close();
}
}
this.Hide();
var form = new FormAdminPage();
form.Closed += (s, args) => this.Close();
form.Show();
}
}
catch
{
MessageBox.Show("Enter valid Entries !!");
}
}
private void button4_Click(object sender, EventArgs e)
{
this.Hide();
var formadmin = new FormAdminPage();
formadmin.Closed += (s, args) => this.Close();
formadmin.Show();
}
private void button2_Click(object sender, EventArgs e)
{
string pass;
int? id;
try
{
id = int.Parse(textBox1.Text);
if (id == null)
{
MessageBox.Show("Enter Id !!");
}
Console.WriteLine("id {0}",id);
pass = textBox2.Text;
if (pass == null)
{
MessageBox.Show("Enter Password !!");
}
Console.WriteLine("password {0}", pass);
if (id != null && pass != null)
{
string cs = @"server=localhost;userid=root;password=1234;database=dairy_mgmt";
Console.WriteLine("inside");
MySqlConnection conn = null;
try
{
conn = new MySqlConnection(cs);
conn.Open();
//to insert data or run commands
//string sql = "SELECT admin_id FROM admin WHERE admin_id = id AND pwd = pass ;";
//MySqlScript script = new MySqlScript(conn, sql);
// Create Command
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = conn;
cmd.CommandText = "SELECT admin_id FROM admin WHERE admin_id = ?id AND pwd = ?pass ;";
cmd.Parameters.AddWithValue("?id", id);
cmd.Parameters.AddWithValue("?pass", pass);
Console.WriteLine("in1");
try {
admin_id_g = (int)(cmd.ExecuteScalar()); }
catch (Exception ex) { Console.WriteLine("Exception : {0}", ex); }
Console.WriteLine("MySQL version : {0}", conn.ServerVersion);
//to show data
//MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM admin;", conn);
//DataSet ds = new DataSet();
//da.Fill(ds);
//dataGridView1.DataSource = ds.Tables[0];
}
catch (MySqlException ex)
{
Console.WriteLine("Error: {0}", ex.ToString());
}
finally
{
if (conn != null)
{
conn.Close();
}
}
}
if (admin_id_g == null)
{
MessageBox.Show("INVALID USER!!");
}
else {
this.Hide();
var form = new FormAdminPage();
form.Closed += (s, args) => this.Close();
form.Show();
}
}
catch {
MessageBox.Show("Enter valid Id !!");
}
//id = int.Parse(textBox1.Text);
}