public JsonResult AddStock(AddStockModel model)
{
int tipo = 0;
string mensaje = "";
if (!ModelState.IsValid)
{
//Extrae el primer mensaje de error que tenga el modelo
mensaje = ModelState.Values.Select(e => e.Errors).Where(e => e.Count > 0).FirstOrDefault().Select(v => v.ErrorMessage).FirstOrDefault();
}
else
{
using (var db = new VentaArticulosCreditoEntities())
{
var stock = new Inventario(model.articulo, model.precioCompra, model.precioVenta, model.cantidad, model.fecha);
db.Inventario.Add(stock);
db.SaveChanges();
tipo = 1;
mensaje = "Stock agregado correctamente";
}
}
return(Json(new { tipo = tipo, mensaje = mensaje }, JsonRequestBehavior.AllowGet));
}
public async Task addStockToProductOption(AddStockModel addStockModel)
{
var productOption = await appDb.ProductOptions.FindAsync(addStockModel.OptionId, addStockModel.ProductId);
productOption.ProductStock = addStockModel.Stock;
await appDb.SaveChangesAsync();
}
public async Task <IActionResult> AddStockToProductOption([FromBody] AddStockModel addStockModel)
{
await productServices.addStockToProductOption(addStockModel);
return(Ok(new ProductResponse
{
Message = "Succesfully added stock"
}));
}
public SuccessOrFailure Add([FromBody] AddStockModel addstock)
{
Boolean canAdd = false;
// get user based on email and password
if (addstock.SessionKey.Length <= 0)
{
return(new SuccessOrFailure()
{
Success = false,
Message = "Invalid Session Key",
});
}
_connection.Open();
SqlCommand select_command = new SqlCommand("Select id, email, session_key from [user] where session_key like @session_key", _connection);
select_command.Parameters.AddWithValue("@session_key", addstock.SessionKey);
using (SqlDataReader select_reader = select_command.ExecuteReader())
{
if (select_reader.Read())
{
if (select_reader.HasRows)
{
canAdd = true;
}
}
}
// check user access
if (!canAdd)
{
return(new SuccessOrFailure()
{
Success = true,
Message = "You cannot add stock with this user"
});
}
// store stock into DB
SqlCommand insert_command = new SqlCommand("INSERT INTO [dbo].[stock] ([reg_no] ,[make] ,[model] ,[model_year] ,[kms] ,[colour] ,[vin] ,[retail_price] ,[cost_price] ,[DTCreated] ,[DTUpdated]) VALUES ( @reg_no, @make, @model, @model_year, @kms, @colour, @vin, @retail_price, @cost_price, @DTCreated, @DTUpdated); SELECT SCOPE_IDENTITY() AS ID; ", _connection);
insert_command.Parameters.AddWithValue("@reg_no", addstock.Stock.RegNumber);
insert_command.Parameters.AddWithValue("@make", addstock.Stock.Make);
insert_command.Parameters.AddWithValue("@model", addstock.Stock.Model);
insert_command.Parameters.AddWithValue("@model_year", addstock.Stock.ModelYear);
insert_command.Parameters.AddWithValue("@kms", addstock.Stock.KMS);
insert_command.Parameters.AddWithValue("@colour", addstock.Stock.Colour);
insert_command.Parameters.AddWithValue("@vin", addstock.Stock.VIN);
insert_command.Parameters.AddWithValue("@retail_price", addstock.Stock.RetailPrice);
insert_command.Parameters.AddWithValue("@cost_price", addstock.Stock.CostPrice);
insert_command.Parameters.AddWithValue("@DTCreated", DateTime.Now);
insert_command.Parameters.AddWithValue("@DTUpdated", DateTime.Now);
insert_command.CommandType = CommandType.Text;
addstock.Stock.ID = Convert.ToInt32(insert_command.ExecuteScalar());
foreach (var image in addstock.Stock.Images)
{
SqlCommand insert_image_command = new SqlCommand("INSERT INTO [dbo].[images] ([name] ,[data] ,[stock_id]) output INSERTED.ID VALUES (@name ,@data ,@stockID)", _connection);
insert_image_command.Parameters.AddWithValue("@name", image.Name);
insert_image_command.Parameters.AddWithValue("@data", image.Data);
insert_image_command.Parameters.AddWithValue("@stockID", addstock.Stock.ID);
insert_image_command.CommandType = CommandType.Text;
insert_image_command.ExecuteNonQuery();
}
foreach (var accessory in addstock.Stock.Accessories)
{
SqlCommand insert_image_command = new SqlCommand("INSERT INTO [dbo].[accessory] ([name] ,[description] ,[stock_id]) VALUES (@name ,@description ,@stockID)", _connection);
insert_image_command.Parameters.AddWithValue("@name", accessory.Name);
insert_image_command.Parameters.AddWithValue("@description", accessory.Description);
insert_image_command.Parameters.AddWithValue("@stockID", addstock.Stock.ID);
insert_image_command.CommandType = CommandType.Text;
insert_image_command.ExecuteNonQuery();
}
_connection.Close();
return(new SuccessOrFailure()
{
Success = true,
Message = "Stock Added Suiccesfully"
});
}
