public static LTD_Subscriber GetLtdSubscriber(string subscriberEmail) { LTD_Subscriber ltdSubscriber = null; Database db = HaveDb(); if (db != null) { long totalPages =0; long totalItems = 0; List<LTD_Subscriber> subscriberList = DataSource.GetPagedLtdSubscriber(1, 1, out totalPages, out totalItems, "", " Where SubscriberEmail=@0", subscriberEmail); if (totalItems > 0) { ltdSubscriber = subscriberList[0]; } } else { Dictionary<Guid, LTD_Subscriber> allLtdSubscriberList = FileSource.LoadLTDSubscriberData(); foreach (KeyValuePair<Guid, LTD_Subscriber> item in allLtdSubscriberList) { if (item.Value.SubscriberEmail == subscriberEmail) { ltdSubscriber = item.Value; break; } } } return ltdSubscriber; }
public static long GetLtdSubscriberCount() { long ltdSubscriberCount = 0; Database db = HaveDb(); if (db != null) { ltdSubscriberCount = db.Single<long>("SELECT COUNT(*) AS TOTAL_COUNT FROM LTD_Subscriber "); } else { Dictionary<Guid, LTD_Subscriber> fileLTDSubscriberList = FileSource.LoadLTDSubscriberData(); ltdSubscriberCount = fileLTDSubscriberList.Count; } return ltdSubscriberCount; }