CCN.Modules.Car.DataAccess.CarDataAccess.GetFinanceProgrammeDetailByFid C# (CSharp) Method

        public IEnumerable<FinanceProgrammeDetailModel> GetFinanceProgrammeDetailByFid(string financeid)
        {
            StringBuilder sql = new StringBuilder(@"select * from finance_programme_detail
                                where 1=1 and financeid=@financeid order by type;");

            try
            {
                var list = Helper.Query<FinanceProgrammeDetailModel>(sql.ToString(), new { financeid });
                return list;
            }
            catch (Exception ex)
            {
                return null;
            }
        }