//public Grammar Grammar { get; set; }
private void Form1_Load(object sender, EventArgs e)
{
ParseGrammar parser = ParseGrammar.GetInstance();
parser.ReadFromFile(@"grammar.txt");
parser.Parse();
Grammar grammar = parser.Grammar;
InitGrammar(grammar);
TableMaker maker = new TableMaker(grammar);
maker.MakeTable();
FillTable(maker);
//Grammar = grammar;
// to excel
ToCsV(dataGridView1, @"table.xls");
}
static void Main(string[] args)
{
#region TxtWriteRead
string baseText;
using (StreamReader fileReader = new StreamReader(@"C:\Users\RAMAND\Desktop\c#_trainingTracker\training1.txt")) {
baseText = fileReader.ReadToEnd();
}
using (StreamWriter file = new StreamWriter(@"C:\Users\RAMAND\Desktop\c#_trainingTracker\training1.txt"))
{
file.WriteLine("abcdef");
}
#endregion
#region XLground
/*using (var workbook = new XLWorkbook())
* {
#region Writing to XL
* var worksheet = workbook.Worksheets.Add("Sample Sheet");
* worksheet.Cell("A1").Value = "Hello World!";
* worksheet.Cell("B5").Value = "llo World!gdsg";
* worksheet.Cell("C3").FormulaA1 = "=MID(B5, 7, 5)";
* worksheet.Columns("A", "D").AdjustToContents();
* workbook.SaveAs(@"C:\Users\RAMAND\Desktop\c#_trainingTracker\trainingX.xlsx");
#endregion
*
#region Reading from XL
* var newWorksheet = workbook.Worksheet("Sample Sheet");
* Console.WriteLine($"{newWorksheet.Cell("C3").Value}");
#endregion
*
* }*/
//WorksheetChecker.CheckWorksheets();
//var TM = new TableMaker();
//TM.CreateTable();
//SheetReader.ReadToConsole();
//SheetReader.ReadDates();
#endregion
var folderPath = @"C:\Users\RAMAND\Desktop\c#_trainingTracker";
var workbookHandler = new _WorkbookHandler(folderPath, "MP");
var workbook = workbookHandler.getWorkbook();
var worksheetHandler = new _WorksheetHandler(workbook, DateTime.Now.AddMonths(0).Month.ToString());
worksheetHandler.Worksheet.Clear();
var tableMaker = new TableMaker(workbook, worksheetHandler.Worksheet);
var tableReader = new TableReader();
List <string[]> tableRows = new List <string[]>();
tableRows.Add(new string[] { "BP", "100", "10", "10", "10000", "HPush" });
tableRows.Add(new string[] { "Cable Row", "100", "10", "10", "10000", "HPull" });
tableRows.Add(new string[] { "OHP", "100", "10", "10", "10000", "VPush" });
tableMaker.CreateTable(new string[] { "Exercise", "Weight", "Sets", "Reps", "Volume", "Type" }, null, tableRows);
TrainingDataMapper.AddTraining(new TrainingModel(DateTime.Now), workbook);
List <ExerciseModel> exerciseList = new List <ExerciseModel>();
exerciseList.Add(new ExerciseModel("A", 1, 1, 1));
exerciseList.Add(new ExerciseModel("B", 2, 2, 2));
exerciseList.Add(new ExerciseModel("C", 3, 3, 3));
TrainingModel training = new TrainingModel(DateTime.Now.AddDays(1), exerciseList);
//tableMaker.InsertTable(tableReader.GetTableStart(worksheetHandler.Worksheet, 7), new string[] { "Exercise", "Weight", "Sets", "Reps", "Volume", "Type" }, null, tableRows);
TrainingDataMapper.UpdateTraining(training, workbook, 2);
TrainingDataMapper.DeleteTraining(worksheetHandler.Worksheet, 1);
//TrainingDataMapper.GetAllTrainings(folderPath, "kk");
//var trg = TrainingDataMapper.GetTraining(worksheetHandler.Worksheet, 1);
//worksheetHandler.SheetName = "3";
//var trgs = TrainingDataMapper.GetMonthTrainings(worksheetHandler.Worksheet);
//var yTrgs = TrainingDataMapper.GetYearTrainings(workbook);
//TrainingDataMapper.DeleteTraining(worksheetHandler.Worksheet, 28);
worksheetHandler.Adjust();
workbook.Save();
Console.WriteLine("Finished");
}
public void ToList_Test_ThrowsArgumentExceptionGivenUnparsableInput()
{
var table = TableMaker.GenerateDataTable <MockSystemFile>(1);
Assert.ThrowsException <ArgumentException>(() => table.Rows.ToList <MockMetadataFile>());
}
public static TableMaker AddToTable(TableMaker table, params object[] items)
{
table.Add(items);
return(table);
}
