private void CSupplierMaster_Load(object sender, EventArgs e)
{
Txtsupplierid.Text = "";
Txtsuppliername.Text = "";
Txtsuppliercom.Text = "";
TxtSupplierEmail.Text = "";
Txtsuppliermob.Text = "";
Txtsupplierphone.Text = "";
Txtsupplieraddress.Text = "";
Txtsuppliername.Focus();
//groupBox1.Enabled = false;
//metroPanel2.Enabled = true;
try
{
con.Open();
SqlDataAdapter ad = new SqlDataAdapter("SELECT * from CSupplier_Master", con);
DataTable ds = new DataTable();
ad.Fill(ds);
dataGridView1.DataSource = ds;
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
//load perchase id
try
{
int a;
con.Open();
SqlCommand cmd = new SqlCommand();
cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select Max (Id) from CSupplier_Master";
SqlDataReader dr;
dr = cmd.ExecuteReader();
if (dr.Read())
{
string val = dr[0].ToString();
if (val == "")
{
Txtsupplierid.Text = "1";
}
else
{
a = Convert.ToInt32(dr[0].ToString());
a = a + 1;
Txtsupplierid.Text = a.ToString();
}
con.Close();
}
//dataGridView1.Rows.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void BtnDelete_Click(object sender, EventArgs e)
{
try
{
con.Open();
SqlCommand cmd = new SqlCommand();
cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from [CSupplier_Master]";
DialogResult re = MessageBox.Show("Do you want to delete this Record!", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (re == DialogResult.No)
{
Txtsupplierid.Focus();
}
else
{
cmd.CommandText = "DELETE FROM CSupplier_Master WHERE [Id]='" + Txtsupplierid.Text + "'";
cmd.ExecuteNonQuery();
MessageBox.Show("Selected record is DELETED", "Delete", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
cmd.CommandText = "SELECT * FROM [CSupplier_Master]";
cmd.Connection.Close();
SqlDataAdapter ad = new SqlDataAdapter("SELECT * FROM [CSupplier_Master]", con);
DataSet ds = new DataSet();
ad.Fill(ds);
DataTable dt = ds.Tables[0];
dataGridView1.DataSource = dt;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
Txtsupplierid.Text = "";
Txtsuppliername.Text = "";
Txtsuppliercom.Text = "";
TxtSupplierEmail.Text = "";
Txtsuppliermob.Text = "";
Txtsupplierphone.Text = "";
Txtsuppliecity.Text = "";
Txtsupplieraddress.Text = "";
Txtsuppliername.Focus();
pictureBox4.Image = null;
pictureBox5.Image = null;
pictureBox6.Image = null;
groupBox1.Enabled = true;
con.Close();
}
}
private void BtnCancel_Click(object sender, EventArgs e)
{
Txtsupplierid.Text = "";
Txtsuppliername.Text = "";
Txtsuppliercom.Text = "";
TxtSupplierEmail.Text = "";
Txtsuppliermob.Text = "";
Txtsupplierphone.Text = "";
Txtsuppliecity.Text = "";
Txtsupplieraddress.Text = "";
Txtsuppliername.Focus();
pictureBox4.Image = null;
pictureBox5.Image = null;
pictureBox6.Image = null;
groupBox1.Enabled = true;
//load perchase id
try
{
int a;
con.Open();
SqlCommand cmd = new SqlCommand();
cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select Max (Id) from CSupplier_Master";
SqlDataReader dr;
dr = cmd.ExecuteReader();
if (dr.Read())
{
string val = dr[0].ToString();
if (val == "")
{
Txtsupplierid.Text = "1";
}
else
{
a = Convert.ToInt32(dr[0].ToString());
a = a + 1;
Txtsupplierid.Text = a.ToString();
}
con.Close();
}
//dataGridView1.Rows.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void BtnSave_Click(object sender, EventArgs e)
{
if (Txtsupplierid.Text == "" || Txtsuppliername.Text == "" || Txtsuppliercom.Text == "" || Txtsuppliermob.Text == "")
{
MessageBox.Show("Please Enter Required Information", "Informed", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
try
{
con.Open();
SqlCommand cmd = new SqlCommand();
cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "INSERT into CSupplier_Master VALUES('" + Txtsupplierid.Text + "','" + Txtsuppliername.Text + "','" + Txtsuppliercom.Text + "','" + TxtSupplierEmail.Text + "','" + Txtsuppliermob.Text + "','" + Txtsupplierphone.Text + "','" + Txtsuppliecity.Text + "','" + Txtsupplieraddress.Text + "')";
cmd.ExecuteNonQuery();
MessageBox.Show("Record is successfully Added", "Congratulation", MessageBoxButtons.OK, MessageBoxIcon.Information);
cmd.Connection.Close();
SqlDataAdapter ad = new SqlDataAdapter("SELECT * from CSupplier_Master", con);
DataSet ds = new DataSet();
ad.Fill(ds);
DataTable dt = ds.Tables[0];
dataGridView1.DataSource = dt;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
Txtsupplierid.Text = "";
Txtsuppliername.Text = "";
Txtsuppliercom.Text = "";
TxtSupplierEmail.Text = "";
Txtsuppliermob.Text = "";
Txtsupplierphone.Text = "";
Txtsuppliecity.Text = "";
Txtsupplieraddress.Text = "";
Txtsuppliername.Focus();
pictureBox4.Image = null;
pictureBox5.Image = null;
pictureBox6.Image = null;
//groupBox1.Enabled = false;
con.Close();
}
}
//load perchase id
try
{
int a;
con.Open();
SqlCommand cmd = new SqlCommand();
cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select Max (Id) from CSupplier_Master";
SqlDataReader dr;
dr = cmd.ExecuteReader();
if (dr.Read())
{
string val = dr[0].ToString();
if (val == "")
{
Txtsupplierid.Text = "1";
}
else
{
a = Convert.ToInt32(dr[0].ToString());
a = a + 1;
Txtsupplierid.Text = a.ToString();
}
con.Close();
}
// dataGridView1.Rows.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
