example repo

namespace mediflow.Areas.Account.Repository
{
    public class AcLedgerRepository
    {
        DBAll db = new DBAll();
        public List<AcLedgerReportModel> GetLedgerReport(DateTime? FromDate, DateTime? Todate, decimal? groupId, decimal? ledgerId, int yearid, int branchid)
        {
            try
            {
                List<AcLedgerReportModel> Data;
                db.connection();
                db.con.Open();

                DynamicParameters parm = new DynamicParameters();
                parm.Add("@fromDate", FromDate);
                parm.Add("@toDate", Todate);
                parm.Add("@accountGroupId", groupId);
                parm.Add("@ledgerId", ledgerId);
                parm.Add("@financialyearid", yearid);
                parm.Add("@branchid", branchid);
                Data = SqlMapper.Query<AcLedgerReportModel>(db.con, "AccountLedgerReportFill", parm, commandType: System.Data.CommandType.StoredProcedure).ToList();
                return Data;
            }
            catch (Exception ex)
            {
                throw ex;
            }

            finally
            {
                db.con.Close();
            }
        }
   }
}