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