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); }