internal MasterRoleEntity GetRoleById(int RoleId) { MasterRoleEntity results = new MasterRoleEntity(); try { StoredProcedureEntity sproc = new StoredProcedureEntity(); sproc.StoredProcedureName = "mapp.GetAllRoles"; sproc.StoredProceduresParameter.Add(GetParam("@RoleId", RoleId.ToString(), SQLServerDatatype.IntDataType)); DataTable dt; dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc); if (dt != null && dt.Rows.Count > 0) { MasterRoleAdapter ta = new MasterRoleAdapter(); foreach (DataRow rw in dt.Rows) { results = ta.AdaptItem(rw, dt); } } } catch (Exception) { throw; } return(results); }
// Gets Role list internal List <MasterRoleEntity> GetRolePaging(int SortOrder, int PageNumber, int PageSize, out int TotalCount) { TotalCount = 0; List <MasterRoleEntity> results = new List <MasterRoleEntity>(); try { StoredProcedureEntity sproc = new StoredProcedureEntity(); sproc.StoredProcedureName = "mapp.GetRolePaging"; sproc.StoredProceduresParameter.Add(GetParam("@SortOrder", SortOrder.ToString(), SQLServerDatatype.IntDataType)); sproc.StoredProceduresParameter.Add(GetParam("@PageNumber", PageNumber.ToString(), SQLServerDatatype.IntDataType)); sproc.StoredProceduresParameter.Add(GetParam("@PageSize", PageSize.ToString(), SQLServerDatatype.IntDataType)); sproc.StoredProceduresParameter.Add(GetParam("@TotalRecords", TotalCount.ToString(), SQLServerDatatype.IntDataType, ParameterDirection.Output)); string outParam = ""; DataTable dt; dt = sql.ExecuteDataTableWithOutputParam(CommandType.StoredProcedure, sproc, out outParam); if (dt != null && dt.Rows.Count > 0) { results = new MasterRoleAdapter().Adapt(dt); } TotalCount = Convert.ToInt32(outParam); } catch (Exception) { throw; } return(results); }
internal List <MasterRoleEntity> GetRole() { List <MasterRoleEntity> results = new List <MasterRoleEntity>(); try { StoredProcedureEntity sproc = new StoredProcedureEntity(); sproc.StoredProcedureName = "mapp.GetAllRoles"; DataTable dt; dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc); if (dt != null && dt.Rows.Count > 0) { MasterRoleAdapter ta = new MasterRoleAdapter(); results = ta.Adapt(dt); } } catch (Exception) { throw; } return(results); }