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