private void Updatebutton_Click(object sender, EventArgs e) { DiryAccess diryAccess = new DiryAccess(); int id = int.Parse(dataGridView1.CurrentRow.Cells[0].Value.ToString()); if (MessageBox.Show("Are you sure want to update this Event?", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { int rows = dataGridView1.RowCount; for (int i = rows - 1; i >= 0; i--) { if (dataGridView1.Rows[i].Selected) { DiaryServices diaryServiice = new DiaryServices(); MemoryStream ms2 = new MemoryStream(); byte[] img_arry = new byte[ms2.Length]; ms2.Read(img_arry, 0, img_arry.Length); //string date = EventdateTime.Value.ToString() ; int result = diaryServiice.UpdateOldEvent(EperiencetextBox.Text, ThoughttextBox.Text, FellingstextBox.Text, importancecomboBox.Text, img_arry, EventdateTime.Value.ToString(), id); if (result > 0) { MessageBox.Show("Event added successfully."); } else { MessageBox.Show("Error in adding Event"); } } } } }
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)); }
private void Deletebutton_Click(object sender, EventArgs e) { DiryAccess diryAccess = new DiryAccess(); int id = int.Parse(dataGridView1.CurrentRow.Cells[0].Value.ToString()); if (MessageBox.Show("Are you sure want to delete this Event?", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { int rows = dataGridView1.RowCount; for (int i = rows - 1; i >= 0; i--) { if (dataGridView1.Rows[i].Selected) { diryAccess.DeleteEvent(id); } } } }
public DiaryServices() { this.diaryAccess = new DiryAccess(); this.dataAccess = new DataAccesscs(); }