private void DoSubscribe()
{
string email = Request.Form["email"] == null ? "" : Request.Form["email"].Trim();
string classes = Request.Form["classes"] == null ? "" : Request.Form["classes"].Trim();
if (String.IsNullOrEmpty(email) || String.IsNullOrEmpty(classes))
{
Response.Write("false");
return;
}
NewsLetter nl = new NewsLetter(email, classes);
if (nl.Save())
{
Response.Write("true");
return;
}
Response.Write("false");
}
public static ArrayList List(string cls,Pager pager)
{
/*
NewsLetterSubscriptionList
@classes varchar(30)='',
@pageindex int=1,
@pagesize int=20,
@sort int=0
*/
//[Id], Email, Classes, Status,[Datetime]
ArrayList list = new ArrayList();
SqlParameter[] prams ={
Database.MakeInParam("@classes",SqlDbType.VarChar,6,cls),
Database.MakeInParam("@pageIndex",SqlDbType.Int,pager.PageIndex),
Database.MakeInParam("@pageSize",SqlDbType.Int,pager.PageSize),
Database.MakeInParam("@sort",SqlDbType.Int,pager.SortNum)
};
SqlDataReader reader = null;
NewsLetter nl = null;
try
{
reader = Database.ExecuteReader(CommandType.StoredProcedure, "NewsLetterSubscriptionList", prams);
if (reader.Read())
{
pager.RecordCount = reader.GetInt32(0);
if (reader.NextResult())
{
while (reader.Read())
{
nl = new NewsLetter();
nl.id = reader.GetInt32(0);
nl.email = reader.GetString(1);
nl.classes = reader.GetString(2);
nl.status = reader.GetBoolean(3);
nl.datetime = reader.GetDateTime(4);
list.Add(nl);
}
}
}
reader.Close();
}
catch
{
throw;
}
finally
{
if (reader != null)
{
reader.Close();
}
}
return list;
}
public static void Remove(string email)
{
NewsLetter nl = new NewsLetter();
nl.email = email;
nl.status = false;
nl.Save();
}
