public async Task Save(Borrow entity) { if (entity.BorrowId > 0) { this._context.Borrows.Update(entity); } else { this._context.Borrows.Add(entity); } await this._context.SaveChangesAsync(); }
/// <summary> /// 更新资产领用 /// </summary> /// <param name="br"></param> /// <returns></returns> public static bool BUpdate(string ID, Borrow br) { string borrower = br.Borrower; //借用人 DateTime bDate = br.BDate; //借用日期 DateTime rDate = br.RDate; //归还日期 string remark = br.bRemark; //备注 string sql = string.Format("update BorrowLog set borrower='{1}', bDate='{2}', rDate='{3}', bRemark='{4}', state='{5}' where serialNo='{0}'", ID, borrower, bDate, rDate, remark, "借出待审核"); sqlHandler sh = new sqlHandler(); return(sh.ExecuteNonQuery(sql) > 0); }
//emprunt d'un media public bool BorrowMedia(int UserId, int MediaId) { Borrow borrow = new Borrow(); borrow.UserId = UserId; borrow.MediaId = MediaId; borrow.BorrowDate = Convert.ToDateTime(DateTime.Now.ToString("dd-MM-yyyy")); bool isBorrowAdded = DatabaseContext.getInstance().Add(borrow); return(isBorrowAdded); }
//SETUPMOCK: private static Mock <IBorrowManager> SetupMock(Borrow borrow) { var borrowManagerMock = new Mock <IBorrowManager>(); borrowManagerMock.Setup(m => m.GetBorrowFromCustomerAndBook(It.IsAny <int>(), It.IsAny <string>())) .Returns(borrow); borrowManagerMock.Setup(m => m.AddBorrow(It.IsAny <int>(), It.IsAny <string>(), It.IsAny <DateTime>(), It.IsAny <DateTime>())); return(borrowManagerMock); }
/// <summary> /// 领用资产 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnOK_Click(object sender, EventArgs e) { Borrow br = new Borrow(); br.ID = this.textSerialNO.Text; br.EqNo = this.textEqNO.Text; br.EqName = this.textName.Text; DataTable Empdt = EmployeeMgr.GetAllName(); DataTable Depdt = DepartMgr.GetAllDepartment(); br.Department = this.name2ID(Depdt, this.textDepartment.Text, "departName"); br.KeepPlace = this.textKeepPlace.Text; br.Keeper = this.name2ID(Empdt, this.textKeeper.Text, "name"); br.BAgent = this.name2ID(Empdt, _user, "name"); br.Borrower = this.cbxborrower.SelectedValue.ToString(); br.BDate = this.dtpBDate.Value; br.RDate = this.dtpRDate.Value; br.bRemark = this.textBorrowRemark.Text; bool flag; if (updata_flag) { flag = BoroowMgr.BUpdate(ID, br); } else { if (IsEqAvailable(this.textEqNO.Text)) { if (_power == "0" || _power == "1") { flag = BoroowMgr.AddWithoutVerify(br); } else { flag = BoroowMgr.Add(br); } flag = EqMgr.BorrowEq(br.EqNo); if (flag) { untCommon.InfoMsg("出借成功。"); } else { untCommon.InfoMsg("出借失败。"); } } else { untCommon.InfoMsg("该资产状态已改变,无法修改该信息。"); } } this.DialogResult = DialogResult.OK; }
public static void Initialize(LibraryContext context) { context.Database.EnsureCreated(); if (context.Readers.Any()) { return; } var readers = new Reader[] { new Reader { FirstName = "Sample A", LastName = "Sample A" }, new Reader { FirstName = "Sample B", LastName = "Sample B" } }; foreach (Reader r in readers) { context.Readers.Add(r); } context.SaveChanges(); var books = new Book[] { new Book { Author = "Sample C", Title = "Sample C", Category = "Sample C" }, new Book { Author = "Sample D", Title = "Sample D", Category = "Sample D" } }; foreach (Book b in books) { context.Books.Add(b); } context.SaveChanges(); var borrows = new Borrow[] { new Borrow { BookID = 1, ReaderID = 1, BorrowDate = DateTime.Parse("02-02-2017") }, new Borrow { BookID = 2, ReaderID = 1, BorrowDate = DateTime.Parse("02-03-2017") } }; foreach (Borrow b in borrows) { context.Borrows.Add(b); } context.SaveChanges(); }
public ActionResult Edit([Bind(Include = "Id,CustomerId,BookId")] Borrow borrow) { if (ModelState.IsValid) { db.Entry(borrow).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.BookId = new SelectList(db.Books, "Id", "Author", borrow.BookId); ViewBag.CustomerId = new SelectList(db.Customers, "Id", "Name", borrow.CustomerId); return(View(borrow)); }
public ActionResult Create([Bind(Include = "BorrowID,BorrowDate,BorrowReturn")] Borrow borrow) { if (ModelState.IsValid) { db.Borrows.Add(borrow); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.BorrowID = new SelectList(db.Borrowers, "BorrowerID", "FirstName", borrow.BorrowID); return(View(borrow)); }
public ActionResult Edit([Bind(Include = "Id_imprumut,Id_user,Id_carte,Date,Nr_carti")] Borrow borrow) { if (ModelState.IsValid) { db.Entry(borrow).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Id_user = new SelectList(db.AspNetUsers, "Id", "Email", borrow.Id_user); ViewBag.Id_carte = new SelectList(db.Cartis, "Id", "Nume_carte", borrow.Id_carte); return(View(borrow)); }
public async Task <IActionResult> Create([Bind("borrow_id,supplier_id,product_id,borrow_qty,borrow_date")] Borrow borrow) { if (ModelState.IsValid) { await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["product_id"] = new SelectList(_context.ProductInfos, "product_id", "product_name", borrow.product_id); ViewData["supplier_id"] = new SelectList(_context.SupplierInfos, "supplier_id", "supplier_name", borrow.supplier_id); return(View(borrow)); }
public void Update(BorrowDTO recDTO) { Borrow borrow = _borrowRepository.Find(recDTO.BookID, recDTO.StudentID); if (borrow == null) { throw new DataException(string.Format(ValidationConstants.SDataNotFoundWithValue, "Borrow", string.Format("book: {0} student: {1}", recDTO.BookID, recDTO.StudentID))); } borrow = BorrowMapper.Map(recDTO); _borrowRepository.Update(borrow); }
public void Add(BorrowDTO recDTO) { if (_borrowRepository.isBookAvaliable(recDTO.BookID)) { Borrow Borrow = BorrowMapper.Map(recDTO); _borrowRepository.Add(Borrow); } else { throw new DataException("This Book is already borrowed"); } }
public static void ManageBorrow(Borrow borrow, EntityState entityState) { IBorrowRepository borrowRepository = new BorrowRepository(); borrow.EntityState = entityState; if (borrow.Quantity == 0 && entityState == EntityState.Modified) { borrow.IsReturn = true; borrow.ReturnTime = DateTime.Now; } borrowRepository.Update(borrow); }
public ActionResult BorrowBook(Borrow borrow) { if (ModelState.IsValid) { borrow.IsBorrowed = true; db.BorrowList.Add(borrow); db.SaveChanges(); FlashMessage.Confirmation("This book has been Borrowd."); return(RedirectToAction("BorrowBook")); } return(View()); }
public async Task <ActionResult> Edit([Bind(Include = "BorrowId,MemberNo,BookId,Author,Publisher")] Borrow borrow) { if (ModelState.IsValid) { db.Entry(borrow).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } ViewBag.BookId = new SelectList(db.Books, "BookId", "BookTitle", borrow.BookId); return(View(borrow)); }
public async Task <IActionResult> Edit(Borrow borrow) { if (ModelState.IsValid) { borrow.To = DateTime.Now; await _borrowRepository.UpdateAsync(borrow.BorrowId, borrow); return(RedirectToAction("Index", "Books")); } return(View(borrow)); }
public ActionResult Return(int id) { Borrow b = bservice.Get(id); Book bk = bkservice.Get(b.Book); bk.Copy = bk.Copy + 1; bkservice.Update(bk); b.Status = 1; b.Rdate = DateTime.Now; bservice.Update(b); return(RedirectToAction("Borrowdetails")); }
public async Task <IActionResult> PostBorrow([FromBody] Borrow borrow) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } _context.Borrows.Add(borrow); await _context.SaveChangesAsync(); return(CreatedAtAction("GetBorrow", new { id = borrow.BorrowId }, borrow)); }
public BorrowDTO Find(int bookID, int studentID) { Borrow borrow = _borrowRepository.Find(bookID, studentID); if (borrow == null) { return(null); } BorrowDTO recDTO = BorrowMapper.Map(borrow); return(recDTO); }
public ActionResult Edit([Bind(Include = "BorrowID,BorrowDate,ReturnDate,BookCopyID,UserID,PunishmentID")] Borrow borrow) { if (ModelState.IsValid) { db.Entry(borrow).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.BookCopyID = new SelectList(db.BookCopies, "BookCopyID", "BookCopyID", borrow.BookCopyID); ViewBag.PunishmentID = new SelectList(db.Punishments, "PunishmentID", "PunishmentID", borrow.PunishmentID); ViewBag.UserID = new SelectList(db.ApplicationUsers, "Id", "Name", borrow.UserID); return(View(borrow)); }
public int Insert(Borrow model) { SqlParameter[] sqlParameters = new SqlParameter[] { new SqlParameter("StudentId", model.StudentId), new SqlParameter("StaffId", model.StaffId), new SqlParameter("BookId", model.BookId), new SqlParameter("ReturnDate", model.ReturnDate == null ? "" : model.ReturnDate), new SqlParameter("Status", model.Status), }; return(db.Database.SqlQuery <int>("uspInsertBorrow @StudentId, @StaffId, @BookId, @ReturnDate, @Status", sqlParameters).SingleOrDefault()); }
public ActionResult Borrow([Bind(Include = "Id,CustomerId,BookId")] Borrow borrow) { if (ModelState.IsValid) { db.Borrows.Add(borrow); db.SaveChanges(); return(RedirectToAction("Catalogue")); } ViewBag.BookId = new SelectList(db.Books, "Id", "Author", borrow.BookId); ViewBag.CustomerId = new SelectList(db.Customers, "Id", "Name", borrow.CustomerId); return(View(borrow)); }
public int Return(Borrow aBorrow) { string query = "UPDATE tbl_borrow SET is_returned='True' WHERE book_id='" + aBorrow.BookId + "'AND member_id='" + aBorrow.MemberId + "'"; DBSqlConnection = new SqlConnection(ConnectionString); DBSqlConnection.Open(); DbSqlCommand = new SqlCommand(query, DBSqlConnection); int rowAffected = DbSqlCommand.ExecuteNonQuery(); DbSqlCommand.Dispose(); DBSqlConnection.Close(); return(rowAffected); }
public async Task <IActionResult> Create([Bind("Id,From,To,BookId,ReaderId")] Borrow borrow) { if (ModelState.IsValid) { _context.Add(borrow); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["BookId"] = new SelectList(_context.Books, "Id", "Title", borrow.BookId); ViewData["ReaderId"] = new SelectList(_context.Readers, "Id", "LastName", borrow.ReaderId); return(View(borrow)); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Borrow borrow = new Borrow(); txtBorrowID.Text = borrow.GetNewBorrowOrderID().ToString(); for (int i = 0; i < 3; i++) { bookID[i] = -1; } } }
public static bool run_insql(Borrow br, int i) { switch (i) { case 0: return(BorrowDAL.ex_insert_insql(br)); case 1: return(BorrowDAL.ex_update_insql(br)); case 2: return(BorrowDAL.ex_delete_insql(br)); default: return(false); } }
//Select Item Stock private void mlvSelectRefundItemStock_ItemSelectionChanged(object sender, ListViewItemSelectionChangedEventArgs e) { if (e.IsSelected) { selectedRefundedItemStock = mlvSelectRefundItemStock.FocusedItem.Index; selectedRefundBorrow = selectedRefunderUser.Borrows.Where(x => !x.IsReturn).ElementAt(selectedRefundedItemStock); selectedItem = RefundItems.FirstOrDefault(x => x.Id.Equals(selectedRefundBorrow.Item_Id)); SelectedItems = new List <int>(); ListUtil.InitializeListView(mlvSelectRefundItem, Borrows.Where(x => x.Id.Equals(selectedRefundBorrow.Id)).ToList(), RefundItems, (int)selectedRefundBorrow.Quantity); tbcManageRefund.SelectedTab = tbpAcceptRefund; } }
public ActionResult Edit([Bind(Include = "BorrowId,BorrowDate,ReturnDate,BookCopyID,ReaderID,EmployeeID")] Borrow borrow) { if (ModelState.IsValid) { db.Entry(borrow).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.BookCopyID = new SelectList(db.BookCopies, "BookCopyID", "BookCopyID", borrow.BookCopyID); ViewBag.EmployeeID = new SelectList(db.Employees, "EmployeeID", "Pesel", borrow.EmployeeID); ViewBag.ReaderID = new SelectList(db.Readers, "ReaderID", "Pesel", borrow.ReaderID); return(View(borrow)); }
/// <summary> /// 资产领用 /// </summary> /// <param name="br"></param> /// <returns></returns> public static bool Add(Borrow br) { string eqno = br.EqNo; int count = br.Count; string depart = br.depart; DateTime date = br.Date; string booker = br.Booker; int boroower = br.Borrower; string sql = string.Format("insert into borrow values('{0}',{1},'{2}','{3}','{4}','{5}')", eqno, count, depart, boroower, date, booker); sqlHandler sh = new sqlHandler(); return(sh.ExecuteNonQuery(sql) > 0); }
public async Task <Borrow> Update(Borrow entity) { Borrow borrow = _context.Borrows.Find(entity.Id); borrow.Status = entity.Status; borrow.Name = entity.Name; borrow.DateRequest = entity.DateRequest; borrow.UpdatedRequest = entity.DateRequest; borrow.UserId = entity.UserId; await _context.SaveChangesAsync(); return(entity); }