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