public int nhapNXB(NXBDTO nxbDTO) { try { connect = new ConnectionData(); int Nparamater = 5; string[] name = new string[Nparamater]; object[] value = new object[Nparamater]; name[0] = "@manxb"; value[0] = nxbDTO.MaNXB; name[1] = "@tennxb"; value[1] = nxbDTO.TenNXB; name[2] = "@diachi"; value[2] = nxbDTO.DiaChi; name[3] = "@email"; value[3] = nxbDTO.Email; name[4] = "@sdt"; value[4] = nxbDTO.Sdt; return connect.UpdateData("NXB_InsertUpdate", name, value, Nparamater); } catch (SqlException ex) { throw ex; } }
public int LoaiDocGia_Xoa(LoaiDGDTO dgDTO) { try { connect = new ConnectionData(); int Nparamater = 1; string[] name=new string[Nparamater]; object[] values=new object[Nparamater]; name[0] = "@MaLDG"; values[0] = dgDTO.MaLDG; return connect.UpdateData("LoaiDocGia_Xoa",name,values,Nparamater); }catch(SqlException ex){ throw ex; } }
// Xóa độc giả public int XoaDG_MaDG(DocGiaDTO dgDTO) { try { connect = new ConnectionData(); int Nparamater = 1; string[] name = new string[Nparamater]; object[] values = new object[Nparamater]; name[0] = "@MaDG"; values[0] = dgDTO.MaDG; return connect.UpdateData("Delete_DocGia_ByMaDG", name, values, Nparamater); } catch (SqlException ex) { throw ex; } }
public int Sach_Xoa(SachDTO sDTO) { try { connect = new ConnectionData(); int Nparamater = 1; string[] name = new string[Nparamater]; object[] value = new object[Nparamater]; name[0] = "@mas"; value[0] = sDTO.MaSach; return connect.UpdateData("Sach_Xoa", name, value, Nparamater); } catch (SqlException ex) { throw ex; } }
public int nhapCTP(PhieuSachDTO p,CTPhieuDTO c) { try { connect = new ConnectionData(); int Nparamater = 2; string[] name = new string[Nparamater]; object[] value = new object[Nparamater]; name[0] = "@MaDG"; value[0] = p.MaDG; name[1] = "@MaSach"; value[1] = c.MaSach; return connect.UpdateData("CTPhieu_Insert", name, value, Nparamater); } catch (Exception) { throw; } }
public int nhapLDG(LoaiDGDTO ldgDTO) { try { connect = new ConnectionData(); int Nparamater = 2; string[] name = new string[Nparamater]; object[] value = new object[Nparamater]; name[0] = "@maldg"; value[0] = ldgDTO.MaLDG; name[1] = "@tenldg"; value[1] = ldgDTO.TenLDG; return connect.UpdateData("loaiDocGia_InsertUpdate", name, value, Nparamater); } catch (SqlException ex) { throw ex; } }
public int nhapTacGia(TacGiaDTO tgDTO) { try { connect = new ConnectionData(); int Nparamater = 2; string[] name = new string[Nparamater]; object[] value = new object[Nparamater]; name[0] = "@matg"; value[0] = tgDTO.MaTG; name[1] = "@tentg"; value[1] = tgDTO.TenTG; return connect.UpdateData("TacGia_InsertUpdate", name, value, Nparamater); } catch (SqlException ex) { throw ex; } }
public int nhapSach(SachDTO sDTO) { try { connect = new ConnectionData(); int Nparamater = 3; string[] name = new string[Nparamater]; object[] value = new object[Nparamater]; name[0] = "@mas"; value[0] = sDTO.MaSach; name[1] = "@mads"; value[1] = sDTO.MaDS; name[2] = "@tt"; value[2] = sDTO.TinhTrang; return connect.UpdateData("Sach_InsertUpdate", name, value, Nparamater); } catch (SqlException ex) { throw ex; } }
// Thêm độc giả public int InsertDG(DocGiaDTO dgDTO) { connect = new ConnectionData(); try { //var binding = BindingObject(dgDTO); // return connect.UpdateData("sp_DocGia_Insert", binding.Names, binding.Values, binding.Names.Length); int Nparamater = 9; String[] name = new string[Nparamater]; object[] values = new object[Nparamater]; name[0] = "@MaDG"; values[0] = dgDTO.MaDG; name[1] = "@HoVaTen"; values[1] = dgDTO.HoVaTen; name[2] = "@GioiTinh"; values[2] = dgDTO.GioiTinh; name[3] = "@NgaySinh"; values[3] = dgDTO.NgaySinh; name[4] = "@DiaChi"; values[4] = dgDTO.DiaChi; name[5] = "@Email"; values[5] = dgDTO.Email; name[6] = "@MaLDG"; values[6] = dgDTO.MaLDG; name[7] = "@NgayLap"; values[7] = dgDTO.NgayLap; name[8] = "@NgayHetHan"; values[8] = dgDTO.NgayHetHan; return connect.UpdateData("sp_DocGia_Insert", name, values, Nparamater); } catch (SqlException ex) { throw ex; } }
public int NhanTraSach(PhieuSachDTO p) { try { connect = new ConnectionData(); int Nparamater = 5; string[] name = new string[Nparamater]; object[] value = new object[Nparamater]; name[0] = "@MaPhieu"; value[0] = p.MaPhieu; name[1] = "@NgayTra"; value[1] = p.NgayTra; name[2] = "@SoNgayMuon"; value[2] = p.SoNgayMuon; name[3] = "@TienPhatKyNay"; value[3] = p.TienPhatKyNay; name[4] = "@SoTienThu"; value[4] = p.SoTienThu; return connect.UpdateData("PHIEUSACH_UPDATE", name, value, Nparamater); } catch (SqlException ex) { throw ex; } }
public int ChoMuonSach(PhieuSachDTO p) { try { connect = new ConnectionData(); int Nparamater = 1; string[] name = new string[Nparamater]; object[] value = new object[Nparamater]; name[0] = "@MaDG"; value[0] = p.MaDG; return connect.UpdateData("PHIEUSACH_Insert", name, value, Nparamater); } catch (SqlException ex) { throw ex; } }
public int Xoa(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.UpdateData("NXB_Xoa", name, value, Nparamater); } catch (SqlException ex) { throw ex; } }
public int nhapTheLoai(TheLoaiDTO tlDTO) { try { connect = new ConnectionData(); int Nparamater = 2; string[] name = new string[Nparamater]; object[] value = new object[Nparamater]; name[0] = "@matl"; value[0] = tlDTO.MaTL; name[1] = "@tentl"; value[1] = tlDTO.TenTL; return connect.UpdateData("TheLoai_InsertUpdate", name, value, Nparamater); } catch (SqlException ex) { throw ex; } }
public int TheLoai_Xoa(TheLoaiDTO tlDTO) { try { connect = new ConnectionData(); int Nparamater = 1; string[] name = new string[Nparamater]; object[] values = new object[Nparamater]; name[0] = "@MaTL"; values[0] = tlDTO.MaTL; return connect.UpdateData("TheLoai_Xoa", name, values, Nparamater); } catch (SqlException ex) { throw ex; } }
public int nhap(DauSachDTO dsDTO) { try { connect = new ConnectionData(); int Nparamater = 8; string[] name = new string[Nparamater]; object[] value = new object[Nparamater]; name[0] = "@mads"; value[0] = dsDTO.MaDS; name[1] = "@tends"; value[1] = dsDTO.TenDS; name[2] = "@matl"; value[2] = dsDTO.MaTL; name[3] = "@matg"; value[3] = dsDTO.MaTG; name[4] = "@manxb"; value[4] = dsDTO.MaNXB; name[5] = "@namxb"; value[5] = dsDTO.NamXB; name[6] = "@trigia"; value[6] = dsDTO.TriGia; name[7] = "@trangthai"; value[7] = dsDTO.TrangThai; return connect.UpdateData("DauSach_InsertUpdate", name, value, Nparamater); } catch (SqlException ex) { throw ex; } }