private void setupCustomerData()
{
string fileContent;
fileContent = System.IO.File.ReadAllText("sample-data/Customers.json");
IEnumerable <Customer> customers = JsonSerializer.Deserialize <IEnumerable <Customer> >(fileContent);
_context.Customers.AddRange(customers);
_context.SaveChanges();
}
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 PostItem(Item item)
{
try
{
using (var db = new OrderManagementDbContext(_configuration))
{
db.Items.Add(item);
db.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
public async Task <string> InsertCustomerReport(List <CustomerReport> requestViewModel)
{
_orderManagementDbContext.Database.BeginTransaction();
try
{
await _orderManagementDbContext.CustomerReport.AddRangeAsync(requestViewModel);
_orderManagementDbContext.SaveChanges();
_orderManagementDbContext.Database.CurrentTransaction.Commit();
return("Customer Added Successfully");
}
catch (Exception ex)
{
_orderManagementDbContext.Database.RollbackTransaction();
throw ex;
}
}
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 int Save()
{
return(_dbContext.SaveChanges());
}