/// <summary> /// Gets a collection of OutgoingSMS objects by a CustomerList object. /// </summary> /// <param name="customerList">customerList</param> /// <param name="startRowIndex"></param> /// <param name="pageSize"></param> /// <param name="totalRows"></param> /// <returns>A collection OutgoingSMS objects.</returns> public static EntityList<OutgoingSMS> GetOutgoingSMsBycustomerlist_(CustomerList @customerlist_, long startRowIndex, int pageSize, out long totalRows) { string commandText = @" FROM [dbo].[OutgoingSMS] WHERE [OutgoingSMS].[customerlist_id] = @customerlist_id "; List<SqlParameter> parameters = new List<SqlParameter>(); parameters.Add(new SqlParameter("@customerlist_id", @customerlist_.customerlist_id)); return GetList<OutgoingSMS>(SelectFieldList, commandText, parameters, null, startRowIndex, pageSize, out totalRows); }
/// <summary> /// Gets a collection of OutgoingSMS objects by a CustomerList object. /// </summary> /// <param name="customerlist_">customerlist_</param> /// <returns>A collection OutgoingSMS objects.</returns> public static EntityList<OutgoingSMS> GetOutgoingSMsBycustomerlist_(CustomerList @customerlist_) { string commandText = "OutgoingSMSGetByCustomerList"; List<SqlParameter> parameters = new List<SqlParameter>(); parameters.Add(new SqlParameter("@customerlist_id", @customerlist_.customerlist_id)); return GetList<OutgoingSMS>(@customerlist_, commandText, parameters); }
/// <summary> /// Create a new OutgoingSMS object from a CustomerList object. /// </summary> /// <param name="customerlist_">customerlist_</param> /// <returns>The newly created OutgoingSMS object.</returns> public static OutgoingSMS CreateOutgoingSMSBycustomerlist_(CustomerList @customerlist_) { OutgoingSMS outgoingSMS = InitializeNew<OutgoingSMS>(); outgoingSMS.customerlist_id = @customerlist_.customerlist_id; outgoingSMS.customerlist_ = @customerlist_; return outgoingSMS; }
/// <summary> /// Deletes OutgoingSMS objects by a CustomerList object. /// </summary> /// <param name="customerList">customerList</param> public static void DeleteOutgoingSMsBycustomerlist_(CustomerList customerList) { string commandText = "OutgoingSMSDeleteByCustomerList"; System.Collections.Generic.List<SqlParameter> parameters = new System.Collections.Generic.List<SqlParameter>(); parameters.Add(new SqlParameter("@customerlist_id", customerList.customerlist_id)); using (SqlHelper helper = new SqlHelper()) { helper.Execute(commandText, CommandType.StoredProcedure, parameters); } }
protected void Page_Load(object sender, EventArgs e) { loggedInAdmin = Helpers.GetLoggedInAdmin(); currentCompany = Helpers.GetCurrentCompany(); currentList = Helpers.GetCurrentList(); CheckPermission(); PopuplateBreadcrumbs(); EnableMailchimp(); if (!IsPostBack) { PopulateCustomers(); } }