public void CreateStatementForTable(CreateStatement createStatement, int rootPage)
{
if (this.If_in(createStatement.TableName))
{
throw new TableOrIndexAlreadyExistsException("Table Already Exists");
}
Models.Table a = new Models.Table(createStatement, rootPage);
tables.Add(a);
Save_table(this.tables);
}
internal static void ManageFooterRow(Models.Document document, Models.Table table, Table wordTable, TableLook tableLook, ContextModel context, OpenXmlPart documentPart, IFormatProvider formatProvider)
{
// add footer row
if (table.FooterRow != null)
{
wordTable.AppendChild(table.FooterRow.Render(document, wordTable, context, documentPart, false, false, formatProvider));
tableLook.LastRow = OnOffValue.FromBoolean(true);
}
}
//try to create one table and save the result into the file
//if succeed, return true
//if the table is already created, return false
public bool TryCreateStatementForTable(CreateStatement createStatement, int rootPage)
{
if (this.If_in(createStatement.TableName))
{
return(false);
}
Models.Table a = new Models.Table(createStatement, rootPage);
tables.Add(a);
Save_table(this.tables);
return(true);
}
internal static void ManageBeforeAfterRows(Models.Document document, Models.Table table, IList <Models.Row> rows, Table wordTable, ContextModel context, OpenXmlPart documentPart, IFormatProvider formatProvider)
{
// After rows :
if (rows != null && rows.Count > 0)
{
foreach (var row in rows)
{
row.InheritFromParent(table);
wordTable.AppendChild(row.Render(document, wordTable, context, documentPart, false, false, formatProvider));
}
}
}
public ActionResult Create([Bind(Include = "Testament,Book,Chapter,Number,Text")] Models.Table verse)
{
try
{
versesDB1.Tables.Add(verse);
versesDB1.SaveChanges();
return(View("Success"));
}
catch
{
return(View("Failure"));
}
}
public async Task <Models.Table[]> GetTablesAsync()
{
var res = await dynamoDB.ScanAsync(new ScanRequest
{
TableName = "Table"
});
if (res != null && res.Items != null)
{
List <Models.Table> tbs = new List <Models.Table>();
foreach (var item in res.Items)
{
var tb = new Models.Table {
tableName = item["tableName"].S
};
try
{
foreach (var name in item["attr"].M)
{
var a = new Models.Attribute {
};
a.attrName = name.Key.ToString();
a.type = name.Value.M["type"].S.ToString();
a.key = name.Value.M["key"].S.ToString();
if (a.key == "HashKey")
{
tb.hashKey = a.attrName;
}
else if (a.key == "RangeKey")
{
tb.rangeKey = a.attrName;
}
tb.attr.Add(a);
}
}catch {
tbs.Add(tb);
continue;
}
tbs.Add(tb);
}
return(tbs.ToArray());
}
return(Array.Empty <Models.Table>());
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
btnSave.Focus();
if (!btnSave.IsFocused)
{
return;
}
if (!AllowSave())
{
return;
}
Models.Table table = new Models.Table();
table.TableID = txtTableID.Text;
table.TableName = txtTableName.Text;
table.Position = txtPosition.Text;
bool bRet = false;
btnSave.IsEnabled = false;
if (_fromState == EnumFormState.FormAdd)
{
bRet = BLTable.AddTable(table);
}
else
{
bRet = BLTable.UpdateTable(table);
}
if (bRet)
{
Lemon3.Messages.L3Msg.SaveOK();
TableID = txtTableID.Text;
Close();
btnSave.IsEnabled = true;
}
else
{
Lemon3.Messages.L3Msg.SaveNotOK();
btnSave.IsEnabled = true;
}
}
public static bool IsTypedTable(this Models.Table obj) => obj?.TypedTable != TypedTableConstants.None;
public static bool IsEnumOnly(this Models.Table obj) => obj?.TypedTable == TypedTableConstants.EnumOnly;
internal static Tuple <Table, TableLook> CreateTable(Models.Document document, Models.Table table, ContextModel context, OpenXmlPart documentPart, IFormatProvider formatProvider)
{
Table wordTable = new Table();
TableProperties wordTableProperties = new TableProperties();
var tableLook = new TableLook()
{
FirstRow = OnOffValue.FromBoolean(false),
LastRow = OnOffValue.FromBoolean(false),
FirstColumn = OnOffValue.FromBoolean(false),
LastColumn = OnOffValue.FromBoolean(false),
NoHorizontalBand = OnOffValue.FromBoolean(false),
NoVerticalBand = OnOffValue.FromBoolean(false)
};
wordTableProperties.AppendChild(tableLook);
//The type must be Dxa, if the value is set to Pct : the open xml engine will ignored it !
wordTableProperties.TableIndentation = new TableIndentation()
{
Width = table.TableIndentation.Width, Type = TableWidthUnitValues.Dxa
};
wordTable.AppendChild(wordTableProperties);
if (table.Borders != null)
{
TableBorders borders = table.Borders.Render();
wordTableProperties.AppendChild(borders);
}
// add column width definitions
if (table.ColsWidth != null)
{
wordTable.AppendChild(new TableLayout()
{
Type = TableLayoutValues.Fixed
});
TableGrid tableGrid = new TableGrid();
foreach (int width in table.ColsWidth)
{
tableGrid.AppendChild(new GridColumn()
{
Width = width.ToString(CultureInfo.InvariantCulture)
});
}
wordTable.AppendChild(tableGrid);
}
if (table.TableWidth != null)
{
wordTable.AppendChild(new TableWidth()
{
Width = table.TableWidth.Width, Type = table.TableWidth.Type.ToOOxml()
});
}
// add header row
if (table.HeaderRow != null)
{
wordTable.AppendChild(table.HeaderRow.Render(document, wordTable, context, documentPart, true, false, formatProvider));
tableLook.FirstRow = OnOffValue.FromBoolean(true);
}
return(new Tuple <Table, TableLook>(wordTable, tableLook));
}
/// <summary>
/// Render a table element
/// </summary>
/// <param name="table"></param>
/// <param name="parent"></param>
/// <param name="context"></param>
/// <param name="formatProvider"></param>
/// <returns></returns>
public static Table Render(this Models.Table table, Models.Document document, OpenXmlElement parent, ContextModel context, OpenXmlPart documentPart, IFormatProvider formatProvider)
{
context.ReplaceItem(table, formatProvider);
var createdTable = CreateTable(document, table, context, documentPart, formatProvider);
var wordTable = createdTable.Item1;
var tableLook = createdTable.Item2;
// Before rows :
ManageBeforeAfterRows(document, table, table.BeforeRows, wordTable, context, documentPart, formatProvider);
// add content rows
if (!string.IsNullOrEmpty(table.DataSourceKey))
{
if (context.ExistItem <DataSourceModel>(table.DataSourceKey))
{
var datasource = context.GetItem <DataSourceModel>(table.DataSourceKey);
int i = 0;
foreach (var item in datasource.Items)
{
var row = table.RowModel.Clone();
row.InheritFromParent(table);
if (!string.IsNullOrWhiteSpace(table.AutoContextAddItemsPrefix))
{
// We add automatic keys :
// Is first item
item.AddItem("#" + table.AutoContextAddItemsPrefix + "_TableRow_IsFirstItem#", new BooleanModel(i == 0));
item.AddItem("#" + table.AutoContextAddItemsPrefix + "_TableRow_IsNotFirstItem#", new BooleanModel(i > 0));
// Is last item
item.AddItem("#" + table.AutoContextAddItemsPrefix + "_TableRow_IsLastItem#", new BooleanModel(i == datasource.Items.Count - 1));
// Index of the element (Based on 0, and based on 1)
item.AddItem("#" + table.AutoContextAddItemsPrefix + "_TableRow_IndexBaseZero#", new StringModel(i.ToString()));
item.AddItem("#" + table.AutoContextAddItemsPrefix + "_TableRow_IndexBaseOne#", new StringModel((i + 1).ToString()));
item.AddItem("#" + table.AutoContextAddItemsPrefix + "_TableRow_IsOdd#", new BooleanModel(i % 2 == 1));
item.AddItem("#" + table.AutoContextAddItemsPrefix + "_TableRow_IsEven#", new BooleanModel(i % 2 == 0));
}
wordTable.AppendChild(row.Render(document, wordTable, item, documentPart, false, (i % 2 == 1), formatProvider));
i++;
}
}
}
else
{
int i = 0;
foreach (var row in table.Rows)
{
row.InheritFromParent(table);
wordTable.AppendChild(row.Render(document, wordTable, context, documentPart, false, (i % 2 == 1), formatProvider));
i++;
}
}
// After rows :
ManageBeforeAfterRows(document, table, table.AfterRows, wordTable, context, documentPart, formatProvider);
// Footer
ManageFooterRow(document, table, wordTable, tableLook, context, documentPart, formatProvider);
parent.AppendChild(wordTable);
return(wordTable);
}
private void AddBd()
{
for (; ;)
{
Dictionary <string, string> Links = JsonConvert.DeserializeObject <Dictionary <string, string> >(File.ReadAllText(@"C:\Users\User\Desktop\БИСО-01-17\сенениум\SELENIUMinog\SELENIUMinog\bin\Debug\Links.json"));
Dictionary <string, string> Text = JsonConvert.DeserializeObject <Dictionary <string, string> >(File.ReadAllText(@"C:\Users\User\Desktop\БИСО-01-17\сенениум\SELENIUMinog\SELENIUMinog\bin\Debug\Text.json"));
Dictionary <string, string[]> Img = JsonConvert.DeserializeObject <Dictionary <string, string[]> >(File.ReadAllText(@"C:\Users\User\Desktop\БИСО-01-17\сенениум\SELENIUMinog\SELENIUMinog\bin\Debug\Img.json"));
int i = 0;
string[] LINK = new string[Links.Values.Count];
string[,] TEXT = new string[2, Links.Keys.Count];
string[,] IMG = new string[2, Links.Keys.Count];
foreach (string c in Links.Values)
{
LINK[i] = c;
i++;
}
i = 0;
foreach (string c in Links.Keys)
{
TEXT[0, i] = c;
if (Text.ContainsKey(TEXT[0, i]))
{
TEXT[1, i] = Text[TEXT[0, i]];
}
else
{
TEXT[1, i] = null;
}
i++;
}
string value;
i = 0;
foreach (string c in Links.Keys)
{
value = null;
IMG[0, i] = c;
if (Img.ContainsKey(IMG[0, i]))
{
for (int j = 0; j < Img[TEXT[0, i]].GetLength(0); j++)
{
value = value + Img[IMG[0, i]][j] + " ; ";
}
IMG[1, i] = value;
}
i++;
}
i = 0;
Models.MyDataBaseEntities db = new Models.MyDataBaseEntities();
List <Models.Table> lst2 = (from t in db.Tables select t).ToList();
foreach (string c in Links.Keys)
{
Models.Table t1 = new Models.Table()
{
Id = c,
Link = LINK[i],
Text = TEXT[1, i],
Img = IMG[1, i]
};
db.Tables.Add(t1);
db.SaveChanges();
i++;
}
File.WriteAllText(@"C:\Users\User\Desktop\Новая папка (2)\qwe.txt", "123123123123");
}
}
