void ganDL(MuonSachDT dt) { dt.Sophieumuon = txtSoPhieuMuon.Text.Trim(); dt.Mathe = txtMaThe.Text.Trim(); dt.Manv = txtMaNV.Text.Trim(); dt.Ngaymuon = dateTra.Text.Trim(); }
//SỬA dl public bool UpdateData(MuonSachDT dt) { cmd.CommandText = "UPDATE muonsach SET MaNV = '" + dt.Manv + "',MaThe='" + dt.Mathe + "', NgayMuon = CONVERT(DATE, '" + dt.Ngaymuon + "',103) WHERE SoPhieuMuon ='" + dt.Sophieumuon + "'"; 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); }
//thêm mới dl public bool AddData(MuonSachDT dt) { cmd.CommandText = "INSERT INTO muonsach VALUES ( '" + dt.Sophieumuon + "','" + dt.Mathe + "', '" + dt.Manv + "',CONVERT(DATE, '" + dt.Ngaymuon + "',103))"; 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 UpdateData(MuonSachDT dt) { return(MH.UpdateData(dt)); }
public bool AddData(MuonSachDT dt) { return(MH.AddData(dt)); }