public int GetTuoiNhoNhat() { try { connect = new ConnectionData(); DataTable dt= connect.GetData("GETTUOINHONHAT"); return int.Parse(dt.Rows[0][0].ToString()); }catch(SqlException ex){ throw ex; } }
public DataTable LoadTenLoaiDG() { try { connect = new ConnectionData(); return connect.GetData("LoadTenLoaiDG"); } catch(SqlException ex) { throw ex; } }
public DataTable TheLoai_GetByLast() { try { connect = new ConnectionData(); return connect.GetData("TheLoai_GetByLast"); } catch (SqlException ex) { throw ex; } }
public DataTable Load() { try { connect = new ConnectionData(); return connect.GetData("NXB_Load"); } catch (SqlException ex) { throw ex; } }
public DataTable QuyDinh_LoadDuLieu() { try { connect = new ConnectionData(); return connect.GetData("QuyDinh_LoadDuLieu"); } catch (SqlException ex) { throw ex; } }
public DataTable DauSach_LoadSach() { try { connect = new ConnectionData(); return connect.GetData("DAUSACH_LOAD"); } catch (SqlException ex) { throw ex; } }
public DataTable LoadTL_CoTenTL() { try { connect = new ConnectionData(); return connect.GetData("THELOAI_LoadDuLieuCoTenTL"); } catch (SqlException ex) { throw ex; } }
public DataTable TheLoai_LoadTheLoai() { try { connect = new ConnectionData(); return connect.GetData("TheLoai_LoadDuLieu"); } catch (SqlException ex) { throw ex; } }
public DataTable DauSach_TraCuu() { try { connect = new ConnectionData(); return connect.GetData("DauSach_TraCuu"); } catch (SqlException ex) { throw ex; } }
public DataTable LoaiDG_LoadDuLieu() { try { connect = new ConnectionData(); return connect.GetData("[LoaiDG_LoadDuLieu]"); } catch (SqlException ex) { throw ex; } }
public DataTable timDauSachDayDu(DauSachDTO dsDTO) { try { connect = new ConnectionData(); int Nparamater = 1; string[] name = new string[Nparamater]; object[] value = new object[Nparamater]; name[0] = "@search"; value[0] = dsDTO.TenDS; return connect.GetData("DauSach_TimDayDu", name, value, Nparamater); } catch (SqlException ex) { throw ex; } }
//Chưa dùng public DataTable DauSach_LoadMaDauSach(DauSachDTO p) { try { connect = new ConnectionData(); int Nparamater = 1; string[] name = new string[Nparamater]; object[] value = new object[Nparamater]; name[0] = "@tends"; value[0] = p.TenDS; return connect.GetData("DAUSACH_LOADMADAUSACH", name, value, Nparamater); } catch (SqlException ex) { throw ex; } }
public DataTable LoaiDG_LoadDuLieuCotMaLDG(LoaiDGDTO ldgDTO) { try { connect = new ConnectionData(); int Nparamater = 1; string[] name = new string[Nparamater]; object[] value = new object[Nparamater]; name[0] = "@maldg"; value[0] = ldgDTO.MaLDG; return connect.GetData("LoaiDocGia_LoadDuLieuCotMaLDG", name, value, Nparamater); } catch (SqlException ex) { throw ex; } }
public DataTable LoadMaTacGia(TacGiaDTO tgDTO) { try { connect = new ConnectionData(); int Nparamater = 1; string[] name = new string[Nparamater]; object[] value = new object[Nparamater]; name[0] = "@matg"; value[0] = tgDTO.MaTG; return connect.GetData("TacGia_LoadDuLieuCotMaTG", name, value, Nparamater); } catch (SqlException ex) { throw ex; } }
public DataTable TheLoai_LoadDuLieuCotMaTL(TheLoaiDTO tlDTO) { try { connect = new ConnectionData(); int Nparamater = 1; string[] name = new string[Nparamater]; object[] value = new object[Nparamater]; name[0] = "@matl"; value[0] = tlDTO.MaTL; return connect.GetData("TheLoai_LoadDuLieuCotMaTL", name, value, Nparamater); } catch(SqlException ex) { throw ex; } }
public DataTable timDauSachTheoTheLoai(DauSachDTO dsDTO) { try { connect = new ConnectionData(); int Nparamater = 1; string[] name = new string[Nparamater]; object[] value = new object[Nparamater]; name[0] = "@theloai"; value[0] = dsDTO.MaTL; return connect.GetData("DauSach_TimTheoTheLoai", name, value, Nparamater); } catch (SqlException ex) { throw ex; } }
public DataTable PhieuMuonSach_ThemSach_MaSach(SachDTO p) { try { connect = new ConnectionData(); int Nparamater = 1; string[] name = new string[Nparamater]; object[] value = new object[Nparamater]; name[0] = "@MaSach"; value[0] = p.MaSach; return connect.GetData("PHIEUSACH_PhieuMuonSach_ThemSach_MaSach", name, value, Nparamater); } catch (SqlException ex) { throw ex; } }
public DataTable LoadSach_TimSach(DauSachDTO p) { try { connect = new ConnectionData(); int Nparamater = 1; string[] name = new string[Nparamater]; object[] value = new object[Nparamater]; name[0] = "@MaDS"; value[0] = p.MaDS; return connect.GetData("PHIEUSACH_TIMSACH", name, value, Nparamater); } catch (SqlException ex) { throw ex; } }
public DataTable LoadDuLieuCotMaNXB(NXBDTO nxbDTO) { try { connect = new ConnectionData(); int Nparamater = 1; string[] name = new string[Nparamater]; object[] value = new object[Nparamater]; name[0] = "@manxb"; value[0] = nxbDTO.MaNXB; return connect.GetData("NXB_LoadDuLieuCotMaNXB", name, value, Nparamater); } catch (SqlException ex) { throw ex; } }
public DataTable TimTheoTen(NXBDTO nxbDTO) { try { connect = new ConnectionData(); int Nparamater = 1; string[] name = new string[Nparamater]; object[] value = new object[Nparamater]; name[0] = "@search"; value[0] = nxbDTO.TenNXB; return connect.GetData("NXB_TimTheoTen", name, value, Nparamater); } catch (SqlException ex) { throw ex; } }
public DataTable CheckDangNhap(DangNhapDTO p) { try { connect = new ConnectionData(); int Nparameter = 2; string[] name = new string[Nparameter]; object[] value = new object[Nparameter]; name[0] = "@TenDangNhap"; value[0] = p.TenDangNhap; name[1] = "@MatKhau"; value[1] = p.MatKhau; return connect.GetData("DANGNHAP_KiemTra", name, value, Nparameter); } catch (SqlException ex) { throw ex; } }
public DataTable TimDG_HoTen(DocGiaDTO dgDTO) { try { connect = new ConnectionData(); int Nparamater = 1; string[] name = new string[Nparamater]; object[] values = new object[Nparamater]; name[0] = "@HoVaTen"; values[0] = dgDTO.HoVaTen; return connect.GetData("FindDocGia_GetByHoTen", name, values, Nparamater); } catch (SqlException ex) { throw ex; } }
public DataTable QuanLyMuonTra_LoadPhieuSachDaTra() { try { connect = new ConnectionData(); return connect.GetData("PHIEUSACH_QuanLyMuonTra_LoadPhieuSachDaTra"); } catch (SqlException ex) { throw ex; } }
// Tim doc gia theo the loai public DataTable LoadDG_TimTheoLoaiDG(DocGiaDTO dgDTO) { try { connect = new ConnectionData(); int Nparamater = 1; string[] name=new string[Nparamater]; object[] values=new object[Nparamater]; name[0] = "@loaidocgia"; values[0] = dgDTO.MaLDG; return connect.GetData("DocGia_TimTheoLoaiDG",name,values,Nparamater); } catch(SqlException ex) { throw ex; } }
public DataTable LoadDuLieuCotMaDS(DauSachDTO dsDTO) { try { connect = new ConnectionData(); int Nparamater = 1; string[] name = new string[Nparamater]; object[] value = new object[Nparamater]; name[0] = "@mads"; value[0] = dsDTO.MaDS; return connect.GetData("DauSach_LoadDuLieuCotMaDS", name, value, Nparamater); } catch (SqlException ex) { throw ex; } }
// tim doc gia theo loai doc gia /*public DataTable TimDG_LoaiDG(DocGiaDTO dgDTO) { try { connect = new ConnectionData(); int Nparamater = 1; string[] name = new string[Nparamater]; object[] values = new object[Nparamater]; name[0] = "@loaidocgia"; values[0] = dgDTO.MaLDG; return connect.GetData("FindDocGia_GetByLoaiDG",name,values,Nparamater); }catch(SqlException ex){ throw ex; } }*/ // tim doc gia theo ten public DataTable DocGia_TimTheoTen(DocGiaDTO dgDTO) { try { connect = new ConnectionData(); int Nparamater = 1; string[] name = new string[Nparamater]; object[] value = new object[Nparamater]; name[0] = "@search"; value[0] = dgDTO.MaDG; return connect.GetData("DocGia_TimTheoTen", name, value, Nparamater); } catch (SqlException ex) { throw ex; } }