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