public bool ThemSach(SachDTO s) { if (sDAO.SelectTLByName(s.TenSach) == null) { sDAO.Insert(s); return(true); } else { return(false); } }
public static bool CapNhatSach(SachDTO s) { if (SachDAO.SelectSachTheoMa(s.MaSach) != null) { SachDAO.Insert(s); return(true); } else { return(false); } }
private void btnimport_Click(object sender, EventArgs e) { string oldPath = Directory.GetCurrentDirectory(); OpenFileDialog of = new OpenFileDialog(); of.ShowDialog(); string strPathName = of.FileName; Directory.SetCurrentDirectory(oldPath); DataTable dt = ExcelRead.getSheet(strPathName, "sheet1"); for (int i = 0; i < dt.Rows.Count; i++) { SachDTO s = new SachDTO(); s.TenSach = dt.Rows[i].ItemArray[1].ToString(); s.GiaBan = int.Parse(dt.Rows[i].ItemArray[2].ToString()); s.SoLuongTon = int.Parse(dt.Rows[i].ItemArray[3].ToString()); s.TacGia = dt.Rows[i].ItemArray[4].ToString(); s.MaTheLoai = int.Parse(dt.Rows[i].ItemArray[5].ToString()); SachDAO.Insert(s); } MessageBox.Show("Import dữ liệu thành công ...", "Thông báo"); HienThiDanhSach(); }
public int Insert(Sach obj) { return(dao.Insert(obj)); }
public void Insert(SachDTO sach) { SachDAO sd = new SachDAO(); sd.Insert(sach); }
public void Insert(Sach info) { data.Insert(info); }
public static bool Insert(Sach a) { return(SachDAO.Insert(a) == 1?true:false); }