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