private void RegisterButton_Click(object sender, EventArgs e)
{
string Name = NameInput.Text;
string Email = EmailInput.Text;
string Address = AddressInput.Text;
string PhoneNumber = PhoneNumberInput.Text;
string Password = PasswordInput.Text;
string ConfirmPassword = ConfirmPasswordInput.Text;
// MessageBox.Show(Name + Email + Address + Region + PhoneNumber + Password + ConfirmPassword);
MedicalRepresentative mr = new MedicalRepresentative(Name, Password, Email, Address, PhoneNumber, null);
mrdb.RegisterMR(mr);
this.Visible = false;
}
public void RegisterMR(MedicalRepresentative mr)
{
int mrid = -1;
using (SqlConnection con = new SqlConnection(cs))
{
SqlCommand cmd = new SqlCommand
{
Connection = con,
CommandText =
"INSERT INTO [dbo].[User] ([name], [password], [email], [role], [address], [phonenumber]) VALUES (@name, @password,@email, @role, @address,@phonenumber)"
};
cmd.Parameters.AddWithValue("@name", mr.Name);
cmd.Parameters.AddWithValue("@email", mr.Email);
cmd.Parameters.AddWithValue("@password", mr.Password);
cmd.Parameters.AddWithValue("@role", "mr");
cmd.Parameters.AddWithValue("@address", mr.Address);
cmd.Parameters.AddWithValue("@phonenumber", mr.PhoneNumber);
con.Open();
cmd.ExecuteNonQuery();
}
using (SqlConnection con = new SqlConnection(cs))
{
SqlCommand cmd = new SqlCommand
{
Connection = con,
CommandText =
"select * from [dbo].[User] where email = @email and password = @password"
};
cmd.Parameters.Add(new SqlParameter("@email", mr.Email));
cmd.Parameters.Add(new SqlParameter("@password", mr.Password));
con.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
this.isLoggedin = true;
reader.Read();
mrid = reader.GetInt32(0);
}
}
}
if (mrid != -1)
{
using (SqlConnection con = new SqlConnection(cs))
{
SqlCommand cmd = new SqlCommand
{
Connection = con,
CommandText =
"INSERT INTO [dbo].[Manager_Mr] ([mid], [mrid]) VALUES (@mid, @mrid)"
};
cmd.Parameters.AddWithValue("@mid", uid);
cmd.Parameters.AddWithValue("@mrid", mrid);
con.Open();
cmd.ExecuteNonQuery();
}
}
}
public bool removeMedicalRepresentative(MedicalRepresentative m)
{
MRs.Remove(m);
return(true);
}
public bool addMedicalRepresentative(MedicalRepresentative m)
{
MRs.Add(m);
return(true);
}