public bool insertTacGia(TacGia tacGia)
{
String sql = @"INSERT INTO [dbo].[TacGia]
([HoTenTG]
,[DiaChiTG]
,[DienThoaiTG])
VALUES
(N'"+tacGia.HoTenTG+ @"'
,N'" + tacGia.DiaChiTG + @"'
,N'" + tacGia.DienThoaiTG + @"')";
return dbcnn.ThucThiSQL(sql);
}
public TacGia getTacGiaById(int id)
{
String sql = @"SELECT [MaTacGia]
,[TenTacGia]
,[DiaChiTacGia]
,[DienThoaiTacGia]
,[Website]
FROM [dbo].[TacGia] WHERE [MaTacGia]=" + id;
DataTable table = dbcnn.getdata(sql);
TacGia newTacGia = new TacGia();
if (table.Rows.Count == 1)
{
newTacGia.MaTG = (int)table.Rows[0]["MaTG"];
newTacGia.HoTenTG = (string)table.Rows[0]["HoTenTG"];
newTacGia.DiaChiTG = (string)table.Rows[0]["DiaChiTG"];
newTacGia.DienThoaiTG = (string)table.Rows[0]["DienThoaiTG"];
}
return newTacGia;
}
public void Insert(TacGia info)
{
cnn = helper.GetConnect();
sqlString = "Insert into TacGia(id, Ten, DiaChi, DienThoai, Email, GhiChu ) values ('" + info.Id + "',N'" + info.Ten + "',N'" + info.DiaChi + "','" + info.DienThoai + "','" + info.Email + "',N'" + info.GhiChu + "')";
try
{
//Thực thi câu lệnh SQL
cmd = new SqlCommand(sqlString, cnn);
cmd.ExecuteNonQuery();
}
catch (System.Exception e)
{
cnn.Close();
throw new Exception("Lỗi Kết Nối Cơ sở dữ liệu.");
}
cnn.Close();
}
public List<TacGia> getListTacGia()
{
String sql = @"SELECT [MaTG]
,[HoTenTG]
,[DiaChiTG]
,[DienThoaiTG]
FROM [dbo].[TacGia]";
DataTable table = dbcnn.getdata(sql);
List<TacGia> listTG = new List<TacGia>();
foreach (DataRow row in table.Rows)
{
TacGia newTacGia = new TacGia();
newTacGia.MaTG = (int)row["MaTG"];
newTacGia.HoTenTG = (String)row["HoTenTG"];
newTacGia.DiaChiTG = (String)row["DiaChiTG"];
newTacGia.DienThoaiTG = (string)row["DienThoaiTG"];
listTG.Add(newTacGia);
}
return listTG;
}
public int isValid()
{
if (TenSach.Equals(""))
{
return(1);
}
if (TacGia.Equals(""))
{
return(2);
}
if (SoLuong <= 0)
{
return(3);
}
if (TheLoai.Equals(""))
{
return(4);
}
if (TomTat.Equals(""))
{
return(5);
}
return(0);
}
public void Update(TacGia info)
{
sqlString = "UPDATE TACGIA SET Ten=N'" + info.Ten +
"',DiaChi=N'" + info.DiaChi +
"',DienThoai='" + info.DienThoai +
"',Email='" + info.Email +
"',GhiChu=N'" + info.GhiChu +
"' WHERE id='" + info.Id + "'";
cnn = helper.GetConnect();
try
{
//Thực thi câu lệnh SQL
cmd = new SqlCommand(sqlString, cnn);
cmd.ExecuteNonQuery();
}
catch (System.Exception e)
{
cnn.Close();
throw new Exception("Lỗi Kết Nối Cơ sở dữ liệu.");
}
cnn.Close();
}
public bool xoatacGia(TacGia tacGia)
{
return tacGiaDAL.deleteTacGia(tacGia);
}
public bool themtacGia(TacGia tacGia)
{
return tacGiaDAL.insertTacGia(tacGia);
}
public bool suatacGia(TacGia tacGia)
{
return tacGiaDAL.updateTacGia(tacGia);
}
public Sach()
{
nxb = new NXB();
tacGia = new TacGia();
theLoai = new TheLoai();
}
public void Update(TacGia info)
{
tgD.Update(info);
}
public void Insert(TacGia info)
{
tgD.Insert(info);
}
public bool updateTacGia(TacGia tacGia)
{
String sql = @"UPDATE [dbo].[TacGia]
SET [HoTenTG] = N'" + tacGia.HoTenTG + @"'
,[DiaChiTG] = N'" + tacGia.DiaChiTG + @"'
,[DienThoaiTG] = N'" + tacGia.DienThoaiTG + @"'
WHERE [MaTG]=" + tacGia.MaTG;
return dbcnn.ThucThiSQL(sql);
}
public bool deleteTacGia(TacGia tacGia)
{
String sql = @"DELETE FROM [dbo].[TacGia]
WHERE [MaTG]=" + tacGia.MaTG;
return dbcnn.ThucThiSQL(sql);
}
