public SPRecordEntity FindByLinkIDAndChannelID(SPChannelEntity spChannelEntity, string linkId)
{
var queryBuilder = new NHibernateDynamicQueryGenerator <SPRecordEntity>();
queryBuilder.AddWhereClause(PROPERTY_CHANNELID.Eq(spChannelEntity));
queryBuilder.AddWhereClause(PROPERTY_LINKID.Eq(linkId));
return(this.FindSingleEntityByQueryBuilder(queryBuilder));
}
public SPPaymentInfoEntity CheckChannleLinkIDIsExist(SPChannelEntity spChannelEntity, SPPaymentInfoEntity paymentInfo)
{
var queryBuilder = new NHibernateDynamicQueryGenerator <SPPaymentInfoEntity>();
queryBuilder.AddWhereClause(PROPERTY_CHANNELID.Eq(spChannelEntity));
queryBuilder.AddWhereClause(PROPERTY_LINKID.Eq(paymentInfo.Linkid));
return(this.FindSingleEntityByQueryBuilder(queryBuilder));
}
public SPSStatePaymentInfoEntity FindByChannelIDAndLinkID(int channelId, string linkid)
{
var queryBuilder = new NHibernateDynamicQueryGenerator <SPSStatePaymentInfoEntity>();
queryBuilder.AddWhereClause(PROPERTY_CHANNELID.Eq(channelId));
queryBuilder.AddWhereClause(PROPERTY_LINKID.Eq(linkid));
return(this.FindSingleEntityByQueryBuilder(queryBuilder));
}
public SPPaymentInfoEntity CheckChannleLinkIDIsExist(SPChannelEntity spChannelEntity, SPPaymentInfoEntity paymentInfo, List <string> uniqueKeyNames)
{
var queryBuilder = new NHibernateDynamicQueryGenerator <SPPaymentInfoEntity>();
queryBuilder.AddWhereClause(PROPERTY_CHANNELID.Eq(spChannelEntity));
queryBuilder.AddWhereClause(PROPERTY_LINKID.Eq(paymentInfo.Linkid));
if (uniqueKeyNames.Contains("mobile"))
{
queryBuilder.AddWhereClause(PROPERTY_MOBILENUMBER.Eq(paymentInfo.MobileNumber));
}
return(this.FindSingleEntityByQueryBuilder(queryBuilder));
}