public static Import FindByContentHash(string h)
{
using (JBOContext context = new JBOContext())
{
return(context.Imports.Where(i => i.contentHash == h).DefaultIfEmpty(null).FirstOrDefault(i => i.contentHash == h));
}
}
public SimpleMembershipInitializer()
{
using (var context = new JBOContext())
context.UserProfiles.Find(1);
if (!WebSecurity.Initialized)
{
WebSecurity.InitializeDatabaseConnection("DefaultConnection", "UserProfile", "UserId", "UserName", autoCreateTables: true);
}
}
/// <summary>
/// Imports sales from a csv stream into the given context.
/// The caller is responsible for calling SaveChanges().
/// </summary>
/// <param name="csv">The CSV stream</param>
/// <param name="context">The DB Context</param>
private static Tuple <int, int> SalesFromCSV(Stream csv, JBOContext context)
{
List <Sale> allImportedSales = new List <Sale>();
var profiler = MiniProfiler.Current;
List <int> salesCodes;
if (csv != null && csv.Length > 0)
{
var csvReader = new CsvReader(new StreamReader(csv));
csvReader.Configuration.RegisterClassMap <SalesClassMap>();
using (profiler.Step("Parsing csv"))
{
allImportedSales = csvReader.GetRecords <Sale>().ToList();
}
//List<Sale> updated = new List<Sale>();
List <Sale> newItems = new List <Sale>();
using (profiler.Step("Getting transaction codes"))
{
salesCodes = context.Sales.Select(s => s.transCode).ToList();
}
// Don't update sales like we did in products.
// Transaction codes are unique to a transaction.
// A transaction could have 30 items sold.
// The system is currently not designed to distinguish which of these items
// it may need to update within a given transaction.
// It is also likely that ShopKeep does not allow changing this data, and we won't
// receive transactions that have been changed anyway.
//updated = (from s in allImportedSales where salesCodes.Contains(s.transCode) select s).ToList();
using (profiler.Step("Finding new sales"))
{
newItems = (from s in allImportedSales where !salesCodes.Contains(s.transCode) select s).ToList();
}
using (profiler.Step("Inserting sales"))
{
// We are in a transaction so go ahead and insert the sales.
context.BulkInsert(newItems);
}
return(new Tuple <int, int>(0, newItems.Count));
}
return(new Tuple <int, int>(0, 0));
}
public ActionResult ExternalLoginConfirmation(RegisterExternalLoginModel model, string returnUrl)
{
string provider = null;
string providerUserId = null;
if (User.Identity.IsAuthenticated || !OAuthWebSecurity.TryDeserializeProviderUserId(model.ExternalLoginData, out provider, out providerUserId))
{
return(RedirectToAction("Manage"));
}
if (ModelState.IsValid)
{
// Insert a new user into the database
using (JBOContext db = new JBOContext())
{
UserProfile user = db.UserProfiles.FirstOrDefault(u => u.UserName.ToLower() == model.UserName.ToLower());
// Check if user already exists
if (user == null)
{
// Insert name into the profile table
db.UserProfiles.Add(new UserProfile {
UserName = model.UserName
});
db.SaveChanges();
OAuthWebSecurity.CreateOrUpdateAccount(provider, providerUserId, model.UserName);
OAuthWebSecurity.Login(provider, providerUserId, createPersistentCookie: false);
return(RedirectToLocal(returnUrl));
}
else
{
ModelState.AddModelError("UserName", "User name already exists. Please enter a different user name.");
}
}
}
ViewBag.ProviderDisplayName = OAuthWebSecurity.GetOAuthClientData(provider).DisplayName;
ViewBag.ReturnUrl = returnUrl;
return(View(model));
}
public SimpleMembershipInitializer()
{
Database.SetInitializer <JBOContext>(null);
try
{
using (var context = new JBOContext())
{
if (!context.Database.Exists())
{
// Create the SimpleMembership database without Entity Framework migration schema
((IObjectContextAdapter)context).ObjectContext.CreateDatabase();
}
}
WebSecurity.InitializeDatabaseConnection("DefaultConnection", "UserProfile", "UserId", "UserName", autoCreateTables: true);
}
catch (Exception ex)
{
throw new InvalidOperationException("The ASP.NET Simple Membership database could not be initialized. For more information, please see http://go.microsoft.com/fwlink/?LinkId=256588", ex);
}
}
/// <summary>
/// Imports the given category from the given CSV stream.
/// </summary>
/// <param name="type">The type of import.</param>
/// <param name="file">The csv file.</param>
/// <param name="contentHash">The hash of the csv content.</param>
public static Tuple <int, int> FromCSV(ImportCategories type, HttpPostedFileBase csv, string contentHash)
{
bool error = false;
Tuple <int, int> results = null;
var profiler = MiniProfiler.Current;
using (profiler.Step("Importing From CSV..."))
using (var context = new JBOContext())
using (var transactionScope = new TransactionScope()) // Start a transaction so BulkInsert optimization can be used.
{
switch (type)
{
case ImportCategories.Sales:
results = SalesFromCSV(csv.InputStream, context);
break;
case ImportCategories.Products:
results = ProductsFromCSV(csv.InputStream, context);
break;
default:
error = true;
break;
}
if (error)
{
// I'm pretty sure C# does this automatically, but just in case
// until I can find out for sure...
throw new InvalidEnumArgumentException("Invalid import type.");
}
else
{
using (profiler.Step("Creating import in context"))
{
// Something should've been imported.
context.Imports.Add(
new Import
{
contentHash = contentHash,
type = type,
filename = csv.FileName,
updatedRecords = results.Item1,
newRecords = results.Item2
});
}
// All done. Let's save the changes.
using (profiler.Step("Save changes"))
{
context.SaveChanges();
}
}
// We made it this far. All must be well.
transactionScope.Complete();
return(results);
}
}
/// <summary>
/// Imports products from a csv stream into the given context.
/// The caller is responsible for calling SaveChanges().
/// </summary>
/// <param name="csv">The CSV stream</param>
/// <param name="context">The DB Context</param>
private static Tuple <int, int> ProductsFromCSV(Stream csv, JBOContext context)
{
List <Product> allImportedProducts = new List <Product>();
var profiler = MiniProfiler.Current;
List <int> products;
if (csv != null && csv.Length > 0)
{
var csvReader = new CsvReader(new StreamReader(csv));
csvReader.Configuration.RegisterClassMap <ProductClassMap>();
allImportedProducts = csvReader.GetRecords <Product>().ToList();
List <Product> updated = new List <Product>();
List <Product> newItems = new List <Product>();
using (profiler.Step("Get Product codes"))
{
products = (from p in context.Products select p.productCode).ToList();
}
using (profiler.Step("Find updated products"))
{
updated = (from p in allImportedProducts where products.Contains(p.productCode) select p).ToList();
}
using (profiler.Step("Find new products"))
{
newItems = (from p in allImportedProducts where !products.Contains(p.productCode) select p).ToList();
}
using (profiler.Step("Inserting new products"))
{
// We are in a transaction so go ahead and insert the
// new items with the BulkInsert extension.
context.BulkInsert(newItems);
}
using (profiler.Step("Updating products in context"))
{
try
{
context.Configuration.AutoDetectChangesEnabled = false;
foreach (Product i in updated)
{
Product prod = context.Products.First(p => p.productCode == i.productCode);
prod.productCode = i.productCode;
prod.description = i.description;
prod.department = i.department;
prod.category = i.category;
prod.upc = i.upc;
prod.storeCode = i.storeCode;
prod.unitPrice = i.unitPrice;
prod.discountable = i.discountable;
prod.taxable = i.taxable;
prod.inventoryMethod = i.inventoryMethod;
prod.quantity = i.quantity;
prod.orderTrigger = i.orderTrigger;
prod.recommendedOrder = i.recommendedOrder;
prod.lastSoldDate = i.lastSoldDate;
prod.supplier = i.supplier;
prod.liabilityItem = i.liabilityItem;
prod.LRT = i.LRT;
}
}
finally
{
context.Configuration.AutoDetectChangesEnabled = true;
}
}
return(new Tuple <int, int>(updated.Count, newItems.Count));
}
return(new Tuple <int, int>(0, 0));
}