public IActionResult Delete(ProEdit proEdit)
{
if (ModelState.IsValid)
{
string connectionString = Configuration["ConnectionStrings:DefaultConnection"];
using (SqlConnection connection = new SqlConnection(connectionString))
{
using (SqlCommand command = new SqlCommand("XoaSP", connection))
{
command.CommandType = System.Data.CommandType.StoredProcedure;
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
connection.Open();
command.Parameters.AddWithValue("@MaSP", proEdit.MaSP);
command.ExecuteNonQuery();
}
}
return(RedirectToAction("Index", "Product"));
}
else
{
return(View());
}
}
private ProEdit GetProduct(int ID)
{
ProEdit pro = new ProEdit();
string connectionString = Configuration["ConnectionStrings:DefaultConnection"];
using (SqlConnection connection = new SqlConnection(connectionString))
{
using (SqlCommand command = new SqlCommand("LaySanPham", connection))
{
command.CommandType = System.Data.CommandType.StoredProcedure;
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
command.Parameters.AddWithValue("@ID", ID);
SqlDataAdapter da = new SqlDataAdapter(command);
DataSet ds = new DataSet();
da.Fill(ds);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
pro.MaSP = Convert.ToInt32(ds.Tables[0].Rows[i]["MaSp"]);
pro.productName = ds.Tables[0].Rows[i]["tenSP"].ToString();
pro.productType = Convert.ToInt32(ds.Tables[0].Rows[i]["MaLoai"]);
pro.Color = ds.Tables[0].Rows[i]["mausac"].ToString();
pro.Description = ds.Tables[0].Rows[i]["Mota"].ToString();
pro.Image = ds.Tables[0].Rows[i]["Hinhanh"].ToString();
pro.Discount = Convert.ToInt32(ds.Tables[0].Rows[i]["Giamgia"]);
pro.Price = Convert.ToDouble(ds.Tables[0].Rows[i]["Gia"]);
pro.Stock = ds.Tables[0].Rows[i]["TrangThai"].ToString();
pro.LastModify = ds.Tables[0].Rows[i]["LastModify"].ToString();
}
}
}
return(pro);
}
public async Task <IActionResult> Edit(ProEdit proEdit, IFormFile pic)
{
ViewProductModel myModel = new ViewProductModel();
myModel.proEdit = proEdit;
myModel.CateList = GetCategory();
if (ModelState.IsValid)
{
if (pic != null)
{
var file = pic;
var uploads = Path.Combine(_appEnvironment.WebRootPath, "Images");
var fileName = Guid.NewGuid().ToString().Replace("-", "") + Path.GetExtension(file.FileName);
using (var fileStream = new FileStream(Path.Combine(uploads, fileName), FileMode.Create))
{
await file.CopyToAsync(fileStream);
string filePath = "Images\\" + fileName;
proEdit.Image = filePath;
}
string connectionString = Configuration["ConnectionStrings:DefaultConnection"];
using (SqlConnection connection = new SqlConnection(connectionString))
{
using (SqlCommand command = new SqlCommand("CapNhatSP", connection))
{
command.CommandType = System.Data.CommandType.StoredProcedure;
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
connection.Open();
command.Parameters.AddWithValue("@MaSP", proEdit.MaSP);
command.Parameters.AddWithValue("@TenSP", proEdit.productName);
command.Parameters.AddWithValue("@MoTa", proEdit.Description);
command.Parameters.AddWithValue("@MaLoai", proEdit.productType);
command.Parameters.AddWithValue("@TrangThai", proEdit.Stock);
command.Parameters.AddWithValue("@Gia", proEdit.Price);
command.Parameters.AddWithValue("@MauSac", proEdit.Color);
command.Parameters.AddWithValue("@hinhanh", proEdit.Image);
command.Parameters.AddWithValue("@Modify", DateTime.Now);
command.ExecuteNonQuery();
}
}
return(RedirectToAction("DetailProduct", "Product", new { id = Convert.ToInt32(proEdit.MaSP) }));
}
else
{
string connectionString = Configuration["ConnectionStrings:DefaultConnection"];
using (SqlConnection connection = new SqlConnection(connectionString))
{
using (SqlCommand command = new SqlCommand("CapNhatSP", connection))
{
command.CommandType = System.Data.CommandType.StoredProcedure;
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
connection.Open();
int MaLoai = Convert.ToInt32(proEdit.productType);
double Gia = Convert.ToDouble(proEdit.Price);
command.Parameters.AddWithValue("@MaSP", proEdit.MaSP);
command.Parameters.AddWithValue("@TenSP", proEdit.productName);
command.Parameters.AddWithValue("@MoTa", proEdit.Description);
command.Parameters.AddWithValue("@MaLoai", proEdit.productType);
command.Parameters.AddWithValue("@TrangThai", proEdit.Stock);
command.Parameters.AddWithValue("@Gia", proEdit.Price);
command.Parameters.AddWithValue("@MauSac", proEdit.Color);
command.Parameters.AddWithValue("@hinhanh", proEdit.Image);
command.Parameters.AddWithValue("@Modify", DateTime.Now);
command.ExecuteNonQuery();
}
}
return(RedirectToAction("DetailProduct", "Product", new { id = Convert.ToInt32(proEdit.MaSP) }));
}
}
return(RedirectToAction("EditProduct", "Product", new { id = Convert.ToInt32(proEdit.MaSP) }));
}
