public PaymentDBOpera()
{
conn = DBConnection.getConnection();
}
public PatientDBOper()
{
conn = DBConnection.getConnection();
}
public LoginDBOpert()
{
conn = DBConnection.getConnection();
}
public DoctorDBOper()
{
conn = DBConnection.getConnection();
}
public CreateUsersDBOpe()
{
conn = DBConnection.getConnection();
}
public ViewDailyAppoiDBOper()
{
conn = DBConnection.getConnection();
}
public ManagerDBOper()
{
conn = DBConnection.getConnection();
}
private void btnlogin_Click(object sender, EventArgs e)
{
SqlConnection conn = DBConnection.getConnection();
string username = txtuname.Text.Trim();
string password = txtpass.Text.Trim();
string acctype = cmbacctype.Text;
if (this.txtuname.Text == "" || this.txtpass.Text == "")
{
MessageBox.Show("Please Enter User Name or Password", "Message", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
try
{
if (cmbacctype.SelectedItem == "Admin")
{
SqlCommand cmd = new SqlCommand("SELECT * FROM UserAcc WHERE Username='******' AND Password='******'", conn);
SqlDataAdapter adapt = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapt.Fill(ds);
int count = ds.Tables[0].Rows.Count;
if (count == 1)
{
MessageBox.Show("Login Successful!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Hide();
AdminPanel ap = new AdminPanel();
ap.Show();
}
else
{
MessageBox.Show("Invalid username or password", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else if (cmbacctype.SelectedItem == "Manager")
{
SqlCommand cmd = new SqlCommand("SELECT Username, Password FROM UserAcc WHERE Username='******' AND Password='******'", conn);
SqlDataAdapter adapt = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapt.Fill(ds);
int count = ds.Tables[0].Rows.Count;
if (count == 1)
{
MessageBox.Show("Login Successful!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Hide();
ManagerMenu mm = new ManagerMenu();
mm.Show();
}
else
{
MessageBox.Show("Invalid username or password", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else if (cmbacctype.SelectedItem == "Front Officer")
{
SqlCommand cmd = new SqlCommand("SELECT Username, Password FROM UserAcc WHERE Username='******' AND Password='******'", conn);
SqlDataAdapter adapt = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapt.Fill(ds);
int count = ds.Tables[0].Rows.Count;
if (count == 1)
{
MessageBox.Show("Login Successful!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Hide();
ClearkMenu cm = new ClearkMenu();
cm.Show();
}
else
{
MessageBox.Show("Invalid username or password", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else if (cmbacctype.SelectedItem == "Doctor")
{
SqlCommand cmd = new SqlCommand("SELECT Username, Password FROM UserAcc WHERE Username='******' AND Password='******'", conn);
SqlDataAdapter adapt = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapt.Fill(ds);
int count = ds.Tables[0].Rows.Count;
if (count == 1)
{
MessageBox.Show("Login Successful!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Hide();
DoctorMenu dm = new DoctorMenu();
dm.Show();
}
else
{
MessageBox.Show("Invalid username or password", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Login Failed", "Message", MessageBoxButtons.OK, MessageBoxIcon.Warning);
this.txtuname.Text = "";
this.txtpass.Text = "";
}
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
}
public FrontOfficeDBOper()
{
conn = DBConnection.getConnection();
}