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