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