public DataTable GetRoleApplications(UsersApplicationsRoles userApplicationRole, int tipo) { CreateColumns(); var lstRole = GetRoleforApplication(userApplicationRole, tipo); ApplicationDA applicationDa = new ApplicationDA(_configuration); if (lstRole.Count > 0) { foreach (var role in lstRole) { _drFixed = _dtFixed.NewRow(); _drFixed["RoleId"] = role.RoleId; _drFixed["RoleName"] = role.RoleName; _drFixed["RoleDescription"] = role.RoleDescription; _drFixed["ApplicationId"] = role.ApplicationId; _drFixed["ApplicationName"] = applicationDa.FindApplication(role.ApplicationId).ApplicationName; _drFixed["CreationDateTime"] = role.CreationDateTime; _drFixed["CreationUserId"] = role.CreationUserId; _drFixed["ModificationDateTime"] = role.ModificationDateTime; _drFixed["ModificationUserId"] = role.ModificationUserId; _drFixed["DeclineDate"] = role.DeclineDate; _drFixed["RoleAuthorizationUserId"] = role.RoleAuthorizationUserId; _drFixed["RoleAuthorizationOwner"] = role.RoleAuthorizationOwner; _dtFixed.Rows.Add(_drFixed); } } applicationDa.Dispose(); return(_dtFixed); }
public DataTable GetRolesApplications(string strValue) { CreateColumns(); var conn = StrConexion; var roleList = new List <Role>(); using (var sqlCon = new SqlConnection(conn)) { sqlCon.Open(); var cmd = new SqlCommand { Connection = sqlCon, CommandType = CommandType.StoredProcedure, CommandText = "usp_FindRoles" }; cmd.Parameters.AddWithValue("@strCampo", strValue); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { var role = new Role { RoleId = (int)reader["RoleId"], RoleName = (string)reader["RoleName"], RoleDescription = (string)reader["RoleDescription"], ApplicationId = (int)reader["ApplicationId"], DeclineDate = string.IsNullOrEmpty(reader["DeclineDate"].ToString()) ? string.Empty : string.Format("{0:dd/MM/yyyy}", reader["DeclineDate"]) }; roleList.Add(role); } ApplicationDA applicationDa = new ApplicationDA(_configuration); //llenamos Tabla if (roleList.Count > 0) { foreach (var role in roleList) { _drFixed = _dtFixed.NewRow(); _drFixed["RoleId"] = role.RoleId; _drFixed["RoleName"] = role.RoleName; _drFixed["RoleDescription"] = role.RoleDescription; _drFixed["ApplicationId"] = role.ApplicationId; _drFixed["ApplicationName"] = applicationDa.FindApplication(role.ApplicationId).ApplicationName; _drFixed["DeclineDate"] = role.DeclineDate; _dtFixed.Rows.Add(_drFixed); } } applicationDa.Dispose(); } return(_dtFixed); }