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