public ActionResult NewsletterSubscribe(NewsletterRegistration model)
{
using (var db = new SiteDbContext())
{
var ifEmailExist = db.NewsletterRegistration
.Any(r => r.Email.Equals(model.Email));
if (!ifEmailExist)
{
NewsletterRegistration newRegistration = new NewsletterRegistration
{
Email = model.Email,
SecretKey = Guid.NewGuid().ToString()
};
db.NewsletterRegistration.Add(newRegistration);
db.SaveChanges();
return(Json("Inscription effectuée !", JsonRequestBehavior.AllowGet));
}
else
{
return(Json("L'adresse email est déjà inscrite !", JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult Articles(string searchTerm = null)
{
using (var context = new SiteDbContext())
{
if (searchTerm != null)
{
ViewBag.searchTerm = searchTerm;
}
List <ArticlesViewModel> model = new List <ArticlesViewModel>();
model = context.Articles
.Where(r => searchTerm == null || r.Title.StartsWith(searchTerm))
.OrderByDescending(r => r.Id)
.Select(r => new ArticlesViewModel
{
Id = r.Id,
Title = r.Title,
Date = r.Date,
Views = r.Views,
PublishState = r.PublishState
}).ToList();
return(View(model));
}
}
public ActionResult GetStatistics(string currencyname)
{
var db = new SiteDbContext();
var OpenOrders = db.LimitOrders.Where(cur => cur.Currency == currencyname).ToList();
var SellOrders = OpenOrders.Where(or => or.OrderType == "Sell").ToList();
var BuyOrders = OpenOrders.Where(or => or.OrderType == "Buy").ToList();
if (OpenOrders.Count <= 0)
{
return(Json(null, JsonRequestBehavior.AllowGet));
}
var Data = Newtonsoft.Json.JsonConvert.SerializeObject(new
{
SellOrders = SellOrders.Count,
BuyOrders = BuyOrders.Count
}
, new JsonSerializerSettings
{
PreserveReferencesHandling = PreserveReferencesHandling.Objects
});
return(Json(Data, JsonRequestBehavior.AllowGet));
}
public ActionResult Index()
{
if (!Request.IsAuthenticated)
{
HomeAuthenticated model = new HomeAuthenticated();
var btc = CoinValues.GetStatistic().Where(c => c.Name.Contains("Bitcoin")).First();
model.Bitcoin = btc;
return(View(model));
}
else
{
SiteDbContext db = new SiteDbContext();
var user = db.Users.Find(User.Identity.GetUserId());
user.Transactions = user.Transactions;
user.Wallet = user.Wallet;
HomeAuthenticated model = new HomeAuthenticated();
model.UserData = db.Users.Find(User.Identity.GetUserId());
model.Bitcoin = CoinValues.GetStatistic().Where(c => c.Name.Contains("Bitcoin")).First();
var TotalBalanceUSD = ProfileController.CalculateTotalBalance(user);
model.TotalBalance = TotalBalanceUSD;
return(View(model));
}
}
// GET: Article
public ActionResult Detail(string id)
{
using (var context = new SiteDbContext())
{
id = HttpUtility.UrlDecode(id);
Articles model = context.Articles
.Where(r => r.Title == id).FirstOrDefault();
if (model == null)
{
return(RedirectToAction("Index", "Article"));
}
if (model.PublishState == 0 && !(User.IsInRole("administrator") || User.IsInRole("writer")))
{
return(RedirectToAction("Index", "Article"));
}
var applicationDbContext = HttpContext.GetOwinContext().Get <ApplicationDbContext>();
var author = applicationDbContext.Users
.Where(r => r.Id == model.AuthorId)
.Select(r => r.UserName).ToArray()[0];
ViewBag.Author = author;
ViewBag.Id = model.Id;
ViewBag.Tags = model.Tags;
return(View(model));
}
}
// GET: Admin/DeletePost
public ActionResult DeletePost(int id)
{
using (var context = new SiteDbContext())
{
Articles post = context.Articles.Find(id);
string path = System.IO.Path.Combine(Server.MapPath("~/Images/Uploads/Articles/Header/"), post.Id.ToString());
if (System.IO.File.Exists(path + "x1280.jpeg"))
{
System.IO.File.Delete(path + "x1280.jpeg");
}
if (System.IO.File.Exists(path + "x800.jpeg"))
{
System.IO.File.Delete(path + "x800.jpeg");
}
if (System.IO.File.Exists(path + "x320.jpeg"))
{
System.IO.File.Delete(path + "x320.jpeg");
}
context.Entry(post).State = System.Data.Entity.EntityState.Deleted;
context.SaveChanges();
}
UpdateSitemapXML();
return(RedirectToAction("Articles", "Admin"));
}
// GET: Tag
public ActionResult Tag(string id)
{
using (var context = new SiteDbContext())
{
id = HttpUtility.UrlDecode(id);
ViewBag.Tag = id;
List <ArticlesViewModel> model = context.Articles
.OrderByDescending(r => r.Id)
.Where(r => r.Tags.Contains(id) && r.PublishState == 2)
.Select(r => new ArticlesViewModel
{
Id = r.Id,
Title = r.Title,
Description = r.Description,
Date = r.Date,
Views = r.Views,
PublishState = r.PublishState
}).Take(10).ToList();
if (model == null)
{
return(RedirectToAction("Index", "Article"));
}
return(View(model));
}
}
public ActionResult Post(int?id)
{
List <SelectListItem> items = new List <SelectListItem>();
items.Add(new SelectListItem {
Text = "Preview (visible seulement pour rédacteur)", Value = "0", Selected = true
});
items.Add(new SelectListItem {
Text = "Non répertoriée", Value = "1"
});
items.Add(new SelectListItem {
Text = "En ligne", Value = "2"
});
ViewBag.State = items;
if (id != null)
{
using (var context = new SiteDbContext())
{
Articles model = context.Articles.Find(id);
ViewBag.Edition = true;
return(View(model));
}
}
else
{
return(View());
}
}
public ActionResult UploadPic()
{
HttpPostedFileBase file = Request.Files["myFile"];
int byteCount = file.ContentLength;
if (file.ContentLength == 0)
{
return(Redirect(Request.UrlReferrer.PathAndQuery));
}
if (!CryptoMarketSimulator.HttpPostedFileBaseExtensions.IsImage(file))
{
return(Redirect(Request.UrlReferrer.PathAndQuery));
}
//check file was submitted
if (file != null && file.ContentLength > 0)
{
using (var db = new SiteDbContext())
{
var currentuser = db.Users.Find(User.Identity.GetUserId());
string fname = Path.GetFileName(file.FileName);
string extension = Path.GetExtension(file.FileName);
file.SaveAs(Server.MapPath(Path.Combine("~/Resources/UsersImages/", currentuser.Id + extension)));
currentuser.ProfilePicture = "/Resources/UsersImages/" + currentuser.Id + extension;
db.SaveChanges();
return(Redirect(Request.UrlReferrer.PathAndQuery));
}
}
return(Redirect(Request.UrlReferrer.PathAndQuery));
}
public ActionResult RefreshCurrency(string currencyname)
{
var coins = CoinValues.GetValues().ToList();
Coin coin = coins
.Where(v => v.Name.Contains(currencyname))
.First();
Coin Bitcoin = coins
.Where(v => v.Name == "Bitcoin".Replace(" ", string.Empty))
.First();
decimal CurrencyUsdPrice = coin.Price;
decimal BitcoinPrice = Bitcoin.Price;
var db = new SiteDbContext();
var user = db.Users.Find(User.Identity.GetUserId());
var UserUsdBalance = user.Balance * BitcoinPrice;
var UserCurrencyBalance = user.Wallet[currencyname.Replace(" ", string.Empty)];
var Data = Newtonsoft.Json.JsonConvert.SerializeObject(new
{
CurrencyUsdPrice = CurrencyUsdPrice,
BitcoinPrice = BitcoinPrice,
UserBtcBalance = user.Balance,
UserUsdBalance = UserUsdBalance,
UserCurrencyBalance = UserCurrencyBalance,
UserOrders = user.LimitOrders.ToList()
}, new JsonSerializerSettings
{
PreserveReferencesHandling = PreserveReferencesHandling.Objects
});
return(Json(Data, JsonRequestBehavior.AllowGet));
}
public async Task <IActionResult> Register(RegisterViewModel model, string returnUrl = null)
{
ViewData["ReturnUrl"] = returnUrl;
if (ModelState.IsValid)
{
if (model.AcceptTerms)
{
var user = new ApplicationUser {
UserName = model.UserName, Email = model.Email, Register = DateTime.Now, SlotForCompanion = 0
};
var result = await _userManager.CreateAsync(user, model.Password);
if (result.Succeeded)
{
// For more information on how to enable account confirmation and password reset please visit http://go.microsoft.com/fwlink/?LinkID=532713
// Send an email with this link
var code = await _userManager.GenerateEmailConfirmationTokenAsync(user);
var callbackUrl = Url.Action("ConfirmEmail", "Account", new { userId = user.Id, code = code }, protocol: HttpContext.Request.Scheme);
await _emailSender.SendEmailAsync(model.Email, "Confirm your account",
$"Please confirm your account by clicking this link: <a href='{callbackUrl}'>link</a>");
// await _signInManager.SignInAsync(user, isPersistent: false);
_logger.LogInformation(3, "User created a new account with password.");
// Setup Gold
Gold gold = new Gold()
{
UserId = user.Id,
Number = 0
};
// Setup Artifacts
Artifacts artifact = new Artifacts()
{
UserId = user.Id,
Number = 10
};
using (var context = new SiteDbContext())
{
context.Add(artifact);
context.Add(gold);
await context.SaveChangesAsync();
}
// Redirect
return(RedirectToLocal(returnUrl));
}
AddErrors(result);
}
else
{
ModelState.AddModelError("AcceptTerms", "You must accept the Terms of Use");
}
}
// If we got this far, something failed, redisplay form
return(View(model));
}
public JsonResult UserTop5()
{
List <TopCurrency> top5 = new List <TopCurrency>();
using (var db = new SiteDbContext())
{
var cuerrentuser = db.Users.Find(User.Identity.GetUserId());
var res = cuerrentuser.Transactions.GroupBy(t => t.Currency).OrderByDescending(g => g.Count()).Take(5).ToList();
// IEnumerable<TopCurrency> smths = res.SelectMany(group => group);
foreach (var group in res)
{
var topcurrency = new TopCurrency();
foreach (var transaction in group)
{
topcurrency.Currency = transaction.Currency;
topcurrency.Transactions = group.Count();
}
topcurrency.DollarsSpend = group.Sum(sum => sum.TotalUSD);
top5.Add(topcurrency);
}
}
return(Json(top5, JsonRequestBehavior.AllowGet));
}
private IEnumerable <HtmlBlock> QueryBySite(Site site)
{
return(SiteDbContext.CreateDbContext().HtmlBlocks
.Where(it => it.SiteName == site.FullName)
.ToArray()
.Select(it => it.ToHtmlBlock()));
}
public ActionResult Statistics(string currency)
{
var Currencies = CoinValues.GetStatistic().Where(cur => cur.Name == currency);
var BitcoinPrice = CoinValues.GetValues().Where(c => c.Name == "Bitcoin").First().Price;
if (currency == null || Currencies.Count() == 0 || Currencies.Count() > 1)
{
return(View("Index"));
}
Coin Currency = Currencies.First();
var db = new SiteDbContext();
List <LimitOrder> Orders = db.LimitOrders.Where(c => c.Currency == Currency.Name).ToList();
List <Transaction> Transactions = db.Transactions.Where(c => c.Currency == Currency.Name).ToList();
Statistics statistics = new Statistics();
statistics.Volume = Transactions.Sum(tr => tr.TotalUSD);
statistics.TotalTransactions = Transactions.Count;
statistics.Currency = Currency;
statistics.OpenOrders = Orders.Count;
statistics.Orders = Orders;
statistics.Transactions = Transactions.OrderByDescending(tr => tr.Date).ToList();
statistics.BitcoinPrice = BitcoinPrice;
return(View(statistics));
}
public ActionResult NewsletterUnsubscribe(string email, string guid)
{
email = HttpUtility.UrlDecode(email);
guid = HttpUtility.UrlDecode(guid);
using (var db = new SiteDbContext())
{
var ifEmailExist = db.NewsletterRegistration
.Any(r => r.Email.Equals(email));
if (ifEmailExist)
{
var userData = db.NewsletterRegistration.Where(r => r.Email.Equals(email)).FirstOrDefault();
if (userData.Email == email && userData.SecretKey == guid)
{
NewsletterRegistration newsletterAccount = db.NewsletterRegistration.Find(userData.Id);
db.Entry(newsletterAccount).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
ViewBag.Message = "Vous êtes maintenant désinscrit de la newsletter de Gamers Addict.";
}
else
{
ViewBag.Message = "Erreur dans clef secrète.";
}
}
else
{
ViewBag.Message = "Vous n'êtes pas inscrit à la newsletter, désinscription impossible.";
}
}
return(View());
}
public void Seed(SiteDbContext context, int sampleSize)
{
// Return if there are already suppliers
if (context.Suppliers.Any())
return;
// Hydrate supplier
var hydrator = new Hydrator<Supplier>()
.WithAmericanAddress(e => e.Address)
.WithAmericanCity(e => e.City)
.WithAmericanState(e => e.Region)
.WithCustomGenerator(e => e.Country, new CountryGenerator())
.WithCustomGenerator(e => e.ContactName, new ContactNameGenerator())
.WithEmailAddress(e => e.ContactEmail)
.WithAmericanPostalCode(e => e.PostalCode, 4)
.WithAmericanPhone(e => e.Phone)
.WithCustomGenerator(e => e.ContactTitle, new TitleGenerator())
.Ignoring(e => e.CompanyName)
.Ignoring(e => e.SupplierId)
.Ignoring(e => e.Products)
.GetList(sampleSize)
.ToList();
// Make sure every company name is unique
var usedCompanyNames = new List<string>();
foreach (var supplier in hydrator)
{
string name;
do
{
name = new CompanyNameGenerator().Generate();
} while (usedCompanyNames.Contains(name));
usedCompanyNames.Add(name);
supplier.CompanyName = name;
// See if this works
supplier.Products = new List<Product>();
// ReSharper disable once LoopCanBePartlyConvertedToQuery
foreach (var i in Enumerable.Range(0, 4))
{
var product = new Product
{
ProductName = new CatchPhraseGenerator().Generate(),
QuantityPerUnit = new IntegerGenerator() {MaximumValue = 10, MinimumValue = 1}.Generate(),
UnitPrice = new IntegerGenerator() { MaximumValue = 200, MinimumValue = 1 }.Generate(),
};
// Add Product to supplier
supplier.Products.Add(product);
}
// Add supplier to context
context.Suppliers.Add(supplier);
}
// Save the changes
context.SaveChanges();
}
public bool IsEmailExist(string emailID)
{
using (SiteDbContext dc = new SiteDbContext())
{
var v = dc.Users.Where(a => a.EmailID == emailID).FirstOrDefault();
return(v != null);
}
}
public Models.Page GetDraft(Models.Page page)
{
var entity = SiteDbContext.CreateDbContext().PageDrafts
.Where(it => it.SiteName == page.Site.FullName && it.FullName == page.FullName)
.FirstOrDefault();
return(PageEntityHelper.ToPage(entity));
}
public Models.HtmlBlock Get(Models.HtmlBlock dummy)
{
var entity = SiteDbContext.CreateDbContext().HtmlBlocks
.Where(it => it.SiteName == dummy.Site.FullName && it.Name == dummy.Name)
.FirstOrDefault();
return(entity == null ? null : entity.ToHtmlBlock());
}
public Models.User Get(Models.User dummy)
{
var entity = SiteDbContext.CreateDbContext().SiteUsers
.Where(it => it.SiteName == dummy.Site.FullName && it.UserName == dummy.UserName)
.FirstOrDefault();
return(entity == null ? null : SiteUserHelper.ToUser(entity));
}
public SiteMailClientsService(
ITenant tenant, IHttpClientFactory httpClientFactory,
SiteDbContext dbContext)
{
_tenant = tenant;
_dbContext = dbContext;
_httpClientFactory = httpClientFactory;
}
public IEnumerable <Models.User> All(Models.Site site)
{
return(SiteDbContext.CreateDbContext().SiteUsers
.Where(it => it.SiteName == site.FullName)
.ToArray()
.Select(it => SiteUserHelper.ToUser(it))
.AsQueryable());
}
public ActionResult Sell(string amount, string name)
{
decimal d;
if (!decimal.TryParse(amount, out d))
{
return(View("Index"));
}
var userId = User.Identity.GetUserId();
decimal sold = decimal.Parse(amount, CultureInfo.InvariantCulture);
decimal currencyPrice = CoinValues.GetValues().Where(v => v.Name == name).First().Price;
decimal bitcoin = CoinValues.GetBtcValue().Price;
decimal boughtPrice = sold * currencyPrice;
decimal btcPrice = boughtPrice / bitcoin;
using (var db = new SiteDbContext())
{
var user = db.Users.Find(userId);
var userBTC = user.Balance;
if (sold > user.Wallet[name.Replace(" ", string.Empty)] || sold < 0)
{
return(View("Index"));
}
user.Wallet[name.Replace(" ", string.Empty)] -= sold;
user.Balance += btcPrice;
//add Transaction
var transaction = new Transaction()
{
Amount = sold,
Currency = name,
Date = DateTime.Now,
User = user,
Type = "Sold",
CurrencyPrice = currencyPrice,
TotalUSD = sold * currencyPrice
};
db.Transactions.Add(transaction);
db.SaveChanges();
var Data = Newtonsoft.Json.JsonConvert.SerializeObject(new
{
CurrencyCurrentPrice = currencyPrice,
CurrencyBalance = user.Wallet[name.Replace(" ", string.Empty)],
UserBtcBalance = user.Balance,
UserUsdBalance = user.Balance * CoinValues.GetBtcValue().Price
});
ViewBag.Result = "Successfully";
return(Json(Data, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Registration([Bind(Exclude = "IsEmailVerified,ActivationCode")] User user)
{
bool Status = false;
string message = "";
// Model Validation
if (ModelState.IsValid)
{
// Generate Random Avatar
var builder = new UriBuilder(Request.Url.Scheme, Request.Url.Host, Request.Url.Port);
Random rnd = new Random();
int rndNum = rnd.Next(0, 14);
user.Avatar = builder.Host + ":" + builder.Port + "/Images/profileIcons/" + rndNum + ".svg";
#region //Email is already Exist
var isExist = IsEmailExist(user.EmailID);
if (isExist)
{
ModelState.AddModelError("EmailExist", "Email already exist");
return(View(user));
}
#endregion
#region Generate Activation Code
user.ActivationCode = Guid.NewGuid();
#endregion
#region Password Hashing
user.Password = Crypto.Hash(user.Password);
user.ConfirmPassword = Crypto.Hash(user.ConfirmPassword); //
#endregion
user.IsEmailVerified = false;
#region Save to Database
using (SiteDbContext dc = new SiteDbContext())
{
dc.Users.Add(user);
dc.SaveChanges();
//Send Email to User
SendVerificationLinkEmail(user.EmailID, user.ActivationCode.ToString());
message = "Registration successfully done. Account activation link" +
" has been sent to your email: " + user.EmailID;
Status = true;
}
#endregion
}
else
{
message = "Invalid Request";
}
ViewBag.Message = message;
ViewBag.Status = Status;
return(View(user));
}
public static Dictionary<string, string> Config()
{
Dictionary<string, string> SettingsList = HttpContext.Current.Cache.Data("SettingsList", () =>
{
SiteDbContext db = new SiteDbContext();
return (from s in db.Settings select s).ToDictionary(s => s.Name, s => s.Value);
});
return SettingsList;
}
public ActionResult ChangeEmail(ChangeEmailViewModel model)
{
if (ModelState.IsValid)
{
//Update Account
var context = HttpContext.GetOwinContext().Get <ApplicationDbContext>();
ApplicationUserManager _userManager = new ApplicationUserManager(new Microsoft.AspNet.Identity.EntityFramework.UserStore <ApplicationUser>(context));
var user = _userManager.FindByName(User.Identity.Name);
var oldEmail = user.Email;
user.Email = model.Email;
_userManager.Update(user);
HttpContext.GetOwinContext().Get <ApplicationDbContext>().SaveChanges();
//Update Newsletter
using (var db = new SiteDbContext())
{
var ifEmailExist = db.NewsletterRegistration
.Any(r => r.Email.Equals(oldEmail));
if (ifEmailExist)
{
NewsletterRegistration newsletterRegistration = db.NewsletterRegistration
.Where(r => r.Email == oldEmail)
.Select(r => r).FirstOrDefault();
newsletterRegistration.Email = model.Email;
db.Entry(newsletterRegistration).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
//Update YouTube Alert
using (var db = new SiteDbContext())
{
var ifEmailExist = db.YouTubeAlertRegistration
.Any(r => r.Email.Equals(oldEmail));
if (ifEmailExist)
{
YouTubeAlertRegistration youTubeAlertRegistration = db.YouTubeAlertRegistration
.Where(r => r.Email == oldEmail)
.Select(r => r).FirstOrDefault();
youTubeAlertRegistration.Email = model.Email;
db.Entry(youTubeAlertRegistration).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
return(RedirectToAction("Index", new { Message = "Adresse Email modifier avec succès !" }));
}
return(View(model));
}
public IQueryable <ElementCategory> Categories()
{
return(SiteDbContext.CreateDbContext().LabelCategories
.Where(it => it.SiteName == SiteName)
.Select(it => new ElementCategory()
{
Category = it.CategoryName
}).ToArray().AsQueryable());
}
public void Localize(Models.Page o, Models.Site targetSite)
{
var dbContext = SiteDbContext.CreateDbContext();
LocalizeWithChildPages(dbContext, o, targetSite);
dbContext.SaveChanges();
ClearCache();
}
public void Move(Models.Site site, string pageFullName, string newParent)
{
var dbContext = SiteDbContext.CreateDbContext();
MovePageRecursively(site, pageFullName, newParent, dbContext);
dbContext.SaveChanges();
ClearCache();
}
/// <summary>
/// 为什么要缓存Page表呢？
/// 1. 因为在实际使用过程中发现，如果页面数量相对比较多的时候，第一次查找页面的过程中会调用很多次ChildPages，导致请求的效率很低，时间花费很高。
/// 2. 目前的设计已经是假设页面数量不多的前提了。所以缓该表的数据量是可以接受的。
/// </summary>
private static List <PageEntity> GetCachedPageList()
{
var cacheObject = CacheManagerFactory.DefaultCacheManager.GlobalObjectCache();
return(cacheObject.GetCache <List <PageEntity> >(cacheKey, () =>
{
return SiteDbContext.CreateDbContext().Pages.ToArray().Select(it => { it.PageObject = PageEntityHelper.ToPage(it); return it; })
.ToList();
}));
}
public ActionResult RedactionToDoListDelete(int id)
{
using (var context = new SiteDbContext())
{
ItemsToDoList team = context.ItemsToDoList.Find(id);
context.Entry(team).State = System.Data.Entity.EntityState.Deleted;
context.SaveChanges();
}
return(RedirectToAction("Redaction", "Admin"));
}
public IQueryable <Element> Elements()
{
return(SiteDbContext.CreateDbContext().Labels
.Where(it => it.SiteName == SiteName)
.Select(it => new Element()
{
Category = it.Category,
Name = it.Name,
Value = it.Value
}).ToArray().AsQueryable());
}
public void insertContact()
{
var Contact = new Entities.Contacts();
TryUpdateModel(Contact);
Contact.DateCreated = DateTime.Now;
if (ModelState.IsValid)
{
SiteDbContext db = new SiteDbContext();
db.Contacts.Add(Contact);
db.SaveChanges();
Response.Redirect("/contact?success=true");
}
}
public void Seed(SiteDbContext context, int sampleSize)
{
// If no Roles Exist return
if (context.Roles.Any()) return;
// Wire up Roles services
var roleStore = new RoleStore<IdentityRole>(context);
var roleManager = new RoleManager<IdentityRole>(roleStore);
// Create the User Roles magically from the UserRoles class properties
var properties = typeof(UserRoles).GetProperties();
foreach (var prop in properties.Where(prop => roleManager.FindByName(prop.Name) == null))
{
roleManager.Create(new IdentityRole(prop.Name));
}
}
/// <summary>
/// Seed the Database with Courses, A default user, and roles
/// </summary>
/// <param name="context">The context.</param>
///
public static void Seed(SiteDbContext context)
{
// Register Mappings
AutoMapperConfig.RegisterMappings();
// Seed the user roles
new RoleSeeder().Seed(context, SampleSize);
// Seed the users
new UserSeeder().Seed(context, SampleSize);
// Seed the Customers
new CustomerSeeder().Seed(context, SampleSize);
// Seed the Suppliers
new SupplierSeeder().Seed(context, SampleSize);
// Seed Headlines
new HeadlineSeeder().Seed(context, SampleSize);
}
public void LoadLoggedUser()
{
if (User.Identity.IsAuthenticated)
{
LoggedUser = UsersLogic.GetLoggedUser();
SiteDbContext db = new SiteDbContext();
LoggedUserLastOrder = db.Orders.Where(o => o.UserId == LoggedUser.UsersId).OrderByDescending(o => o.OrdersId).FirstOrDefault();
//CheckoutForm.ChangeMode(LoggedUserLastOrder == null ? FormViewMode.Insert : FormViewMode.Edit);
Literal checkoutMethodlbl = (Literal)CheckoutForm.FindControl("checkoutMethodlbl");
checkoutMethodlbl.Text = GetLocalResourceObject("LoggedAs") + " " + LoggedUser.FirstName + " " + LoggedUser.LastName;
GetDiv("PersonalDetailsPanel").Visible = false;
HidePanel("checkoutMethod");
HtmlAnchor checkoutMethodTitle = (HtmlAnchor)CheckoutForm.FindControl("checkoutMethodTitle");
checkoutMethodTitle.Attributes["class"] = "panel-title collapsed";
OpenPanel("billingInformation");
}
else
{
OpenPanel("checkoutMethod");
}
}
public void Seed(SiteDbContext context, int sampleSize)
{
var hydrator = new Hydrator<Headline>()
.Ignoring(e => e.HeadlineId)
.Ignoring( e => e.EditedById)
.Ignoring( (e => e.SubmitedById))
.WithCustomGenerator(e => e.Body, new CatchPhraseGenerator())
.WithCustomGenerator(e => e.Title, new CatchPhraseGenerator())
.WithDate(e => e.SubmittedOn, DateTime.Now.AddDays(-5), DateTime.Now.AddMinutes(-20)).GetList(sampleSize).ToList();
hydrator.ForEach(e =>
{
e.HeadlineId = Guid.NewGuid().ToString();
e.Title = Truncate(e.Title, 15);
e.EditedOn = DateTime.Now;
e.EditedById = "Admin";
e.SubmitedById = "Admin";
context.Headlines.Add(e);
});
context.SaveChanges();
}
public static string GetNewHeadlineId(SiteDbContext context)
{
return (context.Headlines.Count() + HeadlineStartId).ToString();
}
public PaymentLogic(ref Orders Order)
{
var OrderPaymentMethod = Order.PaymentMethod;
SiteDbContext db = new SiteDbContext();
var PaymentMethodDetails = db.PaymentMethods.Where(p => p.Type == OrderPaymentMethod).FirstOrDefault();
NameValueCollection Parameters = new NameValueCollection();
if (PaymentMethodDetails!= null && PaymentMethodDetails.Parameters != null)
{
Parameters = HttpUtility.ParseQueryString(PaymentMethodDetails.Parameters.ToLower());
}
if (EqualPayment(Order.PaymentMethod, PaymentMethodsEnum.PayPal))
{
PaymentProvider = new PayPalProvider(Order, Parameters);
}
else if (EqualPayment(Order.PaymentMethod, PaymentMethodsEnum.CreditCard))
{
PaymentProvider = new ZCreditProvider(Order, Parameters);
}
else if(EqualPayment(Order.PaymentMethod,PaymentMethodsEnum.Bitcoin))
{
PaymentProvider = new CoinbaseProvider(Order, Parameters);
}
}
public ProfileController(IAdminRepository adminRepository, SiteDbContext context)
{
AdminRepository = adminRepository;
Context = context;
}
public void Seed(SiteDbContext context, int sampleSize)
{
// If users exist, return
if (context.Users.Any()) return;
// Wire up user services
var userStore = new UserStore<ApplicationUser>(context);
var userManager = new UserManager<ApplicationUser>(userStore);
// Generate A Hashed password
var hashedPassword = new PasswordHasher().HashPassword(DefaultPassword);
// Create The administrator
if (userManager.FindByEmail("*****@*****.**") == null)
{
// Populate the user object
var user = CreateAdminUser("admin", "*****@*****.**", hashedPassword, EmployeeUtils.GetNewEmployeeId(context));
// Set the GUID for the admin user to prevent issues with Identity between refreshes
user.Id = ConfigurationManager.AppSettings["AdminGuid"];
// Create the User
userManager.Create(user, DefaultPassword);
// Add the administrative role to the user
userManager.AddToRole(user.Id, UserRoles.Administrator);
}
// If there is more then 1 user, return
if (context.Users.Count() >= 2) return;
// Create a random number generator
var rand = new Random();
// Create some Dummy users with account create view models
var hydrator = new Hydrator<AccountCreateViewModel>()
.Ignoring(u => u.ReportsToId)
.Ignoring(u => u.ReportsTo)
.Ignoring(u => u.Suboridnates)
.Ignoring(u => u.CreatedCustomers)
.WithAmericanAddress(u => u.Address)
.WithAmericanCity(u => u.City)
.WithAmericanState(u => u.Region)
.WithCustomGenerator(u => u.Country, new CountryGenerator())
.WithFirstName(u => u.FirstName)
.WithLastName(u => u.LastName)
.WithDate(u => u.HireDate, DateTime.Now.AddYears(-25), DateTime.Now)
.WithDate(u => u.BirthDate, DateTime.Now.AddYears(-19), DateTime.Now.AddYears(50))
.WithAmericanPostalCode(u => u.PostalCode, 1)
.GetList(sampleSize)
.ToList();
// Map them to a Application User List
var models = Mapper.Map<List<AccountCreateViewModel>, List<ApplicationUser>>(hydrator);
// Fill in some missing fields and create the user
models.ForEach(e =>
{
e.Title = "Employee";
e.EmployeeId = EmployeeUtils.GetNewEmployeeId(context);
e.UserName = (e.LastName + e.FirstName.First() + e.EmployeeId.Substring(3)).ToLower();
e.Email = $"{e.UserName}@{DomainName}";
e.PasswordHash = hashedPassword;
// Title of salutation
var values = Enum.GetValues(typeof(TitleOfCourtesyEnumeration));
e.TitleOfCourtesy = (TitleOfCourtesyEnumeration)values.GetValue(rand.Next(values.Length));
// All Seeded users report to admin
e.ReportsToId = ConfigurationManager.AppSettings["AdminGuid"];
// Create the user
userManager.Create(e, DefaultPassword);
// Add the user to the user role
userManager.AddToRole(e.Id, UserRoles.User);
});
}
public HeadlineRepository(SiteDbContext context)
{
_context = context;
}
private void RemovePageWithChildPages(SiteDbContext dbContext, PageEntity entity)
{
dbContext.Pages.Remove(entity);
var children = dbContext.Pages
.Where(it => it.SiteName == entity.SiteName && it.ParentPage == entity.FullName)
.ToArray();
foreach (var item in children)
{
RemovePageWithChildPages(dbContext, item);
}
}
public void UpdateTicket(string AssetId, string IssueAddress)
{
Ticket.AssetId = AssetId;
Ticket.IssueAddress = IssueAddress;
Ticket.Issued += Amount;
SiteDbContext db = new SiteDbContext();
db.Entry<Entities.Tickets>(Ticket).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
// Get the next employee ID public static string GetNewEmployeeId(SiteDbContext context) => (context.Users.Count() + EmployeeIdStart).ToString();
private void MovePageRecursively(Models.Site site, string pageFullName, string newParent, SiteDbContext dbContext)
{
var oldPage = Get(new Page(site, pageFullName));
var entity = PageEntityHelper.ToPageEntity<PageEntity>(oldPage);
if (!string.IsNullOrEmpty(newParent))
{
var newPage = new Page(new Page(site, newParent), oldPage.Name);
entity.FullName = newPage.FullName;
entity.ParentPage = newPage.Parent.FullName;
}
else
{
entity.FullName = oldPage.Name;
entity.ParentPage = "";
}
dbContext.Pages.Add(entity);
foreach (var item in ChildPages(oldPage))
{
MovePageRecursively(site, item.FullName, entity.FullName, dbContext);
}
var oldEntity = dbContext.Pages
.Where(it => it.SiteName == oldPage.Site.FullName && it.FullName == oldPage.FullName)
.FirstOrDefault();
if (oldEntity != null)
{
dbContext.Pages.Remove(oldEntity);
}
}
public void Seed(SiteDbContext context, int sampleSize)
{
if (context.Customers.Any())
return;
var hydrator = new Hydrator<CustomerViewModel>()
.WithAmericanAddress(e => e.Address)
.WithAmericanCity(e => e.City)
.WithAmericanState(e => e.Region)
.WithCustomGenerator(e => e.Country, new CountryGenerator())
.WithCustomGenerator(e => e.ContactName, new ContactNameGenerator())
.WithEmailAddress(e => e.ContactEmail)
.WithAmericanPostalCode(e => e.PostalCode, 4)
.WithAmericanPhone(e => e.Phone)
.WithCustomGenerator( e => e.ContactTitle, new TitleGenerator())
.WithDate(e => e.CreatedOn,DateTime.Now.AddYears(-10),DateTime.Now)
.Ignoring(e => e.CustomerId)
.Ignoring(e => e.CreatedBy)
.Ignoring(e => e.CompanyName)
.GetList(sampleSize)
.ToList();
// Map the view models to models
var models = AutoMapper.Mapper.Map<List<CustomerViewModel>, List<Customer>>(hydrator);
// Make sure the company name remains unique
string name; // Current Name
var usedCompanyNames = new List<string>(); // List of used names
var nameGenerator = new CompanyNameGenerator(); // Name generator
// Attempt to get the second user ID
var createdByUserId = context.Users.OrderBy(e => e.FirstName).Skip(1).FirstOrDefault()?.Id;
// If there are no Users, something went wrong
if (createdByUserId == null)
{
throw new DatabaseSeedException();
}
// Go through every model
models.ForEach(e =>
{
do
{
// Generate a random company name
name = nameGenerator.Generate();
}
// Continue until we get a unused name
while (usedCompanyNames.Contains(name));
// Add the name to the list of used names
usedCompanyNames.Add(name);
// Assign the name to the Entity
e.CompanyName = name;
// Generate a slug for the Entity Based on the name
e.Slug = name.GenerateSlug();
// Set the Created By Id
e.CreatedById = createdByUserId;
// Add Customer to context
context.Customers.AddOrUpdate(e);
});
// Save Changes
context.SaveChanges();
}
public CustomerRepository(SiteDbContext context)
{
_context = context;
}
private void LocalizeWithChildPages(SiteDbContext dbContext, Page page, Site targetSite)
{
var entity = dbContext.Pages
.Where(it => it.SiteName == targetSite.FullName && it.FullName == page.FullName)
.FirstOrDefault();
if (entity == null)
{
page = Get(page);
entity = PageEntityHelper.ToPageEntity<PageEntity>(page);
entity.SiteName = targetSite.FullName;
dbContext.Pages.Add(entity);
foreach (var item in ChildPages(page))
{
LocalizeWithChildPages(dbContext, item, targetSite);
}
}
}
