public async Task <IActionResult> Edit(string id, [Bind("Id_SP,Loai_SP_1,Loai_SP_2,Name_SP,Price_SP,Mo_Ta")] San_Pham san_Pham)
{
if (id != san_Pham.Id_SP)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(san_Pham);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!San_PhamExists(san_Pham.Id_SP))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(san_Pham));
}
void ganDL(San_Pham spObj)
{
spObj.Id_sp = txt_idsp.Text.Trim();
spObj.Ten_sp = txt_tensp.Text.Trim();
spObj.Dongia = txt_dongia.Text.Trim();
spObj.Ngaynhap = dt_ngaynhap.Text.Trim();
spObj.Loai_sp = txt_loaisp.Text.Trim();
spObj.Soluong = txt_soluong.Text.Trim();
spObj.Ct_sp = "";
}
public async Task <IActionResult> Create([Bind("Id_SP,Loai_SP_1,Loai_SP_2,Name_SP,Price_SP,Mo_Ta,ngay_add,Sale")] San_Pham san_Pham)
{
if (ModelState.IsValid)
{
_context.Add(san_Pham);
await _context.SaveChangesAsync();
return(RedirectToAction("product", "Product", new { id = san_Pham.Id_SP }));
}
return(View(san_Pham));
}
public bool UpData(San_Pham spObj)
{
cmd.CommandText = "update SAN_PHAM set TEN_SP = '" + spObj.Ten_sp + "',SO_LUONG = " + spObj.Soluong + ",DON_GIA='" + spObj.Dongia + "',NGAY_NHAP=CONVERT(datetime, '" + spObj.Ngaynhap + "', 103)" + " where ID_SP='" + spObj.Id_sp + "'";
cmd.CommandType = CommandType.Text;
cmd.Connection = conn.Connection;
try
{
conn.OpenConn();
cmd.ExecuteNonQuery();
conn.CloseConn();
return(true);
}
catch (Exception ex)
{
String mex = ex.Message;
cmd.Dispose();
conn.CloseConn();
}
return(false);
}
public bool AddData(San_Pham spObj)
{
//cmd.CommandText = "Insert into tb_NhanVien values ('" + nvObj.MaNV + "',N'" + nvObj.Ten + "',N'" + nvObj.Gioitinh + "',CONVERT(DATE,'" + nvObj.Ngaysinh + "',103),N'" + nvObj.Diachi + "','" + nvObj.Sdt + "')";
cmd.CommandText = "insert into SAN_PHAM values('" + spObj.Id_sp + "','" + spObj.Ten_sp + "', CONVERT(datetime, '" + spObj.Ngaynhap + "', 103),'" + spObj.Dongia + "','" + spObj.Soluong + "',N'" + spObj.Ct_sp + "','" + spObj.Loai_sp + "')";
cmd.CommandType = CommandType.Text;
cmd.Connection = conn.Connection;
try
{
conn.OpenConn();
cmd.ExecuteNonQuery();
conn.CloseConn();
return(true);
}
catch (Exception ex)
{
String mex = ex.Message;
cmd.Dispose();
conn.CloseConn();
}
return(false);
}
public bool UpdData(San_Pham spObj)
{
return(spMod.UpData(spObj));
}
public bool AddData(San_Pham spObj)
{
return(spMod.AddData(spObj));
}
