/// <summary>
/// Seed the database
/// </summary>
/// <param name="context">The database context</param>
protected override void Seed(Data.DatabaseContext context)
{
// Add the list of states
context.States.AddOrUpdate(x => x.Id,
new Models.State {
Id = 1, Name = "New York", Abbreviation = "NY"
},
new Models.State {
Id = 2, Name = "New Jersey", Abbreviation = "NJ"
});
base.Seed(context);
}
private void UpdateLessonsInDB(List <Lesson> lessons)
{
using (var context = new Data.DatabaseContext())
{
foreach (var lesson in lessons)
{
if (!context.Lessons.Any(c => c.ID == lesson.ID))
{
context.Lessons.Add(lesson);
}
else
{
context.Lessons.Update(lesson);
}
}
context.SaveChanges();
}
}
public void Add(int productId, long quantity)
{
using (var db = new Data.DatabaseContext())
{
ShoppingCartItem cartItem = Items.SingleOrDefault(item => item.Product.Id == productId);
if (cartItem == null)
{
Product productToAdd = db.Products.Find(productId);
cartItem = new ShoppingCartItem();
cartItem.Product = productToAdd;
cartItem.Quantity = quantity;
Items.Add(cartItem);
}
else
{
cartItem.Quantity += quantity;
}
}
}
public BaseApiControllerWithDatabase(Data.DatabaseContext databaseContext) : base()
{
MyDatabaseContext = databaseContext;
}
static void Main(string[] args)
{
System.Console.WriteLine("1. Add User");
System.Console.WriteLine("2. Remove User");
System.Console.WriteLine("3. Find User");
System.Console.WriteLine("4. Show All");
System.Console.Write("Enter Option: ");
int CheckOption = Convert.ToInt16(Console.ReadLine());
switch (CheckOption)
{
case 1:
{
System.Console.Write("Enter FullName: ");
string Fullname = Console.ReadLine();
System.Console.Write("Enter Username: "******"Enter Password: "******"Enter Username or Fullname: ");
string username = Console.ReadLine();;
var UserList = database.Users.Where(u => u.Username == username || u.FullName == username).First();
database.Users.Remove(UserList);
database.SaveChanges();
}
break;
case 3:
{
Data.DatabaseContext database = new Data.DatabaseContext();
System.Console.Write("Enter Username or Fullname: ");
string username = Console.ReadLine();;
var FindUsername = database.Users.Where(u => u.Username == username || u.FullName == username).Any();
if (FindUsername == true)
{
var UserList = database.Users.Where(u => u.Username == username || u.FullName == username).ToList();
foreach (var item in UserList)
{
System.Console.WriteLine($"FullName: {item.FullName} Username: {item.Username} Password: {item.Password}");
}
}
else
{
System.Console.WriteLine(" Not Find !");
}
}
break;
case 4:
{
Data.DatabaseContext database = new Data.DatabaseContext();
var ShowAll = database.Users.ToList();
foreach (var item in ShowAll)
{
System.Console.WriteLine($"FullName: {item.FullName} Username: {item.Username} Password: {item.Password}");
}
}
break;
}
}
public ApplicationsController(Data.DatabaseContext databaseContext) : base(databaseContext)
{
}
public ReportController(Data.DatabaseContext context)
{
_context = context;
StiLicense.LoadFromString("6vJhGtLLLz2GNviWmUTrhSqnOItdDwjBylQzQcAOiHl2AD0gPVknKsaW0un+3PuM6TTcPMUAWEURKXNso0e5OJN40hxJjK5JbrxU+NrJ3E0OUAve6MDSIxK3504G4vSTqZezogz9ehm+xS8zUyh3tFhCWSvIoPFEEuqZTyO744uk+ezyGDj7C5jJQQjndNuSYeM+UdsAZVREEuyNFHLm7gD9OuR2dWjf8ldIO6Goh3h52+uMZxbUNal/0uomgpx5NklQZwVfjTBOg0xKBLJqZTDKbdtUrnFeTZLQXPhrQA5D+hCvqsj+DE0n6uAvCB2kNOvqlDealr9mE3y978bJuoq1l4UNE3EzDk+UqlPo8KwL1XM+o1oxqZAZWsRmNv4Rr2EXqg/RNUQId47/4JO0ymIF5V4UMeQcPXs9DicCBJO2qz1Y+MIpmMDbSETtJWksDF5ns6+B0R7BsNPX+rw8nvVtKI1OTJ2GmcYBeRkIyCB7f8VefTSOkq5ZeZkI8loPcLsR4fC4TXjJu2loGgy4avJVXk32bt4FFp9ikWocI9OQ7CakMKyAF6Zx7dJF1nZw");
}
public FormFieldService(Data.DatabaseContext dbContext, IMapper mapper)
{
_dbContext = dbContext;
_mapper = mapper;
}
public SubmitService(Data.DatabaseContext dbContext, IMapper mapper, IFormService formService)
{
_dbContext = dbContext;
_mapper = mapper;
_formService = formService;
}
public FormService(Data.DatabaseContext dbContext, IMapper mapper, IAuthService authService)
{
_dbContext = dbContext;
_mapper = mapper;
_authService = authService;
}
