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