public Relationship(Table src, Table dest, Column srcColumn, Column destColumn) { Source = src; Destination = dest; SourceColumns.Add(srcColumn); DestinationColumns.Add(destColumn); }
public Relationship(Table src, Table dest, string srcColumn, string destColumn) { Source = src; Destination = dest; Column srcCol = Source[srcColumn]; Column destCol = Destination[destColumn]; if (srcCol != null && destCol != null) { SourceColumns.Add(srcCol); DestinationColumns.Add(destCol); } }
public ReportColumnsViewModel(Report report) : base(report) { Header = "Report Columns"; SubTitle = "Report Columns:"; Description = "Select the columns to display for this report."; AttributeType = AttributeType.Columns; SourceColumns = GetBasicAttributes(report.Columns.ToList(), report); PropertyChanged += ReportColumnsViewModel_PropertyChanged; foreach (var column in SourceColumns.Where(column => Report.Columns.All(x => x.Name != column.Name))) { column.IsSelected = false; } }
public virtual SourceCollection GetSourceList(SourceColumns orderBy, string orderDirection) { int totalRecords = 0; return GetSourceList(orderBy, orderDirection, 0, 0, out totalRecords); }
public virtual SourceCollection GetSourceList(SourceColumns orderBy, string orderDirection, int page, int pageSize, out int totalRecords) { try { Database database = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = database.GetStoredProcCommand("spSourceGetList"); database.AddInParameter(dbCommand, "@OrderBy", DbType.AnsiString, orderBy.ToString()); database.AddInParameter(dbCommand, "@OrderDirection", DbType.AnsiString, orderDirection.ToString()); database.AddInParameter(dbCommand, "@Page", DbType.Int32, page); database.AddInParameter(dbCommand, "@PageSize", DbType.Int32, pageSize); database.AddOutParameter(dbCommand, "@TotalRecords", DbType.Int32, 4); SourceCollection sourceCollection = new SourceCollection(); using (IDataReader reader = database.ExecuteReader(dbCommand)) { while (reader.Read()) { Source source = CreateSourceFromReader(reader); sourceCollection.Add(source); } reader.Close(); } totalRecords = (int)database.GetParameterValue(dbCommand, "@TotalRecords"); return sourceCollection; } catch (Exception ex) { // log this exception log4net.Util.LogLog.Error(ex.Message, ex); // wrap it and rethrow throw new ApplicationException(SR.DataAccessGetSourceListException, ex); } }
public static SourceCollection GetSourceList(SourceColumns orderBy, string orderDirection) { try { SourceDAO sourceDAO = new SourceDAO(); return sourceDAO.GetSourceList(orderBy, orderDirection); } catch (ApplicationException) { throw; } catch (Exception ex) { // log this exception log4net.Util.LogLog.Error(ex.Message, ex); // wrap it and rethrow throw new ApplicationException(SR.BusinessGetSourceListException, ex); } }