public static void AddTestUsers(ShopLensContext dbContext)
{
Console.WriteLine("Adding users...");
var user1 = new User {
Name = "Marijus",
ShoppingSessions = new List <ShoppingSession>
{
new ShoppingSession {
Date = DateTime.UtcNow.AddDays(-1)
},
new ShoppingSession {
Date = DateTime.UtcNow
}
}
};
var user2 = new User {
Name = "Marijus"
};
var user3 = new User {
Name = "Tomus"
};
var user4 = new User {
Name = "Edus"
};
var usersToAdd = new List <User> {
user1, user2, user3, user4
};
dbContext.Users.AddRange(usersToAdd);
dbContext.SaveChanges();
}
public static void DeleteAllUsers(ShopLensContext dbContext)
{
Console.WriteLine("Deleting users...");
var users = dbContext.Users.ToList();
dbContext.Users.RemoveRange(users);
dbContext.SaveChanges();
}
private ShopLensContext ConnectToDatabase()
{
var useLocalDb = Convert.ToBoolean(ConfigurationManager.AppSettings["UseLocalDb"]);
var connectionString = ConfigurationManager.AppSettings["DatabaseSource"];
var dbContext = new ShopLensContext(connectionString, useLocalDb);
dbContext.Database.Migrate();
return(dbContext);
}
public static void ListAllUsers(ShopLensContext dbContext)
{
Console.WriteLine("Listing all users...");
var users = dbContext.Users.ToList();
if (!users.Any())
{
Console.WriteLine("No users found.");
return;
}
foreach (var user in users)
{
Console.WriteLine($"User {user.UserId}: Name - {user.Name}, BDay - {user.Birthday}");
}
}
static void Main(string[] args)
{
var useLocalDb = Convert.ToBoolean(ConfigurationManager.AppSettings["UseLocalDb"]);
var connectionString = ConfigurationManager.ConnectionStrings["DatabaseSource"].ConnectionString;
ExecuteSqlRequirementQueries();
using (var dbContext = new ShopLensContext(connectionString, useLocalDb))
{
dbContext.Database.Migrate();
Console.WriteLine("Entity Framework queries:");
//DeleteAllUsers(dbContext);
//AddTestUsers(dbContext);
ListAllUsers(dbContext);
}
}
protected override void OnCreate(Bundle savedInstanceState)
{
base.OnCreate(savedInstanceState);
ConfigurationManager.Initialise(PCLAppConfig.FileSystemStream.PortableStream.Current);
DependencyInjection.RegisterInterfaces();
cmdOpenCamera = ConfigurationManager.AppSettings["CmdOpenCamera"];
cmdTakePhoto = ConfigurationManager.AppSettings["CmdTakePhoto"];
cmdOpenCart = ConfigurationManager.AppSettings["CmdOpenCart"];
cmdOpenList = ConfigurationManager.AppSettings["CmdOpenList"];
cmdHelp = ConfigurationManager.AppSettings["CmdHelp"];
cmdRemind = ConfigurationManager.AppSettings["CmdRemind"];
cmdTutorialRequest = ConfigurationManager.AppSettings["CmdTutorialRequest"];
cmdTutorialLikeShopLens = ConfigurationManager.AppSettings["CmdTutorialLikeShopLens"];
userGuidPrefKey = ConfigurationManager.AppSettings["UserGuidPrefKey"];
shopLensDbContext = ConnectToDatabase();
prefs = PreferenceManager.GetDefaultSharedPreferences(this);
talkBackEnabledIntentKey = ConfigurationManager.AppSettings["TalkBackKey"];
voicePrefs = new ActivityPreferences(this, ConfigurationManager.AppSettings["VoicePrefs"]);
CheckVoicePrefs();
talkBackEnabled = IsTalkBackEnabled();
if (!talkBackEnabled)
{
InitiateNoTalkBackMode();
}
// Set our view from the "main" layout resource.
SetContentView(Resource.Layout.Main);
camera2Frag = Camera2Fragment.NewInstance(this, this);
if (savedInstanceState == null)
{
new Thread(() => { FragmentManager.BeginTransaction().Replace(Resource.Id.container, camera2Frag).Commit(); }
).Start();
}
drawerLayout = FindViewById <DrawerLayout>(Resource.Id.DrawerLayout);
toolbar = FindViewById <SupportToolbar>(Resource.Id.Toolbar);
navView = FindViewById <NavigationView>(Resource.Id.NavView);
rootView = FindViewById <CoordinatorLayout>(Resource.Id.root_view);
drawerToggle = new Android.Support.V7.App.ActionBarDrawerToggle(
this,
drawerLayout,
Resource.String.openDrawer,
Resource.String.closeDrawer
);
drawerLayout.AddDrawerListener(drawerToggle);
SetSupportActionBar(toolbar);
SupportActionBar.SetDisplayHomeAsUpEnabled(true);
SupportActionBar.SetHomeButtonEnabled(true);
drawerToggle.SyncState();
gestureListener = new GestureListener();
gestureListener.LeftEvent += GestureLeft;
gestureDetector = new GestureDetector(this, gestureListener);
navView.NavigationItemSelected += (sender, e) =>
{
switch (e.MenuItem.ItemId)
{
case Resource.Id.NavItemShoppingCart:
StartCartIntent();
break;
case Resource.Id.NavItemShoppingList:
StartListIntent();
break;
}
};
}
public static void AddNewUser(ShopLensContext dbContext, User newUser)
{
dbContext.Users.Add(newUser);
}
