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); }