private void add_btn_Click(object sender, EventArgs e) { if (validation()) { //Insert Product //SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-BJH69LU\ASHISSQL;Initial Catalog=Stock;Integrated Security=True"); SqlConnection con = MyConnection.GetConnection(); con.Open(); bool status = false; if (pro_status.SelectedIndex == 0) { status = true; } else { status = false; } string sqlQuery = ""; if (isProductExists(con, pro_code.Text)) { sqlQuery = "UPDATE [tbl_products] SET [product_name] = '" + pro_name.Text + "',[product_status] = '" + status + "' WHERE [product_id] = '" + pro_code.Text + "'"; } else { sqlQuery = "INSERT INTO [dbo].[tbl_products] ([product_id],[product_name],[product_status]) VALUES ('" + pro_code.Text + "','" + pro_name.Text + "','" + status + "')"; } SqlCommand cmd = new SqlCommand(sqlQuery, con); cmd.ExecuteNonQuery(); con.Close(); // Get Products loadData(); resetData(); } }
private void del_btn_Click(object sender, EventArgs e) { DialogResult dialog = MessageBox.Show("Are you sure to delete?", "Message", MessageBoxButtons.YesNo); if (dialog == DialogResult.Yes) { if (validation()) { SqlConnection con = MyConnection.GetConnection(); if (isProductExists(con, pro_code.Text)) { con.Open(); SqlCommand cmd = new SqlCommand("DELETE FROM [tbl_products] WHERE [product_id] = '" + pro_code.Text + "'", con); cmd.ExecuteNonQuery(); con.Close(); } else { MessageBox.Show("Record Not Found!"); } loadData(); resetData(); } } }
private void login_btn_Click(object sender, EventArgs e) { //SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-BJH69LU\ASHISSQL;Initial Catalog=Stock;Integrated Security=True"); SqlConnection con = MyConnection.GetConnection(); SqlDataAdapter sda = new SqlDataAdapter(@"SELECT * FROM[dbo].[tbl_login] WHERE username = '******' AND password = '******'", con); DataTable dt = new DataTable(); sda.Fill(dt); //CTRL + KD To align if (dt.Rows.Count == 1) { this.Hide(); StockMain main = new StockMain(); main.Show(); } else { MessageBox.Show("Invalid login details", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); clear_btn_Click(sender, e); } }
public void loadData() { SqlConnection con = MyConnection.GetConnection(); SqlDataAdapter sda = new SqlDataAdapter(@"SELECT * FROM [dbo].[tbl_products]", con); DataTable dt = new DataTable(); sda.Fill(dt); products_tbl.Rows.Clear(); foreach (DataRow item in dt.Rows) { int n = products_tbl.Rows.Add(); products_tbl.Rows[n].Cells[0].Value = item["product_id"].ToString(); products_tbl.Rows[n].Cells[1].Value = item["product_name"].ToString(); if ((bool)item["product_status"]) { products_tbl.Rows[n].Cells[2].Value = "Active"; } else { products_tbl.Rows[n].Cells[2].Value = "Deactive"; } } }