private void Updatebutton_Click(object sender, EventArgs e)
{
Student stu = new Student();
if (StudentDataGridView.CurrentRow.Index != -1)
{
stu.Id = Convert.ToInt32(StudentDataGridView.CurrentRow.Cells["Id"].Value);
stu.StudentID = Convert.ToString(StudentDataGridView.CurrentRow.Cells["StudentID"].Value);
stu = ctx.Students.Where(q => q.StudentID == stu.StudentID).FirstOrDefault();
stu.StudentID = studentTb.Text;
stu.L_Name = lnameTb.Text;
stu.F_Name = fnameTb.Text;
stu.Class = classTb.Text;
try
{
ctx.Entry(stu).State = System.Data.Entity.EntityState.Modified;
ctx.SaveChanges();
PopulateDataGridView();
clear();
MessageBox.Show("Book updated successfully");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error cancel", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void userdeletebtn_Click(object sender, EventArgs e)
{
User model3 = new User();
if (UserDataGridView.CurrentRow.Index != -1)
{
model3.Id = Convert.ToInt32(UserDataGridView.CurrentRow.Cells["userid"].Value);
model3.User_Name = Convert.ToString(UserDataGridView.CurrentRow.Cells["username"].Value);
model3 = ctx.Users.Where(q => q.Id == model3.Id).FirstOrDefault();
try
{
MessageBox.Show("Do you really want to delete this record?", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
ctx.Entry(model3).State = System.Data.Entity.EntityState.Deleted;
ctx.SaveChanges();
UpdateDataViewGrid();
MessageBox.Show("Record was deleted successfully");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error cancel", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void updatebutton_Click(object sender, EventArgs e)
{
Book bk = new Book();
if (dataGridView1.CurrentRow.Index != -1)
{
bk.Id = Convert.ToInt32(dataGridView1.CurrentRow.Cells["Id"].Value);
bk = ctx.Books.Where(q => q.Id == bk.Id).FirstOrDefault();
bk.Category = booksubjectTb.Text;
bk.Title = booktitleTb.Text;
bk.Author = authorTb.Text;
bk.Publisher = publisherTb.Text;
bk.Year_Released = yearTb.Text;
bk.ISBN = isbnTb.Text;
bk.Num_of_Copies = numcopiesTb.Text;
bk.Pages = pagesTb.Text;
bk.Shelf_Number = shelfnumberTb.Text;
try
{
ctx.Entry(bk).State = System.Data.Entity.EntityState.Modified;
ctx.SaveChanges();
PopulateDataGridView();
clear();
MessageBox.Show("Book updated successfully");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error cancel", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void addperiodbutton_Click(object sender, EventArgs e)
{
Period pd = new Period();
if (PeriodicalDataGridView.CurrentRow.Index != -1)
{
pd.Id = Convert.ToInt32(PeriodicalDataGridView.CurrentRow.Cells["Id"].Value);
pd = ctx.Periods.Where(q => q.Id == pd.Id).FirstOrDefault();
pd.P_Category = categoryTb.Text;
pd.Name = periodicalnameTb.Text;
pd.ISBN = isbnTb.Text;
pd.Volume_Number = volumenumberTb.Text;
pd.Year = yearTb.Text;
pd.Page_Number = pagenumberTb.Text;
pd.Shelf_Num = shelfnumberTb.Text;
try
{
ctx.Entry(pd).State = System.Data.Entity.EntityState.Added;
ctx.SaveChanges();
clear();
UpdateDataViewGrid();
MessageBox.Show("Periodical added successfully");
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Error Please cancel ");
}
}
}