public Memo(MemoEntity entity)
{
Id = entity.Id;
Sender = entity.Sender;
Message = entity.Message;
Received = entity.Received;
}
public List <MemoEntity> GetMemos()
{
List <MemoEntity> lst = new List <MemoEntity>();
SqlConnection con = new SqlConnection(
WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
SqlCommand cmd = new SqlCommand("Select * From Memos Order By Num Desc", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds, "Memos");
DataTable dt = ds.Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
MemoEntity objMemo = new MemoEntity();
objMemo.Num = Convert.ToInt32(dt.Rows[i]["Num"]);
objMemo.Name = dt.Rows[i]["Name"].ToString();
objMemo.Email = dt.Rows[i]["Email"].ToString();
objMemo.Title = dt.Rows[i]["Title"].ToString();
objMemo.PostDate = Convert.ToDateTime(dt.Rows[i]["PostDate"]);
objMemo.PostIP = dt.Rows[i]["PostIP"].ToString();
lst.Add(objMemo);
}
return(lst);
}
public List <MemoEntity> GetMemosByPage(int page, int pageSize)
{
List <MemoEntity> lst = new List <MemoEntity>();
SqlConnection con = new SqlConnection(
WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
string strSql = @"
With MemoLists
As
(
Select
Num, Name, Email, Title, PostDate, PostIP,
ROW_NUMBER() Over (Order By Num Desc) As 'RowNumber'
From Memos
)
Select * From MemoLists
Where RowNumber
Between " + ((page - 1) * pageSize + 1).ToString() + @" And " + (page * pageSize).ToString() + @"";
SqlCommand cmd = new SqlCommand(strSql, con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds, "Memos");
DataTable dt = ds.Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
MemoEntity objMemo = new MemoEntity();
objMemo.Num = Convert.ToInt32(dt.Rows[i]["Num"]);
objMemo.Name = dt.Rows[i]["Name"].ToString();
objMemo.Email = dt.Rows[i]["Email"].ToString();
objMemo.Title = dt.Rows[i]["Title"].ToString();
objMemo.PostDate = Convert.ToDateTime(dt.Rows[i]["PostDate"]);
objMemo.PostIP = dt.Rows[i]["PostIP"].ToString();
lst.Add(objMemo);
}
return(lst);
}
public void Update(MemoEntity item)
{
_context.Memos.Update(item);
}
public void Add(MemoEntity item)
{
_context.Memos.Add(item);
}
