many to many relationship master detail editing
I changed Enrollment to Registration. Here is the table:
The only requirement is you can see student table and registration table, like:
v | Studid| Firstname| Lastname| Street| City| DOB|
CourseName
And then you can add or delete courses through that CourseName detail grid, which adds or removes a row in registration. Also, you can do CRUD for a Student row in the master grid.
The only code I know are these, as you can see, there is no detail grid editing handler:
public static List<Student> GetStudent()
{
List<Student> student = new List<Student>() {
new Student { Studid=1, Firstname= "Peter", Lastname="Suresh", Street="1 Santa Street", City="Mexico", DOB=new DateTime(2025, 02, 23)},
new Student { Studid=2, Firstname= "Sarah", Lastname="Dimino", Street="2 Rocket Street", City="Mexico", DOB=new DateTime(2025, 02, 23)}
};
return student;
}
public static List<Course> GetCourse()
{
List<Course> course = new List<Course>() {
new Course { Courseid=1, Coursename= "A class", Duration=5, Fees=2000},
new Course { Courseid=2, Coursename= "B class", Duration=6, Fees=2000}
};
return course;
}
public class Course
{
public int Courseid { get; set; }
public string Coursename { get; set; }
public int Duration { get; set; }
public int Fees { get; set; }
public IList<Registration> registration { get; set; } = new List<Registration>();
}
public class Student
{
public int Studid { get; set; }
public string Firstname { get; set; }
public string Lastname { get; set; }
public string Street { get; set; }
public string City { get; set; }
public DateTime DOB { get; set; }
public IList<Registration> registration { get; set; } = new List<Registration>();
}
And, after the master grid is edited, this is called:
public void GridEdited(Syncfusion.Blazor.Grids.ActionEventArgs<GanttSegClass> Args)
{
if (Args.RequestType.Equals(Syncfusion.Blazor.Grids.Action.Save))
{
if (Args.Action == "Add")
{
//Add
}
else
{
//Update
}
}
if (Args.RequestType.Equals(Syncfusion.Blazor.Grids.Action.Delete))
{
//Delete
}
}
Except the codes in GridEdited should look similar (coz I know someone prefer SfDataManager), other codes provided could be changed.
I think I am not the first asking how to edit normalized many to many relationships using master detail.
