mynoteservice.cs

will let you know the result once they replied will let you know the result once they replied

using System;
using System.Collections.Generic;
using System.Text;
using MyOffice.Models;
using MyOffice.DBUtility;
using System.Data;
using System.Data.SqlClient;

namespace MyOffice.DAL
{
    public class MyNoteService
    {
        public IList<MyNote> GetAllNotes()
        {
            IList<MyNote> list = new List<MyNote>();
            string sql = string.Format(@"select * from mynote");
            using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql, null))
            {
                while (reader.Read())
                {
                    MyNote note = new MyNote();
                    note.NoteId = reader.GetInt32(0);
                    note.NoteTitle = reader.GetString(1);
                    note.NoteContent = reader.GetString(2);
                    note.CreateTime = reader.GetDateTime(3);
                    note.CreateUser = reader.GetString(4);
                    list.Add(note);
                }
                return list;
            }
        }

        public int AddNewNote(MyNote note)
        {
            int flag = -1;
            string sql = string.Format(@"insert mynote(notetile,notecontent,createtime,createuser)values
                (@notetile,@notecontent,@createtime,@createuser)");
            SqlParameter[] para = new SqlParameter[]
            {
                new SqlParameter("@notetile",note.NoteTitle),
                new SqlParameter("@notecontent",note.NoteContent),
                new SqlParameter("@createtime",note.CreateTime),
                new SqlParameter("@createuser",note.CreateUser)
            };
            flag = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction,CommandType.Text,sql,para);
            return flag;
        }
    }
}