public static QueuedEmailCollection Search(SearchFilter SearchKey) { QueuedEmailCollection collection = new QueuedEmailCollection(); using (var reader = SqlHelper.ExecuteReader("QueuedEmail_Search", SearchFilterManager.SqlSearchParam(SearchKey))) { while (reader.Read()) { QueuedEmail obj = new QueuedEmail(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
public static QueuedEmailCollection ReminderContractEmailList(int CompanyID) { QueuedEmailCollection collection = new QueuedEmailCollection(); //var sqlParams = new SqlParameter[1]; //sqlParams[0] = new SqlParameter("@isActive", isActive); using (var reader = SqlHelper.ExecuteLongReaderService(ModuleConfig.MyConnection, 600, "USP_CMS_JOB_Reminder_Fetch_V1", null)) { QueuedEmail obj = new QueuedEmail(); while (reader.Read()) { obj = GetQueMessageFromReader(reader, CompanyID); collection.Add(obj); } } return(collection); }
public static QueuedEmailCollection GetbyUser(string CreatedUser, int CompanyID) { QueuedEmailCollection collection = new QueuedEmailCollection(); QueuedEmail obj; var sqlParams = new SqlParameter[] { new SqlParameter("@CreatedUser", CreatedUser), new SqlParameter("@CompanyID", CompanyID), }; using (var reader = SqlHelper.ExecuteReader("QueuedEmail_GetAll_byUser", sqlParams)) { while (reader.Read()) { obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
public static QueuedEmailCollection GetAllItem(int CompanyID) { QueuedEmailCollection collection = new QueuedEmailCollection(); var sqlParams = new SqlParameter[] { new SqlParameter("@CompanyID", CompanyID), }; using (var reader = SqlHelper.ExecuteReader("QueuedEmail_GetAll", sqlParams)) { while (reader.Read()) { QueuedEmail obj = new QueuedEmail(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }