示例#1
0
        public int UpdateEvent(Diry diry)
        {
            string sql    = "UPDATE DiryTabel SET Experience='" + diry.Experience + "',Thought=" + diry.Thought + ",Fellings=" + diry.Fellings + ",Importance=" + diry.Importance + " Picture=" + diry.Picture + " EventDate=" + diry.EventDate + " WHERE ProductId=" + diry.Number;
            int    result = dataAccess.ExecuteQuery(sql);

            return(result);
        }
示例#2
0
        public int InsertEvent(Diry diary)
        {
            var sql = "INSERT INTO DiryTabel(UserId,Experience,Thought,Fellings,Importance,Picture,EventDate) VALUES('" + Utility.UserId + "','" + diary.Experience + "','" + diary.Thought + "','" + diary.Fellings + "','" + diary.Importance + "','" + diary.Picture + "','" + diary.EventDate + "')";

            using (var sqlCon = new SqlConnection(_connectionString))
            {
                var cmd = new SqlCommand(@sql, sqlCon);
                sqlCon.Open();
                var isInserted = cmd.ExecuteNonQuery();
                sqlCon.Close();
                return(isInserted);
            }
        }
示例#3
0
        public int AddNewEvent(string Experience, string Thought, string Fellings, string Importance, byte[] Picture, string EventDate)
        {
            Diry diary = new Diry();

            diary.Experience = Experience;
            diary.Thought    = Thought;
            diary.Fellings   = Fellings;
            diary.Importance = Importance;
            diary.Picture    = Picture;
            diary.EventDate  = EventDate;

            DiryAccess diaryAccess = new DiryAccess();

            return(this.diaryAccess.InsertEvent(diary));
        }
示例#4
0
        public List <Diry> GetEvent()
        {
            string        sql    = "SELECT * FROM DiryTabel WHERE UserId=" + Utility.UserId;
            SqlDataReader reader = this.dataAccess.GetData(sql);
            List <Diry>   diries = new List <Diry>();

            while (reader.Read())
            {
                Diry diry = new Diry();
                diry.Number     = (int)reader["Id"];
                diry.UserId     = (int)reader["UserId"];
                diry.Experience = reader["Experience"].ToString();
                diry.Thought    = reader["Thought"].ToString();
                diry.Fellings   = reader["Fellings"].ToString();
                diry.Importance = reader["Importance"].ToString();
                //diry.Picture = (byte[])reader["Picture"];
                diry.EventDate = reader["EventDate"].ToString();
                diries.Add(diry);
            }
            return(diries);
        }