public Task Update(EmployeeModel model)
{
string sql =
@"UPDATE employees_table SET FirstName=@FirstName, LastName=@LastName, MiddleName=@MiddleName, EmployeePosition=@EmployeePosition WHERE EmployeeId=@EmployeeId";
return(_db.ExecuteSQLQuery(sql, model));
}
public Task Update(ProductCompositionsModel model)
{
string sql =
@"UPDATE product_compositions SET ProductId=@ProductId, ProductComposition=@ProductComposition WHERE CompositionId=@CompositionId";
return(_db.ExecuteSQLQuery(sql, model));
}
public Task UpdateOrder(OrderModel model)
{
string sql =
@"UPDATE orders SET ClientId=@ClientId, Sum=@Sum, OrderTime=@OrderTime, StatusId=@StatusId, OrderContents=@OrderContents, EmployeeId=@EmployeeId WHERE OrderId=@OrderId";
return(_db.ExecuteSQLQuery(sql, model));
}
public Task Update(PartnerProductModel model)
{
string sql =
@"UPDATE partner_products SET ProductId=@ProductId, ProductPartnerPrice=@ProductPartnerPrice, ProductCount=@ProductCount WHERE PartnerProductId=@PartnerProductId";
return(_db.ExecuteSQLQuery(sql, model));
}
public Task UpdateClient(ClientModel client)
{
string sql =
@"UPDATE table_clients SET Name=@Name, Address=@Address, PhoneNumber=@PhoneNumber WHERE ClientId=@ClientId";
return(_db.ExecuteSQLQuery(sql, client));
}
public Task Update(ProductRecipeModel model)
{
string sql =
@"UPDATE product_recipes SET ProductId=@ProductId, ProductRecipe=@ProductRecipe WHERE RecipeId=@RecipeId";
return(_db.ExecuteSQLQuery(sql, model));
}
public Task UpdateProduct(MenuProductModel product)
{
string sql = @"update products_table set ProductName=@ProductName, ProductPrice=@ProductPrice, ProductDescription=@ProductDescription, ProductMarks=@ProductMarks where ProductId=@ProductId";
return(_db.ExecuteSQLQuery(sql, product));
}