private void SeedData()
{
if (!dbContext.Orders.Any())
{
dbContext.OrderItems.Add(new Db.OrderItem {
Id = 1, ProductId = 1, Quatity = 10, UnitPrice = 10
});
dbContext.OrderItems.Add(new Db.OrderItem {
Id = 2, ProductId = 5, Quatity = 50, UnitPrice = 80
});
dbContext.OrderItems.Add(new Db.OrderItem {
Id = 3, ProductId = 8, Quatity = 60, UnitPrice = 90
});
dbContext.OrderItems.Add(new Db.OrderItem {
Id = 4, ProductId = 10, Quatity = 70, UnitPrice = 100
});
dbContext.SaveChanges();
dbContext.Orders.Add(new Db.Order {
Id = 1, CustomerId = 1, OrderDate = System.DateTime.Now, Total = 100
});
dbContext.Orders.Add(new Db.Order {
Id = 2, CustomerId = 5, OrderDate = System.DateTime.Now, Total = 200
});
dbContext.Orders.Add(new Db.Order {
Id = 3, CustomerId = 6, OrderDate = System.DateTime.Now, Total = 300
});
dbContext.Orders.Add(new Db.Order {
Id = 4, CustomerId = 7, OrderDate = System.DateTime.Now, Total = 400
});
dbContext.SaveChanges();
}
}
public IHttpActionResult PutContact(int id, Contact contact)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != contact.ContactId)
{
return(BadRequest());
}
db.Entry(contact).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ContactExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public async Task Token(LoginModel model)
{
string mobileID = Request.Form["mobileID"];
string code = Request.Form["agentCode"];
string password = Request.Form["password"];
try
{
mobileID = Request.Form["mobileID"];
code = Request.Form["agentCode"];
password = Request.Form["password"];
}
catch
{
mobileID = model.mobileID;
code = model.agentCode;
password = model.password;
}
if (!db.MobileUsers.Any(s => s.AgentId == code && s.AgentPassword.ToLower() == password.ToString().ToLower()))
{
Response.StatusCode = 404;
await Response.WriteAsync("Page not found.");;
return;
}
if (db.MobileUsers.Any(s => s.AgentMobileId == mobileID))
{
var mobileAgent = db.MobileUsers.FirstOrDefault(s => s.AgentMobileId == mobileID);
mobileAgent.AgentMobileId = String.Empty;
db.SaveChanges();
}
var mobileUser = db.MobileUsers.SingleOrDefault(s => s.AgentId == code);
mobileUser.AgentMobileId = mobileID;
db.SaveChanges();
var identity = GetIdentity(mobileID);
var now = DateTime.UtcNow;
// создаем JWT-токен
var jwt = new JwtSecurityToken(
issuer: AuthOptions.ISSUER,
audience: AuthOptions.AUDIENCE,
notBefore: now,
claims: identity.Claims,
expires: now.Add(TimeSpan.FromMinutes(AuthOptions.LIFETIME)),
signingCredentials: new SigningCredentials(AuthOptions.GetSymmetricSecurityKey(), SecurityAlgorithms.HmacSha256));
var encodedJwt = new JwtSecurityTokenHandler().WriteToken(jwt);
var response = new
{
access_token = encodedJwt,
username = identity.Name
};
// сериализация ответа
Response.ContentType = "application/json";
await Response.WriteAsync(JsonConvert.SerializeObject(response, new JsonSerializerSettings {
Formatting = Formatting.Indented
}));
}
private void SeedData()
{
if (!dbContext.Orders.Any())
{
dbContext.OrderItems.Add(new DB.OrderItem()
{
Id = 1, OrderId = 1, ProductId = 3, Quantity = 1, UnitPrice = 35
});
dbContext.OrderItems.Add(new DB.OrderItem()
{
Id = 2, OrderId = 1, ProductId = 4, Quantity = 1, UnitPrice = 100
});
dbContext.OrderItems.Add(new DB.OrderItem()
{
Id = 3, OrderId = 2, ProductId = 2, Quantity = 1, UnitPrice = 15
});
dbContext.OrderItems.Add(new DB.OrderItem()
{
Id = 4, OrderId = 2, ProductId = 3, Quantity = 1, UnitPrice = 35
});
dbContext.OrderItems.Add(new DB.OrderItem()
{
Id = 5, OrderId = 2, ProductId = 4, Quantity = 1, UnitPrice = 100
});
dbContext.OrderItems.Add(new DB.OrderItem()
{
Id = 6, OrderId = 3, ProductId = 4, Quantity = 1, UnitPrice = 100
});
dbContext.OrderItems.Add(new DB.OrderItem()
{
Id = 7, OrderId = 4, ProductId = 3, Quantity = 1, UnitPrice = 35
});
dbContext.OrderItems.Add(new DB.OrderItem()
{
Id = 8, OrderId = 4, ProductId = 4, Quantity = 1, UnitPrice = 100
});
dbContext.SaveChanges();
dbContext.Orders.Add(new DB.Order()
{
Id = 1, CustomerId = 1, OrderDate = DateTime.Now, Total = 135
});
dbContext.Orders.Add(new DB.Order()
{
Id = 2, CustomerId = 2, OrderDate = DateTime.Now, Total = 150
});
dbContext.Orders.Add(new DB.Order()
{
Id = 3, CustomerId = 3, OrderDate = DateTime.Now, Total = 100
});
dbContext.Orders.Add(new DB.Order()
{
Id = 4, CustomerId = 4, OrderDate = DateTime.Now, Total = 135
});
dbContext.SaveChanges();
}
}
public IActionResult Post([FromBody] Order order, int UserId)
{
if (ModelState.IsValid && context.Users.FirstOrDefault(x => x.Id == UserId) != null)
{
context.Orders.Add(order);
context.SaveChanges();
return(Ok());
}
return(BadRequest(ModelState));
}
public IActionResult Post([FromBody] User user)
{
if (ModelState.IsValid)
{
context.Users.Add(user);
context.SaveChanges();
return(Ok());
}
return(BadRequest(ModelState));
}
public ActionResult Create([Bind(Include = "OrderId,ContactId,OrderDate,OrderDescription,OrderAmount")] Order order)
{
if (ModelState.IsValid)
{
db.Orders.Add(order);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ContactId = new SelectList(db.Contacts, "ContactId", "FirstName", order.ContactId);
return(View(order));
}
public void SeedData()
{
if (_dbContext != null && !_dbContext.Orders.Any())
{
_dbContext.Orders.Add(new Core.Entities.Order
{
OrderId = 1,
CustomerId = 1,
OrderDate = DateTime.Now,
Total = 30
});
_dbContext.Orders.Add(new Core.Entities.Order
{
OrderId = 2,
CustomerId = 2,
OrderDate = DateTime.Now,
Total = 10
});
_dbContext.Orders.Add(new Core.Entities.Order
{
OrderId = 3,
CustomerId = 4,
OrderDate = DateTime.Now,
Total = 100
});
_dbContext.SaveChanges();
}
}
public void Execute(SaveMineralDataCommand command)
{
/* In ordinary case I would use AutoMapper to handle type conversion.
* Due to time limitations we need to live with this solution. */
MineralPriceData mineralPriceData = new MineralPriceData()
{
GoldPrice = command.PriceData.XagPrice,
GoldChange = command.PriceData.ChgXau,
SilverPrice = command.PriceData.XauPrice,
SilverChange = command.PriceData.ChgXag,
GoldClose = command.PriceData.XauClose,
SilverClose = command.PriceData.XagClose,
GoldPcExchange = command.PriceData.PcXau,
SilverPcExchange = command.PriceData.PcXag,
Currency = ConvertToEnumCurrency(command.PriceData.Currency),
TimeOfRegistration = command.PriceDataTimestamp.GetDateTime(),
Timestamp = command.PriceDataTimestamp
};
try
{
_orderDbContext.MineralPriceData.Add(mineralPriceData);
_orderDbContext.SaveChanges();
}
catch (DbUpdateException exception)
{
_logger.Log(LogLevel.Error, $" {handlerName} caused an DbUpdateException { exception.Message} ");
throw;
}
catch (Exception exception)
{
_logger.Log(LogLevel.Error, $" {handlerName} caused an Exception { exception.Message} ");
throw;
}
}
public void MakeOrder(OrderModel orderModel)
{
var order = MapOrderModelToOrder(orderModel);
_context.Orders.Add(order);
_context.SaveChanges();
}
private void SeedData()
{
if (!dbContext.Orders.Any())
{
dbContext.Orders.Add(new db.Order {
Id = 1, CustomerId = 1, OrderDate = new DateTime(2020, 1, 1), Total = 1000
});
dbContext.Orders.Add(new db.Order {
Id = 2, CustomerId = 2, OrderDate = new DateTime(2020, 2, 1), Total = 1500
});
dbContext.Orders.Add(new db.Order {
Id = 3, CustomerId = 3, OrderDate = new DateTime(2020, 3, 1), Total = 2000
});
dbContext.OrderItems.Add(new db.OrderItem {
Id = 1, OrderId = 1, ProductId = 1
});
dbContext.OrderItems.Add(new db.OrderItem {
Id = 2, OrderId = 1, ProductId = 2
});
dbContext.OrderItems.Add(new db.OrderItem {
Id = 3, OrderId = 1, ProductId = 3
});
dbContext.SaveChanges();
}
}
public void Add(UserModel userModel)
{
_context.Users.Add(new User {
Email = userModel.Email, Password = userModel.Password, RoleId = 1
});
_context.SaveChanges();
}
public IActionResult LoadApp(IFormFile fileApp, string password)
{
try
{
if (fileApp.Length > 0)
{
using (var reader = new StreamReader(fileApp.OpenReadStream()))
{
var parsedContentDisposition = ContentDispositionHeaderValue.Parse(fileApp.ContentDisposition);
var fileName = parsedContentDisposition.FileName;
if (Regex.Match(fileName, @"\.\w{3,4}$", RegexOptions.IgnoreCase).Value != ".apk")
{
return(StatusCode(404));
}
string path = Path.Combine(@"D:\order\app", fileName);
using (var stream = new FileStream(path, FileMode.Create))
{
fileApp.CopyTo(stream);
}
LogApp fileLog = new LogApp {
id = 0, file = fileApp.FileName, path = path, period = DateTime.Now
};
db.Entry(fileLog).State = EntityState.Added;
db.SaveChanges();
}
}
}
catch (Exception ex)
{
return(StatusCode(404));
}
return(Ok("Ok"));
}
public void Execute(RegisterUserCommand command)
{
/* We compute hash of a password. */
User user = new User {
Username = command.UserName,
Password = ComputeHash(command.Password)
};
try
{
if (_orderDbContext.Users.Any((registeredUser) => registeredUser.Username.Equals(user.Username)))
{
string exceptionMessage = $"{handlerName} caused an exception User with {user.Username} already exists!";
_logger.Log(LogLevel.Error, exceptionMessage);
throw new ArgumentException(exceptionMessage);
}
_orderDbContext.Users.Add(user);
_orderDbContext.SaveChanges();
}
catch (DbUpdateException exception)
{
_logger.Log(LogLevel.Error, $" {handlerName} database update caused an DbUpdateException {exception.Message} ");
throw;
}
catch (Exception exception)
{
_logger.Log(LogLevel.Error, $" {handlerName} database update caused an Exception {exception.Message} ");
throw;
}
}
private void SeedData()
{
if (!dbContext.Orders.Any())
{
dbContext.Orders.Add(new Order
{
CustomerId = 100,
Id = 100,
Items = new List <OrderItem> {
new OrderItem {
Id = 1, OrderId = 100, ProductId = 10, Quantity = 1, UnitPrice = 10.00M
}
},
OrderDate = new DateTime(2020, 12, 1),
Total = 10.00M
});
dbContext.Orders.Add(new Order
{
CustomerId = 101,
Id = 101,
Items = new List <OrderItem> {
new OrderItem {
Id = 2, OrderId = 101, ProductId = 20, Quantity = 10, UnitPrice = 100.00M
},
new OrderItem {
Id = 3, OrderId = 101, ProductId = 22, Quantity = 10, UnitPrice = 750.00M
}
},
OrderDate = new DateTime(2020, 12, 1),
Total = 850.00M
});;
dbContext.SaveChanges();
}
}
public int Add(ClientModel clientModel)
{
var client = MapClientModelToClient(clientModel);
_context.Clients.Add(client);
_context.SaveChanges();
return(client.ClientId);
}
public int Add(ManagerModel managerModel)
{
var manager = MapManagerModelToManager(managerModel);
_context.Managers.Add(manager);
_context.SaveChanges();
return(manager.ManagerId);
}
public int Add(ProductModel productModel)
{
var product = MapProductModelToProduct(productModel);
_context.Products.Add(product);
_context.SaveChanges();
return(product.ProductId);
}
public IActionResult Add([FromBody] Payment model)
{
try
{
if (db.Payments.Any(s => s.id == model.id))
{
var item = db.Payments.SingleOrDefault(s => s.id == model.id);
item.sum = model.sum;
db.Update(item);
db.SaveChanges();
}
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
return(RedirectToAction("Payments"));
}
public string SaveFromFile(string file)
{
string model;
using (System.IO.StreamReader fileStr =
new System.IO.StreamReader(@"D:\order\log\" + file + ".txt"))
{
model = fileStr.ReadToEnd();
}
try
{
var log = new logsString {
id = 0, agent = "manual", content = model, date = DateTime.Now
};
db.Entry(log).State = EntityState.Added;
db.SaveChanges();
var logs = JsonConvert.DeserializeObject <log[]>(model);
foreach (var item in logs.ToList())
{
item.timeStampServer = DateTime.Now;
db.Entry(item).State = EntityState.Added;
db.SaveChanges();
}
var orders = JsonConvert.DeserializeObject <Order[]>(model);
foreach (var a in orders.ToList())
{
foreach (var c in db.Orders.Where(o => o.agent == a.agent && o.customer == a.customer && o.number == a.number).ToList())
{
db.Entry(c).State = EntityState.Deleted;
db.SaveChanges();
}
}
foreach (var item in orders)
{
db.Entry(item).State = EntityState.Added;
db.SaveChanges();
}
return("Записано");
}
catch (Exception ex)
{
return(ex.Message);
}
}
public void Put(long id, [FromHeader] int invoce)
{
using (var db = new OrdersDbContext())
{
var order = db.Orders.Find(id);
order.InvoiceNumber = invoce;
db.Orders.Update(order);
db.SaveChanges();
}
}
public void Put(long id, [FromHeader] Byte status)
{
using (var db = new OrdersDbContext())
{
var order = db.Orders.Find(id);
order.OrderStatus = status;
db.Orders.Update(order);
db.SaveChanges();
}
}
public string Save(string model)
{
agent = db.agents.FirstOrDefault(s => s.name == db.MobileUsers.FirstOrDefault(a => a.AgentMobileId == User.Identity.Name).AgentName);
using (System.IO.StreamWriter fileLog =
new System.IO.StreamWriter(@"D:\order\log\" + agent.name + ".txt"))
{
fileLog.WriteLine("{0}", model);
}
try
{
var log = new logsString {
id = 0, agent = agent.name, content = model, date = DateTime.Now
};
db.Entry(log).State = EntityState.Added;
db.SaveChanges();
var logs = JsonConvert.DeserializeObject <log[]>(model);
foreach (var item in logs.ToList())
{
item.timeStampServer = DateTime.Now;
db.Entry(item).State = EntityState.Added;
db.SaveChanges();
}
var orders = JsonConvert.DeserializeObject <Order[]>(model);
if (!orders.Any())
{
return("Нет данных");
}
foreach (var a in orders.ToList())
{
foreach (var c in db.Orders.Where(o => o.agent == a.agent && o.customer == a.customer && o.number == a.number).ToList())
{
db.Entry(c).State = EntityState.Deleted;
db.SaveChanges();
}
}
foreach (var item in orders)
{
db.Entry(item).State = EntityState.Added;
db.SaveChanges();
}
return("Записано");
}
catch (Exception ex)
{
return(ex.Message);
}
}
public void PlaceOrder(CustomerDto customerDto, string supplierName, List <ProductDto> productDtos)
{
using (var ctx = new OrdersDbContext())
{
var supplier = ctx.Suppliers.FirstOrDefault(s => s.Name == supplierName);
if (supplier == null)
{
return;
}
var customer = ctx.Customers
.FirstOrDefault(c => c.Name == customerDto.Name && c.IdentificationNumber == customerDto.IdentificationNumber);
if (customer == null)
{
customer = new Customer
{
Name = customerDto.Name,
IdentificationNumber = customerDto.IdentificationNumber
};
}
customer.Address = customerDto.Address;
customer.PhoneNumber = customerDto.PhoneNumber;
var order = new Order
{
Customer = customer,
Supplier = supplier,
OrderedDate = DateTime.Now,
Status = OrderStatus.Opened,
ExpectedDate = DateTime.Now.AddDays(_random.Next(1, 10))
};
foreach (var productDto in productDtos)
{
var product = ctx.Products.Find(productDto.Id);
var orderDetails = new OrderDetails
{
Order = order,
Product = product,
ProductQuantity = productDto.Quantity
};
order.OrderDetails.Add(orderDetails);
}
ctx.Orders.Add(order);
ctx.SaveChanges();
}
}
public ActionResult PlaceOrder(Orders order)
{
order.Id = Guid.NewGuid();
order.DateOrdered = DateTime.UtcNow;
ordersDb.Orders.Add(order);
ordersDb.SaveChanges();
bool success = true;
string message = "Order Success! Enjoy your coffee.";
try
{
var drink = drinksDb.Drinks.Find(order.DrinkOrderedGuid);
var recipe = recipeDb.Recipes.Where(x => x.DrinkId.Equals(drink.Id));
foreach (var ingredient in recipe)
{
var updateStock = stocksDb.Stocks.Find(ingredient.StockId);
int requiredStocks = ingredient.Quantity * order.Quantity;
if (updateStock.Quantity < requiredStocks)
{
success = false;
message = "Sorry we have insufficient stocks. Try ordering less?";
break;
}
else
{
updateStock.Quantity -= requiredStocks;
stocksDb.Entry(updateStock).State = EntityState.Modified;
stocksDb.SaveChanges();
}
}
}
catch (Exception ex)
{
success = false;
message = "Error encountered" + ex.Message;
}
return(Json(new { message = message, success = success }, JsonRequestBehavior.AllowGet));
}
public static void Seed(this OrdersDbContext dbContext)
{
/*dbContext.Orders.Add(new OrderDetails
* {
* ID_Order = 1,
* order = null,
* ID_Cocktail = 1,
* cocktail = { },
* Quantite = 2
* });*/
dbContext.SaveChanges();
}
private void SeedData()
{
if (!dbContext.Orders.Any())
{
dbContext.Orders.Add(new Db.Order()
{
Id = 1,
CustomerId = 1,
OrderDate = DateTime.Now,
Items = new List<Db.OrderItem>()
{
new Db.OrderItem() { OrderId = 1, ProductId = 1, Quantity = 10, UnitPrice = 10 },
new Db.OrderItem() { OrderId = 1, ProductId = 2, Quantity = 10, UnitPrice = 10 },
new Db.OrderItem() { OrderId = 1, ProductId = 3, Quantity = 10, UnitPrice = 10 },
new OrderItem() { OrderId = 2, ProductId = 2, Quantity = 10, UnitPrice = 10 },
new OrderItem() { OrderId = 3, ProductId = 3, Quantity = 1, UnitPrice = 100 }
},
Total = 100
});
dbContext.Orders.Add(new Db.Order()
{
Id = 2,
CustomerId = 1,
OrderDate = DateTime.Now.AddDays(-1),
Items = new List<Db.OrderItem>()
{
new OrderItem() { OrderId = 1, ProductId = 1, Quantity = 10, UnitPrice = 10 },
new OrderItem() { OrderId = 1, ProductId = 2, Quantity = 10, UnitPrice = 10 },
new OrderItem() { OrderId = 1, ProductId = 3, Quantity = 10, UnitPrice = 10 },
new OrderItem() { OrderId = 2, ProductId = 2, Quantity = 10, UnitPrice = 10 },
new OrderItem() { OrderId = 3, ProductId = 3, Quantity = 1, UnitPrice = 100 }
},
Total = 100
});
dbContext.Orders.Add(new Order()
{
Id = 3,
CustomerId = 2,
OrderDate = DateTime.Now,
Items = new List<OrderItem>()
{
new OrderItem() { OrderId = 1, ProductId = 1, Quantity = 10, UnitPrice = 10 },
new OrderItem() { OrderId = 2, ProductId = 2, Quantity = 10, UnitPrice = 10 },
new OrderItem() { OrderId = 3, ProductId = 3, Quantity = 1, UnitPrice = 100 }
},
Total = 100
});
dbContext.SaveChanges();
}
}
public IHttpActionResult DeleteOrder(int id)
{
Order order = db.Orders.Find(id);
if (order == null)
{
return(NotFound());
}
db.Orders.Remove(order);
db.SaveChanges();
return(Ok(order));
}
public IActionResult Delete(int id)
{
try
{
if (!db.Orders.Any(s => s.id == id)) return BadRequest("Заказ не найден");//NotFound
var item = db.Orders.FirstOrDefault(s => s.id == id);
db.Remove(item);
db.SaveChanges();
return RedirectToAction("Orders");
}
catch (Exception ex)
{
return BadRequest(ex.Message);
}
}
public void CloseOrder(int orderId)
{
using (var ctx = new OrdersDbContext())
{
var order = ctx.Orders.Find(orderId);
if (order == null)
{
throw new Exception("Order does not exist.");
}
order.Status = OrderStatus.Closed;
ctx.SaveChanges();
}
}