protected void Button1_Click(object sender, EventArgs e)
{
Member aMember = new Member();
aMember.Number = memberNoTextBox.Text;
int memberId = memberManager.GatMemberId(aMember);
borrowedBookDropDownList.DataSource = memberManager.GetBookId(memberId);
borrowedBookDropDownList.DataTextField = "Title";
borrowedBookDropDownList.DataBind();
}
protected void saveButton_Click(object sender, EventArgs e)
{
Member aMember = new Member();
aMember.Number = numberTextBox.Text;
aMember.Name = nameTextBox.Text;
if(memberManager.IfNymberExists(aMember)){
msgMemberLabel.Text = "Sorry, Member already exists.";
return;
}
msgMemberLabel.Text = memberManager.SaveMember(aMember);
}
public string SaveMember(Member aMember)
{
int value = memberGateway.SaveMember(aMember);
if (value > 0)
{
return "This Member has been saved.";
}
else
{
return "Sorry! Member saved failed.";
}
}
protected void returnButton_Click(object sender, EventArgs e)
{
Member aMember = new Member();
aMember.Number = memberNoTextBox.Text;
int memberid= memberManager.GatMemberId(aMember);
if (memberManager.ReturnBook(memberid))
{
return;
}
else
{
return;
}
}
public int GetMemberId(Member aMember)
{
int id = 0;
string query = "SELECT * FROM Member_tbl WHERE Number='" + aMember.Number + "'";
SqlConnection connection = new SqlConnection(connectionString);
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while(reader.Read()){
id = int.Parse(reader["Id"].ToString());
}
return id;
}
protected void borrowButton_Click(object sender, EventArgs e)
{
Member aMember = new Member();
aMember.Number = memberNoTextBox.Text;
int memberid = memberManager.GatMemberId(aMember);
int bookId = int.Parse(bookDropDownList.SelectedValue);
if(!memberManager.IfNymberExists(aMember)){
msgBorrowLabel.Text = "Sorry, member number does not exists.";
return;
}
memberManager.SaveBorrowBook(memberid, bookId);
msgBorrowLabel.Text = "This Book is borrowed by member whose number is:"+aMember.Number;
}
public bool IfNumberExist(Member aMember)
{
string query = "SELECT * FROM Member_tbl WHERE Number='" + aMember.Number + "'";
SqlConnection connection = new SqlConnection(connectionString);
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
return true;
}
else
{
return false;
}
}
public int SaveMember(Member aMember)
{
string query = "INSERT INTO Member_tbl Values('" +aMember.Number + "','" + aMember.Name + "')";
SqlConnection connection = new SqlConnection(connectionString);
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
int rowAffect = command.ExecuteNonQuery();
connection.Close();
return rowAffect;
}
public bool IfNymberExists(Member aMember)
{
return memberGateway.IfNumberExist(aMember);
}
public int GatMemberId(Member aMember)
{
return memberGateway.GetMemberId(aMember);
}
