public int Return(int memberId, int bookId) { var parameters = new[] { new SqlParameter(BorrowParameters.MemberId, memberId), new SqlParameter(BorrowParameters.BookId, bookId) }; return(SqlWrapper.ExecuteProcedure(StoredProceduresName.ReturnABook, parameters)); }
public int Renew(int memberId, string membershipName) { var parameters = new[] { new SqlParameter(MemberParameters.Id, memberId), new SqlParameter(MemberParameters.MembershipName, membershipName) }; return(SqlWrapper.ExecuteProcedure(StoredProceduresName.RenewMembership, parameters)); }
public int Lend(int memberId, int bookId, int employeeId) { var parameters = new[] { new SqlParameter(BorrowParameters.MemberId, memberId), new SqlParameter(BorrowParameters.BookId, bookId), new SqlParameter(BorrowParameters.LendedBy, employeeId) }; return(SqlWrapper.ExecuteProcedure(StoredProceduresName.LendABook, parameters)); }
public int Add(MemberEntity member) { var parameters = new[] { new SqlParameter(MemberParameters.FirstName, member.FirstName), new SqlParameter(MemberParameters.LastName, member.LastName), new SqlParameter(MemberParameters.Email, member.Email), new SqlParameter(MemberParameters.PhoneNumber, member.PhoneNumber), new SqlParameter(MemberParameters.Gender, member.Gender), new SqlParameter(MemberParameters.City, member.City), new SqlParameter(MemberParameters.MembershipName, member.MembershipName) }; return(SqlWrapper.ExecuteProcedure(StoredProceduresName.AddMember, parameters)); }
public int Update(MemberEntity member) { var parameters = new[] { new SqlParameter(MemberParameters.Id, member.ID), new SqlParameter(MemberParameters.FirstName, member.FirstName), new SqlParameter(MemberParameters.LastName, member.LastName), new SqlParameter(MemberParameters.Email, member.Email), new SqlParameter(MemberParameters.PhoneNumber, member.PhoneNumber), new SqlParameter(MemberParameters.Gender, member.Gender), new SqlParameter(MemberParameters.City, member.City) }; return(SqlWrapper.ExecuteProcedure(StoredProceduresName.UpdateMember, parameters.ToArray())); }
public int Delete(int memberId) { var id = new SqlParameter(MemberParameters.Id, memberId); return(SqlWrapper.ExecuteProcedure(StoredProceduresName.DeleteMember, id)); }
public int Add(BookEntity book) { var parameters = ParseBookIntoParameters(book); return(SqlWrapper.ExecuteProcedure(StoredProceduresName.AddBook, parameters)); }
public int Delete(int bookId) { var id = new SqlParameter(BookParameters.Id, bookId); return(SqlWrapper.ExecuteProcedure(StoredProceduresName.DeleteBook, id)); }