public void ConfirmBorrow([FromBody] BorrowList borrow)
{
var borrowItems = borrow.Items.ToArray();
borrow.Date = DateTime.UtcNow;
var items = ListItems(borrow.LockerId).ToArray();
for (int i = 0; i < items.Length; i++)
{
for (int j = 0; j < borrowItems.Length; j++)
{
if (items[i].Id == borrowItems[j].Id)
{
items[i].Amount -= borrowItems[j].BorrowAmount;
}
}
}
foreach (var item in items)
{
Item.ReplaceOne(x => x.Id == item.Id, item);
}
BorrowList.ReplaceOne(x => x.Id == borrow.Id, borrow);
}
public void Insert(BorrowList _borrowList)
{
using (StudentContext db = new StudentContext())
{
db.Database.ExecuteSqlCommand(@"Insert into BorrowLists (StudentId, BookId, StartRent, EndRent)
Values ({0},{1},{2},{3})", _borrowList.StudentId, _borrowList.BookId, _borrowList.StartRent, _borrowList.EndRent);
}
}
void OutputBook(BorrowList _borrow)
{
Console.WriteLine();
Console.WriteLine("{0,-10}{1,0}{2,-20}", "NAME: ", " ", _borrow.Book.Name);
Console.WriteLine("{0,-10}{1,0}{2,-20}", "AUTHOR: ", " ", _borrow.Book.Author.Name + " " + _borrow.Book.Author.Surname);
Console.WriteLine("{0,-10}{1,0}{2,-20}", "YEAR: ", " ", _borrow.Book.YearOfPublish);
}
public BorrowList SelectOneBorrowList(int _userChoise)
{
BorrowList _targetBorrow = new BorrowList();
List <BorrowList> _borrows = new Database.CRUD().SelectBorrowLists();
_targetBorrow = _borrows.Find(i => i.BorrowListId == _userChoise);
return(_targetBorrow);
}
public void OutputBorrowInfo(BorrowList _borrowList)
{
Console.WriteLine("| {0,-7} | {1,20} | {2,11} | {3,14} | {4,10} | {5,12} | {6,15} | {7,10} |",
"BOOK ID", "BOOK NAME", "AUTHOR NAME", "AUTHOR SURNAME", "STUDENT ID", "STUDENT NAME", "STUDENT SURNAME", "START RENT");
Console.WriteLine("| {0,-7} | {1,20} | {2,11} | {3,14} | {4,10} | {5,12} | {6,15} | {7,10} |",
_borrowList.BookId, _borrowList.Book.Name, _borrowList.Book.Author.Name, _borrowList.Book.Author.Surname, _borrowList.StudentId,
_borrowList.Student.Name, _borrowList.Student.Surname, _borrowList.StartRent.ToString("yyyy.MM.dd"));
Console.WriteLine();
}
bool IsBorrowAvailable(int _userChoise)
{
bool _checkIsValueExist = false;
BorrowList _borrow = SelectOneBorrowList(_userChoise);
if (_borrow.EndRent.ToString("yyyy.MM.dd") == DateTime.MaxValue.ToString("yyyy.MM.dd"))
{
_checkIsValueExist = true;
}
return(_checkIsValueExist);
}
public void Update(int _userInput, BorrowList _chosenBorrow)
{
BorrowList _changingBorrow = new BorrowList();
using (StudentContext db = new StudentContext())
{
_changingBorrow = db.BorrowLists.Find(_userInput);
_changingBorrow.EndRent = _chosenBorrow.EndRent;
db.SaveChanges();
}
}
public void ConfirmReturn([FromBody] ReturnList returnList)
{
var returnItems = returnList.Items.ToArray();
returnList.Date = DateTime.UtcNow;
var items = ListItems(returnList.LockerId).ToArray();
for (int i = 0; i < items.Length; i++)
{
for (int j = 0; j < returnItems.Length; j++)
{
if (items[i].Id == returnItems[j].Id)
{
items[i].Amount += returnItems[j].ReturnAmount;
}
}
}
foreach (var item in items)
{
Item.ReplaceOne(x => x.Id == item.Id, item);
}
BorrowList borrowList = GetBorrow(returnList.BorrowListId);
for (int i = 0; i < borrowList.Items.ToArray().Length; i++)
{
for (int j = 0; j < returnItems.Length; j++)
{
if (borrowList.Items[i].Id == returnItems[j].Id)
{
borrowList.Items[i].BorrowAmount -= returnItems[j].ReturnAmount;
}
}
}
var borrowItems = borrowList.Items.Where(x => x.BorrowAmount != 0).ToArray();
if (borrowItems.Length == 0)
{
CancelBorrow(borrowList);
}
else
{
EditBorrowList(borrowList);
}
CancelReturn(returnList);
}
public void Run()
{
Console.WriteLine("{0,55}", "/// RETURN THE BOOK. ///");
Console.WriteLine();
_userBorrow = new BorrowList();
int _borrowId = new Functions().ChooseBorrow();
_userBorrow = new Functions().SelectOneBorrowList(_borrowId);
new Functions().OutputBorrowInfo(_userBorrow);
Console.ReadKey();
IsReturnBook();
}
public bool ReturnBorrowFile(string borrowId)
{
using (var conn = SqlHelper.SqlConnection())
{
IDbTransaction transaction = conn.BeginTransaction();
try
{
var applyBorrow = conn.GetById <ApplyBorrowTable>(borrowId, null, transaction);
var borrowHistory = new BorrowHistory()
{
BorrowID = applyBorrow.BorrowID,
BorrowUser = applyBorrow.ApplyUser,
BorrowTime = applyBorrow.ApplyTime,
ReturnTime = DateTime.Now
};
//插入借阅历史记录表
conn.Insert(borrowHistory, transaction);
//删除原有申请借阅记录
conn.DeleteById <ApplyBorrowTable>(borrowId, transaction);
var applyBorrowFileList = conn.GetByWhere <ApplyBorrowFileList>(" where BorrowID=@BorrowID",
new { BorrowID = borrowId }, null, null, transaction);
//循环插入借阅历史文件表
foreach (var temp in applyBorrowFileList)
{
var borrowList = new BorrowList()
{
BorrowID = temp.BorrowID,
RecordID = temp.RecordID
};
conn.Insert <BorrowList>(borrowList, transaction);
conn.DeleteById <ApplyBorrowFileList>(temp.ID, transaction);
//更新档案状态
conn.UpdateByWhere <Record>(" where RecordID=@RecordID", "RecordStatus",
new { RecordID = temp.RecordID, RecordStatus = 2 }, transaction);
}
transaction.Commit();
return(true);
}
catch (System.Exception e)
{
transaction.Rollback();
return(false);
}
}
}
public BorrowList CreateBorrow([FromBody] BorrowList borrowDetail)
{
var borrowItems = borrowDetail.Items.Where(x => x.BorrowAmount != 0).ToArray();
BorrowList borrow = borrowDetail;
borrow.Id = Guid.NewGuid().ToString();
borrow.Items = borrowItems.ToList();
borrow.Date = DateTime.UtcNow;
BorrowList.InsertOne(borrow);
return(borrow);
}
public void AddToBorrow(string s)
{
if (Client.NGLAPTHE?.AddMonths(dataProvider.LibraryRules.THOIHANTHE ?? 0) < DateTime.Today)
{
MessageBox.Show("Thẻ độc giả quá hạn!", "Thông báo", MessageBoxButton.OK, MessageBoxImage.Warning);
return;
}
if (Client.TIENNO > dataProvider.LibraryRules.TIENPHATTOIDA)
{
eventAggregator.PublishOnCurrentThread(new Models.Message("Thông báo", "Tiền nợ vượt mức tối đa! Hãy thanh toán trước khi mượn sách mới."));
return;
}
CTSACH temp = dataProvider.GetBookDetailList(x => x.MACTS.ToString() == s).FirstOrDefault();
if (temp is null)
{
eventAggregator.PublishOnCurrentThread(new Models.Message("Thông báo", "Không tìm thấy!"));
return;
}
if (Amount == BorrowList.Count)
{
eventAggregator.PublishOnCurrentThread(new Models.Message("Thông báo", "Không thể mượn thêm được nữa!"));
return;
}
if (temp.MATT != 1)
{
eventAggregator.PublishOnCurrentThread(new Models.Message("Thông báo", "Không thể mượn!"));
return;
}
if (BorrowList.FirstOrDefault(x => x.MACTS == temp.MACTS) is null)
{
BorrowList.Add(temp);
}
else
{
eventAggregator.PublishOnCurrentThread(new Models.Message("Thông báo", "Sách đã có trong đơn!"));
}
}
public void Run()
{
Console.WriteLine("{0,55}", "/// BOOK RENTAL. ///");
Console.WriteLine();
_book = new Book();
_student = new Student();
_borrowList = new BorrowList();
int _studentId = new Functions().ChooseStudent(); //return ID student
_student = new Functions().SelectOneStudent(_studentId); //return object Student
AddStudentToBorrow(_studentId); //Add Student to Borrow
new Functions().OutputStudent(_student); //Output student
int _bookId = new Functions().ChooseBook(); //return Id Book
_book = new Functions().SelectOneBook(_bookId);
AddBookToBorrow(_bookId); //Add book to borrow
new Functions().OutputBook(_book); //Output borrow
SaveChanges();
}
public void Delete(CTSACH cs)
{
BorrowList.Remove(cs);
}
public IEnumerable <BorrowList> GetAllBorrow()
{
var borrows = BorrowList.Find(x => true).ToList();
return(borrows);
}
public IEnumerable <BorrowList> ListBorrow(string lockerId)
{
var borrows = BorrowList.Find(x => x.LockerId == lockerId).ToList();
return(borrows);
}
public IEnumerable <BorrowList> GetBorrowLender(string lenderId)
{
var borrows = BorrowList.Find(x => (x.LenderId == lenderId || x.BuddyId == lenderId)).ToList();
return(borrows);
}
public BorrowList GetBorrow(string id)
{
var borrow = BorrowList.Find(x => x.Id == id).FirstOrDefault();
return(borrow);
}
public void CancelBorrow([FromBody] BorrowList borrow)
{
BorrowList.DeleteOne(x => x.Id == borrow.Id);
}
public void EditBorrowList([FromBody] BorrowList borrowList)
{
BorrowList.ReplaceOne(x => x.Id == borrowList.Id, borrowList);
}
