public async Task <IActionResult> PostProductPrice([FromBody] List <ProductPrice> productPrice)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
int count = 0;
foreach (var item in productPrice)
{
Product productdb = _context.Products.FirstOrDefault(p => p.Code == item.Code);
if (productdb != null)
{
productdb.Price = item.Price;
productdb.Price1 = item.Price1;
productdb.Quantity = item.Quantity;
productdb.Quantity1 = item.Quantity1;
_context.AttachRange(productdb);
count++;
}
}
await _context.SaveChangesAsync();
return(Ok(new { count = count }));
}
public async Task <IActionResult> AddCustomerShoppingArea([FromBody] Customer customer)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var user = await _context.Users.SingleAsync(x => x.UserName == HttpContext.User.Identity.Name);
if (user == null)
{
ModelState.AddModelError("", "Sory, your user is empty !");
return(BadRequest(ModelState));
}
UserMeta userMeta = _context.UserMeta.FirstOrDefault(u => u.Id == user.UserMetaId);
ShoppingArea shoppingArea = await _context.ShoppingArea.FirstOrDefaultAsync(x => x.ShoppingAreaId == userMeta.ShoppingAreaId);
if (shoppingArea == null)
{
ModelState.AddModelError("", "Sory, your Shoping Area is empty !");
return(BadRequest(ModelState));
}
_context.AttachRange(customer);
CustomerShoppingArea customerShoppingArea = _context.CustomerShoppingArea.FirstOrDefault(c => c.CustomerId == customer.CustomerId & c.ShoppingAreaId == shoppingArea.ShoppingAreaId);
if (customerShoppingArea != null)
{
customerShoppingArea.ShoppingArea = shoppingArea;
customerShoppingArea.Customer = customer;
customerShoppingArea.UpdateStatus = 1;
await _context.SaveChangesAsync();
return(CreatedAtAction("GetCustomerShoppingArea", new CustomerShoppingAreaCode {
ShoppingAreaCode = shoppingArea.Code, CustomerCode = customer.Code
}));
}
else
{
customerShoppingArea = new CustomerShoppingArea();
customerShoppingArea.ShoppingArea = shoppingArea;
customerShoppingArea.Customer = customer;
customerShoppingArea.UpdateStatus = 1;
_context.CustomerShoppingArea.Add(customerShoppingArea);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetCustomerShoppingArea", new CustomerShoppingAreaCode {
ShoppingAreaCode = shoppingArea.Code, CustomerCode = customer.Code
}));
}
}
public async Task <IActionResult> AddWarehouseShoppingArea([FromBody] Warehouse warehouse)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var user = await _context.Users.SingleAsync(x => x.UserName == HttpContext.User.Identity.Name);
if (user == null)
{
ModelState.AddModelError("", "Sory, your user is empty !");
return(BadRequest(ModelState));
}
UserMeta userMeta = _context.UserMeta.FirstOrDefault(u => u.Id == user.UserMetaId);
ShoppingArea shoppingArea = await _context.ShoppingArea.FirstOrDefaultAsync(x => x.ShoppingAreaId == userMeta.ShoppingAreaId);
if (shoppingArea == null)
{
ModelState.AddModelError("", "Sory, your Shoping Area is empty !");
return(BadRequest(ModelState));
}
_context.AttachRange(warehouse);
WarehouseShoppingArea warehouseShoppingArea = _context.WarehouseShoppingArea.FirstOrDefault(c => c.WarehouseId == warehouse.WarehouseId & c.ShoppingAreaId == shoppingArea.ShoppingAreaId);
if (warehouseShoppingArea != null)
{
warehouseShoppingArea.ShoppingArea = shoppingArea;
warehouseShoppingArea.Warehouse = warehouse;
warehouseShoppingArea.UpdateStatus = 1;
await _context.SaveChangesAsync();
}
else
{
warehouseShoppingArea = new WarehouseShoppingArea();
warehouseShoppingArea.ShoppingArea = shoppingArea;
warehouseShoppingArea.Warehouse = warehouse;
warehouseShoppingArea.UpdateStatus = 1;
_context.WarehouseShoppingArea.Add(warehouseShoppingArea);
await _context.SaveChangesAsync();
}
return(Ok());
}
public async Task <IActionResult> PostMarketingEventProduct([FromBody] List <MarketingEventProductCode> marketingEventProductCode)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
int count = 0;
foreach (var item in marketingEventProductCode)
{
MarketingEvent marketingEvent = _context.MarketingEvent.FirstOrDefault(p => p.Code == item.MarketingEventCode);
Product product = _context.Products.FirstOrDefault(p => p.Code == item.ProductCode);
if (marketingEvent == null)
{
return(BadRequest(ModelState));
}
if (product == null)
{
return(BadRequest(ModelState));
}
var marketingEventProduct = await _context.MarketingEventProduct.SingleOrDefaultAsync(c => c.MarketingEventId == marketingEvent.MarketingEventId& c.ProductId == product.ProductId);
if (marketingEventProduct != null)
{
marketingEventProduct.MarketingEvent = marketingEvent;
marketingEventProduct.Product = product;
}
else
{
marketingEventProduct = new MarketingEventProduct();
marketingEventProduct.MarketingEvent = marketingEvent;
marketingEventProduct.Product = product;
}
_context.AttachRange(marketingEventProduct);
count++;
}
await _context.SaveChangesAsync();
return(Ok(new { count = count }));
}
public async Task <IActionResult> PostShoppingAreaUsers([FromBody] List <UserShoppingArea> userShoppingArea)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
int count = 0;
foreach (var item in userShoppingArea)
{
var user = await _context.Users.FirstOrDefaultAsync(x => x.Id == item.UserId);
if (user != null)
{
UserMeta userMeta = _context.UserMeta.FirstOrDefault(u => u.Id == user.UserMetaId);
ShoppingArea shoppingarea = await _context.ShoppingArea.FirstOrDefaultAsync(c => c.Code == item.ShoppingAreaCode);
if (shoppingarea != null)
{
userMeta.ShoppingAreaId = shoppingarea.ShoppingAreaId;
_context.AttachRange(userMeta);
//user.ShoppingAreaId = shoppingarea.ShoppingAreaId;
//_context.AttachRange(user);
count++;
}
}
}
await _context.SaveChangesAsync();
return(Ok(new { count = count }));
}
public async Task <IActionResult> PostOrder([FromBody] Order order)
{
if (!string.IsNullOrWhiteSpace(order.Number))
{
Order orderdb = await _context.Orders.SingleOrDefaultAsync(m => m.Number == order.Number);
if (orderdb != null)
{
ModelState.AddModelError("", "Sory, order exist !");
}
}
//Заполняем из БД
if (order.Customer.CustomerId == 0)
{
Customer customer = await _context.Customers.SingleOrDefaultAsync(m => m.Code == order.Customer.Code);
if (customer != null)
{
order.Customer = customer;
}
}
if (order.Outlet.OutletId == 0)
{
Outlet outlet = await _context.Outlets.SingleOrDefaultAsync(m => m.Code == order.Outlet.Code);
if (outlet != null)
{
order.Outlet = outlet;
}
}
if (order.Warehouse.WarehouseId == 0)
{
Warehouse warehouse = await _context.Warehouses.SingleOrDefaultAsync(m => m.Code == order.Warehouse.Code);
if (warehouse != null)
{
order.Warehouse = warehouse;
}
}
foreach (var item in order.Lines)
{
if (item.Product.ProductId == 0)
{
Product product = await _context.Products.SingleOrDefaultAsync(m => m.Code == item.Product.Code);
if (product != null)
{
item.Product = product;
}
}
}
if (order.Lines.Count() == 0)
{
ModelState.AddModelError("", "Sory, your cart is empty !");
}
if (order.Customer.CustomerId == 0)
{
ModelState.AddModelError("", "Sory, your customer is empty !");
}
if (order.Outlet.OutletId == 0)
{
ModelState.AddModelError("", "Sory, your outlet is empty !");
}
if (order.Warehouse.WarehouseId == 0)
{
ModelState.AddModelError("", "Sory, your warehouse is empty !");
}
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
order.Shipped = false;
order.Date = DateTime.Now;
var userApi = await _context.Users.SingleAsync(x => x.UserName == HttpContext.User.Identity.Name);
if (userApi != null)
{
order.UserId = userApi.Id;
order.FirstName = userApi.FirstName;
order.LastName = userApi.LastName;
}
_context.AttachRange(order.Customer);
_context.AttachRange(order.Outlet);
_context.AttachRange(order.Warehouse);
_context.AttachRange(order.Lines.Select(l => l.Product));
var marketingEventList = order.Lines.Where(m => m.MarketingEvent != null).Select(l => l.MarketingEvent);
List <int> newList = new List <int>();
foreach (var item in marketingEventList)
{
if (newList.IndexOf(item.MarketingEventId) == -1)
{
newList.Add(item.MarketingEventId);
_context.AttachRange(item);
}
}
_context.Orders.Add(order);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetOrder", new { id = order.OrderId }, order));
}