public BooksController(LibContext context, IBookRepository bookRepository, IMapper mapper, ILogger <BooksController> logger)
{
_context = context;
_bookRepository = bookRepository;
_mapper = mapper;
_logger = logger;
}
static BooksController()
{
using (LibContext db = new LibContext())
{
data = db.Books.ToList();
}
}
public AdminController(LibContext context, IBookRepository bookRepository, IMapper mapper, IUserRepository userRepository, ILogger <AdminController> logger, UserManager <User> userManager)
{
_context = context;
_mapper = mapper;
_bookRepository = bookRepository;
_userRepository = userRepository;
_logger = logger;
_userManager = userManager;
}
public ResultModel RegisterEmployee(UserTypeEnum type, int userId, int id)
{
ResultModel result = new ResultModel();
try
{
using (LibContext context = new LibContext())
{
if (type == UserTypeEnum.Librarian)
{
GenericRepository <Librarians> generic = new GenericRepository <Librarians>(context);
var librarian = generic.FindById(id);
if (librarian != null)
{
librarian.UserId = userId;
generic.Update(librarian);
}
else
{
result.Code = OperationStatusEnum.UnexpectedError;
result.Message = "Неверный идентификатор сотрудника";
}
}
else if (type == UserTypeEnum.Provider)
{
GenericRepository <Providers> generic = new GenericRepository <Providers>(context);
var provider = generic.FindById(id);
if (provider != null)
{
provider.UserId = userId;
generic.Update(provider);
}
else
{
result.Code = OperationStatusEnum.UnexpectedError;
result.Message = "Неверный идентификатор сотрудника";
}
}
else
{
result.Code = OperationStatusEnum.UnexpectedError;
result.Message = "Ошибка присваивания роли пользователя";
}
}
}
catch (Exception ex)
{
result.Code = OperationStatusEnum.UnexpectedError;
result.Message = ex.StackTrace;
}
return(result);
}
public LibUnitOfWork()
{
var optionsBuilder = new DbContextOptionsBuilder <LibContext>();
var options = optionsBuilder
.UseLazyLoadingProxies()
.UseSqlServer(@"Server=(localdb)\mssqllocaldb;Database=libwebappdb;Trusted_Connection=True;")
.Options;
db = new LibContext(options);
}
public EditRecord(Record r)
{
InitializeComponent();
db = new LibContext();
db.Readers.Load();
db.Books.Load();
db.Cards.Load();
record = r;
DataContext = record;
bookCombo.ItemsSource = db.Books.Select(p => p.Name).ToList();
}
private void BeforeAllTests()
{
context = new TestContext();
books = new Repository <Book>(context);
// deletes DB
context.Database.EnsureDeleted(); // rekreiramo bazu
// creates DB
context.Database.EnsureCreated();
books.Insert(new Book {
Title = "Book 1"
});
books.Insert(new Book {
Title = "Book 2"
});
context.SaveChanges();
}
private static void Main(string[] args)
{
using (LibContext contex = new LibContext())
{
Publisher p = new Publisher();
Console.WriteLine("Publisher name: ");
p.Name = Console.ReadLine();
Console.WriteLine("Address: ");
p.Road = Console.ReadLine();
Console.WriteLine("Zip code: ");
p.ZipCode = Console.ReadLine();
Console.WriteLine("City: ");
p.City = Console.ReadLine();
Console.WriteLine("Country: ");
p.Country = Console.ReadLine();
contex.Publishers.Add(p);
contex.SaveChanges();
Book b = new Book();
Console.WriteLine("Book title: ");
b.Title = Console.ReadLine();
Console.WriteLine("Book cover: ");
b.Image = Console.ReadLine();
Console.WriteLine("Number of pages: ");
b.Pages = int.Parse(Console.ReadLine());
Console.WriteLine("Book price: ");
b.Price = decimal.Parse(Console.ReadLine());
Console.Write("Publisher: ");
string pubName = Console.ReadLine();
Publisher pub = contex.Publishers.FirstOrDefault(x => x.Name == pubName);
b.Publisher = pub;
contex.Books.Add(b);
int n = contex.SaveChanges();
Console.WriteLine($"{ n } transactions commited.");
}
}
public MainWindow()
{
InitializeComponent();
db = new LibContext();
try
{
db.Readers.Load();
db.Records.Load();
db.Cards.Load();
db.Books.Load();
}
catch (SqlException) {
MessageBox.Show(
"Невозможно подключиться к базе данных.\nПроверьте настройки подключения.",
"Library Assistant",
MessageBoxButton.OK,
MessageBoxImage.Error
);
Close();
}
readerGrid.ItemsSource = db.Readers.Local.ToBindingList();
}
public ProviderPage(LibContext context)
{
_context = context;
}
public SectionController(LibContext dbContext)
{
_dbContext = dbContext;
}
public int Undone(int current, DateTime time)
{
{
int step = current;
try
{
List <IssuesHistory> history;
using (LibContext context = new LibContext())
{
history = context.IssuesHistory.Where(c => c.OperationDate <= time).ToList();
history.Reverse();
GenericRepository <Issues> generic = new GenericRepository <Issues>(context);
if (step < history.Count && step >= 0)
{
IssuesHistory pacient = history[step];
string operation = pacient.Operation;
context.Database.ExecuteSqlCommand("DISABLE TRIGGER IssuesHistory ON Issues");
context.Database.ExecuteSqlCommand("DISABLE TRIGGER IssuesInsert ON Issues");
if (operation == "inserted")
{
Issues entity = generic.Get(c => c.Id == pacient.Id).FirstOrDefault();
if (entity != null)
{
generic.Remove(entity);
}
}
else if (operation == "updated")
{
Issues entity = generic.Get(c => c.Id == pacient.Id).FirstOrDefault();
if (entity != null)
{
entity.Book = pacient.HistoryBook.Value;
entity.Reader = pacient.HistoryReader.Value;
entity.IssueDate = pacient.HistoryIssueDate;
entity.ReturnDate = pacient.HistoryReturnDate;
generic.Update(entity);
}
}
else if (operation == "deleted")
{
Issues entity = new Issues
{
Id = pacient.Id,
Book = pacient.HistoryBook.Value,
Reader = pacient.HistoryReader.Value,
IssueDate = pacient.HistoryIssueDate,
ReturnDate = pacient.HistoryReturnDate
};
using (var scope = context.Database.BeginTransaction())
{
context.Issues.Add(entity);
context.SaveChanges();
scope.Commit();
}
}
context.Database.ExecuteSqlCommand("ENABLE TRIGGER IssuesHistory ON Issues");
context.Database.ExecuteSqlCommand("ENABLE TRIGGER IssuesInsert ON Issues");
}
}
step++;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(step);
}
}
public HomeController(LibContext context)
{
db = context;
}
public AutoriRepository(LibContext context)
{
this.context = context;
}
public ReaderRepository(LibContext context)
{
this.db = context;
}
public AdminRepository(LibContext context)
{
_context = context;
}
public ReceiptRepository(DbContext db) : base(db)
{
_db = new LibContext();
}
public int Redone(int current, DateTime time)
{
int step = current;
try
{
step--;
List <SuppliesHistory> history;
using (LibContext context = new LibContext())
{
history = context.SuppliesHistory.Where(c => c.OperationDate <= time).ToList();
history.Reverse();
GenericRepository <Supplies> generic = new GenericRepository <Supplies>(context);
if (step < history.Count && step >= 0)
{
SuppliesHistory pacient = history[step];
string operation = pacient.Operation;
context.Database.ExecuteSqlCommand("DISABLE TRIGGER SuppliesHistory ON Supplies");
context.Database.ExecuteSqlCommand("DISABLE TRIGGER SuppliesInsert ON Supplies");
if (operation == "inserted")
{
Supplies entity = new Supplies
{
Id = pacient.Id,
Shop = pacient.CurrentShop.Value,
Summ = pacient.CurrentSumm,
Date = pacient.CurrentDate
};
using (var scope = context.Database.BeginTransaction())
{
context.Supplies.Add(entity);
context.SaveChanges();
scope.Commit();
}
}
else if (operation == "updated")
{
Supplies entity = generic.Get(c => c.Id == pacient.Id).FirstOrDefault();
if (entity != null)
{
entity.Shop = pacient.CurrentShop.Value;
entity.Summ = pacient.CurrentSumm;
entity.Date = pacient.CurrentDate;
generic.Update(entity);
}
}
else if (operation == "deleted")
{
Supplies entity = generic.Get(c => c.Id == pacient.Id).FirstOrDefault();
if (entity != null)
{
generic.Remove(entity);
}
}
context.Database.ExecuteSqlCommand("ENABLE TRIGGER SuppliesHistory ON Supplies");
context.Database.ExecuteSqlCommand("ENABLE TRIGGER SuppliesInsert ON Supplies");
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(step);
}
public IzdavacRepository(LibContext context) : base(context)
{
}
public ReaderPageController()
{
context = new LibContext();
readerContext = new ReaderPage(context);
}
public ReaderPage(LibContext context)
{
_context = context;
}
public ProviderPageController()
{
context = new LibContext();
providerContext = new ProviderPage(context);
}
public int Redone(int current, DateTime time)
{
int step = current;
try
{
step--;
List <ReadersHistory> history;
using (LibContext context = new LibContext())
{
history = context.ReadersHistory.Where(c => c.OperationDate <= time).ToList();
history.Reverse();
GenericRepository <Readers> generic = new GenericRepository <Readers>(context);
if (step < history.Count && step >= 0)
{
ReadersHistory pacient = history[step];
string operation = pacient.Operation;
context.Database.ExecuteSqlCommand("DISABLE TRIGGER ReadersHistory ON Readers");
context.Database.ExecuteSqlCommand("DISABLE TRIGGER ReadersInsert ON Readers");
if (operation == "inserted")
{
Readers entity = new Readers
{
Id = pacient.Id,
Surname = pacient.CurrentSurname,
Name = pacient.CurrentName,
Patronymic = pacient.CurrentPatronymic,
BirthDate = pacient.CurrentBirthDate,
PassSeria = pacient.CurrentPassSeria,
PassNumber = pacient.CurrentPassNumber,
Phone = pacient.CurrentPhone,
Address = pacient.CurrentAddress,
UserId = pacient.CurrentUserId
};
using (var scope = context.Database.BeginTransaction())
{
context.Readers.Add(entity);
context.SaveChanges();
scope.Commit();
}
}
else if (operation == "updated")
{
Readers entity = generic.Get(c => c.Id == pacient.Id).FirstOrDefault();
if (entity != null)
{
entity.Surname = pacient.CurrentSurname;
entity.Name = pacient.CurrentName;
entity.Patronymic = pacient.CurrentPatronymic;
entity.BirthDate = pacient.CurrentBirthDate;
entity.PassSeria = pacient.CurrentPassSeria;
entity.PassNumber = pacient.CurrentPassNumber;
entity.Phone = pacient.CurrentPhone;
entity.Address = pacient.CurrentAddress;
entity.UserId = pacient.CurrentUserId;
generic.Update(entity);
}
}
else if (operation == "deleted")
{
Readers entity = generic.Get(c => c.Id == pacient.Id).FirstOrDefault();
if (entity != null)
{
generic.Remove(entity);
}
}
context.Database.ExecuteSqlCommand("ENABLE TRIGGER ReadersHistory ON Readers");
context.Database.ExecuteSqlCommand("ENABLE TRIGGER ReadersInsert ON Readers");
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(step);
}
public BookRepository(LibContext context)
{
this.db = context;
}
public EditReader(Reader r)
{
InitializeComponent();
db = new LibContext();
db.Readers.Load();
}
public AuthController(UserManager <User> userManager, IMapper mapper, LibContext context)
{
_userManager = userManager;
_mapper = mapper;
_context = context;
}
public int Undone(int current, DateTime time)
{
int step = current;
try
{
List <AuthorsHistory> history;
using (LibContext context = new LibContext())
{
history = context.AuthorsHistory.Where(c => c.OperationDate <= time).ToList();
history.Reverse();
GenericRepository <Authors> generic = new GenericRepository <Authors>(context);
if (step < history.Count && step >= 0)
{
AuthorsHistory pacient = history[step];
string operation = pacient.Operation;
context.Database.ExecuteSqlCommand("DISABLE TRIGGER AuthorsHistory ON Authors");
context.Database.ExecuteSqlCommand("DISABLE TRIGGER AuthorsInsert ON Authors");
if (operation == "inserted")
{
Authors entity = generic.Get(c => c.Id == pacient.Id).FirstOrDefault();
if (entity != null)
{
generic.Remove(entity);
}
}
else if (operation == "updated")
{
Authors entity = generic.Get(c => c.Id == pacient.Id).FirstOrDefault();
if (entity != null)
{
entity.Surname = pacient.HistorySurname;
entity.Name = pacient.HistoryName;
entity.Patronymic = pacient.HistoryPatronymic;
generic.Update(entity);
}
}
else if (operation == "deleted")
{
Authors entity = new Authors
{
Id = pacient.Id,
Surname = pacient.HistorySurname,
Name = pacient.HistoryName,
Patronymic = pacient.HistoryPatronymic
};
using (var scope = context.Database.BeginTransaction())
{
context.Authors.Add(entity);
context.SaveChanges();
scope.Commit();
}
}
context.Database.ExecuteSqlCommand("ENABLE TRIGGER AuthorsHistory ON Authors");
context.Database.ExecuteSqlCommand("ENABLE TRIGGER AuthorsInsert ON Authors");
}
}
step++;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(step);
}
public KnjigeRepository(LibContext context)
{
this.context = context;
}
public BookController(LibContext dbContext)
{
_dbContext = dbContext;
}
public LibrarianPage(LibContext context)
{
_context = context;
}
