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