/// <summary>
/// SelectMemberHistories() method
/// - Select MemberHistory table row by fromDate and toDate
/// </summary>
/// <param name="fromDate">From date</param>
/// <param name="toDate">To date</param>
/// <returns></returns>
public List <MemberHistory> SelectMemberHistories(DateTime fromDate, DateTime toDate)
{
try
{
using (connection)
{
connection.Open();
return((List <MemberHistory>)OracleDataHelperFactory.SelectMultipleEntities <MemberHistory>(connection,
typeof(MemberHistory),
CommandType.Text,
@"SELECT Seq, MemberID, MemberName, IsSuccess, Message, InsertedDate " +
@"FROM Product.MemberHistory " +
@"WHERE InsertedDate >= :FromDate AND InsertedDate <= :ToDate " +
@"ORDER BY InsertedDate DESC ",
OracleParameterHelperFactory.CreateParameter(providerName, ":FromDate", fromDate, ParameterDirection.Input),
OracleParameterHelperFactory.CreateParameter(providerName, ":ToDate", toDate, ParameterDirection.Input)
));
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// SelectMemberHistories() method
/// - Select MemberHistory table row by fromDate and toDate
/// </summary>
/// <param name="fromDate">From date</param>
/// <param name="toDate">To date</param>
/// <returns></returns>
public List <MemberHistory> SelectMemberHistories(DateTime fromDate, DateTime toDate)
{
try
{
using (connection)
{
connection.Open();
return((List <MemberHistory>)OracleDataHelperFactory.SelectMultipleEntities <MemberHistory>(connection,
typeof(MemberHistory),
CommandType.StoredProcedure,
"Product.sp_Select_MemberHistories_Date",
OracleParameterHelperFactory.CreateParameter(providerName, ":FromDate", fromDate, ParameterDirection.Input),
OracleParameterHelperFactory.CreateParameter(providerName, ":ToDate", toDate, ParameterDirection.Input),
OracleParameterHelperFactory.CreateParameter <OracleDbType>(providerName, ":OutputData", null, OracleDbType.RefCursor, ParameterDirection.Output)
));
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// SelectMembers method
/// - Select Member table rows by memberName
/// </summary>
/// <param name="memberName">Member name</param>
/// <returns></returns>
public List <Member> SelectMembers(string memberName)
{
try
{
using (connection)
{
connection.Open();
List <Member> ret = (List <Member>)OracleDataHelperFactory.SelectMultipleEntities <Member>(connection,
typeof(Member),
CommandType.StoredProcedure,
"Product.sp_Select_Members_By_MemName",
OracleParameterHelperFactory.CreateParameter(providerName, ":MemName", String.Format("%{0}%", memberName), ParameterDirection.Input),
OracleParameterHelperFactory.CreateParameter <OracleDbType>(providerName, ":OutputData", null, OracleDbType.RefCursor, ParameterDirection.Output)
);
return(ret);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// SelectMembers method
/// - Select Member table rows by memberName
/// </summary>
/// <param name="memberName">Member name</param>
/// <returns></returns>
public List <Member> SelectMembers(string memberName)
{
try
{
using (connection)
{
connection.Open();
List <Member> ret = (List <Member>)OracleDataHelperFactory.SelectMultipleEntities <Member>(connection,
typeof(Member),
CommandType.Text,
@"SELECT MemberID, MemberName, IsAvailable, Email, PhoneNumber, Address, InsertedDate, UpdatedDate " +
@"FROM Product.Member " +
@"WHERE MemberName LIKE '%" + memberName + "%' "
);
return(ret);
}
}
catch (Exception ex)
{
throw ex;
}
}
