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