public IActionResult WareHouseUpdate(warehouseModel myModel)
{
if (ModelState.IsValid)
{
string connectionString = Configuration["ConnectionStrings:DefaultConnection"];
using (SqlConnection connection = new SqlConnection(connectionString))
{
using (SqlCommand command = new SqlCommand("CapNhatSoLuong", connection))
{
command.CommandType = System.Data.CommandType.StoredProcedure;
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
connection.Open();
command.Parameters.AddWithValue("@Masp", myModel.MaSp);
command.Parameters.AddWithValue("@SoLuong", myModel.soluong);
command.ExecuteNonQuery();
}
}
return(RedirectToAction("DetailProduct", "Product", new { id = Convert.ToInt32(myModel.MaSp) }));
}
return(View(myModel));
}
private warehouseModel GetInfoWareHouse(int ID)
{
warehouseModel sl = new warehouseModel();
if (ModelState.IsValid)
{
string connectionString = Configuration["ConnectionStrings:DefaultConnection"];
using (SqlConnection connection = new SqlConnection(connectionString))
{
using (SqlCommand command = new SqlCommand("LaySoLuongSP", connection))
{
command.CommandType = System.Data.CommandType.StoredProcedure;
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
connection.Open();
command.Parameters.AddWithValue("@Masp", ID);
SqlDataAdapter da = new SqlDataAdapter(command);
DataSet ds = new DataSet();
da.Fill(ds);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
sl.MaSp = Convert.ToInt32(ds.Tables[0].Rows[i]["MaSp"]);
sl.TenSP = ds.Tables[0].Rows[i]["tenSP"].ToString();
sl.soluong = Convert.ToInt32(ds.Tables[0].Rows[i]["SoLuong"]);
}
}
}
}
return(sl);
}
public IActionResult WareHouse(int ID)
{
warehouseModel myModel = new warehouseModel();
myModel = GetInfoWareHouse(ID);
return(View(myModel));
}
public ActionResult insertLog(int itemID, int totalnumber, int reasonID)
{
String description = _reasonRepository.getDescription(reasonID);
String itemName = _itemRepository.GetItemName(itemID);
log newlog = _logRepository.insertLog(itemID, totalnumber, description);
warehouse newwarehouse = _warehouseRepository.UpdateWarehouse(itemID, totalnumber, description);
logModel.logString lm = logModel.ToLogString(newlog, itemName);
warehouseModel wm = warehouseModel.ToWarehouseModel(newwarehouse, itemName);
return(Json(new
{
lm
}));
}
