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