public ActionResult InsertWarehouse(int idOperative, string name_warehouse, string desc_warehouse, string address_warehouse)
{
Warehouse_Entity warehouse_Entity = new Warehouse_Entity();
int idClientBusiness = userOperative.getIdClientBusiness(idOperative);
warehouse_Entity.name = name_warehouse;
warehouse_Entity.description = desc_warehouse;
warehouse_Entity.address = address_warehouse;
warehouse_Entity.clientBusiness.id_client_business = idClientBusiness;
if (warehouse.InsertWarehouse(warehouse_Entity))
{
return(Content("<script>" +
"alert('Registro Insertado Correctamente');" +
"</script>"));
}
else
{
return(Content("<script>" +
"alert('No se pudo ingresar');" +
"window.location.href='/Inventory/Index';" +
"</script>"));
}
}
public bool InsertWarehouse(Warehouse_Entity warehouse)
{
bool response = false;
try
{
sqlConnection.Open();
sqlCommand = new SqlCommand("add_warehouse", sqlConnection);
sqlCommand.CommandType = CommandType.StoredProcedure;
SqlParameter p_name = new SqlParameter();
p_name.ParameterName = "@name";
p_name.SqlDbType = SqlDbType.VarChar;
p_name.Size = 25;
p_name.Value = warehouse.name;
SqlParameter p_desc = new SqlParameter();
p_desc.ParameterName = "@desc";
p_desc.SqlDbType = SqlDbType.VarChar;
p_desc.Size = 50;
p_desc.Value = warehouse.description;
SqlParameter p_address = new SqlParameter();
p_address.ParameterName = "@address";
p_address.SqlDbType = SqlDbType.VarChar;
p_address.Size = 20;
p_address.Value = warehouse.address;
SqlParameter fkClientBusiness = new SqlParameter();
fkClientBusiness.ParameterName = "@fkClientBusiness";
fkClientBusiness.SqlDbType = SqlDbType.Int;
fkClientBusiness.Value = warehouse.clientBusiness.id_client_business;
sqlCommand.Parameters.Add(p_name);
sqlCommand.Parameters.Add(p_desc);
sqlCommand.Parameters.Add(p_address);
sqlCommand.Parameters.Add(fkClientBusiness);
sqlCommand.ExecuteNonQuery();
response = true;
sqlConnection.Close();
}
catch (Exception e)
{
throw;
}
return(response);
}
public List <Warehouse_Entity> getWarehouseOfClient(int id)
{
List <Warehouse_Entity> list = new List <Warehouse_Entity>();
try
{
sqlConnection.Open();
sqlCommand = new SqlCommand("return_warehouse", sqlConnection);
sqlCommand.CommandType = CommandType.StoredProcedure;
SqlParameter id_parameter = new SqlParameter();
id_parameter.ParameterName = "@idClientBusiness";
id_parameter.SqlDbType = SqlDbType.Int;
id_parameter.Value = id;
sqlCommand.Parameters.Add(id_parameter);
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
while (sqlDataReader.Read())
{
Warehouse_Entity warehouse = new Warehouse_Entity();
warehouse.idWarehouse = Convert.ToInt32(sqlDataReader["Identificador"]);
warehouse.name = sqlDataReader["Nombre"].ToString();
warehouse.description = sqlDataReader["Descripcion"].ToString();
warehouse.idInventory = Convert.ToInt32(sqlDataReader["Inventario"]);
warehouse.address = sqlDataReader["Direccion"].ToString();
list.Add(warehouse);
}
sqlConnection.Close();
}
catch (Exception e)
{
throw;
}
return(list);
}
public bool InsertWarehouse(Warehouse_Entity warehouse)
{
return(warehouse_Data.InsertWarehouse(warehouse));
}
