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