public Notice GetNotice(int noticeNo)
{
using (var db = new OrderManagementDbContext(_configuration))
{
return(db.Notices
.FirstOrDefault(n => n.NoticeNo.Equals(noticeNo)));
}
}
public User GetUser(int userNo)
{
using (var db = new OrderManagementDbContext(_configuraton))
{
return(db.Users
.FirstOrDefault(n => n.UserID.Equals(userNo)));
}
}
public Item GetItem(int itemNo)
{
using (var db = new OrderManagementDbContext(_configuration))
{
return(db.Items
.FirstOrDefault(n => n.ItemNo.Equals(itemNo)));
}
}
public Category GetCategory(int cateNo)
{
using (var db = new OrderManagementDbContext(_configuration))
{
return(db.Categories
.FirstOrDefault(n => n.CateNo.Equals(cateNo)));
}
}
public Review GetReview(int reviewNo)
{
using (var db = new OrderManagementDbContext(_configuration))
{
return(db.Reviews
.FirstOrDefault(n => n.ReviewNo.Equals(reviewNo)));
}
}
public List <Item> GetItems()
{
using (var db = new OrderManagementDbContext(_configuration))
{
return(db.Items
.OrderByDescending(n => n.ItemNo)
.ToList());
}
}
public List <Order> GetOrderList()
{
using (var db = new OrderManagementDbContext(_configuration))
{
return(db.Orders
.OrderByDescending(n => n.OrderNo)
.ToList());
}
}
public List <Category> GetCategoryList()
{
using (var db = new OrderManagementDbContext(_configuration))
{
return(db.Categories
.OrderByDescending(n => n.CateNo)
.ToList());
}
}
public List <Notice> GetNoticeList()
{
using (var db = new OrderManagementDbContext(_configuration))
{
return(db.Notices
.OrderByDescending(n => n.NoticeNo)
.ToList());
}
}
public List <Review> GetReviewList()
{
using (var db = new OrderManagementDbContext(_configuration))
{
return(db.Reviews
.OrderByDescending(n => n.ReviewNo)
.ToList());
}
}
public List <User> GetUserList()
{
using (var db = new OrderManagementDbContext(_configuraton))
{
return(db.Users
.OrderByDescending(n => n.UserName)
.ToList());
}
}
private static OrderManagementDbContext GetEmptyDBContext()
{
var optionsBuilder = new DbContextOptionsBuilder <OrderManagementDbContext>();
optionsBuilder.UseInMemoryDatabase(Guid.NewGuid().ToString());
optionsBuilder.EnableSensitiveDataLogging();
var inMemoryContext = new OrderManagementDbContext(optionsBuilder.Options);
return(inMemoryContext);
}
public bool Signin(SigninViewModel signinModel)
{
using (var db = new OrderManagementDbContext(_configuraton))
{
var user = db.Users.FirstOrDefault(u => u.UserID.Equals(signinModel.UserID) && u.UserPW.Equals(signinModel.UserPW));
if (user != null)
{
return(true);
}
else
{
return(false);
}
}
}
public bool PostItem(Item item)
{
try
{
using (var db = new OrderManagementDbContext(_configuration))
{
db.Items.Add(item);
db.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
public bool PostCategory(Category category)
{
try
{
using (var db = new OrderManagementDbContext(_configuration))
{
db.Categories.Add(category);
db.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
public bool PostNotice(Notice notice)
{
try
{
using (var db = new OrderManagementDbContext(_configuration))
{
notice.UserNo = db.Users.Single(u => u.UserID == notice.UserID).UserNo;
db.Notices.Add(notice);
db.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
public bool Signup(User user)
{
try
{
using (var db = new OrderManagementDbContext(_configuraton))
{
user.Money = 1000000;
user.SignUpDate = DateTime.Now;
db.Users.Add(user);
db.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
public bool PostReview(Review review)
{
try
{
using (var db = new OrderManagementDbContext(_configuration))
{
review.UserNo = db.Users.Single(u => u.UserID == review.UserID).UserNo;
//나중에 Order 연동해서 해결해야 함.
//review.ItemName = db.Items.Single(c => c.ItemNo == review.ItemNo).ItemName;
db.Reviews.Add(review);
db.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
public Repository(OrderManagementDbContext dbContext)
{
DbContext = dbContext;
DbSet = dbContext.Set <TEntity>();
}
public ProductsController(OrderManagementDbContext context)
{
_context = context;
}
public OrderDetailRepository(OrderManagementDbContext dbContext) : base(dbContext)
{
_dbContext = dbContext;
}
public BaseRepository(OrderManagementDbContext db,
IUserPrincipalAccessor userPrincipalAccessor)
{
_db = db;
_user = userPrincipalAccessor.User;
}
public ProductRepository(OrderManagementDbContext dbContext) : base(dbContext)
{
_dbContext = dbContext;
}
public OrdersController(OrderManagementDbContext context)
{
_context = context;
}
//private readonly ICustomer_Report _ICustomer_Report;
public CustomerReportService(OrderManagementDbContext orderManagementDbContext)
{
_orderManagementDbContext = orderManagementDbContext;
}
public TestController(OrderManagementDbContext context)
{
this.dbContext = context;
}
public RepositoryBase(OrderManagementDbContext repositoryContext)
{
this.RepositoryContext = repositoryContext;
}
public OrderRepository(OrderManagementDbContext dbContext) : base(dbContext)
{
}
public CustomerController(ILogger <CustomerController> logger, ICustomerDataService customerDataService, OrderManagementDbContext context)
{
_context = context;
_logger = logger;
_customerDataService = customerDataService;
}
//private readonly ICustomer_Report _ICustomer_Report;
public InvoiceListService(OrderManagementDbContext orderManagementDbContext)
{
_orderManagementDbContext = orderManagementDbContext;
}
