public List<Member> GetAllMembers()
{
int count = 0;
List<Member> memberList = new List<Member>();
SqlConnection connection = new SqlConnection(connectionString);
string query = "SELECT * FROM MemberTBL";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Member aMember = new Member();
aMember.Name = reader["Name"].ToString();
aMember.Number = reader["Number"].ToString();
count++;
aMember.SerialNo = count;
memberList.Add(aMember);
}
reader.Close();
connection.Close();
return memberList;
}
public string SaveMember(Member aMember)
{
int value = memberGateway.SaveMember(aMember);
if (value > 0)
{
return "This member has been saved!";
}
else
{
return "Faild to save!";
}
}
protected void saveButton_Click(object sender, EventArgs e)
{
Member aMember=new Member();
aMember.Number = numberMemberEntryTextBox.Text;
aMember.Name = nameMemberEntryTextBox.Text;
if (memberManager.IsMemberExist(aMember))
{
mesMemberLabel.Text = "Sorry, Member already exists!";
}
else
{
mesMemberLabel.Text = memberManager.SaveMember(aMember);
memberEntryGridView.DataSource = memberManager.GetAllMembers();
memberEntryGridView.DataBind();
}
}
protected void borrowButton_Click(object sender, EventArgs e)
{
Member anMember=new Member();
anMember.Number = numberBorrowBookTextBox.Text;
if (!memberManager.IsMemberExist(anMember))
{
mesBorrowBookLabe.Text = "Sorry, member number doesn't exists!";
}
else
{
int memberId = memberManager.GetMemberId(anMember);
int bookId =int.Parse( borrowBookDropDownList.SelectedValue);
mesBorrowBookLabe.Text = memberManager.BorrowBook(memberId, bookId);
borrowBookGridView.DataSource = borrowBookManager.BorrowedBookList();
borrowBookGridView.DataBind();
}
}
public Member GetMemberInformation(int id)
{
Member aMember = new Member();
SqlConnection connection = new SqlConnection(connectionString);
string query = "SELECT * FROM MemberTBL WHERE Id='" + id + "'";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
aMember.Name = reader["Name"].ToString();
}
reader.Close();
connection.Close();
return aMember;
}
public int GetMemberId(Member aMember)
{
int memberId = 0;
SqlConnection connection = new SqlConnection(connectionString);
string query = "SELECT * FROM MemberTBL WHERE Number='" + aMember.Number + "'";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
memberId = int.Parse(reader["Id"].ToString());
}
reader.Close();
connection.Close();
return memberId;
}
public void ShowAllBooks()
{
Member aMember = new Member();
aMember.Number = numberReturnBookTextBox.Text;
if (!memberManager.IsMemberExist(aMember))
{
mesReturnLabel.Text = "Sorry, member number doesn't exists!";
}
else
{
int memberId = memberManager.GetMemberId(aMember);
returnBookDropDownList.DataSource = bookManager.GetBorrowBooks(memberId);
returnBookDropDownList.DataTextField = "Title";
returnBookDropDownList.DataValueField = "Id";
returnBookDropDownList.DataBind();
returnGridView.DataSource = bookManager.GetBorrowBooks(memberId);
returnGridView.DataBind();
}
}
public bool IsMemberExist(Member aMember)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "SELECT * FROM MemberTBL WHERE Number='" + aMember.Number + "'";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
reader.Close();
connection.Close();
return true;
}
else
{
reader.Close();
connection.Close();
return false;
}
}
public int SaveMember(Member aMember)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "INSERT INTO MemberTBL VALUES('" + aMember.Number + "','" + aMember.Name + "')";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
int rowAffected = command.ExecuteNonQuery();
connection.Close();
return rowAffected;
}
public bool IsMemberExist(Member aMember)
{
return memberGateway.IsMemberExist(aMember);
}
public int GetMemberId(Member aMember)
{
return memberGateway.GetMemberId(aMember);
}
