public async Task <ActionResult <Customer> > Excute()
{
var _context = new TGDDContext();
Customer customer = _context.Customers.FirstOrDefault(customer => customer.UserName == Username);
if (customer == null)
{
return(BadRequest());
}
else
{
customer.Password = SecurityUtils.CreateMD5(Password);
_context.Entry(customer).State = EntityState.Modified;
}
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
bool customerExist = _context.Customers.Any(c => c.Id == customer.Id);
if (!customerExist)
{
return(NotFound());
}
else
{
throw;
}
}
return(Ok());
}
public async Task <ActionResult <Product> > Excute()
{
AssigndataUtils AssigndataUtils = new AssigndataUtils();
var _context = new TGDDContext();
Product newProduct = await AssigndataUtils.AssignProduct(productDTO, 0);
_context.Products.Add(newProduct);
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateException)
{
bool productExist = _context.Products.Any(p => p.Id == newProduct.Id);
if (productExist)
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtAction("GetProducts", new { id = newProduct.Id }, newProduct));
}
public async Task <ActionResult <Image> > Excute()
{
var _context = new TGDDContext();
var images = _context.Images.Where(image => image.ProductId == ProductId).ToList();
if (images.Count < 1)
{
return(NotFound());
}
else
{
foreach (Image img in images)
{
_context.Images.Remove(img);
}
}
try
{
await _context.SaveChangesAsync();
}
catch
{
return(BadRequest("Đã xảy ra lỗi"));
}
return(Ok());
}
public async Task <IActionResult> Excute()
{
//if (id != comments.Id)
//{
// return BadRequest();
//}
AssigndataUtils AssigndataUtils = new AssigndataUtils();
var _context = new TGDDContext();
Comment comment = AssigndataUtils.AssignComment(CommentDTO, CommentId);
_context.Entry(comment).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
bool commentExist = _context.Comments.Any(e => e.Id == CommentId);
if (!commentExist)
{
return(NotFound("Không tìm thấy comment!"));
}
else
{
throw;
}
}
return(Ok("Chỉnh sửa thành công !"));
}
public async Task <IActionResult> Excute()
{
AssigndataUtils AssigndataUtils = new AssigndataUtils();
var _context = new TGDDContext();
Voucher voucherUpdate = AssigndataUtils.AssignVoucher(voucherDTO, voucherDTO.Id);
_context.Entry(voucherUpdate).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
bool voucherExist = _context.Vouchers.Any(voucher => voucher.Id == voucherUpdate.Id);
if (!voucherExist)
{
return(NotFound());
}
else
{
throw;
}
}
return(Ok("Update Voucher thành công !"));
}
public async Task <ActionResult <Voucher> > Excute()
{
AssigndataUtils AssigndataUtils = new AssigndataUtils();
Voucher newVoucher = AssigndataUtils.AssignVoucher(voucherDTO, 0);
var _context = new TGDDContext();
_context.Vouchers.Add(newVoucher);
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateException)
{
bool voucherExist = _context.Vouchers.Any(voucher => voucher.Id == newVoucher.Id);
if (voucherExist)
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtAction("GetVoucher", new { id = newVoucher.Id }, newVoucher));
}
public async Task <ActionResult <Contact> > Excute()
{
var _context = new TGDDContext();
contact.Id = _context.Contacts.Max(c => c.Id) + 1;
contact.Date = DateTime.Now;
contact.IsReply = false;
_context.Contacts.Add(contact);
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateException)
{
bool contactExist = _context.Contacts.Any(c => c.Id == contact.Id);
if (contactExist)
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtAction("GetContact", new { id = contact.Id }, contact));
}
public async Task <Customer> SignUp(Customer oCustomer)
{
var _context = new TGDDContext();
_oCustomer = new Customer();
try
{
Customer customer = await this.CheckRecordExistence(oCustomer);
if (customer != null)
{
var newCustomerId = _context.Customers.Max(p => p.Id) + 1;
oCustomer.Id = newCustomerId;
_context.Customers.Add(customer);
}
}
catch (Exception ex)
{
throw ex;
}
return(oCustomer);
}
public async Task <IActionResult> Excute()
{
var _context = new TGDDContext();
var contact = await _context.Contacts.FindAsync(ContactId);
contact.IsReply = true;
_context.Entry(contact).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
bool contactExist = _context.Contacts.Any(c => c.Id == ContactId);
if (!contactExist)
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <ActionResult <IEnumerable <Contact> > > GetContacts()
{
var _context = new TGDDContext();
List <Order> Orders = await _context.Orders.OrderBy(order => order.Date).ToListAsync();
List <int> day = new List <int>();
List <int> month = new List <int>();
List <int> year = new List <int>();
foreach (Order order in Orders)
{
day.Add(order.Date.Value.Day);
month.Add(order.Date.Value.Month);
year.Add(order.Date.Value.Year);
}
//for (int i = 0; i < 52; i++)
//{
//}
var contactGetAll = new ContactGetAll();
return(await contactGetAll.Excute());
}
public async Task <ActionResult> Excute()
{
var _context = new TGDDContext();
Customer customer = await _context.Customers.FindAsync(CustomerId);
customer.Password = SecurityUtils.CreateMD5(NewPassword);
//OldPassword = SecurityUtils.CreateMD5(OldPassword);
//if(OldPassword == customer.Password)
//{
// customer.Password = SecurityUtils.CreateMD5(NewPassword);
//}
//else
//{
// return BadRequest("Mật khẩu hiện tại không đúng !");
//}
_context.Entry(customer).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch
{
throw;
};
return(Ok("Đổi mật khẩu thành công !"));
}
public async Task <ActionResult <IList <long?> > > Excute()
{
var _context = new TGDDContext();
var p = await _context.Orders.ToListAsync();
//Customer t = await _context.Customers.Where(c => c.Id == CustomerId).Include(customer => customer.Favorites).FirstOrDefaultAsync();
//List<Favorite> f = t.Favorites.ToList();
List <Favorite> f = await _context.Favorites.ToListAsync();
//IList<Favorite> favorites = await _context.Favorites.ToListAsync();
//IList<Favorite> favorites = null;
var productsId = new List <long?>();
if (f.Count < 1)
{
return(NotFound("Không có sản phẩm yêu thích !"));
}
else
{
foreach (var item in f)
{
productsId.Add(item.ProductId);
}
}
return(productsId);
}
public async Task <IActionResult> Excute()
{
var _context = new TGDDContext();
Customer customer = _context.Customers.Where(customer => customer.UserName == Username).FirstOrDefault();
if (customer == null)
{
return(BadRequest("Không tìm thấy tài khoản!"));
}
if (customer.Password == Pw)
{
customer.Verified = true;
_context.Entry(customer).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch
{
return(BadRequest());
}
}
else
{
return(BadRequest());
}
return(Ok("Xác thực thành công !"));
}
public async Task <ActionResult <Customer> > Excute()
{
var _context = new TGDDContext();
var newCustomerId = _context.Customers.Max(c => c.Id) + 1;
Customer.Id = newCustomerId;
Customer.Password = SecurityUtils.CreateMD5(Customer.Password);
_context.Customers.Add(Customer);
try
{
await _context.SaveChangesAsync();
{
MailClass mailClass = GetMailObject(Customer);
await _mailService.SendMail(mailClass);
}
}
catch (DbUpdateException)
{
bool customerExist = _context.Customers.Any(c => c.Id == Customer.Id);
if (customerExist)
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtAction("GetCustomers", new { id = Customer.Id }, Customer));
}
public async Task <ActionResult <Favorite> > Excute()
{
var _context = new TGDDContext();
var favorite = new Favorite();
List <Favorite> favorites = await _context.Favorites.Where(f => f.ProductId == Favorite.ProductId).ToListAsync();
foreach (Favorite f in favorites)
{
if (f.CustomerId == Favorite.CustomerId)
{
favorite = f;
break;
}
}
if (favorite == null)
{
return(NotFound());
}
_context.Favorites.Remove(favorite);
await _context.SaveChangesAsync();
return(favorite);
}
public async Task <ActionResult <Comment> > Excute()
{
AssigndataUtils AssigndataUtils = new AssigndataUtils();
var _context = new TGDDContext();
var comment = AssigndataUtils.AssignComment(commentDTO, 0);
_context.Comments.Add(comment);
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateException)
{
bool commentExist = _context.Comments.Any(e => e.Id == comment.Id);
if (commentExist)
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtAction("GetComments", new { id = comment.Id }, comment));
}
public async Task <ActionResult <Favorite> > Excute()
{
var _context = new TGDDContext();
var newFavoriteId = _context.Favorites.Max(c => c.Id) + 1;
Favorite.Id = newFavoriteId;
_context.Favorites.Add(Favorite);
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateException)
{
var favoriteExist = _context.Favorites.Any(f => f.Id == Favorite.Id);
if (favoriteExist)
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtAction("GetFavorite", new { id = Favorite.Id }, Favorite));
}
public LoginController(IConfiguration config, TGDDContext context)
{
_config = config;
_context = context;
//AssigndataUtils._context = _context;
SecurityUtils._context = _context;
SecurityUtils._config = config;
}
public static bool IsAdmin(TGDDContext _context, string username)
{
Admin admin = null;
admin = _context.Admins.FirstOrDefault(a => a.UserName == username);
return(admin != null ? true : false);
}
public async Task <ActionResult <IEnumerable <Comment> > > Excute()
{
var _context = new TGDDContext();
var comments = _context.Comments.Include(c => c.Customer);
return(await comments.ToListAsync());
}
public async Task <ActionResult <Order> > Excute()
{
var _context = new TGDDContext();
var order = await _context.Orders.FindAsync(OrderId);
if (order == null)
{
return(NotFound("Không tìm thấy đơn hàng !"));
}
return(order);
}
public async Task <ActionResult <IEnumerable <Order> > > Excute()
{
var _context = new TGDDContext();
var orders = _context.Orders.Include(o => o.OrderDetails).ThenInclude(d => d.Product)
.Include(o => o.Status)
.Include(o => o.Customer)
.Include(o => o.OrderDetails);
return(await orders.ToListAsync());
}
public async Task <ActionResult <Voucher> > Excute()
{
var _context = new TGDDContext();
var voucher = await _context.Vouchers.FindAsync(VoucherId);
if (voucher == null)
{
return(NotFound());
}
return(voucher);
}
public async Task <ActionResult <Customer> > Excute()
{
var _context = new TGDDContext();
Customer customer = _context.Customers.FirstOrDefault(c => c.UserName == Username);
if (customer == null)
{
return(NotFound());
}
return(customer);
}
public async Task <ActionResult <Customer> > Excute()
{
var _context = new TGDDContext();
var customers = await _context.Customers.FindAsync(Id);
if (customers == null)
{
return(NotFound());
}
return(customers);
}
public async Task <ActionResult <List <Comment> > > Excute()
{
var _context = new TGDDContext();
List <Comment> comments = await _context.Comments.Where(c => c.ProductId == ProductId).ToListAsync();
if (comments.Count < 1)
{
return(NotFound());
}
return(comments);
}
public async Task <ActionResult <UseVoucher> > Excute()
{
var _context = new TGDDContext();
Voucher voucher = _context.Vouchers.FirstOrDefault(voucher => voucher.Code == UserVoucherDTO.CodeVoucher);
if (voucher == null)
{
return(NotFound("Voucher khồn tồn tại"));
}
else
{
DateTime date = DateTime.Now;
if (date < voucher.StartDate && date > voucher.EndDate)
{
return(NotFound("Voucher đã hết hạn"));
}
//UseVoucher useVoucher = _context.UseVouchers.FirstOrDefault(useVoucher.VoucherId == voucher.Id && useVoucher.CustomerId == UserVoucherDTO.CustomerId);
UseVoucher useVoucher = _context.UseVouchers.Where(useVoucher => useVoucher.VoucherId == voucher.Id && useVoucher.CustomerId == UserVoucherDTO.CustomerId).FirstOrDefault();
if (useVoucher == null)
{
long newId = _context.UseVouchers.Max(useVoucher => useVoucher.Id) + 1;
useVoucher = new UseVoucher
{
Id = newId,
CustomerId = UserVoucherDTO.CustomerId,
Used = true,
VoucherId = voucher.Id,
Voucher = voucher,
};
_context.UseVouchers.Add(useVoucher);
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateException)
{
throw;
}
}
else
{
return(NotFound("Voucher đã được sử dụng !"));
};
}
return(Ok());
}
public async Task <ActionResult <IEnumerable <Product> > > Excute()
{
var _context = new TGDDContext();
var products = await _context.Products.Include(p => p.Descriptions)
.Include(p => p.Images)
.Include(p => p.Category)
.Include(p => p.Brand)
.Include(p => p.Comments)
.ToListAsync();
return(products);
}
public async Task <Customer> FindAccount(string username)
{
var _context = new TGDDContext();
Customer userinfo = await _context.Customers.FirstOrDefaultAsync(c => c.UserName == username);
if (userinfo == null)
{
userinfo = await _context.Customers.FirstOrDefaultAsync(c => c.Email == username);
}
return(userinfo);
}
public void UpdateQuantity(long ProductId, int Quantity)
{
var _context = new TGDDContext();
Product product = _context.Products.Find(ProductId);
if (product != null)
{
product.Stock -= Quantity;
product.BuyingTimes += Quantity;
}
_context.Entry(product).State = EntityState.Modified;
_context.SaveChangesAsync();
}