public void ActToAdd(IDatabase database, ITable table) { ISystemeDatabaseModule databaseModule = (ISystemeDatabaseModule)this.systeme.GetSystemeModule(SystemeConstants.SystemeDatabaseModule); IDatabase systemDatabase = databaseModule.GetDatabaseContainer().GetDatabase(SystemeConstants.SystemDatabaseName); ITable profilesPrivilegesTable = systemDatabase.GetTable(SystemeConstants.PrivilegesOfProfilesOnTablesTableName); ITable tablePrivilegesTable = systemDatabase.GetTable(SystemeConstants.PrivilegesTableName); ITable adminProfileTable = systemDatabase.GetTable(SystemeConstants.NoRemovableProfilesTableName); IEnumerator <Row> adminProfilesrowEnumerator = adminProfileTable.GetRowEnumerator(); IEnumerator <Row> tablePrivilegesRowEnumerator = tablePrivilegesTable.GetRowEnumerator(); Row row; while (adminProfilesrowEnumerator.MoveNext()) { while (tablePrivilegesRowEnumerator.MoveNext()) { row = profilesPrivilegesTable.CreateRowDefinition(); row.GetCell(SystemeConstants.PrivilegesOfProfilesOnTablesDatabaseNameColumnName).data = database.databaseName; row.GetCell(SystemeConstants.PrivilegesOfProfilesOnTablesTableNameColumnName).data = table.tableName;//If i dont use an array with lamdas with this is because of NO LIAR LA COSA MAS row.GetCell(SystemeConstants.PrivilegesOfProfilesOnTablesProfileColumnName).data = adminProfilesrowEnumerator.Current.GetCell(SystemeConstants.ProfileNameColumn).data; row.GetCell(SystemeConstants.PrivilegesOfProfilesOnTablesPrivilegeColumnName).data = tablePrivilegesRowEnumerator.Current.GetCell(SystemeConstants.PrivilegesPrivilegeNameColumnName).data; profilesPrivilegesTable.AddRow(row); } tablePrivilegesRowEnumerator.Reset(); } }
private static void CreateSitesCsv(CsvDb db, Dictionary <CompoundIdentity, Tuple <int, Site> > siteDict) { string[] cols = new string[] { "SiteKey", "Name", "Description", "Location", "LocationMark" }; ITable sites = db.Create("Sites", cols); var orderedSites = siteDict.OrderBy(x => x.Value.Item1); foreach (var site in orderedSites) { Site s = site.Value.Item2; IRow r = sites.CreateRow(); r[0] = site.Value.Item1.ToString(); r[1] = s.Name; r[2] = s.Description; IGeometry2 <double> geom = s.Location; if (geom != null) { if (geom is PolygonBag2 <double> ) { r[3] = WktUtils.ToWkt(geom as PolygonBag2 <double>).ToString(); } else if (geom is Polygon2 <double> ) { r[3] = WktUtils.ToWkt(geom as Polygon2 <double>).ToString(); } else if (geom is Polyline2 <double> ) { r[3] = WktUtils.ToWkt(geom as Polyline2 <double>).ToString(); } else if (geom is PolylineBag2 <double> ) { r[3] = WktUtils.ToWkt(geom as PolylineBag2 <double>).ToString(); } else if (geom is Point2 <double> ) { r[3] = WktUtils.ToWkt(geom as Point2 <double>).ToString(); } } else { r[3] = ""; } Point2 <double> geom2 = s.LocationMark; if (geom2 != null) { r[4] = WktUtils.ToWkt(geom2 as Point2 <double>).ToString(); } else { r[4] = ""; } sites.AddRow(r); } sites.Flush(); return; }
public override void ExecuteParticularQueryAction() { ITable table = this.GetContainer().GetDatabase(this.targetDatabase).GetTable(this.targetTableName); Row row = table.CreateRowDefinition(); row.GetCell(SystemeConstants.ProfileNameColumn).data = this.profileName; table.AddRow(row); this.SetResult(QuerysStringResultConstants.SecurityProfileCreated); }
private void RenderTableRow(TableRowLayout layout, ITable table) { ITableRow row = table.AddRow((s.TableRowStyle)layout.Style, layout.TrackingInfo); foreach (TableCellLayout cell in layout.SubLayouts) { RenderTableCell(cell, row); } }
private void AddTableRows(ITable table) { ITableRow tableRow; ITableCell tableCell; IText cellText; int i = 0; Paddings cellPaddings = new Paddings(3, 0, 5, 3); string modifiedDate; foreach (Order order in this.ordersData) { tableRow = table.AddRow(); tableRow.Height = new FixedHeight(30); Background cellBackgroundColor = (i % 2 == 0) ? new Background(Colors.White) : new Background(new Color(235, 235, 235)); tableCell = tableRow.AddCell(); tableCell.Paddings = cellPaddings; tableCell.Background = cellBackgroundColor; tableCell.Borders = bordersStyle; cellText = tableCell.AddText(); cellText.Style.Font = fontStyle; cellText.AddContent(order.OrderID.ToString()); tableCell = tableRow.AddCell(); tableCell.Paddings = cellPaddings; tableCell.Background = cellBackgroundColor; tableCell.Borders = bordersStyle; cellText = tableCell.AddText(); cellText.Style.Font = fontStyle; cellText.AddContent(order.ContactName.ToString()); tableCell = tableRow.AddCell(); tableCell.Paddings = cellPaddings; tableCell.Background = cellBackgroundColor; tableCell.Borders = bordersStyle; cellText = tableCell.AddText(); cellText.Style.Font = fontStyle; cellText.AddContent(order.ShipAddress.ToString()); tableCell = tableRow.AddCell(); tableCell.Paddings = cellPaddings; tableCell.Background = cellBackgroundColor; tableCell.Borders = bordersStyle; cellText = tableCell.AddText(); cellText.Style.Font = fontStyle; modifiedDate = order.OrderDate != null?string.Format("{0:d}", order.OrderDate) : ""; cellText.AddContent(modifiedDate); i++; } }
static void CreateTable(CsvDb db, string name) { string[] cols = new string[] { "ColA", "ColB", "Col\"Tricky", "Col S" }; ITable tab = db.Create(name, cols); string[] vals = new string[] { "klsdkfs", "1231432", "sdfsdj' sdf'' sdf\"sdfs\"'sd sd ", ConvertUtils.F(DateTime.Now) }; for (int i = 0; i < 1000; i++) { IRow r = tab.CreateRow(); r.Write(vals); tab.AddRow(r); } tab.Flush(); for (int i = 0; i < 1000; i++) { IRow r = tab.CreateRow(); r[0] = ConvertUtils.F(new CompoundIdentity(Guid.NewGuid(), Guid.NewGuid())); r[1] = ConvertUtils.F((float)i); r[2] = "Hoos " + i; r[3] = ConvertUtils.F(Math.PI); tab.AddRow(r); } tab.Flush(); for (int i = 0; i < 1000; i++) { IRow r = tab.CreateRow(); r.S(0, new CompoundIdentity(Guid.NewGuid(), Guid.NewGuid())); r.S(1, (float)i); r.S(2, "Hoos " + i); r.S(3, Math.PI); tab.AddRow(r); } tab.Flush(); }
private static void CreateSampleEventCsv(CsvDb db, Dictionary <CompoundIdentity, Tuple <int, SamplingEvent> > eventDict, Dictionary <CompoundIdentity, Organization> orgDict, Dictionary <CompoundIdentity, FieldTrip> fieldTripDict, Dictionary <CompoundIdentity, FieldActivity> fieldActivityDict, Dictionary <CompoundIdentity, Project> projectDict) { //string[] cols = new string[] { "Org", "FieldTrip", "Activity", "Project", "SampleEvent", "SampleEventKey","SampleEventDesc", "SampleEventStart", "SampleEventEnd" }; string[] cols = new string[] { "Org", "FieldTrip", "Activity", "Project", "SampleEvent", "SampleEventKey", "SampleEventDesc" }; ITable samp = db.Create("SamplingEvents", cols); const string na = "Unknown or Not Authorized"; var orderedEvents = eventDict.OrderBy(x => x.Value.Item1); foreach (var evt in orderedEvents) { string orgName = na; if (orgDict.ContainsKey(evt.Value.Item2.PrincipalOrgId)) { orgName = orgDict[evt.Value.Item2.PrincipalOrgId].Name; } string ftripName = na; string factivityName = na; string projName = na; if (fieldTripDict.ContainsKey(evt.Value.Item2.FieldTripId)) { FieldTrip ftrip = fieldTripDict[evt.Value.Item2.FieldTripId]; ftripName = ftrip.Name; if (fieldActivityDict.ContainsKey(ftrip.FieldActivityId)) { FieldActivity factivity = fieldActivityDict[ftrip.FieldActivityId]; factivityName = factivity.Name; if (projectDict.ContainsKey(factivity.ProjectId)) { projName = projectDict[factivity.ProjectId].Name; } } } IRow r = samp.CreateRow(); r[0] = orgName; r[1] = ftripName; r[2] = factivityName; r[3] = projName; r[4] = evt.Value.Item2.Name; r[5] = evt.Value.Item1.ToString(); r[6] = evt.Value.Item2.Description; //r[7] = evt.Value.Item2.DateRange.Min.ToString(); //r[8] = evt.Value.Item2.DateRange.Max.ToString(); samp.AddRow(r); } samp.Flush(); return; }
public ITable Execute(Database db) { ITable t = db.Tables[Query.TableName]; Row nr = new Row(t); foreach (Set s in Query.Sets) { nr[s.Field] = s.Value; } t.AddRow(nr); return(null); }
public override void ExecuteParticularQueryAction() { ITable table = this.GetContainer().GetDatabase(this.targetDatabase).GetTable(this.targetTableName); Row row = table.CreateRowDefinition(); IEnumerator <string> keyEnumerator = this.values.Keys.GetEnumerator(); while (keyEnumerator.MoveNext()) { row.GetCell(keyEnumerator.Current).data = this.values[keyEnumerator.Current]; } table.AddRow(row); this.SetResult(QuerysStringResultConstants.SecurityUserCreated); }
public override void ExecuteParticularQueryAction(ITable table) { IEnumerator <string> valuesEnumerator = values.GetEnumerator(); IEnumerator <Column> columnEnumerator = table.GetColumnEnumerator(); Row newRow = table.CreateRowDefinition(); while (valuesEnumerator.MoveNext() && columnEnumerator.MoveNext()) { newRow.GetCell(columnEnumerator.Current.columnName).data = valuesEnumerator.Current; } table.AddRow(newRow); this.SetResult(this.GetResult() + QuerysStringResultConstants.InsertSuccess); }
public void DeleteRow_BadArgumentsInWhere_NotifiedInResult() { Database db = ObjectConstructor.CreateDatabaseFull("db"); ITable t = db.GetTable("Table1"); t.AddRow(t.CreateRowDefinition()); IDatabaseContainer container = ObjectConstructor.CreateDatabaseContainer(); container.AddDatabase(db); Delete delete = CreateDelete(container, db.databaseName, t.tableName); delete.whereClause.AddCritery("x", "a", Operator.equal); Assert.IsFalse(delete.ValidateParameters()); Assert.AreEqual(0, delete.GetAfectedRowCount()); }
public void GrandDatabasePrivilege_PKViolated_NoticeInValidate() { IDatabaseContainer databaseContainer = ObjectConstructor.CreateDatabaseContainer(); ITable table = databaseContainer.GetDatabase(SystemeConstants.SystemDatabaseName).GetTable(SystemeConstants.PrivilegesOfProfilesOnDatabasesTableName); Row row = table.CreateRowDefinition(); row.GetCell(SystemeConstants.PrivilegesOfProfilesOnDatabasesProfileColumnName).data = SystemeConstants.DefaultProfile; row.GetCell(SystemeConstants.PrivilegesOfProfilesOnDatabasesDatabaseNameColumnName).data = SystemeConstants.DefaultDatabaseName; row.GetCell(SystemeConstants.PrivilegesOfProfilesOnDatabasesPrivilegeColumnName).data = SystemeConstants.CreatePrivilegeName; table.AddRow(row); GrantDatabasePrivilege grantDatabasePrivilege = CreateGrantDatabasePrivilege(databaseContainer, SystemeConstants.SystemDatabaseName, table.tableName); grantDatabasePrivilege.SetData(row.GetCell(SystemeConstants.PrivilegesOfProfilesOnDatabasesPrivilegeColumnName).data, row.GetCell(SystemeConstants.PrivilegesOfProfilesOnDatabasesProfileColumnName).data, row.GetCell(SystemeConstants.PrivilegesOfProfilesOnDatabasesDatabaseNameColumnName).data); Assert.IsFalse(grantDatabasePrivilege.ValidateParameters()); }
public void DeleteRow_GodArguments_RowsDeleted() { Database db = ObjectConstructor.CreateDatabaseFull("db"); ITable t = db.GetTable("Table1"); t.AddRow(t.CreateRowDefinition()); IDatabaseContainer container = ObjectConstructor.CreateDatabaseContainer(); container.AddDatabase(db); Delete delete = CreateDelete(container, db.databaseName, t.tableName); delete.whereClause.AddCritery("Column3", t.GetColumn("Column3").dataType.GetDataTypeDefaultValue(), Operator.equal); Assert.IsTrue(delete.ValidateParameters()); delete.ExecuteParticularQueryAction(t); Assert.IsTrue(delete.GetAfectedRowCount() > 0); }
public void Select_GoodArguments_ShouldFindResults() { Database database = ObjectConstructor.CreateDatabaseFull("test1"); ITable table = database.GetTable("Table1"); table.AddRow(table.CreateRowDefinition()); IDatabaseContainer databaseContainer = ObjectConstructor.CreateDatabaseContainer(); databaseContainer.AddDatabase(database); Select select = CreateSelect(databaseContainer, database.databaseName, table.tableName, true); select.whereClause.AddCritery("Column3", table.GetColumn("Column3").dataType.GetDataTypeDefaultValue(), Operator.equal); Assert.IsTrue(select.ValidateParameters()); select.Execute(); Assert.IsTrue(select.GetAfectedRowCount() > 0); }
public void LoginUserExist_Login() { IDatabaseContainer databaseContainer = ObjectConstructor.CreateDatabaseContainer(); IUserThread userThread = ObjectConstructor.GetFakeUserThread(); ITable table = databaseContainer.GetDatabase(SystemeConstants.SystemDatabaseName).GetTable(SystemeConstants.UsersTableName); string newUsername = ShittyUtilities.GetDoesntExistUserName(databaseContainer); string password = "******"; Row row = table.CreateRowDefinition(); row.GetCell(SystemeConstants.UsersNameColumnName).data = newUsername; row.GetCell(SystemeConstants.UsersPasswordColumnName).data = password; table.AddRow(row); Login login = CreateLogin(databaseContainer, userThread, SystemeConstants.SystemDatabaseName, SystemeConstants.UsersTableName); login.SetData(newUsername, password); Assert.IsTrue(login.ValidateParameters()); }
public void RevoqueDatabasePrivilege_AllParamsExist_RowExist_DeleteRow() { IDatabaseContainer databaseContainer = ObjectConstructor.CreateDatabaseContainer(); ITable table = databaseContainer.GetDatabase(SystemeConstants.SystemDatabaseName).GetTable(SystemeConstants.PrivilegesOfProfilesOnDatabasesTableName); Row row = table.CreateRowDefinition(); row.GetCell(SystemeConstants.PrivilegesOfProfilesOnDatabasesProfileColumnName).data = SystemeConstants.DefaultProfile; row.GetCell(SystemeConstants.PrivilegesOfProfilesOnDatabasesDatabaseNameColumnName).data = SystemeConstants.DefaultDatabaseName; row.GetCell(SystemeConstants.PrivilegesOfProfilesOnDatabasesPrivilegeColumnName).data = SystemeConstants.CreatePrivilegeName; table.AddRow(row); int rowNumber = table.GetRowCount(); RevokeDatabasePrivilege revoqueDatabasePrivilege = CreateRevoqueDatabasePrivilege(databaseContainer, SystemeConstants.SystemDatabaseName, SystemeConstants.PrivilegesOfProfilesOnDatabasesTableName); revoqueDatabasePrivilege.SetData(SystemeConstants.DefaultProfile, SystemeConstants.DefaultDatabaseName, SystemeConstants.CreatePrivilegeName); Assert.IsTrue(revoqueDatabasePrivilege.ValidateParameters()); revoqueDatabasePrivilege.Execute(); Assert.AreEqual(rowNumber - 1, table.GetRowCount()); }
private static void CreateMeasurementsCsv(CsvDb db, Dictionary <CompoundIdentity, Tuple <int, Site> > siteDict, Dictionary <CompoundIdentity, Tuple <int, SamplingEvent> > eventDict, Dictionary <CompoundIdentity, Tuple <int, WaterQualityDeployment> > deploymentDict, List <Tuple <int, WaterQualityMeasurement> > measurementList) { string[] cols = new string[] { "DataKey", "Deployment", "DeployDesc", "SamplingEventKey", "SiteKey", "DeployStart", "DeployEnd", "SampleDate", "SurfaceElevation", "Temperature", "pH", "DissolvedOxygen", "Conductivity", "Salinity", "Velocity" }; ITable measurements = db.Create("WaterQualityMeasurements", cols); var orderedMeasurements = measurementList.OrderBy(x => x.Item1); foreach (var meas in orderedMeasurements) { WaterQualityDeployment deploy = deploymentDict[meas.Item2.DeploymentId].Item2; WaterQualityMeasurement measurement = meas.Item2; int eventIndex = eventDict[deploy.SampleEventId].Item1; //deploy.SiteId could be a dangling reference string siteFK = na; if (siteDict.ContainsKey(deploy.SiteId)) { siteFK = siteDict[deploy.SiteId].Item1.ToString(); } IRow r = measurements.CreateRow(); r[0] = meas.Item1.ToString(); r[1] = deploy.Name; r[2] = deploy.Description; r[3] = eventIndex.ToString(); r[4] = siteFK; r[5] = deploy.Range.StartDate.ToString(); r[6] = deploy.Range.EndDate.ToString(); r[7] = measurement.SampleDate.ToString(); r[8] = measurement.SurfaceElevation.ToString(); r[9] = measurement.Temperature.ToString(); r[10] = measurement.pH.ToString(); r[11] = measurement.DissolvedOxygen.ToString(); r[12] = measurement.Conductivity.ToString(); r[13] = measurement.Salinity.ToString(); r[14] = measurement.Velocity.ToString(); measurements.AddRow(r); } measurements.Flush(); return; }
private void RenderPhotoTable(PhotoTableLayout layout, IContentContainer container) { // Create a table s.TableStyle tableStyle = null; if (layout.Style != null) { s.PhotoStyle photoStyle = (s.PhotoStyle)layout.Style; tableStyle = new s.TableStyle { Border = photoStyle.Border, Padding = photoStyle.Padding }; } int columnWidth = layout.Bounds.Width / layout.NumColumns; int[] columnWidths = new int[layout.NumColumns]; for (int x = 0; x < columnWidths.Length; ++x) { columnWidths[x] = columnWidth; } ITable table = container.AddTable(layout.Bounds.Width, columnWidths, tableStyle, layout.TrackingInfo); // Create a table row for each photo row foreach (PhotoRowLayout photoRow in layout.SubLayouts) { s.TableRowStyle rowStyle = null; if (photoRow.Style != null) { s.PhotoStyle photoStyle = (s.PhotoStyle)photoRow.Style; rowStyle = new s.TableRowStyle { BackColor = photoRow.BackgroundColor, Padding = photoStyle.Padding }; } ITableRow tableRow = table.AddRow(rowStyle, photoRow.TrackingInfo); RenderPhotoRow(photoRow, tableRow); } }
public void DeleteUser_TheUserExist_DeleteUser() { IDatabaseContainer databaseContainer = ObjectConstructor.CreateDatabaseContainer(); ITable table = databaseContainer.GetDatabase(SystemeConstants.SystemDatabaseName).GetTable(SystemeConstants.UsersTableName); Column column = table.GetColumn(SystemeConstants.UsersNameColumnName); string username = VariousFunctions.GenerateRandomString(8); while (column.ExistCells(username)) { username = VariousFunctions.GenerateRandomString(8); } Row row = table.CreateRowDefinition(); row.GetCell(SystemeConstants.UsersNameColumnName).data = username; table.AddRow(row); DeleteUser deleteUser = CreateDeleteUser(databaseContainer); deleteUser.SetTargetUserName(username); Assert.IsTrue(deleteUser.ValidateParameters()); deleteUser.Execute(); Assert.IsFalse(column.ExistCells(username)); }
public void DropSecurity_TheProfileCanDrop_DropTheProfile() { IDatabaseContainer databaseContainer = ObjectConstructor.CreateDatabaseContainer(); ITable table = databaseContainer.GetDatabase(SystemeConstants.SystemDatabaseName).GetTable(SystemeConstants.ProfilesTableName); Column column = table.GetColumn(SystemeConstants.ProfileNameColumn); string profileName = VariousFunctions.GenerateRandomString(8); while (column.ExistCells(profileName)) { profileName = VariousFunctions.GenerateRandomString(8); } Row row = table.CreateRowDefinition(); row.GetCell(SystemeConstants.ProfileNameColumn).data = profileName; table.AddRow(row); int numberOfRow = table.GetRowCount(); DropSecurityProfile dropSecurityProfile = CreateDropSecurityProfile(databaseContainer, SystemeConstants.SystemDatabaseName, SystemeConstants.ProfilesTableName); dropSecurityProfile.SetTargetSecurityProfile(profileName); Assert.IsTrue(dropSecurityProfile.ValidateParameters()); dropSecurityProfile.Execute(); Assert.AreEqual(numberOfRow - 1, table.GetRowCount()); }
private void LoadTableData(string databaseName, ITable table) { XmlDocument tableDataDocument = new XmlDocument(); tableDataDocument.Load(this.GetUbicationManager().GetTableDataFilePath(databaseName, table.tableName) + extension); IEnumerator rowEnumerator = tableDataDocument.GetElementsByTagName(XMLTagsConstants.TableDataRowElementTag_WR).GetEnumerator(); IEnumerator cellEnumerator; XmlNode xmlCellNode; Row row; Cell cell; while (rowEnumerator.MoveNext()) { row = table.CreateRowDefinition(); cellEnumerator = ((XmlNode)rowEnumerator.Current).SelectNodes(XMLTagsConstants.TableDataCellElementTag_WR).GetEnumerator(); while (cellEnumerator.MoveNext()) { xmlCellNode = (XmlNode)cellEnumerator.Current; cell = row.GetCell(xmlCellNode.Attributes.GetNamedItem(XMLTagsConstants.TableDataCellColumnNameAtributeTag_WR).InnerText); cell.data = cell.column.dataType.ParseLoadData(xmlCellNode.InnerText); } table.AddRow(row); } }
public void ActToAdd(IDatabase database) { ISystemeDatabaseModule databaseModule = (ISystemeDatabaseModule)this.systeme.GetSystemeModule(SystemeConstants.SystemeDatabaseModule); IDatabase systemDatabase = databaseModule.GetDatabaseContainer().GetDatabase(SystemeConstants.SystemDatabaseName); ITable profilesPrivilegesOnDatabasesTable = systemDatabase.GetTable(SystemeConstants.PrivilegesOfProfilesOnDatabasesTableName); ITable databasesPrivilegesTable = systemDatabase.GetTable(SystemeConstants.DatabasesPrivilegesTableName); ITable adminProfileTable = systemDatabase.GetTable(SystemeConstants.NoRemovableProfilesTableName); IEnumerator <Row> adminProfilesrowEnumerator = adminProfileTable.GetRowEnumerator(); IEnumerator <Row> databasesPrivilegesRowEnumerator = databasesPrivilegesTable.GetRowEnumerator(); Row row; while (adminProfilesrowEnumerator.MoveNext()) { while (databasesPrivilegesRowEnumerator.MoveNext()) { row = profilesPrivilegesOnDatabasesTable.CreateRowDefinition(); row.GetCell(SystemeConstants.PrivilegesOfProfilesOnDatabasesDatabaseNameColumnName).data = database.databaseName; row.GetCell(SystemeConstants.PrivilegesOfProfilesOnDatabasesProfileColumnName).data = adminProfilesrowEnumerator.Current.GetCell(SystemeConstants.ProfileNameColumn).data; row.GetCell(SystemeConstants.PrivilegesOfProfilesOnDatabasesPrivilegeColumnName).data = databasesPrivilegesRowEnumerator.Current.GetCell(SystemeConstants.DatabasesPrivilegesPrivilegeNameColumnName).data; profilesPrivilegesOnDatabasesTable.AddRow(row); } databasesPrivilegesRowEnumerator.Reset(); } }
/// <summary> /// Вывод информации в таблицу: (5) /// </summary> /// <param name="tableCreationData"></param> private void DisplayInformationInTable(ITableRowCreationData tableCreationData) { var data = tableCreationData; table.AddRow(data); }
private void AddTableRows(ITable table) { ITableRow tableRow; ITableCell tableCell; IText cellText; int i = 0; Paddings cellPaddings = new Paddings(3, 0, 5, 3); string modifiedDate; foreach (Order order in this.ordersData) { tableRow = table.AddRow(); tableRow.Height = new FixedHeight(30); Background cellBackgroundColor = (i % 2 == 0) ? new Background(Colors.White) : new Background(new Color(235, 235, 235)); tableCell = tableRow.AddCell(); tableCell.Paddings = cellPaddings; tableCell.Background = cellBackgroundColor; tableCell.Borders = bordersStyle; cellText = tableCell.AddText(); cellText.Style.Font = fontStyle; cellText.AddContent(order.OrderID.ToString()); tableCell = tableRow.AddCell(); tableCell.Paddings = cellPaddings; tableCell.Background = cellBackgroundColor; tableCell.Borders = bordersStyle; cellText = tableCell.AddText(); cellText.Style.Font = fontStyle; cellText.AddContent(order.ContactName.ToString()); tableCell = tableRow.AddCell(); tableCell.Paddings = cellPaddings; tableCell.Background = cellBackgroundColor; tableCell.Borders = bordersStyle; cellText = tableCell.AddText(); cellText.Style.Font = fontStyle; cellText.AddContent(order.ShipAddress.ToString()); tableCell = tableRow.AddCell(); tableCell.Paddings = cellPaddings; tableCell.Background = cellBackgroundColor; tableCell.Borders = bordersStyle; cellText = tableCell.AddText(); cellText.Style.Font = fontStyle; modifiedDate = order.OrderDate != null ? string.Format("{0:d}", order.OrderDate) : ""; cellText.AddContent(modifiedDate); i++; } }