// Customer details belong to NND campaign type
public async ValueTask <object> CustomerDetailsBelongToNNDCampaignType(string id)
{
try
{
ContactPCC contact = GetContactPCCByContactId(id);
if (contact == null)
{
throw new Exception("Not found");
}
if (contact.CAMPAIGN_CATEGORY_ID == new Guid("E259EE32-21A0-417D-B4B2-2B8E5CBDE9B2") || contact.CAMPAIGN_CATEGORY_ID == new Guid("4D90412A-49F7-47C9-8484-68AF5DB70B44"))
{
return(await WithConnection(async conn =>
{
string sql = "Select PCC_CIC_RESULT, PCC_MAX_LIMIT, PCC_LAST_RESULT, PCC_CIC_RESULT_DATE, PCC_PCC_RESULT_DATE, PCC_NOTE,PCC_RESOLUTION, PCC_NOTE_2, PCC_LOAN_TYPE, PCC_REASON," +
"PCC_NOTE_3,PCC_STATUS FROM vwCIC_PCC WHERE CONTACT_ID_C = @CONTACT_ID_C";
var query = await conn.QueryFirstOrDefaultAsync <object>(sql, new { CONTACT_ID_C = new Guid(id) });
return query;
}));
}
}
catch (Exception e)
{
throw e;
}
throw new Exception("Not found");
}
public async ValueTask <object> CustomerDetailsBelongToExpireCampaignType(string id)
{
ContactPCC contact = GetContactPCCByContactId(id);
if (contact == null)
{
throw new Exception("Not found");
}
if (contact.CAMPAIGN_CATEGORY_ID == new Guid("9A5F5C2F-C947-484D-8E72-E1C6FCEAC72D") || contact.CAMPAIGN_CATEGORY_ID == new Guid("D3537DAD-54A9-4A7F-B66D-F816A6D6E7EA"))
{
return(await WithConnection(async conn =>
{
string sql = "Select PCC_CIC_RESULT, PCC_MAX_LIMIT, PCC_LAST_RESULT, PCC_CIC_RESULT_DATE, PCC_PCC_RESULT_DATE, PCC_NOTE,PCC_RESOLUTION, PCC_NOTE_2, PCC_LOAN_TYPE, PCC_REASON," +
"PCC_NOTE_3,PCC_STATUS FROM vwCIC_PCC WHERE CONTACT_ID_C = @CONTACT_ID_C";
var query = await conn.QueryFirstOrDefaultAsync <object>(sql, new { CONTACT_ID_C = new Guid(id) });
return query;
}));
}
throw new Exception("Not found");
}
public async ValueTask <object> CustomerDetailsBelongToLendingCampaignType(string id)
{
ContactPCC contact = GetContactPCCByContactId(id);
if (contact == null)
{
throw new Exception("Not found");
}
if (contact.CAMPAIGN_CATEGORY_ID == new Guid("AF7E7C77-5FCE-410D-A8FD-BDCF0F2540AF") || contact.CAMPAIGN_CATEGORY_ID == new Guid("3FF440A0-D677-4B56-B221-7AA4F1DDFDA2"))
{
return(await WithConnection(async conn =>
{
string sql = "Select PCC_CIC_RESULT, PCC_MAX_LIMIT, PCC_LAST_RESULT, PCC_CIC_RESULT_DATE, PCC_PCC_RESULT_DATE, PCC_NOTE,PCC_RESOLUTION, PCC_NOTE_2, PCC_LOAN_TYPE, PCC_REASON," +
"PCC_NOTE_3,PCC_STATUS FROM vwCIC_PCC WHERE CONTACT_ID_C = @CONTACT_ID_C";
var query = await conn.QueryFirstOrDefaultAsync <object>(sql, new { CONTACT_ID_C = new Guid(id) });
return query;
}));
}
throw new Exception("Not found");
}
