private void removeBanch_Click(object sender, RoutedEventArgs e) { BranchClass brancheselect = new BranchClass(); brancheselect = branch.SelectedItem as BranchClass; var query = (from branch in context3.branches where branch.Name == brancheselect.Name select branch).FirstOrDefault(); branch branchesupdated = context3.branches.Where(em => em.Name == query.Name).FirstOrDefault(); context3.branches.Remove(branchesupdated); context3.SaveChanges(); }
private void AddBranch_Click(object sender, RoutedEventArgs e) { BranchClass newBracnh = new BranchClass(); newBracnh.Name = BranchLocation_textbox.Text.ToString(); newBracnh.Year = branchdate.DisplayDate; var counter = 1; var BranchAddedToDataBase = new branch { BranchId = (++counter), Name = newBracnh.Name, Year = newBracnh.Year, }; context3.branches.Add(BranchAddedToDataBase); context3.SaveChanges(); branch.Items.Add(BranchAddedToDataBase); }
private void updateBranch_Click(object sender, RoutedEventArgs e) { BranchClass branchselect = new BranchClass(); branchselect = branch.SelectedItem as BranchClass; var query = (from branch in context3.branches where branch.Name == branchselect.Name select branch).FirstOrDefault(); branch branchesupdated = context3.branches.Where(em => em.Name == query.Name).FirstOrDefault(); branchesupdated.Name = (BranchLocation_textbox.Text.ToString()); branchesupdated.Year = DateTime.Now; context3.SaveChanges(); }
private void removeBanch_Click(object sender, RoutedEventArgs e) { try { BranchClass brancheselect = new BranchClass(); brancheselect = branch.SelectedItem as BranchClass; var query = (from branch in context3.branches where branch.Name == brancheselect.Name select branch).FirstOrDefault(); branch branchesupdated = context3.branches.Where(em => em.Name == query.Name).FirstOrDefault(); context3.branches.Remove(branchesupdated); context3.SaveChanges(); } catch (Exception f) { MessageBox.Show("invalid inputs"); } }
private void addstudent_Click(object sender, RoutedEventArgs e) { try { track addtrackstudent = new track(); intake addintakstudent = new intake(); branch addbranchstudent = new branch(); user studentuser = new user(); rel_branch_track_intake ITb = new rel_branch_track_intake(); student newstudent = new student(); newstudent.StuId = int.Parse(idstudent.Text.ToString()); newstudent.FirstName = studentFirstName.Text.ToString(); newstudent.LastName = lastnamestudent.Text.ToString(); newstudent.BirthDate = datestudent.DisplayDate; newstudent.StuEmail = emailstudent.Text.ToString(); newstudent.MatrailStatus = "single"; newstudent.JoinDate = DateTime.Now; addbranchstudent.Year = DateTime.Now; addbranchstudent.Name = branchstudent.SelectedItem.ToString(); addtrackstudent.Year = DateTime.Now; addtrackstudent.TrackName = tracksstudent.SelectedItem.ToString(); addintakstudent.IntakeNumber = int.Parse(intakestudent.SelectedItem.ToString()); addintakstudent.Year = DateTime.Now; ShowStudentData newstudentwasadded = new ShowStudentData(); newstudentwasadded.StuId = int.Parse(idstudent.Text.ToString()); newstudentwasadded.StuEmail = emailstudent.Text.ToString(); newstudentwasadded.FirstName = studentFirstName.Text.ToString(); newstudentwasadded.LastName = lastnamestudent.Text.ToString(); newstudentwasadded.Track = tracksstudent.SelectedItem.ToString(); newstudentwasadded.Intake = int.Parse(intakestudent.SelectedItem.ToString()); newstudentwasadded.Branch = branchstudent.SelectedItem.ToString(); newstudentwasadded.BirthDate = DateTime.Now; studentuser.Email = newstudent.StuEmail; studentuser.Password = passswordstudent.Text.ToString(); studentuser.Type = "student"; int branchFindId = (from branches in context3.branches where branches.Name == addbranchstudent.Name select branches.BranchId).FirstOrDefault(); int trackFindId = (from trackID in context3.tracks where trackID.TrackName == addtrackstudent.TrackName select trackID.TrackId).FirstOrDefault(); int intakeFindId = (from intakeId in context3.intakes where intakeId.IntakeNumber == addintakstudent.IntakeNumber select intakeId.IntakeNo ).FirstOrDefault(); ITb.intack = intakeFindId; ITb.trackID = trackFindId; ITb.branchID = branchFindId; int findITB = ( from TIB in context3.rel_branch_track_intake where TIB.branchID == branchFindId && TIB.trackID == trackFindId && TIB.intack == intakeFindId select TIB.id ).Count(); int lastindexOfTIB; lastindexOfTIB = (from lastindexes in context3.rel_branch_track_intake select lastindexes).Count(); MessageBox.Show(lastindexOfTIB.ToString()); if (findITB > 0) { int findITB2 = ( from TIB in context3.rel_branch_track_intake where TIB.branchID == branchFindId && TIB.trackID == trackFindId && TIB.intack == intakeFindId select TIB.id ).FirstOrDefault(); newstudent.ITBid = findITB2; context3.users.Add(studentuser); context3.students.Add(newstudent); context3.SaveChanges(); lvUsers.Items.Add(newstudentwasadded); } else { newstudent.ITBid = lastindexOfTIB; ITb.id = lastindexOfTIB; context3.rel_branch_track_intake.Add(ITb); context3.SaveChanges(); context3.users.Add(studentuser); context3.students.Add(newstudent); context3.SaveChanges(); lvUsers.Items.Add(newstudentwasadded); } } catch (Exception d) { MessageBox.Show("invalid inputs"); } }