/* Phương thức xóa tất cả sách của một đầu sách */ public static int DelAllBooks(DauSachDTO dauSach) { if (NotHaveBook(dauSach)) { return(SachDAO.DeletAllBooks(dauSach)); } return(-1); }
public IList GetList() { SachDAO sd = new SachDAO(); IList ds; ds = SachDAO.GetList(); return(ds); }
public DataTable GetTable() { SachDAO sd = new SachDAO(); DataTable dt = new DataTable(); dt = SachDAO.GetTable(); return(dt); }
public ActionResult Delete(string id) { SachDAO sachDAO = new SachDAO(); Sach sach = sachDAO.Details(id); ShoppingCart cart = (ShoppingCart)Session[shop]; cart.Remove(sach); return(Redirect(Request.UrlReferrer.ToString())); }
public PartialViewResult ListSach(int page = 1) { List <Sach> listSach = new List <Sach>(); ViewBag.currentPage = page; ViewBag.listSach = SachDAO.getListSach(page); ViewBag.numOfBook = SachDAO.getNumberOfBook(); return(PartialView()); }
// GET: Home public ActionResult Index(int?page) { SachDAO sach = new SachDAO(); var ListSach = sach.GetSachMoi(); int pageSize = 9; int pageNumber = (page ?? 1); return(View(ListSach.ToPagedList(pageNumber, pageSize))); }
public ActionResult Update(string id, int soluong) { SachDAO sachDAO = new SachDAO(); Sach sach = sachDAO.Details(id); ShoppingCart cart = (ShoppingCart)Session[shop]; cart.UpdateAmount(sach, soluong); Session[shop] = cart; return(Redirect(Request.UrlReferrer.ToString())); }
public ActionResult ChuDe(long idCD) { var cd = new ChuDeDAO(); Session["Title"] = cd.Find(idCD).Ten; var sach = new SachDAO(); Session["Products"] = sach.GetListCD(idCD); return(View("../DanhSachSanPham/Index")); }
// GET: Sach public ActionResult Index(string strSearch, int pagenumber = 1, int pagesize = 8) { SachDAO sachDAO = new SachDAO(); if (strSearch != null) { return(View(sachDAO.timKiemND(strSearch, pagenumber, pagesize))); } return(View(sachDAO.dsBan(pagenumber, pagesize))); }
// GET: Admin/QuanLySach public ActionResult Index(string strSearch, int pagenumber = 1, int pagesize = 5) { SachDAO sachDAO = new SachDAO(); if (strSearch != null) { return(View(sachDAO.timKiemNQT(strSearch, pagenumber, pagesize))); } return(View(sachDAO.listProduct(pagenumber, pagesize))); }
public static List <SachDTO> loadMostBuy() { var listID = SachDAO.loadIDMostBuy(); var result = new List <SachDTO>(); listID.ForEach(i => { result.Add(loadByID(i.ToString())); }); return(result); }
private void menuItemBanSach_Click(object sender, EventArgs e) { DisposeFormOpening(); List <Sach> sachGroup = SachDAO.LoadSach(); if (sachGroup.Count > 0) { arrForm[INDEX_FORM_BANSACH] = new FormBanSach(nv, sachGroup); OpenForm(INDEX_FORM_BANSACH); } }
public ActionResult ChiTietKhuyenMai(long id) { var km = new KhuyenMaiDAO(); Session["KM"] = km.Find(id); var sach = new SachDAO(); Session["Title"] = km.Find(id).TenKhuyenMai; Session["Products"] = sach.GetListKM(id); return(View("../DanhSachSanPham/Index")); }
public ActionResult Index(int page = 1, int pagesize = 8) { SachDAO sachDAO = new SachDAO(); TheLoaiDAO theLoaiDAO = new TheLoaiDAO(); ViewBag.sanphammoi = sachDAO.dsSanPhamTheoUuTien(3, page, pagesize).Take(4); ViewBag.loaisanpham = theLoaiDAO.dsTheLoai(); ViewBag.danhsachban = sachDAO.dsBan(page, pagesize); ViewBag.hethang = sachDAO.dsHetHang(page, pagesize); return(View()); }
/* Phương thức xóa đi một cuốn sách được đánh dấu mất trả về số dòng thực hiện được */ public static int DelBook(DauSachDTO dauSach) { List <SachDTO> saches = GetBooks(dauSach); int indexlost = FindLostBookLastIndex(saches); if (indexlost != -1) { return(SachDAO.DeletBook(saches[indexlost])); } return(0); }
public static bool XoaSach(SachDTO s) { if (SachDAO.SelectSachTheoMa(s.MaSach) != null) { SachDAO.Delete(s); return(true); } else { return(false); } }
public static bool ThemSach(SachDTO s) { if (SachDAO.SelectTLByName(s.TenSach) == null) { SachDAO.Insert(s); return(true); } else { return(false); } }
public static List <SachDTO> loadBySearch(string textToSearch, string MaLoai) { if (textToSearch == "") { return(loadByMaLoai(MaLoai)); } if (MaLoai == "0") { return(SachDAO.loadBySearch(textToSearch)); } return(SachDAO.loadBySearch(textToSearch, MaLoai)); }
public static bool CapNhatSach(SachDTO s) { if (SachDAO.SelectSachTheoMa(s.MaSach) != null) { SachDAO.Insert(s); return(true); } else { return(false); } }
public static bool updateSach(SachDTO newSach) { int chenhLech = newSach.SoLuong - SachDAO.loadByID(newSach.MaSach.ToString()).SoLuong; if (Global.ControlRules.LuongNhapToiThieu == 1) { if (chenhLech <= Global.quyDinh.LuongNhapToiThieu && chenhLech != 0) { return(false); } } return(SachDAO.updateSach(newSach)); }
public ActionResult CreateSach(Sach sach) { ViewBag.danhmuc = danhMucDAO.dsDanhMuc(); ViewBag.theloai = theLoaiDAO.dsTheLoai(); ViewBag.tacgia = tacGiaDAO.dsTacGia(); ViewBag.nxb = nXBDAO.dsNXB(); if (ModelState.IsValid) { SachDAO sachDAO = new SachDAO(); sachDAO.Create(sach); return(Redirect("Index")); } return(View("Create")); }
private void frmphieunhapsach_Load(object sender, EventArgs e) { this.Size = new Size(369, 511); colcmbsach.DataSource = SachDAO.SelectSachAll(); colcmbsach.ValueMember = "MaSach"; colcmbsach.DisplayMember = "TenSach"; colcbmtacgia.DataSource = SachDAO.SelectSachAll(); colcbmtacgia.ValueMember = "MaSach"; colcbmtacgia.DisplayMember = "TacGia"; HienThiDanhSach(); dtpick.Value = DateTime.Now; }
public ActionResult AddItem(string id, int soluong = 1) { SachDAO sachDAO = new SachDAO(); Sach sach = sachDAO.Details(id); ShoppingCart cart = (ShoppingCart)Session[shop]; if (cart == null) { cart = new ShoppingCart(); } cart.AddItem(sach, soluong); Session[shop] = cart; return(Redirect(Request.UrlReferrer.ToString())); }
// // GET: /Cart/ public ActionResult themgiohang(int maSach = 0, int soLuongMua = 0) { Cart cart = (Cart)Session["cart"]; Sach sach = SachDAO.getSachCanLay(maSach); if (cart.getCartItems().ContainsKey(maSach)) { cart.plusTocart(maSach, new Item(sach, cart.getCartItems()[maSach].getSoLuongBan()), soLuongMua); } else { cart.plusTocart(maSach, new Item(sach, soLuongMua), soLuongMua); } return(Redirect("~/Home/index")); }
private void UpdateSach(string maSach, string tenSach, string tenTacGia, string tenTheLoai, string tenNXB, string gia, string soLuong) { int maNXB = NXB_DAO.GetIdNXBByName(tenNXB); int maTheLoai = TheLoaiDAO.GetIdTheLoaiByName(tenTheLoai); int maTacGia = TacGiaDAO.GetIdTacGiaByName(tenTacGia); if (SachDAO.UpdateSach(maSach, tenSach, maNXB, maTacGia, maTheLoai, Convert.ToDouble(gia), Convert.ToInt32(soLuong))) { MessageBox.Show("Cập nhật thành công"); Dispose(); } else { MessageBox.Show("Cập nhật thất bại"); } }
public List <SachDAO> TimSachTheoDanhMuc(SachDAO timsachdm) { List <SachDAO> dsSachh = new List <SachDAO>(); OpenConnection(); string cmd = "SELECT s.Id, s.TenSach, s.NamXuatBan, dm.TenDanhMuc, s.TacGia, s.NgonNgu, s.NoiDungSach,s.TrangThai,s.SoLuong FROM Sach s " + "INNER JOIN DanhMuc dm ON s.DanhMucID = dm.IdDanhMuc Where dm.TenDanhMuc =N'" + timsachdm.TheLoai + "'"; SqlCommand command = new SqlCommand(); command.CommandType = CommandType.Text; command.CommandText = cmd; command.Connection = conn; SqlDataReader reader = command.ExecuteReader(); //Console.WriteLine("Inside " + cmd); while (reader.Read()) { //Console.WriteLine("In loop"); int masach = reader.GetInt32(0); string tensach = reader.GetString(1); int namxuatban = reader.GetInt32(2); string theloai = reader.GetString(3); string tacgia = reader.GetString(4); string ngonngu = reader.GetString(5); string noidung = reader.GetString(6); string trangthai = reader.GetString(7); int soluong = reader.GetInt32(8); SachDAO sc = new SachDAO(); sc.ID = masach; sc.TenSach = tensach; sc.NamXuatBan = namxuatban; sc.TheLoai = theloai; sc.TacGia = tacgia; sc.NgonNgu = ngonngu; sc.NoiDungSach = noidung; sc.SoLuong = soluong; sc.TrangThai = trangthai; dsSachh.Add(sc); } reader.Close(); return(dsSachh); }
// kiem tra so luong ton int KiemTraSLTon() { Sach sach = new Sach("", txtSach.Text, txtTacgia.Text, txtTheloai.Text, int.Parse(txtGia.Text), int.Parse(txtSl.Text)); SachDAO objSach = new SachDAO(); if (objSach.KiemTraSach(sach) == false) { string masach = objSach.GetMaSach(txtSach.Text, txtTacgia.Text).Rows[0]["masach"].ToString(); int soluongton = int.Parse(objSach.GetSach(masach).Rows[0]["soluong"].ToString()); if (soluongton > ThietLap.SLTonMin) { MessageBox.Show("số lượng tồn quá " + ThietLap.SLTonMin.ToString()); return(0); } } return(1); }
public static bool CheckUpdateSoLuong(string id, string soLuong) { int luongTon = SachDAO.loadByID(id).SoLuong - int.Parse(soLuong); if (luongTon < 0) { return(false); } if (Global.ControlRules.LuongTonSauKhiBan == 1) { if (luongTon < Global.quyDinh.LuongTonSauKhiBan) { return(false); } } return(true); }
private void btnCMTCTimTenS_Click(object sender, EventArgs e) { SachDAO sac = new SachDAO(); sac.TenSach = txtCMTCTimTenS.Text; SachBLL sacbll = new SachBLL(); List <SachDAO> dssachtim = sacbll.TimSachTrongTheoTen(sac); lvCMTCDSSach.Items.Clear(); foreach (SachDAO sachtim in dssachtim) { ListViewItem lvi = new ListViewItem(sachtim.ID + ""); lvi.SubItems.Add(sachtim.TenSach); lvCMTCDSSach.Items.Add(lvi); } }
public List <SachDAO> TimSachTrongTheoTen(SachDAO timsach) { List <SachDAO> dsSach = new List <SachDAO>(); OpenConnection(); string cmd = "exec TimSachTrongTheoTen @ten=N'" + timsach.TenSach + "'"; SqlCommand command = new SqlCommand(); command.CommandType = CommandType.Text; command.CommandText = cmd; command.Connection = conn; SqlDataReader reader = command.ExecuteReader(); //Console.WriteLine("Inside " + cmd); while (reader.Read()) { //Console.WriteLine("In loop"); int masach = reader.GetInt32(0); string tensach = reader.GetString(1); int namxuatban = reader.GetInt32(2); string theloai = reader.GetString(3); string tacgia = reader.GetString(4); string ngonngu = reader.GetString(5); string noidung = reader.GetString(6); int soluong = reader.GetInt32(7); string trangthai = reader.GetString(8); SachDAO sc = new SachDAO(); sc.ID = masach; sc.TenSach = tensach; sc.NamXuatBan = namxuatban; sc.TheLoai = theloai; sc.TacGia = tacgia; sc.NgonNgu = ngonngu; sc.NoiDungSach = noidung; sc.SoLuong = soluong; sc.TrangThai = trangthai; dsSach.Add(sc); } reader.Close(); return(dsSach); }