private void login_Button_Click(object sender, EventArgs e) { DataTable dt = DataAccess.LoadData($"SELECT * FROM [PublicPricing].[dbo].[Usercredential] WHERE Username = '******'"); if (username_TextBox.Text == "") { MessageBox.Show("Enter Username", "Error Message"); } else if (password_TextBox.Text == "") { MessageBox.Show("Enter Password", "Error Message"); } else if (dt.Rows.Count <= 0) { MessageBox.Show("Username Does Not Exist", "Error Message"); } else { DataTable dt1 = DataAccess.LoadData($"SELECT * FROM [PublicPricing].[dbo].[Usercredential] WHERE Username = '******' AND Password = '******'"); if (dt1.Rows.Count <= 0) { MessageBox.Show("Username and Password doesn't match", "Error Message"); } else { ModProductListing mdl = new ModProductListing(username_TextBox.Text); //MessageBox.Show("Login Successful"); mdl.Show(); this.Hide(); } } }
private void back_Button_Click(object sender, EventArgs e) { ModProductListing mdl = new ModProductListing(this.username); mdl.Show(); this.Hide(); }
private void deleteproduct_Button_Click(object sender, EventArgs e) { String del_query = $"DROP TABLE {product_name}"; DataAccess.DeleteQuery(del_query); MessageBox.Show("Product Deleted", "Info"); String remove_query = $"DELETE FROM productlisting WHERE name_of_product ='{product_name}';"; DataAccess.DeleteQuery(remove_query); ModProductListing mdl = new ModProductListing(this.username); mdl.Show(); this.Hide(); }