public AddGroupPageController() { InitializeComponent(); ObservableCollection <MajorTable> majors = new ObservableCollection <MajorTable>(); var majorController = new MajorController(); var majorsList = majorController.GetMajors(); foreach (Major m in majorsList) { majors.Add(new MajorTable { Id = m.Id, Name = m.Name }); } GroupDataGrid.ItemsSource = majors; /* for (int i = 0; i < GroupDataGrid.Items.Count; i++) * { * (DataGridRow)GroupDataGrid.Items.IndexOf(0)).Tag.ToString() = "ReadOnly"; * (DataGridRow)GroupDataGrid.Items. * GroupDataGrid.Columns[i].IsReadOnly = true; * //GroupDataGrid. * }*/ // Point relativePoint = myVisual.TransformToAncestor(rootVisual) // .Transform(new Point(0, 0)); }
private void ButtonFecr_Click(object sender, RoutedEventArgs e) { var majorController = new MajorController(); // majorController.Add("poz"); var majorsList = majorController.GetMajors(); // int k = 0; //groupController. }
static void Main(string[] args) { var SQLLibConn = new BCConnection(); SQLLibConn.Connect(@"localhost\sqlexpress", "EdDb", "trusted_connection = true"); StudentController.BCConnection = SQLLibConn; MajorController.BCConnection = SQLLibConn; InstructorController.BCConnection = SQLLibConn; var majors = MajorController.GetAllMajors(); foreach (var major in majors) { Console.WriteLine(major); } var Students = StudentController.GetAllStudents(); foreach (Student student in Students) { Console.WriteLine(student); } var Instructors = InstructorController.GetAllInstructors(); foreach (Instructor instructor in Instructors) { Console.WriteLine(instructor); } #region specifics instances for modification //var newStudent = new Student { // Id = 660, // Firstname = "Timmy", // Lastname = "Nook", // SAT = 810, // GPA = 2.90, // MajorId = 1 //}; //Console.WriteLine(StudentController.InsertStudent(newStudent)); //var studentById = StudentController.GetByPK(100); //if (studentById == null) { // Console.WriteLine("Could not find a student with that primary key."); //} else { // Console.WriteLine(studentById); //} #endregion SQLLibConn.Disconnect(); }
static void Main(string[] args) { var sqllib = new BcConnection(); sqllib.Connect(@"localhost\sqlexpress", "EdDb", "trusted_connection=true"); MajorController.bcConnection = sqllib; var Major = MajorController.GetMajorByPk(1); Console.WriteLine(Major); var majors = MajorController.GetAllMajors(); foreach (var major in majors) { Console.WriteLine(major); } // insert new major // var newMajor = new Major { // Id = 11 , // Description = "Graphics Design" , // MinSAT = 1100 // }; // var successmjins = MajorController.InsertMajor(newMajor); StudentController.bcConnection = sqllib; // setting property to instance var newStudent = new Student { Id = 885, Firstname = "Crazy", Lastname = "Eights", SAT = 600, GPA = 0.00, MajorId = 1 }; // var success = StudentController.InsertStudent(newStudent); var student = StudentController.GetStudentByPK(newStudent.Id); if (student == null) { Console.WriteLine("Student with primary key not found"); } else { Console.WriteLine(student); } student.Firstname = "Charlie"; student.Lastname = "Chan"; var success = StudentController.UpdateStudent(student); /* * var studentToDelete = new Student { * Id = 885 * }; * success = StudentController.DeleteStudent(885); */ var students = StudentController.GetAllStudents(); foreach (var student0 in students) { Console.WriteLine(student0); } sqllib.Disconnect(); }
public MajorControllerTest() { _seed = Guid.NewGuid().ToString(); _controller = MockController.CreateController <MajorController>(_seed, "user"); }
static void Main(string[] args) { var sqllib = new BcConnection(); sqllib.Connect(@"localhost", "EdDb", "trusted_connection=true"); MajorController.bcConnection = sqllib; var majors = MajorController.GetAllMajors(); foreach (var major in majors) { Console.WriteLine(major); } StudentController.bcConnection = sqllib; //var newStudent = new Student { // Id = 667, // FirstName = "Chuck", // LastName = "Intern of Darkness", // SAT = 000, // GPA = 4.0, // MajorId = null //}; //var success = StudentController.InsertStudent(newStudent); var student100 = StudentController.GetByPk(888); if (student100 == null) { Console.WriteLine("Student not found"); } else { Console.WriteLine(student100); } //student100.FirstName = "Jackie"; //student100.LastName = "Chan"; //var success = StudentController.UpdateStudent(student100); // //var studentToDelete = new Student { // Id = 777 //}; //success = StudentController.DeleteStudent(888); var students = StudentController.GetAllStudents(); foreach (var student in students) { Console.WriteLine(student); } var m = MajorController.GetByPk(1); foreach (var major in majors) { Console.WriteLine(m); } InstructorController.bcConnection = sqllib; var instructors = InstructorController.GetAllInstructors(); foreach (var instructor in instructors) { Console.WriteLine(instructor); } var instructPK = InstructorController.GetByPk(30); if (instructPK == null) { Console.WriteLine("Instructor not found"); } else { Console.WriteLine(instructPK); } ClassController.bcConnection = sqllib; var classes = ClassController.GetAllClasses(); foreach (var cla in classes) { Console.WriteLine(cla); } sqllib.Disconnect(); }
static void Main(string[] args) { var sqllib = new BcConnection(); sqllib.Connect(@"localhost\sqlexpress", "EdDb", "trusted_connection=true"); StudentController.bcConnection = sqllib; MajorController.bcConnection = sqllib; InstructorController.bcConnection = sqllib; #region Instructor methods var instructors = InstructorController.GetAllInstructors(); foreach (var i in instructors) { Console.WriteLine(i); } var instructor = InstructorController.GetInstructorByPk(10); if (instructor == null) { Console.WriteLine("Instructor not found!"); } else { Console.WriteLine(instructor); } #endregion #region Major Controller methods var major = MajorController.GetMajorByPK(1); if (major == null) { Console.WriteLine("Major not found!"); } else { Console.WriteLine(major); } var majors = MajorController.GetAllMajors(); foreach (var m in majors) { Console.WriteLine(m); } #endregion #region Student Controller methods //var newStudent = new Student { // Id = 999, // Firstname = "Lazy", // Lastname = "Larry", // SAT = 1600, // GPA = 4.0, // MajorId = 3 //}; //var success = StudentController.InsertStudent(newStudent); var student = StudentController.GetStudentByPk(888); if (student == null) { Console.WriteLine("Student not found"); } else { Console.WriteLine(student); } //var studentToDelete = new Student { // Id = 999 //}; //var success = StudentController.DeleteStudent(999); //student.Firstname = "Charlie"; //student.Lastname = "Chan"; //var success = StudentController.UpdateStudent(student); var students = StudentController.GetAllStudents(); foreach (var student0 in students) { Console.WriteLine(student0); } #endregion sqllib.Disconnect(); }