static void Main(string[] args)
{
var builder = new ConfigurationBuilder()
.SetBasePath(Directory.GetCurrentDirectory())
.AddJsonFile("appsettings.json");
Configuration = builder.Build();
string banjoConnectionString = Configuration.GetConnectionString("banjo");
Console.WriteLine(banjoConnectionString);
var optionsBuilder = new DbContextOptionsBuilder <BanjoContext>();
optionsBuilder.UseSqlServer(banjoConnectionString);
var banjoContext = new BanjoContext(optionsBuilder.Options);
var repository = new GuestsRepository(banjoContext);
if (!args.Any())
{
Console.WriteLine("Required Argument: Excel File For Import");
return;
}
string fileName = $"{Directory.GetCurrentDirectory()}\\{args[0]}";
Console.WriteLine($"Reading: {fileName}");
//Create COM Objects. Create a COM object for everything that is referenced
XSSFWorkbook workbook = new XSSFWorkbook(fileName);
ISheet sheet = workbook.GetSheetAt(0);
var guestList = new List <Guest>();
for (int i = 0; i <= sheet.LastRowNum; ++i) //Loop the records upto filled row
{
IRow row = sheet.GetRow(i);
if (row != null) //null is when the row only contains empty cells
{
//PrintGuest(row.ToEntity());
guestList.Add(row.ToEntity());
}
}
var task = Task.Run(async() => { await repository.Add(guestList); });
Task.WaitAll(task);
Console.WriteLine("Finished, Cleaning up!");
}
public void Can_Save_Node()
{
var node = new Node { Text = "Test Note " + DateTime.Now.ToString() };
using (var db = new BanjoContext())
{
db.Nodes.Add(node);
db.SaveChanges();
Assert.IsNotNull(node.NodeId);
Assert.AreNotEqual(0, node.NodeId);
}
using (var db = new BanjoContext())
{
var savedNode = db.Nodes.SingleOrDefault(x => x.NodeId == node.NodeId);
Assert.IsNotNull(savedNode);
}
}
public void Can_Save_Node()
{
var node = new Node {
Text = "Test Note " + DateTime.Now.ToString()
};
using (var db = new BanjoContext())
{
db.Nodes.Add(node);
db.SaveChanges();
Assert.IsNotNull(node.NodeId);
Assert.AreNotEqual(0, node.NodeId);
}
using (var db = new BanjoContext())
{
var savedNode = db.Nodes.SingleOrDefault(x => x.NodeId == node.NodeId);
Assert.IsNotNull(savedNode);
}
}
public void Can_Save_Children()
{
int rootNodeId;
int childNodeId;
using (var db = new BanjoContext())
{
var rootNode = new Node
{
Text = "Root"
};
db.Nodes.Add(rootNode);
db.SaveChanges();
rootNodeId = rootNode.NodeId.Value;
}
using (var db = new BanjoContext())
{
var childNode = new Node
{
Text = "Child",
ParentNodeId = rootNodeId
};
db.Nodes.Add(childNode);
db.SaveChanges();
childNodeId = childNode.NodeId.Value;
}
using (var db = new BanjoContext())
{
var rootNode = db.Nodes.Single(x => x.NodeId == rootNodeId);
Assert.IsNotNull(rootNode);
Assert.IsNotNull(rootNode.ChildNodes);
Assert.AreEqual(1, rootNode.ChildNodes.Count);
}
}
public void Can_Save_Children()
{
int rootNodeId;
int childNodeId;
using (var db = new BanjoContext())
{
var rootNode = new Node
{
Text = "Root"
};
db.Nodes.Add(rootNode);
db.SaveChanges();
rootNodeId = rootNode.NodeId.Value;
}
using (var db = new BanjoContext())
{
var childNode = new Node
{
Text = "Child",
ParentNodeId = rootNodeId
};
db.Nodes.Add(childNode);
db.SaveChanges();
childNodeId = childNode.NodeId.Value;
}
using (var db = new BanjoContext())
{
var rootNode = db.Nodes.Single(x => x.NodeId == rootNodeId);
Assert.IsNotNull(rootNode);
Assert.IsNotNull(rootNode.ChildNodes);
Assert.AreEqual(1, rootNode.ChildNodes.Count);
}
}
public GuestsRepository(BanjoContext banjoContext)
{
_banjoContext = banjoContext;
}
public CommentsRepository(BanjoContext banjoContext)
{
_banjoContext = banjoContext;
}
