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();
}