public List <EntityRoleModel> GetList(int?deptId = null) { List <EntityRoleModel> output = new List <EntityRoleModel>(); this.DBConnection.OpenDBConnect(); if (this.DBConnection.ERROR != null) { this.DBConnection.CloseDBConnect(); throw new Exception("Can't connect to db"); } ; try { DBConnection.command.Parameters.Clear(); DBConnection.command.CommandText = USP_GET_ROLES_BY_ORGID; DBConnection.command.CommandType = CommandType.StoredProcedure; DBConnection.command.Parameters.AddWithValue("@deptID", (object)deptId ?? DBNull.Value); using (SqlDataReader reader = DBConnection.command.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { EntityRoleModel entityRole = new EntityRoleModel(); entityRole.RoleId = reader.GetInt32(reader.GetOrdinal("RoleId")); entityRole.Name = reader.GetString(reader.GetOrdinal("Name")); entityRole.Description = reader.GetString(reader.GetOrdinal("Description")); entityRole.DepartmentName = reader.GetString(reader.GetOrdinal("OrganizationName")); entityRole.DepartId = reader.GetInt32(reader.GetOrdinal("DepartId")); output.Add(entityRole); } } } } catch (Exception ex) { this.ERROR = ex.ToString(); } finally { this.DBConnection.CloseDBConnect(); } return(output); }
public BlockDataUserCreateModel GetEntityById(int id) { BlockDataUserCreateModel output = new BlockDataUserCreateModel(); try { DBConnection.OpenDBConnect(); if (this.DBConnection.ERROR != null) { throw new Exception("Can't connect to db"); } //STEP1: ***************************************************************/ Dictionary <string, object> dicParas = new Dictionary <string, object>(); Dictionary <string, object> dicParaOuts = new Dictionary <string, object>(); dicParas.Add("USERID", id); DataSet dataSet = DBConnection.ExecSelectSP("SP_USER_GET_BY_ID", dicParas, ref dicParaOuts, true); //**********************TABLE: ROLE*************************************** DataTable table1 = dataSet.Tables[0]; foreach (DataRow row in table1.Rows) { output.Email = row["Email"].ToString(); output.Phone = row["Phone"].ToString(); output.IsAdmin = (bool)row["IsAdmin"]; output.UserName = (string)row["UserName"]; output.UserId = (int)row["UserId"]; output.DeptId = (int)row["deptID"]; } output.IsSuperAdmin = output.IsAdmin && (output.DeptId == 0); //**********************TABLE: ROLEMENU *********************************************** DataTable table2 = dataSet.Tables[1]; foreach (DataRow row in table2.Rows) { output.LstSelectedMenu.Add(Int32.Parse(row["menuid"].ToString())); } foreach (DataRow row in dataSet.Tables[2].Rows) { output.LstSelectedRole.Add(Int32.Parse(row["roleid"].ToString())); } //**********************TABLE: ROLE *********************************************** DataTable table3 = dataSet.Tables[2]; foreach (DataRow row in table3.Rows) { BI_Project.Models.EntityModels.EntityRoleModel entityRoleModel = new EntityRoleModel(); //entityRoleModel.Name = row["Name"].ToString(); entityRoleModel.RoleId = (int)row["RoleId"]; output.ListAllRoles.Add(entityRoleModel); } } catch (Exception ex) { this.ERROR = ex.ToString(); } finally { this.DBConnection.CloseDBConnect(); } return(output); }