public async Task <ActionResult> CreateOrUpdate(string userId, string[] array, DateTime ngayTra)
        {
            var muontra  = new MuonTra();
            var autoList = AutoCompleteTextHoSos(_taiLieuVanBanService.Gets(p => p.TrangThai == true, p => p.OrderBy(x => x.Ten)).ToList());
            var users    = await _userService.GetAllAsync();

            var muonTras = new List <MuonTra>();
            var model    = Users(users, muonTras);

            muontra.UserId      = model.FirstOrDefault(m => m.UserName == userId).Id;
            muontra.VanThu      = User.Identity.GetUserName();
            muontra.NgayMuon    = DateTime.Now;
            muontra.NgayKetThuc = ngayTra;
            muontra.TinhTrang   = EnumTinhTrang.DangMuon;

            _muonTraService.Insert(muontra);

            for (int i = 0; i < array.Length; i++)
            {
                var chitietmuontra = new ChiTietMuonTra();
                var b = array[i];
                var a = autoList.FirstOrDefault(p => p.Text == b).Id;
                chitietmuontra.TaiLieuVanBanId = a;
                chitietmuontra.MuonTraID       = muontra.Id;
                _chiTietMuonTraService.Insert(chitietmuontra);
                var chiTietMuonTras = _chiTietMuonTraService.GetAll();
                muontra.SoLuong = chiTietMuonTras.Count(m => m.MuonTraID == muontra.Id);
                _muonTraService.Update(muontra);
                var vanBan = _taiLieuVanBanService.Get(m => m.Id == a);
                vanBan.TinhTrang = EnumTinhTrang.DangMuon;
                _taiLieuVanBanService.Update(vanBan);
            }
            TempData["AlertMessage"] = "Tạo Mới Thành Công";
            return(RedirectToAction("Index"));
        }
Пример #2
0
 public ActionResult Payment()
 {
     try
     {
         var cart = (Cart)Session[CartSession];
         foreach (var item in cart.Lines)
         {
             var obj = new MuonTra();
             obj.SachID       = item.sach.SachID;
             obj.soluong      = item.Quantity;
             obj.Ngaymuon     = DateTime.Now;
             obj.Ngaytra      = DateTime.Now.AddMonths(2);
             obj.ThethuvienID = new TaiKhoanFunction().GetId(CommonConstant.USERNAME.username);
             obj.Datra        = false;
             var id = new MuontraFunction().Insert(obj);
         }
         Session["CartSession"] = null;
     }
     catch (Exception ex)
     {
         //ghi log
         return(RedirectToAction("/Loi"));
     }
     return(RedirectToAction("DatHangThanhCong", "Cart"));
 }
Пример #3
0
        public MuonTra GetMuonTraDAL(string s)
        {
            int     a  = Convert.ToInt32(s);
            MuonTra mt = new MuonTra();

            mt = db.MuonTras.Where(p => p.STT == a).SingleOrDefault();
            return(mt);
        }
        public ActionResult DeleteConfirmed(string id)
        {
            MuonTra muonTra = db.MuonTras.Find(id);

            db.MuonTras.Remove(muonTra);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
Пример #5
0
        public void DelMuonTraDAL(string s)
        {
            int     a  = Convert.ToInt32(s);
            MuonTra mt = db.MuonTras.Where(p => p.STT == a).SingleOrDefault();

            db.MuonTras.Remove(mt);
            db.SaveChanges();
        }
        private MuonTra getTra()
        {
            MuonTra mt     = new MuonTra();
            int     select = dgvDSTra.SelectedRows[0].Index;

            mt.Ma      = int.Parse(dgvDSTra["clTma", select].Value.ToString());
            mt.Ngaytra = dtpNgayTra.Value;

            return(mt);
        }
 public ActionResult Edit([Bind(Include = "SoThuTu,SoThe,NgayMuon,NgayTra,NgayPhaiTra,MaSach,MaThuThu")] MuonTra muonTra)
 {
     if (ModelState.IsValid)
     {
         db.Entry(muonTra).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     return(View(muonTra));
 }
        public ActionResult Create([Bind(Include = "SoThuTu,SoThe,NgayMuon,NgayTra,NgayPhaiTra,MaSach,MaThuThu")] MuonTra muonTra)
        {
            if (ModelState.IsValid)
            {
                db.MuonTras.Add(muonTra);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(muonTra));
        }
Пример #9
0
 //public void AddDocGiaDAL(DocGia dg)
 //{
 //    try
 //    {
 //        db.DocGias.Add(dg);
 //        db.SaveChanges();
 //    }
 //    catch (Exception e)
 //    {
 //        MessageBox.Show("Ma Doc Gia trung, xin nhap lai");
 //    }
 //}
 //public void AddNhanVienDAL(NhanVien nv)
 //{
 //    try
 //    {
 //        db.NhanViens.Add(nv);
 //        db.SaveChanges();
 //    }
 //    catch (Exception e)
 //    {
 //        MessageBox.Show("Ma Nhan Vien trung, xin nhap lai");
 //    }
 //}
 //public void AddLoaiSachDAL(LoaiSach ls)
 //{
 //    try
 //    {
 //        db.LoaiSachs.Add(ls);
 //        db.SaveChanges();
 //    }
 //    catch (Exception e)
 //    {
 //        MessageBox.Show("Ma Loai Sach trung, xin nhap lai");
 //    }
 //}
 //public void AddSachDAL(Sach s)
 //{
 //    try
 //    {
 //        db.Sachs.Add(s);
 //        db.SaveChanges();
 //    }
 //    catch (Exception e)
 //    {
 //        MessageBox.Show("Ma Sach trung hoac Nhap Sai Ma Loai, xin nhap lai");
 //    }
 //}
 public void AddMuonTraDAL(MuonTra mt)
 {
     try
     {
         db.MuonTras.Add(mt);
         db.SaveChanges();
     }
     catch (Exception e)
     {
         MessageBox.Show("Nhap sai Ma Doc gia, Nhan vien hoac Ma Sach, xin nhap lai");
     }
 }
        private MuonTra getMuon()
        {
            MuonTra mt = new MuonTra();

            mt.Masach     = txtMSach.Text;
            mt.Manhansu   = int.Parse(txtNVMuon.Text);
            mt.Thethuvien = int.Parse(txtNMMuon.Text);
            mt.Ngaymuon   = dtpNgayMuon.Value;
            mt.Hanmuon    = dtpHanMuon.Value;

            return(mt);
        }
Пример #11
0
 private void btSua_Click(object sender, EventArgs e)
 {
     if (tbMaDGMT.Text == "" || tbMaNVMT.Text == "" || tbMaSachMT.Text == "")
     {
         MessageBox.Show("Ban chua nhap day du Thong tin Muon Tra sach");
     }
     else
     {
         MuonTra mt = GetFormMuontra();
         bll.UpdateMuonTraBLL(mt);
     }
 }
Пример #12
0
        public List <MuonTra> ModelByIdMuon(string idthethuvien)
        {
            List <MuonTra> ls = new List <MuonTra>();
            DataTable      dt = DataByIdMuon(idthethuvien);

            foreach (DataRow row in dt.Rows)
            {
                MuonTra item = new MuonTra(row);
                ls.Add(item);
            }
            return(ls);
        }
Пример #13
0
        public bool XoaMuonTra(string MaThe, string MaCuon, string MaNV)
        {
            QLThuVienEntities qltvEntity = new QLThuVienEntities();
            MuonTra           mt         = new MuonTra();

            mt.MaThe  = MaThe;
            mt.MaCuon = MaCuon;
            mt.MaNV   = MaNV;
            qltvEntity.MuonTras.Attach(mt);
            qltvEntity.MuonTras.Remove(mt);
            qltvEntity.SaveChanges();
            return(true);
        }
Пример #14
0
        public void GiveBackOneOrTwo(List <ChiTietMuonTraViewModel> chiTietMuons)
        {
            if (chiTietMuons.Count() <= 0)
            {
                return;
            }
            string muontraId = "";

            var muontraNew = new MuonTra
            {
                Id     = Guid.NewGuid().ToString(),
                VanThu = User.Identity.GetUserName(),
            };

            var chiTietMuonTras = new List <ChiTietMuonTra>();

            foreach (var item in chiTietMuons)
            {
                var ctmt = _chiTietMuonTraService.GetById(item.Id);
                muontraId = item.MuonTraId;
                if (item.Checkbox)
                {
                    ctmt.TrangThai = false;
                    UpdateVanBan(ctmt.TaiLieuVanBanId);
                    var chtmtNew = new ChiTietMuonTra
                    {
                        Id              = Guid.NewGuid().ToString(),
                        MuonTraID       = muontraNew.Id,
                        TaiLieuVanBanId = item.TaiLieuVanBanId,
                        NgayTao         = DateTime.Now,
                        TrangThai       = true
                    };
                    chiTietMuonTras.Add(chtmtNew);
                }
            }

            var muonTraOld = _muonTraService.GetById(muontraId);

            _muonTraService.Update(muonTraOld);

            muontraNew.UserId      = muonTraOld.UserId;
            muontraNew.NgayMuon    = muonTraOld.NgayMuon;
            muontraNew.NgayKetThuc = muonTraOld.NgayKetThuc;
            muontraNew.SoLuong     = chiTietMuons.Count(m => m.Checkbox == true);

            _muonTraService.Insert(muontraNew);
            _chiTietMuonTraService.Insert(chiTietMuonTras);

            UpdateMuonTra(muontraNew.Id);
        }
        // GET: MuonTras/Delete/5
        public ActionResult Delete(string id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            MuonTra muonTra = db.MuonTras.Find(id);

            if (muonTra == null)
            {
                return(HttpNotFound());
            }
            return(View(muonTra));
        }
Пример #16
0
        public bool ThemMuonTra(string MaThe, string MaCuon, string MaNV, DateTime NgayMuon, DateTime NgayTra)
        {
            QLThuVienEntities qltvEntity = new QLThuVienEntities();
            MuonTra           mt         = new MuonTra();

            mt.MaThe    = MaThe;
            mt.MaCuon   = MaCuon;
            mt.MaNV     = MaNV;
            mt.NgayMuon = NgayMuon;
            mt.NgayTra  = NgayTra;
            qltvEntity.MuonTras.Add(mt);
            qltvEntity.SaveChanges();

            return(true);
        }
Пример #17
0
        private void dataGridView1_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            string stt;

            stt = dataGridView1.SelectedRows[0].Cells["STT"].Value.ToString();
            MuonTra mt = bll.GetMuonTraBLL(stt);

            tbSTT.Text          = mt.STT.ToString();
            tbMaDGMT.Text       = mt.MaDG;
            tbMaNVMT.Text       = mt.MaNV;
            tbMaSachMT.Text     = mt.MaSach;
            dtpNgayMuon.Value   = mt.NgayMuon;
            dtpNgayTra.Value    = mt.NgayTra;
            dtpNgayHenTra.Value = mt.NgayHenTra;
        }
Пример #18
0
 private void btOK_Click(object sender, EventArgs e)
 {
     if (tbMaDGMT.Text == "" || tbMaNVMT.Text == "" || tbMaSachMT.Text == "")
     {
         MessageBox.Show("Ban chua nhap day du Thong tin Muon Tra sach");
     }
     else
     {
         if (On_btOK != null)
         {
             On_btOK();
         }
         MuonTra mt = GetFormMuontra();
         bll.AddMuonTraBLL(mt);
         MessageBox.Show("Thanh cong");
         Close();
     }
 }
Пример #19
0
 public void UpdateMuonTraDAL(MuonTra mt)
 {
     try
     {
         MuonTra mt1 = db.MuonTras.Where(p => p.STT == mt.STT).SingleOrDefault();
         mt1.MaDG       = mt.MaDG;
         mt1.MaNV       = mt.MaNV;
         mt1.MaSach     = mt.MaSach;
         mt1.NgayMuon   = mt.NgayMuon;
         mt1.NgayTra    = mt.NgayTra;
         mt1.NgayHenTra = mt.NgayHenTra;
         db.SaveChanges();
     }
     catch (Exception)
     {
         MessageBox.Show("Sai ma DocGia, NhanVien, hoac ma Sach");
     }
 }
Пример #20
0
        public bool TraSach(MuonTra mt)
        {
            string query = "update MuonTra ";

            query += " set ngaytra = @ngaytra ";
            query += "where id = @id ";

            Dictionary <string, object> paras = new Dictionary <string, object>();

            paras.Add("@id", mt.Ma);
            paras.Add("@ngaytra", mt.Ngaytra);


            if (DBConnect.Instance.InsertUpdateDelete(query, paras))
            {
                return(true);
            }
            return(false);
        }
Пример #21
0
        private MuonTraViewModel GetMuonTra(MuonTra muonTra)
        {
            var model = new MuonTraViewModel
            {
                Id              = muonTra.Id,
                NgayMuon        = muonTra.NgayMuon,
                NgayCapNhat     = muonTra.NgayCapNhat,
                NgayTra         = muonTra.NgayKetThuc,
                UserId          = muonTra.UserId,
                TinhTrang       = muonTra.TinhTrang,
                TrangThai       = muonTra.TrangThai,
                User            = muonTra.User,
                SoLuong         = muonTra.SoLuong,
                VanThu          = muonTra.VanThu,
                ChiTietMuonTras = muonTra.ChiTietMuonTras
            };

            return(model);
        }
Пример #22
0
        public bool MuonSach(MuonTra mt)
        {
            string query = "insert into MuonTra (ngaymuon, hanmuon, idnhansu, idthethuvien, idsach) ";

            query += " values (@ngaymuon, @hanmuon, @idnhansu, @idthethuvien, @idsach )";

            Dictionary <string, object> paras = new Dictionary <string, object>();

            paras.Add("@ngaymuon", mt.Ngaymuon);
            paras.Add("@hanmuon", mt.Hanmuon);
            paras.Add("@idnhansu", mt.Manhansu);
            paras.Add("@idthethuvien", mt.Thethuvien);
            paras.Add("@idsach", mt.Masach);

            if (DBConnect.Instance.InsertUpdateDelete(query, paras))
            {
                return(true);
            }
            return(false);
        }
        private MuonTraViewModel GetMuonTra(MuonTra muonTra)
        {
            var autoList        = AutoCompleteTextHoSos(_taiLieuVanBanService.GetAll());
            var chiTietMuonTras = _chiTietMuonTraService.GetAll();
            var model           = new MuonTraViewModel
            {
                Id              = muonTra.Id,
                NgayMuon        = muonTra.NgayMuon,
                NgayCapNhat     = muonTra.NgayCapNhat,
                NgayTra         = muonTra.NgayKetThuc,
                UserId          = muonTra.UserId,
                TinhTrang       = muonTra.TinhTrang,
                TrangThai       = muonTra.TrangThai,
                User            = muonTra.User,
                SoLuong         = muonTra.SoLuong,
                VanThu          = muonTra.VanThu,
                ChiTietMuonTras = chiTietMuonTras,
            };

            return(model);
        }
Пример #24
0
 public void AddMuonTraBLL(MuonTra mt)
 {
     dal.AddMuonTraDAL(mt);
 }
Пример #25
0
 public int Insert(MuonTra model)
 {
     db.MuonTras.Add(model);
     db.SaveChanges();
     return(model.MuontraID);
 }
Пример #26
0
 public int Insert(MuonTra order)
 {
     db.MuonTras.Add(order);
     db.SaveChanges();
     return(order.MuontraID);
 }
Пример #27
0
 public void UpdateMuonTraBLL(MuonTra mt)
 {
     dal.UpdateMuonTraDAL(mt);
 }