public static void Main(string[] args) { Console.WriteLine("Starting...."); // Check for envvars var dbVars = CheckEnvVars(); if (dbVars.Item1 == null || dbVars.Item2 == null) { Console.WriteLine("Environment vars not set, stopping...."); Environment.Exit(1); } else { Console.WriteLine("User: "******" Pass:"******"*****@*****.**"); // AddItem(db, "*****@*****.**"); } Console.WriteLine("Done..."); Console.ReadLine(); }
private static void AddUser(mapContext db, string emailAddress) { Mapuser mu = new Mapuser { Email = emailAddress }; db.Mapuser.Add(mu); db.SaveChanges(); Console.WriteLine(mu.Id + " " + mu.Email); }
private static void JustMe(mapContext db) { // Just me var me = db.Mapuser .Include(ua => ua.Useractions) .Single(u => u.Email.ToString() == "*****@*****.**"); Console.WriteLine(me.Email); foreach (var a in me.Useractions) { Console.WriteLine("\t" + a.Actions.Action); } }
private static void AllUserActions(mapContext db) { // Collection of UserActions var users = db.Useractions .Include(mu => mu.User) .Include(act => act.Actions) .ToList(); foreach (var u in users) { Console.WriteLine(u.User.Email + " ----- " + u.Actions.Action); } }
private static void ViaMapUsers(mapContext db) { // Go through the MapUsers to then get the Actions var fromUsers = db.Mapuser .Include(ua => ua.Useractions) .ToList(); foreach (var u in fromUsers) { Console.WriteLine(u.Email); foreach (var a in u.Useractions) { Console.WriteLine("\t" + a.Actions.Action); } } }
private static void AddItem(mapContext db, string who) { // get the user var me = db.Mapuser .Single(u => u.Email.ToString() == who); // get the first action var action = db.Actions .Single(i => i.Id == 1); // New up an object var ua = new Useractions(); ua.Actions = action; ua.User = me; ua.Actiondate = DateTime.Now; // Save it db.Useractions.Add(ua); db.SaveChanges(); // if it returns an ID, we're good Console.WriteLine("Done: " + ua.Id); }
public UnitOfWork(IDatabaseFactory dbFactory) { this.dbFactory = dbFactory; dataContext = dbFactory.DataContext; }
public DatabaseFactory() { dataContext = new mapContext(); }