public static BEL_HoaDonMuon GetObjectById(string Id) { try { GetConnection(); string Query = string.Format("select* from HOADONMUON where MaHoaDon = '{0}'", Id); SqlCommand Command = new SqlCommand(Query, Connection); SqlDataReader DataReader = Command.ExecuteReader(); DataReader.Read(); string MaHoaDon = (string)DataReader["MaHoaDon"]; string MaNhanVien = (string)DataReader["MaNhanVien"]; string MaDocGia = (string)DataReader["MaDocGia"]; DateTime NgayLap = (DateTime)DataReader["NgayLap"]; DateTime NgayTra = (DateTime)DataReader["NgayTra"]; bool DaTra = (bool)DataReader["DaTra"]; string TrangThai = (string)DataReader["TrangThai"]; BEL_HoaDonMuon HoaDonMuon = new BEL_HoaDonMuon(MaHoaDon, MaNhanVien, MaDocGia, NgayLap, NgayTra, DaTra, TrangThai); return(HoaDonMuon); } catch (Exception Err) { throw; } finally { Connection.Close(); } }
public static bool Update(BEL_HoaDonMuon HoaDonMuon) { try { GetConnection(); string Query = string.Format("update HOADONMUON set MaNhanVien = '{0}', MaDocGia = '{1}', NgayLap = '{2}', NgayTra = '{3}', DaTra = {4}, where MaLoai = '{5}'", HoaDonMuon.MaNhanVien, HoaDonMuon.MaHoaDon, HoaDonMuon.MaDocGia, HoaDonMuon.NgayLap.ToString("MM-dd-yyyy"), HoaDonMuon.NgayTra.ToString("MM-dd-yyyy"), HoaDonMuon.DaTra, HoaDonMuon.MaHoaDon); SqlCommand Command = new SqlCommand(Query, Connection); int Result = Command.ExecuteNonQuery(); return(Result == 1); } catch (Exception Err) { throw; } finally { Connection.Close(); } }
public static bool Add(BEL_HoaDonMuon HoaDonMuon) { try { GetConnection(); string Query = string.Format("insert into HOADONMUON(MaHoaDon, MaNhanVien, MaDocGia, NgayLap, NgayTra, DaTra, TrangThai) values('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', N'{7}')", HoaDonMuon.MaHoaDon, HoaDonMuon.MaNhanVien, HoaDonMuon.MaDocGia, HoaDonMuon.NgayLap.ToString("MM-dd-yyyy"), HoaDonMuon.NgayTra.ToString("MM-dd-yyyy"), false, HoaDonMuon.TrangThai); SqlCommand Command = new SqlCommand(Query, Connection); int Result = Command.ExecuteNonQuery(); return(Result == 1); } catch (Exception Err) { throw; } finally { Connection.Close(); } }