public EditShowroomForm()
{
InitializeComponent();
DesignTimeDbContextFactory factory = new DesignTimeDbContextFactory();
dbContext = factory.CreateDbContext();
listBoxShowrooms.Items.Clear();
checkedListBoxCars.Items.Clear();
checkedListBoxWorkers.Items.Clear();
var showrooms = dbContext.Set<CarShowrooms>();
foreach (CarShowrooms cs in showrooms)
{
listBoxShowrooms.Items.Add(cs.Address + ", " + cs.Name + ", ID: " + cs.Id);
}
var employees = dbContext.Set<Employees>().Include(e => e.CarShowroom);
foreach (Employees employee in employees)
{
checkedListBoxWorkers.Items.Add(employee.LastName + ", " + employee.FirstName + ", ID: " + employee.Id);
}
var cars = dbContext.Set<Cars>().Include(c => c.CarShowroom).Include(c => c.Model);
foreach (Cars car in cars)
{
checkedListBoxCars.Items.Add(car.Model.Name + ", " + car.ProductionYear + ", " + car.Body + ", ID: " + car.Id);
}
}
private UnitOfWork CreateUnitOfWork()
{
DesignTimeDbContextFactory designTimeDbContextFactory = new DesignTimeDbContextFactory();
context = designTimeDbContextFactory.CreateDbContext(new string[] { });
return(new UnitOfWork(context));
}
public IEnumerable <Department> GetAllDepartments()
{
using (var db = new DesignTimeDbContextFactory().CreateDbContext(args))
{
return(db.Department.ToList());
}
}
private IModelService GetSQLiteDatabaseService(string loadFromPath)
{
if (!string.IsNullOrEmpty(loadFromPath))
{
if (File.Exists(loadFromPath))
{
var dbContextFactory = new DesignTimeDbContextFactory();
var args = new string[] { $"ConnectionStrings:DefaultConnection=Data Source={loadFromPath}" };
SQLiteDbContext context = dbContextFactory.CreateDbContext(args);
// update
context.Database.Migrate();
return(new FindSimilarSQLiteService(context));
}
else
{
var dbContextFactory = new DesignTimeDbContextFactory();
var args = new string[] { $"ConnectionStrings:DefaultConnection=Data Source={loadFromPath}" };
SQLiteDbContext context = dbContextFactory.CreateDbContext(args);
// create
context.Database.Migrate();
return(new FindSimilarSQLiteService(context));
}
}
return(null);
}
public ActionResult Create(Order Order, string ListEcardString)
{
if (ModelState.IsValid)
{
using (var context = new DesignTimeDbContextFactory().CreateDbContext(null))
{
var listEcardID = ListEcardString.Split('-').Where(x => x.Length > 0).Select(x => Convert.ToInt32(x)).ToList();
var listOrderDetails = new List <OrderDetail>();
foreach (var ecardID in listEcardID)
{
var ecard = context.Set <Ecard>().Find(ecardID);
var orderDetails = new OrderDetail
{
SendStatus = false,
Ecard = ecard,
CreatedDate = DateTime.Now,
};
listOrderDetails.Add(orderDetails);
}
Order.OrderDetails = listOrderDetails;
Order.SendStatus = false;
Order.TotalPrice = listOrderDetails.Select(x => x.Ecard.Price).Sum();
Order.CreatedDate = DateTime.Now;
context.Set <Order>().Add(Order);
context.SaveChanges();
}
return(RedirectToAction("Index"));
}
ViewBag.Ecards = EcardBusiness.AllNoTracking.Where(x => x.Draft != true).ToList();
return(View(ViewNamesConstant.AdminOrdersCreate, Order));
}
public ActionResult Edit(Payment Payment, int?EgreetingUserID)
{
if (ModelState.IsValid)
{
using (var context = new DesignTimeDbContextFactory().CreateDbContext(null))
{
var paymentUpdate = context.Set <Payment>().Find(Payment.PaymentID);
if (EgreetingUserID != null && paymentUpdate.EgreetingUser.EgreetingUserID != EgreetingUserID)
{
var egreetingUser = context.Set <EgreetingUser>().Find(EgreetingUserID);
if (egreetingUser != null)
{
paymentUpdate.EgreetingUser = egreetingUser;
}
}
paymentUpdate.Month = Payment.Month;
paymentUpdate.Year = Payment.Year;
paymentUpdate.PaymentStatus = Payment.PaymentStatus;
paymentUpdate.ModifiedDate = DateTime.Now;
context.Set <Payment>().Attach(paymentUpdate);
context.Entry(paymentUpdate).State = EntityState.Modified;
context.SaveChanges();
}
return(RedirectToAction("Index"));
}
ViewBag.EgreetingUsers = EgreetingUserBusiness.AllNoTracking.Where(x => x.Draft != true).Select(x => new { x.EgreetingUserID, x.Email }).ToDictionary(k => k.EgreetingUserID, v => v.Email);
return(View(ViewNamesConstant.AdminPaymentsEdit, Payment));
}
public UsuariosRepositorio()
{
var reference = new DesignTimeDbContextFactory();
var context = reference.CreateDbContext(null);
_repositorioBase = new RepositorioBase <Usuarios>(context);
}
public IActionResult Index()
{
var myContext = new DesignTimeDbContextFactory().CreateDbContext();
List <Book> books = myContext.Books.ToList();
return(View(books));
}
public ActionResult Create(Feedback feedback, int?EcardID)
{
if (ModelState.IsValid)
{
using (var context = new DesignTimeDbContextFactory().CreateDbContext(null))
{
var user = new EgreetingUser();
if (HttpContext.User != null)
{
string email = HttpContext.User.Identity.Name;
user = context.Set <EgreetingUser>().Where(x => x.Email.Equals(email)).FirstOrDefault();
}
if (user != null)
{
feedback.EgreetingUser = user;
}
var ecard = context.Set <Ecard>().Find(EcardID);
if (ecard != null)
{
feedback.Ecard = ecard;
}
feedback.CreatedDate = DateTime.Now;
context.Set <Feedback>().Add(feedback);
context.SaveChanges();
}
return(RedirectToAction("Index"));
}
return(View(ViewNamesConstant.AdminFeedbacksCreate, feedback));
}
public AddCustomerForm()
{
InitializeComponent();
DesignTimeDbContextFactory fac = new DesignTimeDbContextFactory();
databaseContext = fac.CreateDbContext();
}
public void TestDesignTimeDbContextFactory()
{
IDesignTimeDbContextFactory <FSContext> o = new DesignTimeDbContextFactory();
FSContext context = o.CreateDbContext(null);
context.Database.EnsureCreated();
}
public EditCarForm()
{
InitializeComponent();
listBoxCars.ScrollAlwaysVisible = true;
DesignTimeDbContextFactory factory = new DesignTimeDbContextFactory();
databaseContext = factory.CreateDbContext();
listBoxCars.Items.Clear();
var cars = databaseContext.Set <Cars>().Include(c => c.CarShowroom).Include(c => c.Model);
foreach (Cars car in cars)
{
listBoxCars.Items.Add(car.Model.Name + ", " + car.ProductionYear + ", " + car.Body + ", ID: " + car.Id);
}
var brands = databaseContext.Set <CarBrands>();
foreach (CarBrands brand in brands)
{
comboBoxBrand.Items.Add(brand.Name);
}
var showrooms = databaseContext.Set <CarShowrooms>();
foreach (CarShowrooms cs in showrooms)
{
comboBoxAdress.Items.Add(cs.Address + ", " + cs.Name);
}
}
static void Main(string[] args)
{
Console.WriteLine("Recreate database");
using (var ctx = new DesignTimeDbContextFactory().CreateDbContext(new [] { "" }))
{
//var loggerFactory = ctx.GetService<ILoggerFactory>();
ctx.Database.EnsureDeleted();
ctx.Database.EnsureCreated();
Console.WriteLine("Recreate database - done");
var queryModule = new QueryModule(ctx);
queryModule.showCategories();
//queryModule.queryProducts();
queryModule.AddProduct("2", "Квас", 25m, 15, "25");
queryModule.ListProducts();
Console.WriteLine("Increase result: " + queryModule.IncreaseProductPrice("Квас", 35m));
queryModule.ListProducts();
queryModule.JoinGroups();
queryModule.querySugar();
}
Console.ReadKey();
}
public IActionResult ReadBook(int bookId)
{
var myContext = new DesignTimeDbContextFactory().CreateDbContext();
Book books = myContext.Books.Find(bookId);
return(View(books));
}
public ActionResult Create(Feedback feedback, int?EcardID)
{
if (ModelState.IsValid)
{
using (var context = new DesignTimeDbContextFactory().CreateDbContext(null))
{
if (User.Identity.IsAuthenticated)
{
var user = new EgreetingUser();
if (HttpContext.User != null)
{
string email = User.Identity.Name;
user = context.Set <EgreetingUser>().Where(x => x.Email.Equals(email)).FirstOrDefault();
if (user != null)
{
feedback.EgreetingUser = user;
}
}
}
var ecard = context.Set <Ecard>().Find(EcardID);
if (ecard != null)
{
feedback.Ecard = ecard;
}
feedback.CreatedDate = DateTime.Now;
context.Set <Feedback>().Add(feedback);
context.SaveChanges();
}
return(Redirect(Request.Headers["Referer"].ToString()));
}
return(Redirect(Request.Headers["Referer"].ToString()));
}
public AddWorkerForm()
{
DesignTimeDbContextFactory fac = new DesignTimeDbContextFactory();
databaseContext = fac.CreateDbContext();
InitializeComponent();
FillListBoxes();
}
public IEnumerable <Employee> GetAllEmployees()
{
using (var db = new DesignTimeDbContextFactory().CreateDbContext(args))
{
return(db.Employee.Include(e => e.Department).ToList());
}
}
public LoginForm()
{
InitializeComponent();
DesignTimeDbContextFactory fac = new DesignTimeDbContextFactory();
dbContext = fac.CreateDbContext();
}
public AccountService(DesignTimeDbContextFactory contextFactory, UserManager <IdentityUser> userManager, SignInManager <IdentityUser> signInManager, ILogger logger)
{
_contextFactory = contextFactory;
_userManager = userManager;
_signInManager = signInManager;
_logger = logger;
}
public async Task <ActionResult> Create(Subcriber subcriber)
{
if (ModelState.IsValid)
{
var egreetingUser = new EgreetingUser
{
CreatedDate = DateTime.Now,
Avatar = System.IO.File.ReadAllBytes($"{Startup.StaticHostEnvironment.WebRootPath}/Admin/dist/img/avatar.png"),
Email = subcriber.Email,
};
var applicationUser = new ApplicationUser {
Email = egreetingUser.Email, UserName = egreetingUser.Email, EgreetingUser = egreetingUser
};
var result = await _userManager.CreateAsync(applicationUser, "delete123456Aa");
await _userManager.AddToRoleAsync(applicationUser, "Subcriber");
if (result.Succeeded)
{
using (var context = new DesignTimeDbContextFactory().CreateDbContext(null))
{
var eUser = context.Set <EgreetingUser>().Where(x => x.Email.Equals(egreetingUser.Email)).FirstOrDefault();
eUser.EgreetingUserRoles = (ICollection <EgreetingUserRole>)context.Set <EgreetingRole>().Where(x => x.EgreetingRoleName.Equals("Subcriber")).Select(x => x.EgreetingUserRoles).ToList();
subcriber.EgreetingUser = eUser;
context.Set <Subcriber>().Attach(subcriber);
context.Entry(subcriber).State = EntityState.Modified;
context.SaveChanges();
}
return(RedirectToAction("Index"));
}
AddErrors(result);
}
return(View(ViewNamesConstant.AdminSubcribersCreate, subcriber));
}
public List <Product> List()
{
using (var db = new DesignTimeDbContextFactory().CreateDbContext(args))
{
return(db.Product.ToList());
}
}
public SalesHistoryForm()
{
DesignTimeDbContextFactory factory = new DesignTimeDbContextFactory();
databaseContext = factory.CreateDbContext();
InitializeComponent();
FillListBoxes();
}
public BaseService()
{
if (db == null)
{
DesignTimeDbContextFactory factory = new DesignTimeDbContextFactory();
db = factory.CreateDbContext(null);
}
}
public EditModelBrandForm()
{
DesignTimeDbContextFactory fac = new DesignTimeDbContextFactory();
databaseContext = fac.CreateDbContext();
InitializeComponent();
FillListBoxes();
}
public AddOrderForm()
{
DesignTimeDbContextFactory factory = new DesignTimeDbContextFactory();
databaseContext = factory.CreateDbContext();
InitializeComponent();
FillComboBoxes();
}
private static async Task DeleteAllTablesInDatabase(string connectionString)
{
CreateIfNotExists(connectionString);
var contextFactory = new DesignTimeDbContextFactory(connectionString);
await contextFactory.CreateDbContext(Array.Empty <string>()).Database.EnsureDeletedAsync();
}
public void Add(Product Entity)
{
using (var db = new DesignTimeDbContextFactory().CreateDbContext(args))
{
db.Add(Entity);
db.SaveChanges();
}
}
public AddModelBrandForm()
{
DesignTimeDbContextFactory factory = new DesignTimeDbContextFactory();
databaseContext = factory.CreateDbContext();
InitializeComponent();
fillComboBox();
}
public ShowCustomerForm()
{
DesignTimeDbContextFactory factory = new DesignTimeDbContextFactory();
databaseContext = factory.CreateDbContext();
InitializeComponent();
FillListBox();
}
public void AddEmployees(Employee employee)
{
using (var db = new DesignTimeDbContextFactory().CreateDbContext(args))
{
db.Add(employee);
db.SaveChanges();
}
}
