public DetailBorrowInfoForm(string readerID)
{
InitializeComponent();
ReaderDAO dao = new ReaderDAO();
list = dao.getAllOrderByReader(readerID);
DataTable table = new DataTable();
table.Columns.Add("RecordID", typeof(string));
table.Columns.Add("EmployeeID", typeof(string));
table.Columns.Add("BorrowQuantity", typeof(string));
table.Columns.Add("BorrowDate", typeof(DateTime));
table.Columns.Add("ReturnDate", typeof(DateTime));
table.Columns.Add("Status", typeof(string));
table.Columns.Add("Time remaining", typeof(int));
foreach (Order order in list)
{
TimeSpan time = order.ReturnDate - order.BorrowDate;
int timeRemaining = time.Days;
table.Rows.Add(order.RecordID, order.EmployeeID, order.TotalQuantity, order.BorrowDate, order.ReturnDate, order.Status, timeRemaining);
}
dgvListOrder.DataSource = table;
dgvListOrder.AllowUserToAddRows = false;
dgvListOrder.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}
private void btnHistoryBorrow_Click(object sender, EventArgs e)
{
if (txtReaderID1.Text.Length == 0)
{
MessageBox.Show("Pls Chosse the Reader first!!");
return;
}
ReaderDAO readerDAO = new ReaderDAO();
DetailBorrowInfoForm frm = new DetailBorrowInfoForm(txtReaderID1.Text);
this.Visible = false;
frm.ShowDialog();
this.Visible = true;
}
private bool checkDuplicateReaderID(string readerID)
{
bool check = true;
ReaderDAO readerDAO = new ReaderDAO();
List <Reader> listReader = readerDAO.getAllReaders();
foreach (Reader r in listReader)
{
if (r.ReaderID.Equals(readerID))
{
check = false;
}
}
return(check);
}
private void btnUpdateReader_Click(object sender, EventArgs e)
{
if (txtReaderID1.Text.Length == 0)
{
MessageBox.Show("Pls Chosse the Reader first!!");
return;
}
if (txtReaderName1.Text.Length == 0 || txtAddress1.Text.Length == 0 || txtPhone1.Text.Length == 0 || txtEmail1.Text.Length == 0)
{
MessageBox.Show("All value must not blank");
return;
}
try
{
int test = int.Parse(txtPhone1.Text);
}catch (Exception ex)
{
MessageBox.Show("The phone must be a number!!");
return;
}
Reader reader = new Reader(txtReaderID1.Text, txtReaderName1.Text, txtAddress1.Text, txtPhone1.Text, txtEmail1.Text);
ReaderDAO readerDAO = new ReaderDAO();
if (readerDAO.updateReader(reader))
{
DataTable table = new DataTable();
table.Columns.Add("ID", typeof(string));
table.Columns.Add("Name", typeof(string));
table.Columns.Add("Address", typeof(string));
table.Columns.Add("Phone", typeof(string));
table.Columns.Add("Email", typeof(string));
List <Reader> list = readerDAO.getAllReaders();
foreach (Reader r in list)
{
table.Rows.Add(r.ReaderID, r.ReaderName, r.ReaderAddress, r.ReaderPhone, r.Email);
}
MessageBox.Show("Update Success!!");
dgvListReader.DataSource = table;
dgvListReader.AllowUserToAddRows = false;
dgvListReader.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}
else
{
MessageBox.Show("Update Fail...");
}
}
private void btnSearchReader_Click(object sender, EventArgs e)
{
List <Reader> list = null;
string search = txtSearchReader.Text;
ReaderDAO readerDAO = new ReaderDAO();
DataTable table = new DataTable();
table.Columns.Add("ID", typeof(string));
table.Columns.Add("Name", typeof(string));
table.Columns.Add("Address", typeof(string));
table.Columns.Add("Phone", typeof(string));
table.Columns.Add("Email", typeof(string));
if (search.Length == 0)
{
list = readerDAO.getAllReaders();
foreach (Reader r in list)
{
table.Rows.Add(r.ReaderID, r.ReaderName, r.ReaderAddress, r.ReaderPhone, r.Email);
}
}
else
{
Reader rd = readerDAO.findReaderByID(search);
if (rd == null)
{
MessageBox.Show("Not Found!!");
return;
}
else
{
table.Rows.Add(rd.ReaderID, rd.ReaderName, rd.ReaderAddress, rd.ReaderPhone, rd.Email);
}
}
dgvListReader.DataSource = table;
dgvListReader.AllowUserToAddRows = false;
dgvListReader.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}
private void btnConfirmOldReader_Click(object sender, EventArgs e)
{
if (txtOldReaderID.Text.Length == 0)
{
MessageBox.Show("Pls input ReaderID first!!");
}
OrderDAO orderDAO = new OrderDAO();
string readerID = txtOldReaderID.Text;
if (checkDuplicateReaderID(readerID))
{
MessageBox.Show("This Reader is not exist!!");
return;
}
DateTime borrowDate = dtpBorrowDate1.Value;
DateTime returnDate = dtpReturnDate1.Value;
if (returnDate.CompareTo(borrowDate) < 0)
{
MessageBox.Show("Return Date must not be earlier than Borrow Date!!");
return;
}
DateTime dateOfCreate = DateTime.Now;
string lastOrder = orderDAO.getLastOrderIDByReader(readerID);
string recordID = "";
ReaderDAO readerDAO = new ReaderDAO();
if (lastOrder != null)
{
string[] tmp = lastOrder.Split('-');
recordID = "OD" + "-" + readerID + "-" + (int.Parse(tmp[3]) + 1);
}
else
{
recordID = "OD-" + readerID + "-1";
}
List <Book> listBook = dao.getAllBooks();
List <Book> listcheckQuantityBook = new List <Book>();
foreach (Cart c in listcart)
{
foreach (Book b in listBook)
{
if (b.BookID.Equals(c.BookID))
{
b.Quantity = b.Quantity - c.Quantity;
listcheckQuantityBook.Add(b);
}
}
}
foreach (Book b in listcheckQuantityBook)
{
if (b.Quantity < 0)
{
MessageBox.Show("Quantity of the book " + b.BookName + " is not enough");
return;
}
}
int totalQuantity = 0;
foreach (Cart c in listcart)
{
totalQuantity += c.Quantity;
}
Order order = new Order(recordID, emp.EmployeeID, readerID, borrowDate, returnDate, dateOfCreate, totalQuantity, "Đang mượn");
bool checkCreateOrder = orderDAO.createOrder(order);
if (checkCreateOrder)
{
int count = 0;
foreach (Cart c in listcart)
{
count++;
string recordDetailID = recordID + "-" + count;
orderDAO.createOrderDetail(recordDetailID, recordID, c.BookID, c.Quantity);
}
orderDAO.setQuantityBook(listcheckQuantityBook);
MessageBox.Show("Order Success!!");
listcart.Clear();
txtCartBookID.Text = "";
txtCartBookName.Text = "";
txtCartQuantityBook.Text = "";
txtNewReaderName.Text = "";
txtNewReaderAddress.Text = "";
txtNewReaderPhone.Text = "";
txtNewReaderEmail.Text = "";
txtOldReaderID.Text = "";
dgvListBorrow.DataSource = null;
}
}
private void btnConfirmNewReader_Click(object sender, EventArgs e)
{
try
{
int test = int.Parse(txtNewReaderPhone.Text);
} catch (Exception ex)
{
MessageBox.Show("Phone must be a number");
return;
}
OrderDAO orderDAO = new OrderDAO();
ReaderDAO readerDAO = new ReaderDAO();
List <Reader> listReader = readerDAO.getAllReaders();
if (txtNewReaderName.Text.Length == 0 || txtNewReaderEmail.Text.Length == 0 || txtNewReaderAddress.Text.Length == 0 || txtNewReaderPhone.Text.Length == 0)
{
MessageBox.Show("All info must not blank!!");
return;
}
int cc = 1;
foreach (Reader r in listReader)
{
string[] tmp = r.ReaderID.Split('-');
if (int.Parse(tmp[1]) == cc)
{
cc++;
}
else
{
string ID = "SE-" + cc;
if (checkDuplicateReaderID(ID))
{
break;
}
else
{
cc++;
}
}
}
string readerID = "SE-" + cc;
string readerName = txtNewReaderName.Text;
string readerAddress = txtNewReaderAddress.Text;
string readerPhone = txtNewReaderPhone.Text;
string readerEmail = txtNewReaderEmail.Text;
DateTime borrowDate = dtpBorrowDate.Value;
DateTime returnDate = dtpReturnDate.Value;
if (returnDate.CompareTo(borrowDate) < 0)
{
MessageBox.Show("Return Date must not be earlier than Borrow Date!!");
return;
}
DateTime dateOfCreate = DateTime.Now;
Reader rd = new Reader(readerID, readerName, readerAddress, readerPhone, readerEmail);
string recordID = "OD-" + readerID + "-1";
List <Book> listBook = dao.getAllBooks();
List <Book> listcheckQuantityBook = new List <Book>();
foreach (Cart c in listcart)
{
foreach (Book b in listBook)
{
if (b.BookID.Equals(c.BookID))
{
b.Quantity = b.Quantity - c.Quantity;
listcheckQuantityBook.Add(b);
}
}
}
foreach (Book b in listcheckQuantityBook)
{
if (b.Quantity < 0)
{
MessageBox.Show("Quantity of the book " + b.BookName + " is not enough");
return;
}
}
int totalQuantity = 0;
foreach (Cart c in listcart)
{
totalQuantity += c.Quantity;
}
Order order = new Order(recordID, emp.EmployeeID, readerID, borrowDate, returnDate, dateOfCreate, totalQuantity, "Đang mượn");
readerDAO.insertReader(rd);
bool checkCreateOrder = orderDAO.createOrder(order);
if (checkCreateOrder)
{
int count = 0;
foreach (Cart c in listcart)
{
count++;
string recordDetailID = recordID + "-" + count;
orderDAO.createOrderDetail(recordDetailID, recordID, c.BookID, c.Quantity);
}
orderDAO.setQuantityBook(listcheckQuantityBook);
MessageBox.Show("New Reader has ID: " + readerID + " is added!!");
MessageBox.Show("Order Success!!");
listcart.Clear();
txtCartBookID.Text = "";
txtCartBookName.Text = "";
txtCartQuantityBook.Text = "";
txtNewReaderName.Text = "";
txtNewReaderAddress.Text = "";
txtNewReaderPhone.Text = "";
txtNewReaderEmail.Text = "";
dgvListBorrow.DataSource = null;
}
}
public void delete(string madocgia)
{
ReaderDAO.delete(madocgia);
}
public void update(ReaderDTO reader)
{
ReaderDAO.update(reader);
}
public void insert(ReaderDTO reader)
{
ReaderDAO.insert(reader);
}
public DataTable readAll()
{
return(ReaderDAO.readAll());
}
