public ListMortgageDocResponse ListByUserID(long UserID)
{
ListMortgageDocResponse response = new ListMortgageDocResponse();
string sql = @"SELECT A.* FROM MortgageLoanDocs A
INNER JOIN MortgageLoanApplication B
ON A.MortgageLoanID = B.MortgageLoanID
INNER JOIN Users C
ON B.UserID = C.UserID
WHERE C.UserID = ?UserID";
try
{
using (IDbConnection conn = GetConnection())
{
response.MortgageDocs = conn.Query <MorgageLoanDocs>(sql, new { UserID }).ToList();
if (response.MortgageDocs.Count > 0)
{
response.Status = true;
response.Description = "Successful";
}
else
{
response.Status = false;
response.Description = "No data";
}
}
}
catch (Exception ex)
{
response.Status = false;
response.Description = ex.Message;
}
return(response);
}
public ListMortgageDocResponse ListByMortgageLoanID(long MortgageLoanID)
{
ListMortgageDocResponse response = new ListMortgageDocResponse();
try
{
using (IDbConnection conn = GetConnection())
{
response.MortgageDocs = conn.GetList <MorgageLoanDocs>("Where MortgageLoanID = ?MortgageLoanID", new { MortgageLoanID }).ToList();
if (response.MortgageDocs.Count > 0)
{
response.Status = true;
response.Description = "Successful";
}
else
{
response.Status = false;
response.Description = "No data";
}
}
}
catch (Exception ex)
{
response.Status = false;
response.Description = ex.Message;
}
return(response);
}
