public static void ClassClean()
{
BookStoreDBContext context = new BookStoreDBContext();
Console.WriteLine("@@@@@@@@@@@@@@@@@@@@@");
var customer = context.Customer.SingleOrDefault(c => c.CustomerId == customerId);
var book = context.Book.SingleOrDefault(b => b.BookId == bookId);
context.Customer.Remove(customer);
context.Book.Remove(book);
//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Payment p = context.Payment.SingleOrDefault(c => c.InvoiceNumber == InvoiceNo);
var orderdetails = context.OrderDetails.Where(c => c.OrderId == p.OrderId).ToArray();
context.OrderDetails.RemoveRange(orderdetails);
context.Payment.Remove(p);
Orders order = context.Orders.SingleOrDefault(c => c.OrderId == p.OrderId);
context.Orders.Remove(order);
var productorder = context.ProductOrder.SingleOrDefault(c => c.RequestId == requestId);
context.ProductOrder.Remove(productorder);
var productorderdetails = context.ProductOrderDetails.SingleOrDefault(c => c.RequestId == requestId);
context.ProductOrderDetails.Remove(productorderdetails);
context.SaveChanges();
}
public BookRepository(BookStoreDBContext context)
{
_context = context;
if (!_context.Books.Any())
{
_context.Books.Add(new Book
{
Id = 1,
BookName = "Tom and Jerry",
Price = 123.5,
Author = "Unknow",
Publisher = "Kim Dong"
});
_context.Books.Add(new Book
{
Id = 2,
BookName = "Steve Job",
Price = 200,
Author = "Unknow",
Publisher = "BBC"
});
_context.Books.Add(new Book
{
Id = 3,
BookName = "Golden Axe",
Price = 199,
Author = "David Copy and Paste",
Publisher = "SEGA"
});
_context.SaveChanges();
}
}
public WebServiceTests()
{
context = new BookStoreDBContext();
controller = new AdminSeviceController();
controller1 = new BookServiceController();
controller2 = new OrderServiceController();
}
public UserRepository(BookStoreDBContext context)
{
_context = context;
if (!_context.Users.Any())
{
_context.Users.Add(new User
{
UserId = "test_id",
FullName = "test",
UserName = "******",
Role = "Admin",
GoogleId = "123",
Password = "******"
});
_context.SaveChanges();
}
}
public BookRepository(BookStoreDBContext context)
{
_context = context;
if (!_context.Books.Any())
{
_context.Books.Add(new Books
{
Id = 1,
Author = "tac gia A",
BookName = "Sach A",
Publisher = "Kim dong"
});
_context.Books.Add(new Books
{
Id = 1,
Author = "tac gia B",
BookName = "Sach B",
Publisher = "Kim dong"
});
_context.Books.Add(new Books
{
Id = 1,
Author = "tac gia C",
BookName = "Sach C",
Publisher = "Kim dong"
});
_context.Books.Add(new Books
{
Id = 1,
Author = "tac gia D",
BookName = "Sach D",
Publisher = "Kim dong"
});
_context.SaveChanges();
}
}
public SalesController(BookStoreDBContext context)
{
_context = context;
}
public BooksRepository(BookStoreDBContext dbContext)
{
_dbContext = dbContext;
}
public AuthorDBRepository(BookStoreDBContext _db)
{
db = _db;
}
public PublishersController(BookStoreDBContext context)
{
_context = context;
}
public ReviewsController(BookStoreDBContext dbContext)
{
_dbContext = dbContext;
}
// Dependency Injection
public AuthorController(ILogger <WeatherForecastController> logger, BookStoreDBContext context)
{
_logger = logger;
_context = context;
}
public OrderService()
{
context = new BookStoreDBContext();
}
public TokenRepository(BookStoreDBContext context)
{
_context = context;
}
public ImpCartRepoRL(BookStoreDBContext bookStoreDB)
{
this.bookStoreDB = bookStoreDB;
}
public AuthRepository(BookStoreDBContext context, IUserRepository userRepository)
{
_context = context;
_userRepository = userRepository;
}
public TestController(BookStoreDBContext dbContext, IBookStoreApiRepository repository)
{
_repository = repository;
}
public BookDbRepository(BookStoreDBContext _db)
{
db = _db;
}
public CategoriesRepository(BookStoreDBContext dbContext)
{
_dbContext = dbContext;
}
public BookImpRL(BookStoreDBContext bookStoreDB, IConfiguration configuration)
{
this.bookStoreDB = bookStoreDB;
this.configuration = configuration;
}
public CustomerImpRL(BookStoreDBContext bookStoreDB)
{
this.bookStoreDB = bookStoreDB;
}
public DBAuthorRepository(BookStoreDBContext db)
{
this.db = db;
}
public UsersController(BookStoreDBContext dbContext)
{
_dbContext = dbContext;
}
public AuthorsController(BookStoreDBContext context)
{
_context = context;
}
public SearchController(BookStoreDBContext context)
{
this._context = context;
}
public AdminService()
{
context = new BookStoreDBContext();
}
public LoginRepoRL(BookStoreDBContext context)
{
this.context = context;
}
public DiscountRepository(BookStoreDBContext context)
{
_context = context;
}
public CompanyRepository(BookStoreDBContext context)
{
_context = context;
}
public BookRepository(BookStoreDBContext context)
{
_context = context;
}
public AuthorsController(BookStoreDBContext dbContext)
{
_dbContext = dbContext;
}