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; }