public static int GetOfficeIdForDoctor(int idDoctor)
{
string querry = "USE db_Clinic " +
"SELECT Office_id " +
"FROM tbl_Doctor " +
"WHERE Doctor_id = " + idDoctor + " ";
SqlDataReader dr = ClassQuerry.ExecuteQuerry(querry);
int officeId = 0;
while (dr.Read())
{
officeId = dr.GetInt32("Office_id");
}
ClassQuerry.CloseConnection();
return(officeId);
}
public static int GetLoggedDoctorId(string login, string password)
{
string querry = "USE db_Clinic " +
"SELECT Doctor_id FROM tbl_Doctor " +
"WHERE Employee_id = " +
"(SELECT Employee_id FROM tbl_Employee WHERE User_id = " +
"(SELECT User_id FROM tbl_User WHERE tbl_User.Login = '******' AND tbl_User.Password = '******')) ";
SqlDataReader dr = ClassQuerry.ExecuteQuerry(querry);
int loggedDoctorId = 0;
while (dr.Read())
{
loggedDoctorId = dr.GetInt32("Doctor_id");
}
ClassQuerry.CloseConnection();
return(loggedDoctorId);
}
//Method that gets and returns type of permission from logged user (from database)
public static ClassPermission GetUserType(string login, string password)
{
string querry = "USE db_Clinic " +
"SELECT tbl_User.Role_id, Type_of_role FROM tbl_User, tbl_Role " +
"WHERE tbl_Role.Role_id = tbl_User.Role_id " +
"AND login = '******' AND Password = '******' ";
SqlDataReader dr = ClassQuerry.ExecuteQuerry(querry);
ClassPermission permission = new ClassPermission();
while (dr.Read())
{
permission.PermissionId = dr.GetInt32("Role_id");
permission.Permission = dr.GetString("Type_of_role");
}
ClassQuerry.CloseConnection();
return(permission);
}
