internal bool Read_Login_VIEW(ref string Err) { if (m_Login_VIEW == null) { m_Login_VIEW = new LoginDB_DataSet.Login_VIEW(Login_con); } m_Login_VIEW.Clear(); m_Login_VIEW.select.all(true); if (m_Login_VIEW.Read(ref Err)) { if (m_Login_VIEW.dt.Rows.Count > 0) { return true; } else { Err = "ERROR: Some Login Tables are empty !"; return false; } } else { return false; } }
internal bool LoginRoles_Get(int LoginUser_id,List<Role> roles, ref string Err) { LoginDB_DataSet.Login_VIEW xLogin_VIEW = new LoginDB_DataSet.Login_VIEW(Login_con); xLogin_VIEW.Clear(); xLogin_VIEW.select.all(false); xLogin_VIEW.select.Role_id = true; xLogin_VIEW.select.Role_Name = true; xLogin_VIEW.select.Role_PrivilegesLevel = true; xLogin_VIEW.select.Role_description = true; xLogin_VIEW.where.all(false); xLogin_VIEW.where.Users_id = true; xLogin_VIEW.where.Users_id_Expression(" = " + LoginUser_id.ToString()); if (xLogin_VIEW.Read(ref Err)) { roles.Clear(); foreach (DataRow dr in xLogin_VIEW.dt.Rows) { int LoginRole_id = -1; string LoginRole_Name = null; int LoginRole_PrivilegesLevel = -1; string LoginRole_description = ""; if (dr[LoginDB_DataSet.Login_VIEW.Role_id.name].GetType()== typeof(int)) { LoginRole_id = (int)dr[LoginDB_DataSet.Login_VIEW.Role_id.name]; } if (dr[LoginDB_DataSet.Login_VIEW.Role_Name.name].GetType() == typeof(string)) { LoginRole_Name = (string)dr[LoginDB_DataSet.Login_VIEW.Role_Name.name]; } if (dr[LoginDB_DataSet.Login_VIEW.Role_PrivilegesLevel.name].GetType() == typeof(int)) { LoginRole_PrivilegesLevel = (int)dr[LoginDB_DataSet.Login_VIEW.Role_PrivilegesLevel.name]; } if (dr[LoginDB_DataSet.Login_VIEW.Role_description.name].GetType() == typeof(string)) { LoginRole_description = (string)dr[LoginDB_DataSet.Login_VIEW.Role_description.name]; } if ((LoginRole_Name != null) && (LoginRole_PrivilegesLevel >= 0)) { Role role = new Role(); role.id = LoginRole_id; role.Name = LoginRole_Name; role.PrivilegesLevel = LoginRole_PrivilegesLevel; role.description = LoginRole_description; roles.Add(role); } } return true; } else { return false; } }