public DataTable TimTheoTen(SachDTO sDTO)
{
try
{
return sDAL.TimTheoTen(sDTO);
}
catch (SqlException ex)
{
throw ex;
}
}
public DataTable PhieuMuonSach_ThemSach_MaSach(SachDTO p)
{
try
{
return psDAL.PhieuMuonSach_ThemSach_MaSach(p);
}
catch (SqlException ex)
{
throw ex;
}
}
public DataTable LoadSach_ThemSach(SachDTO p)
{
try
{
return psDAL.LoadSach_ThemSach(p);
}
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 LoadDuLieuCotMaSach(SachDTO sDTO)
{
try
{
connect = new ConnectionData();
int Nparapater = 1;
string[] name = new string[Nparapater];
object[] value = new object[Nparapater];
name[0] = "@mas";
value[0] = sDTO.MaSach;
return connect.GetData("Sach_LoadDuLieuCotMaSach", name, value, Nparapater);
}
catch (SqlException ex)
{
throw ex;
}
}
public DataTable TimTheoTen(SachDTO sDTO)
{
try
{
connect = new ConnectionData();
int Nparamater = 1;
string[] name = new string[Nparamater];
object[] value = new object[Nparamater];
name[0] = "@search";
value[0] = sDTO.MaDS;
return connect.GetData("Sach_TimTheoTen", name, value, 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 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;
}
}
public int Xoa(SachDTO sDTO)
{
return sDAL.Sach_Xoa(sDTO);
}
public DataTable LoadDuLieuCotMaSach(SachDTO sDTO)
{
return sDAL.LoadDuLieuCotMaSach(sDTO);
}
public int nhapSach(SachDTO sDTO)
{
return sDAL.nhapSach(sDTO);
}
