public void Update(int manufacturingOrderId, ManufacturingOrder manufacturingOrder) { var id = new SqlParameter("id", manufacturingOrderId); var statusId = new SqlParameter("status_id", manufacturingOrder.StatusId); var factoryUnitId = new SqlParameter("factory_unit_id", manufacturingOrder.FactoryUnitId); var deadlineDate = new SqlParameter("deadline_date", manufacturingOrder.DeadlineDate); _context.Database.ExecuteSqlCommand(ManufacturingOrderUpdateSqlCommand, id, statusId, factoryUnitId, deadlineDate); _context.SaveChanges(); }
public void Save(Ingredient ingredient) { var name = new SqlParameter("name", ingredient.Name); var price = new SqlParameter("price", ingredient.Price); var measurementUnitId = new SqlParameter("measurement_unit_id", ingredient.MeasurementUnitId); _context.Database.ExecuteSqlCommand(InsertIngredientSqlCommand, name, price, measurementUnitId); _context.SaveChanges(); _context.Ingredient.Load(); var id = _context.Ingredient.FromSqlRaw("SELECT * FROM ingredient WHERE ingredient.id = (SELECT MAX(id) FROM ingredient)").First().Id; _context.Database.ExecuteSqlRaw($"INSERT INTO ingredient_storage (ingredient_id, factory_id, [count]) SELECT {id}, factory.id, 0 FROM factory"); }
public void Save(Sweet sweet, IEnumerable <SweetIngredient> ingredients) { var dateTable = new DataTable(); dateTable.Columns.Add(new DataColumn("ingredient_id", typeof(long))); dateTable.Columns.Add(new DataColumn("count", typeof(decimal))); foreach (var ingredient in ingredients) { dateTable.Rows.Add(ingredient.IngredientId, ingredient.Count); } var parameters = new[] { new SqlParameter("Name", sweet.Name), new SqlParameter("Description", sweet.Description), new SqlParameter("Price", sweet.Price), new SqlParameter("CategoryId", sweet.CategoryId), new SqlParameter { SqlDbType = SqlDbType.Structured, Direction = ParameterDirection.Input, ParameterName = "SweetIngredientsList", TypeName = "[dbo].[SweetIngredients]", Value = dateTable } }; _context.Database.ExecuteSqlCommand("dbo.SaveSweet @Name, @Description, @Price, @CategoryId, @SweetIngredientsList", parameters); _context.SaveChanges(); }
public long Register(User newUser) { var firstName = new SqlParameter("first_name", newUser.FirstName); var lastName = new SqlParameter("last_name", newUser.LastName); var email = new SqlParameter("email", newUser.Email); var password = new SqlParameter("password", PasswordHasher.Hash(newUser.Password)); var roleId = new SqlParameter("role_id", newUser.RoleId); _context.Database.ExecuteSqlCommand(RegisterSqlCommand, firstName, lastName, email, password, roleId); _context.SaveChanges(); return(LogIn(new LogInForm { Email = newUser.Email, Password = newUser.Password }).Id); }
public void UpdateSweetStorage(int sweetId, int factoryId, int count) { _context.Database.ExecuteSqlRaw($"dbo.UpdateSweetStorage {sweetId}, {factoryId}, {count}"); _context.SaveChanges(); }
public void UpdateIngredientStorage(int ingredientId, int factoryId, decimal count) { _context.Database.ExecuteSqlRaw($"dbo.UpdateIngredientStorage {ingredientId}, {factoryId}, {count}"); _context.SaveChanges(); }
public void Save(FactoryUnit factoryUnit) { _context.Database.ExecuteSqlRaw( $"dbo.SaveFactoryUnit {factoryUnit.ControllerId}, {factoryUnit.CategoryId}, {factoryUnit.FactoryId}"); _context.SaveChanges(); }
public void SaveUnitWorker(long userId, long unitId) { _context.Database.ExecuteSqlRaw($"dbo.SaveUnitWorker {userId}, {unitId}"); _context.SaveChanges(); }
public void Save(Category category) { _context.Database.ExecuteSqlRaw($"dbo.SaveCategory {category.Name}"); _context.SaveChanges(); }