private void btnMember_Click(object sender, EventArgs e)
{
int borrowerNumber;
try
{
borrowerNumber = int.Parse(txtBorrowerNumber.Text);
}
catch
{
MessageBox.Show("Borrower number must be a integer!");
txtBorrowerNumber.Focus();
return;
}
Borrower b = BorrowerDAO.GetBorrower(borrowerNumber);
if (b == null)
{
MessageBox.Show(String.Format("Borrower number {0} does't exist!", borrowerNumber));
txtBorrowerNumber.Focus();
return;
}
txtName.Text = b.Name;
View();
displayButtons(2);
}
protected void btnCheckMember_Click(object sender, EventArgs e)
{
if (txtBorrowerNumber.Text.Trim().Equals(""))
{
showMessageError("Borrower number can't be empty");
return;
}
if (!DAO.checkInt(txtBorrowerNumber.Text))
{
showMessageError("BorrowerNumber must be a integer number");
return;
}
int borrowerNumber = int.Parse(txtBorrowerNumber.Text);
Borrower b = BorrowerDAO.GetBorrower(borrowerNumber);
if (b == null)
{
showMessageError(String.Format("Borrower number {0} doesn't exist!", borrowerNumber));
txtBorrowerNumber.Focus();
return;
}
txtName.Text = b.Name;
getData();
displayButtons(2);
}
private void btnAdd_Click(object sender, EventArgs e)
{
Button btn = (Button)sender;
if (btn.Text == "Add")
{
b = new Borrower(BorrowerDAO.GetBorrowerNumberMax() + 1, "", 'M', "", "", "");
displayBook();
displayButtons(2);
}
else
{
b.Name = txtName.Text;
b.Sex = char.Parse(txtSex.Text);
b.Address = txtAddress.Text;
b.Telephone = txtTelephone.Text;
b.Email = txtEmail.Text;
BorrowerDAO.Insert(b);
// Add to DataTable
DataTable dt = dv.Table;
DataRow newRow = dt.NewRow();
newRow["borrowerNumber"] = b.BorrowerNumber;
newRow["name"] = b.Name;
newRow["sex"] = b.Sex;
newRow["address"] = b.Address;
newRow["telephone"] = b.Telephone;
newRow["email"] = b.Email;
dt.Rows.Add(newRow);
dv.RowFilter = "";
displayButtons(1);
}
}
public BorrowerGUI()
{
InitializeComponent();
m = new BorrowerDAO();
showData();
}
protected void btCheckMember_Click(object sender, EventArgs e)
{
txtName.Text = "";
lbNumberOfBorrowedBooks.Text = "0";
lbError.Visible = false;
int borrowerNumber;
try
{
borrowerNumber = int.Parse(txtMemberCode.Text);
}
catch
{
lbError.Visible = true;
lbError.Text = "Borrower number must be a integer!";
txtMemberCode.Focus();
return;
}
Borrower b = BorrowerDAO.GetBorrower(borrowerNumber);
if (b == null)
{
lbError.Visible = true;
lbError.Text = String.Format("Borrower number {0} does't exist!", borrowerNumber);
txtMemberCode.Focus();
return;
}
txtName.Text = b.Name;
lbNumberOfBorrowedBooks.Text = GridView1.Rows.Count.ToString();
// View();
}
private void View()
{
DataTable dt = BorrowerDAO.GetDataTable();
dv = new DataView(dt);
dataGridView1.DataSource = dv;
}
private void btCheckMember_Click(object sender, EventArgs e)
{
int borrowerNumber;
try
{
borrowerNumber = int.Parse(txtMemberCode.Text);
}
catch
{
MessageBox.Show("Borrower number must be a integer!");
txtMemberCode.Focus();
return;
}
Borrower b = new BorrowerDAO().GetBorrower(borrowerNumber);
if (b == null)
{
MessageBox.Show(String.Format("Borrower number {0} does't exist!", borrowerNumber));
txtMemberCode.Focus();
return;
}
txtName.Text = b.Name;
View();
if (dataGridView1.Rows.Count >= 1)
{
MessageBox.Show("You has already reserved !!!");
txtMemberCode.Focus();
return;
}
displayButtons(2);
}
protected void btnMember_Click(object sender, EventArgs e)
{
int borrowerNumber;
try
{
borrowerNumber = int.Parse(txtBorrowerNumber.Text);
}
catch
{
lblError.Text = "Borrower number must be a integer!";
txtBorrowerNumber.Focus();
return;
}
Borrower b = BorrowerDAO.GetBorrower(borrowerNumber);
if (b == null)
{
txtBorrowerNumber.Focus();
return;
}
txtName.Text = b.Name;
View();
displayButtons(2);
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (check == 1)
{
string name = txtName.Text;
char sex = txtSex.Text[0];
string address = txtAddress.Text;
string telephone = txtTelephone.Text;
string email = txtEmail.Text;
Borrower b = new Borrower(name, sex, address, telephone, email);
if (BorrowerDAO.Insert(b))
{
//lblError.Text = "";
clear();
displayButtons(1);
}
}
if (check == 2)
{
int borrowerNum = (int)Session["borrowerNumber"];
string name = txtName.Text;
char sex = txtSex.Text[0];
string address = txtAddress.Text;
string telephone = txtTelephone.Text;
string email = txtEmail.Text;
Borrower b = new Borrower(borrowerNum, name, sex, address, telephone, email);
if (BorrowerDAO.Update(b))
{
//lblError.Text = "";
clear();
displayButtons(1);
}
}
GridView2.DataBind();
}
protected void btnMember_Click(object sender, EventArgs e)
{
int borrowerNumber;
try
{
borrowerNumber = int.Parse(txtBorrowerNumber.Text);
}
catch
{
lblError.Text = "Borrower number must be a integer!";
txtBorrowerNumber.Focus();
return;
}
Borrower b = BorrowerDAO.GetBorrower(borrowerNumber);
if (b == null)
{
lblError.Text = String.Format("Borrower number {0} does't exist!", borrowerNumber);
txtBorrowerNumber.Focus();
return;
}
txtName.Text = b.Name;
View();
if (lblNumberReservedBooks.Text == "0")
{
displayButtons(2);
}
else
{
displayButtons(1);
}
}
public new ActionResult Profile()
{
string username = (string)Session["username"];
ViewBag.borrower = BorrowerDAO.GetBorrowerByUsername(username);
ViewBag.reservations = ReservationDAO.GetReservationByUsername(username);
ViewBag.reviews = ReviewDAO.GetReviewByUsername(username);
ViewBag.message = "";
return(View());
}
public BorrowerGUI()
{
InitializeComponent();
DataTable bobd = BorrowerDAO.GetDataTable();
dataGridView1.DataSource = bobd;
txtBorrowedDate.Text = DateTime.Now.ToString("dd / MM / yyyy");
txtDueDate.Text = DateTime.Now.AddDays(14).ToString("dd/MM/yyyy");
displayButtons(1);
}
public ActionResult Register(FormCollection form)
{
string username = form["username"];
string password = form["password"];
string passRepeat = form["password-repeat"];
string email = form["email"];
string fullname = form["fullname"];
ViewBag.username = username;
ViewBag.email = email;
ViewBag.fullname = fullname;
if (username == null || username.Equals("") || password == null || password.Equals("") ||
passRepeat == null || passRepeat.Equals("") || email == null || email.Equals("") ||
fullname == null || fullname.Equals(""))
{
ViewBag.Error = "All fields are required!";
return(View());
}
if (!password.Equals(passRepeat))
{
ViewBag.Error = "The repeat password doesn't match";
return(View());
}
Regex mailRegex = new Regex(@"[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,4}");
if (!mailRegex.IsMatch(email))
{
ViewBag.Error = "Invalid email address";
return(View());
}
var borrower = new Borrower(username, password, fullname, email);
if (!BorrowerDAO.IsUserExisted(borrower.Username))
{
if (BorrowerDAO.InsertBorrower(borrower) == 1)
{
ViewData["Message"] = "Successfully register";
return(View());
}
}
ViewBag.Error = "The username is already existed";
return(View());
}
protected void btnReserve_Click(object sender, EventArgs e)
{
int borrowerNum = int.Parse(txtBorrowerNumber.Text);
Borrower borrower = BorrowerDAO.GetBorrower(borrowerNum);
Reservation rv = new Reservation(int.Parse(txtBorrowerNumber.Text), int.Parse(txtBookNumber.Text), Calendar1.SelectedDate);
if (ReserveDAO.Insert(rv))
{
View(borrower);
btnReserve.Enabled = false;
}
else
{
lblError.Text = "Reserve queue failse! ";
}
}
public ActionResult Login(string username, string password)
{
Console.WriteLine(BorrowerDAO.IsLoginSuccessfully("nguyen", "123"));
if (username.Equals("nguyen") && password.Equals("123"))
{
return(RedirectToAction("ManageBook", "Admin"));
}
if (BorrowerDAO.IsLoginSuccessfully(username, password))
{
Session["username"] = username;
return(RedirectToAction("Index", "Home"));
}
else
{
ViewBag.error = "Incorrect username or password!";
return(RedirectToAction("Error", "Home"));
}
}
private void btnMember_Click(object sender, EventArgs e)
{
int borrowerNumber;
try
{
borrowerNumber = int.Parse(txtBorrowerNumber.Text);
}
catch
{
MessageBox.Show("Borrower number must be a integer!");
txtBorrowerNumber.Focus();
return;
}
//create in DAO
Borrower b = BorrowerDAO.GetBorrower(borrowerNumber);
if (b == null)
{
MessageBox.Show(String.Format("Borrower number {0} does't exist!", borrowerNumber));
txtBorrowerNumber.Focus();
return;
}
txtName.Text = b.Name;
View();
int n = dataGridView1.Rows.Count;
MessageBox.Show("Number = " + n);
if (dataGridView1.Rows.Count >= 5)
{
MessageBox.Show("You borrowed 5 books, so you can't borrow any more!");
txtBorrowerNumber.Focus();
return;
}
displayButtons(2);
r = null;
c = null;
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (!isSelected())
{
return;
}
int borrowerNumber = (int)dataGridView1.SelectedRows[0].Cells["borrowerNumber"].Value;
DialogResult dr = MessageBox.Show(String.Format("Do you want to delete this borrower number {0}?", borrowerNumber), "Confirm deteting", MessageBoxButtons.YesNo);
if (dr == DialogResult.No)
{
return;
}
BorrowerDAO.Delete(borrowerNumber);
View();
}
protected void btnCheckMember_Click(object sender, EventArgs e)
{
int borrowerNum;
if (DAO.checkInt(txtBorrowerNumber.Text) == false)
{
lblError.Text = "Borrower number must be a integer!";
/*MessageBox.Show("");
* txtMemberCode.Focus();*/
return;
}
borrowerNum = int.Parse(txtBorrowerNumber.Text);
Borrower borrower = BorrowerDAO.GetBorrower(borrowerNum);
if (borrower != null)
{
txtName.Text = borrower.Name; //display name
View(borrower);
//MessageBox.Show("R".Equals("R") + "");
if (ReserveDAO.GetLastReserveOfBorrower(int.Parse(txtBorrowerNumber.Text)) != null &&
ReserveDAO.GetLastReserveOfBorrower(int.Parse(txtBorrowerNumber.Text)).Status.ToString().Equals("R")) //mean the last record still R
{
//have a book in reserve
/* MessageBox.Show("Oops! you have book in reserve queue! You can't reserve book until it's over");*/
lblError.Text = "Oops! you have book in reserve queue! You can't reserve book until it's over";
btnChkCondition.Enabled = false;
txtBookNumber.Enabled = false;
btnReserve.Enabled = false;
}
else
{
lblError.Text = " ";
btnChkCondition.Enabled = true;
txtBookNumber.Enabled = true;
}
}
else
{
lblError.Text = "Oops, ID is not exist! Check again!";
}
}
public ActionResult Profile(FormCollection f)
{
string username = (string)Session["username"];
string name = f["fullname"];
string email = f["email"];
double deposit = Convert.ToDouble(f["deposit"]);
if (BorrowerDAO.UpdateBorrower(name, username, email, deposit) > 0)
{
ViewBag.borrower = BorrowerDAO.GetBorrowerByUsername(username);
ViewBag.reservations = ReservationDAO.GetReservationByUsername(username);
ViewBag.message = "Update Successful!";
}
else
{
ViewBag.message = "Update Failed!";
}
return(View());
}
protected void btnCheckButton_Click(object sender, EventArgs e)//check member
{
lblError.Visible = false;
int borrowerNumber;
try
{
borrowerNumber = int.Parse(txtBorrowerNumber.Text);
}
catch
{
lblError.Visible = true;
lblError.Text = "Borrower number must be a integer!";
txtBorrowerNumber.Focus();
return;
}
Borrower b = BorrowerDAO.GetBorrower(borrowerNumber);
if (b == null)
{
lblError.Visible = true;
lblError.Text = String.Format("Borrower number {0} does't exist!", borrowerNumber);
txtBorrowerNumber.Focus();
return;
}
txtName.Text = b.Name;
showData();
int n = GridView1.Rows.Count;
lblNoOfBorrowedCopy.Text = n.ToString();
if (GridView1.Rows.Count >= 5)
{
lblError.Visible = true;
lblError.Text = "You borrowed 5 books, so you can't borrow any more!";
return;
}
displayButtons(2);
c = null;
r = null;
}
public ActionResult AddFund(FormCollection f)
{
string username = (string)Session["username"];
double amount = Convert.ToDouble(f["amount"]);
string type = f["type"];
DateTime date = Convert.ToDateTime(f["date"]);
Payment p = new Payment(amount, username, date, type);
if (PaymentDAO.InsertPayment(p) > 0)
{
Borrower b = BorrowerDAO.GetBorrowerByUsername(username);
double NewDeposit = amount + b.Deposit;
BorrowerDAO.UpdateDeposit(username, NewDeposit);
ViewBag.message = "Payment Successfully !";
}
else
{
ViewBag.message = "Failed !!";
}
return(View());
}
protected void btnCheck_Click(object sender, EventArgs e)
{
if (txtBorrowerNumber.Text != null)
{
int borrowNumber;
if (DAO.checkInt(txtBorrowerNumber.Text) == false)
{
lblError.Text = "Borrower number must be a integer!";
txtBorrowerNumber.Focus();
return;
}
borrowNumber = int.Parse(txtBorrowerNumber.Text);
Borrower b = BorrowerDAO.GetBorrower(borrowNumber);
if (b == null)
{
lblError.Text = String.Format("Borrower number {0} does't exist!", txtBorrowerNumber.Text);
txtBorrowerNumber.Focus();
return;
}
txtName.Text = b.Name;
//check borrowed >= 5 books
if (BorrowDAO.GetBorrowedCopies(int.Parse(txtBorrowerNumber.Text)).Rows.Count >= 5)
{
lblError.Text = "You borrowed 5 books, so you can't borrow any more!";
return;
}
ObjectDataSource1.FilterExpression = "borrowerNumber = " + txtBorrowerNumber.Text;
GridView1.DataBind();
displayButtons(2);
/*ObjectDataSource1.DataBind();*/
}
else
{
lblError.Text = "Borrower number required!";
}
}
private void btnEdit_Click(object sender, EventArgs e)
{
Button btn = (Button)sender;
if (btn.Text == "Edit")
{
if (!isSelected())
{
return;
}
txtMemberCode.Text = dataGridView1.SelectedRows[0].Cells["borrowerNumber"].Value.ToString();
txtName.Text = dataGridView1.SelectedRows[0].Cells["name"].Value.ToString();
txtSex.Text = dataGridView1.SelectedRows[0].Cells["sex"].Value.ToString();
txtAddress.Text = dataGridView1.SelectedRows[0].Cells["address"].Value.ToString();
txtTelephone.Text = dataGridView1.SelectedRows[0].Cells["telephone"].Value.ToString();
txtEmail.Text = dataGridView1.SelectedRows[0].Cells["email"].Value.ToString();
displayButtons(3);
}
else
{
b = new Borrower(int.Parse(txtMemberCode.Text), txtName.Text, char.Parse(txtSex.Text), txtAddress.Text, txtTelephone.Text, txtEmail.Text);
BorrowerDAO.Update(b);
// Update in DataTable
DataTable dt = dv.Table;
DataRow[] result = dt.Select("borrowerNumber = " + b.BorrowerNumber);
DataRow row = result[0];
row["name"] = b.Name;
row["sex"] = b.Sex;
row["address"] = b.Address;
row["telephone"] = b.Telephone;
row["email"] = b.Email;
dv.RowFilter = "";
displayButtons(1);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
int add = (int)Session["add"];
int borrowerNumber = (int)Session["borrowerNumber"];
Borrower c = new Borrower();
c.BorrowerNumber = borrowerNumber;
c.Name = txtName.Text;
c.Sex = txtSex.Text.ToCharArray()[0];
c.Address = txtAdd.Text;
c.Telephone = txtPhone.Text;
c.Email = txtEmail.Text;
if (add == 1)
{
BorrowerDAO.Insert(c);
}
else
{
BorrowerDAO.Edit(c);
}
ObjectDataSource1.Select();
GridView1.DataBind();
}
protected void btCheckMember_Click(object sender, EventArgs e)
{
lbError.Visible = false;
int borrowerNumber;
try
{
borrowerNumber = int.Parse(txtMemberCode.Text);
}
catch
{
lbError.Visible = true;
lbError.Text = "Borrower number must be a integer!";
txtMemberCode.Focus();
return;
}
Borrower b = BorrowerDAO.GetBorrower(borrowerNumber);
if (b == null)
{
lbError.Visible = true;
lbError.Text = String.Format("Borrower number {0} does't exist!", borrowerNumber);
txtMemberCode.Focus();
return;
}
txtName.Text = b.Name;
View();
if (GridView1.Rows.Count >= 1)
{
lbError.Visible = true;
lbError.Text = "You has already reserved !!!";
txtMemberCode.Focus();
return;
}
displayButtons(2);
}
protected void btnSave_Click(object sender, EventArgs e)
{
int add = (int)Session["add"];
Borrower b = new Borrower();
b.Name = txtName.Text;
b.Sex = char.Parse(txtSex.Text);
b.Address = txtAddress.Text;
b.Telephone = txtTelephone.Text;
b.Email = txtEmail.Text;
if (add == 1)
{
b.BorrowerNumber = BorrowerDAO.GetBorrowerNumberMax() + 1;
BorrowerDAO.Insert(b);
}
else if (add == 2)
{
b.BorrowerNumber = Int32.Parse(GridView1.SelectedRow.Cells[1].Text);
BorrowerDAO.Update(b);
}
displayButtons(1);
ObjectDataSource1.Select();
GridView1.DataBind();
}
