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++;
}
}
