public string Save() { string error = ""; try { using (SQLDatabaseDataContext db = new SQLDatabaseDataContext(Program.Connectionstring)) { if ((this.Student == null || this.Speciality == null) && this.ID > 0) { var cc = (from sc in db.StudentCourses where sc.ID == this.ID select sc).FirstOrDefault(); db.StudentCourses.DeleteOnSubmit(cc); db.SubmitChanges(); return(string.Empty); } if ((this.Student == null || this.Speciality == null)) { return(string.Empty); } StudentCourse studentCourse = new StudentCourse(); if (this.ID > 0 && this.Selected == true) { return(error); } else if (this.ID > 0 && this.Selected == false) { studentCourse = (from sc in db.StudentCourses where sc.ID == this.ID select sc).FirstOrDefault(); db.StudentCourses.DeleteOnSubmit(studentCourse); } else if (this.ID == 0 && this.Selected == true) { db.StudentCourses.InsertOnSubmit(studentCourse); studentCourse.SpecialityID = this.SpecialityID; studentCourse.StudentsID = this.StudentsID; studentCourse.CourseID = this.CourseID; studentCourse.SubjectsID = this.SubjectsID; } if (this.ID == 0) { db.StudentCourses.InsertOnSubmit(studentCourse); } db.SubmitChanges(); } } catch (Exception ex) { error = ex.Message; } return(error); }
public string Save() { string error = ""; try { using (SQLDatabaseDataContext db = new SQLDatabaseDataContext(Program.Connectionstring)) { User use = new User(); if (this.ID > 0) { use = (from us in db.Users where us.ID == this.ID select us).FirstOrDefault(); } use.FirstName = this.FirstName; use.LastName = this.LastName; use.Phone = this.Phone; use.Email = this.Email ?? string.Empty; use.Username = this.Username; use.Password = this.Password; if (this.ID == 0) { db.Users.InsertOnSubmit(use); } if (this.ID > 0) { var dbRoles = db.UserRoles.Where(i => i.UserID == this.ID).ToList(); db.UserRoles.DeleteAllOnSubmit(dbRoles); } db.SubmitChanges(); this.ID = use.ID; foreach (var r in this.Roles) { var role = new UserRole(); role.UserID = this.ID; role.RoleID = r.RoleID; db.UserRoles.InsertOnSubmit(role); } db.SubmitChanges(); } } catch (Exception ex) { error = ex.Message; } return(error); }
public string Save() { string error = ""; try { using (SQLDatabaseDataContext db = new SQLDatabaseDataContext(Program.Connectionstring)) { UserRole userRole = new UserRole(); if (this.ID > 0) { userRole = (from us in db.UserRoles where us.ID == this.ID select us).FirstOrDefault(); } userRole.UserID = this.UserID; userRole.RoleID = this.RoleID; if (this.ID == 0) { db.UserRoles.InsertOnSubmit(userRole); } db.SubmitChanges(); } } catch (Exception ex) { error = ex.Message; } return(error); }
public string Save() { string error = ""; try { using (SQLDatabaseDataContext db = new SQLDatabaseDataContext(Program.Connectionstring)) { University university = new University(); if (this.ID > 0) { university = (from un in db.Universities where un.ID == this.ID select un).FirstOrDefault(); } university.City = this.City; university.Name = this.Name; if (this.ID == 0) { db.Universities.InsertOnSubmit(university); } db.SubmitChanges(); } } catch (Exception ex) { error = ex.Message; } return(error); }
public string Save() { string error = string.Empty; try { using (SQLDatabaseDataContext db = new SQLDatabaseDataContext(Program.Connectionstring)) { ЕducationaLevel educationLevel = new ЕducationaLevel(); if (this.ID > 0) { educationLevel = (from edu in db.ЕducationaLevels where edu.ID == this.ID select edu).FirstOrDefault(); } educationLevel.LevelName = this.LevelName; if (this.ID == 0) { db.ЕducationaLevels.InsertOnSubmit(educationLevel); } db.SubmitChanges(); } } catch (Exception ex) { error = ex.Message; } return(error); }
public string Save() { string error = ""; try { using (SQLDatabaseDataContext db = new SQLDatabaseDataContext(Program.Connectionstring)) { InterruptedRepeat interruptedRepeat = new InterruptedRepeat(); if (this.ID > 0) { interruptedRepeat = (from intr in db.InterruptedRepeats where intr.ID == this.ID select intr).FirstOrDefault(); } interruptedRepeat.RepeastYear = this.RepeastYear; interruptedRepeat.StudentID = this.StudentID; interruptedRepeat.SpecialityID = this.SpecialityID; interruptedRepeat.CourseID = this.CourseID; if (this.ID == 0) { db.InterruptedRepeats.InsertOnSubmit(interruptedRepeat); } db.SubmitChanges(); } } catch (Exception ex) { error = ex.Message; } return(error); }
public string Save() { //List<TCourse>Courses = new List<TCourse>(); string error = ""; try { using (SQLDatabaseDataContext db = new SQLDatabaseDataContext(Program.Connectionstring)) { Course course = new Course(); if (this.ID > 0) { course = (from co in db.Courses where co.ID == this.ID select co).FirstOrDefault(); } course.NameCourse = this.NameCourse; if (this.ID == 0) { db.Courses.InsertOnSubmit(course); } db.SubmitChanges(); } } catch (Exception ex) { error = ex.Message; } return(error); }
public string Save() { string error = ""; try { using (SQLDatabaseDataContext db = new SQLDatabaseDataContext()) { Faculty faculty = new Faculty(); if (this.ID > 0) { faculty = (from fa in db.Faculties where fa.ID == this.ID select fa).FirstOrDefault(); } faculty.FacultyName = this.FacultyName; faculty.UniversityID = this.UniversityID; //faculty.SpecialityID = this.SpecialityID; if (this.ID == 0) { db.Faculties.InsertOnSubmit(faculty); } db.SubmitChanges(); } } catch (Exception ex) { error = ex.Message; } return(error); }
public string Save() { string error = ""; try { using (SQLDatabaseDataContext db = new SQLDatabaseDataContext(Program.Connectionstring)) { Role role = new Role(); if (this.ID > 0) { role = (from r in db.Roles where r.ID == this.ID select r).FirstOrDefault(); } role.Description = this.Description; role.Delete = this.Delete; if (this.ID == 0) { db.Roles.InsertOnSubmit(role); } db.SubmitChanges(); } } catch (Exception ex) { error = ex.Message; } return(error); }
public string Save() { string error = ""; try { using (SQLDatabaseDataContext db = new SQLDatabaseDataContext(Program.Connectionstring)) { SubjectSpeciality subjectSpeciality = new SubjectSpeciality(); if (this.ID > 0) { subjectSpeciality = (from sub in db.SubjectSpecialities where sub.ID == this.ID select sub).FirstOrDefault(); } subjectSpeciality.SubjectID = this.SubjectID; subjectSpeciality.SpecialityID = this.SpecialityID; if (this.ID == 0) { db.SubjectSpecialities.InsertOnSubmit(subjectSpeciality); } db.SubmitChanges(); } } catch (Exception ex) { error = ex.Message; } return(error); }
public string Save() { string error = ""; try { using (SQLDatabaseDataContext db = new SQLDatabaseDataContext(Program.Connectionstring)) { Department department = new Department(); if (this.ID > 0) { department = (from dp in db.Departments where dp.ID == this.ID select dp).FirstOrDefault(); } department.Txt = this.Txt; department.Name = this.Name; department.FacultyID = this.FacultyID; if (this.ID == 0) { db.Departments.InsertOnSubmit(department); } db.SubmitChanges(); } } catch (Exception ex) { error = ex.Message; } return(error); }
public string Save() { string error = ""; try { using (SQLDatabaseDataContext db = new SQLDatabaseDataContext(Program.Connectionstring)) { SubjectCourse subjectCourse = new SubjectCourse(); if (this.ID > 0) { subjectCourse = (from sc in db.SubjectCourses where sc.ID == this.ID select sc).FirstOrDefault(); } subjectCourse.SubjectID = this.SubjectID; subjectCourse.CourseiD = this.CourseID; subjectCourse.SemesterID = this.SemesterID; subjectCourse.SpecialityID = this.SpecialityID; if (this.ID == 0) { db.SubjectCourses.InsertOnSubmit(subjectCourse); } db.SubmitChanges(); } } catch (Exception ex) { error = ex.Message; } return(error); }
public string Save() { string error = ""; try { using (SQLDatabaseDataContext db = new SQLDatabaseDataContext()) { DepartmentLecture departmentLecture = new DepartmentLecture(); if (this.ID > 0) { departmentLecture = (from dl in db.DepartmentLectures where dl.ID == this.ID select dl).FirstOrDefault(); } departmentLecture.LectureID = this.LectureID; departmentLecture.DepartmentID = this.DepartmentID; departmentLecture.StartDate = this.StartDate; departmentLecture.FinishDate = this.FinishDate; departmentLecture.SubjectID = this.SubjectID; if (this.ID == 0) { db.DepartmentLectures.InsertOnSubmit(departmentLecture); } db.SubmitChanges(); } } catch (Exception ex) { error = ex.Message; } return(error); }
public string Save() { string error = ""; try { using (SQLDatabaseDataContext db = new SQLDatabaseDataContext(Program.Connectionstring)) { FormOfEducation formOfEducation = new FormOfEducation(); if (this.ID > 0) { formOfEducation = (from foe in db.FormOfEducations where foe.ID == this.ID select foe).FirstOrDefault(); } formOfEducation.Name = this.Name; if (this.ID == 0) { db.FormOfEducations.InsertOnSubmit(formOfEducation); } db.SubmitChanges(); } } catch (Exception ex) { error = ex.Message; } return(error); }
public string Save() { string error = ""; try { using (SQLDatabaseDataContext db = new SQLDatabaseDataContext(Program.Connectionstring)) { Subject subject = new Subject(); if (this.ID > 0) { subject = (from su in db.Subjects where su.ID == this.ID select su).FirstOrDefault(); } subject.FacultyID = this.FacultyID; subject.DepartmentsID = this.DeparmentsID; subject.SubjectName = this.SubjectName; subject.CompulsoryDiscipline = this.CompulsoryDiscipline; subject.FacultativeDiscipline = this.FacultativeDiscipline; if (this.ID == 0) { db.Subjects.InsertOnSubmit(subject); } db.SubmitChanges(); } } catch (Exception ex) { error = ex.Message; } return(error); }
public string Save() { string err = ""; try { using (SQLDatabaseDataContext db = new SQLDatabaseDataContext(Program.Connectionstring)) { Student stu = new Student(); if (this.ID > 0) { stu = (from st in db.Students where st.ID == this.ID select st).FirstOrDefault(); //if (s.EGN != this.EGN) { err = ""; return err; } } stu.FirstName = this.FirstName; stu.MiddleName = this.MiddleName; stu.LastName = this.LastName; stu.EGN = this.EGN; stu.Phone = this.Phone; stu.Email = this.Email; stu.City = this.City; stu.GraduateSecondarySchool = this.GraduateSecondarySchool; stu.DateOfEnrollmentInFirstCourse = this.DateOfEnrollmentInFirstCourse; stu.Male = this.Male; stu.Address = this.Address; stu.Image = this.Image; stu.FacultyID = this.FacultyID; if (this.ID == 0) { db.Students.InsertOnSubmit(stu); } db.SubmitChanges(); this.ID = stu.ID; //TStudentSpeciality.Save(db, this); } } catch (Exception ex) { err = ex.Message; } return(err); }
public string Save() { string error = ""; try { using (SQLDatabaseDataContext db = new SQLDatabaseDataContext(Program.Connectionstring)) { Lecture lecture = new Lecture(); if (this.ID > 0) { lecture = (from le in db.Lectures where le.ID == this.ID select le).FirstOrDefault(); } lecture.FirstName = this.FirstName; lecture.LastName = this.LastName; lecture.MiddleName = this.MiddleName; lecture.Title = this.Title; lecture.Phone = this.Phone; lecture.Email = this.Email; lecture.FacultyID = this.FacultyID; // lecture.Departmnet = this.Department; lecture.GraduateUniversity = this.GraduateUniversity; lecture.City = this.City; lecture.Image = this.Image; if (this.ID == 0) { db.Lectures.InsertOnSubmit(lecture); } db.SubmitChanges(); } } catch (Exception ex) { error = ex.Message; } return(error); }
public string Save() { string error = ""; try { using (SQLDatabaseDataContext db = new SQLDatabaseDataContext(Program.Connectionstring)) { StudentSpeciality studentSpeciality = new StudentSpeciality(); if (this.ID > 0) { studentSpeciality = (from sts in db.StudentSpecialities where sts.ID == this.ID select sts).FirstOrDefault(); } studentSpeciality.Credits = this.Credits; studentSpeciality.SpecialityID = this.SpecialityID; studentSpeciality.StartYear = this.StartYear; studentSpeciality.FinishYear = this.FinishYear; studentSpeciality.CourseID = this.CourseID; studentSpeciality.FormOfEducationID = this.FormOfEducationID; studentSpeciality.StudentID = this.StudentID; studentSpeciality.FacultyNumber = this.FacultyNumber; studentSpeciality.EducationLevelID = this.EducationLevel.ID; if (this.ID == 0) { db.StudentSpecialities.InsertOnSubmit(studentSpeciality); } db.SubmitChanges(); } } catch (Exception ex) { error = ex.Message; } return(error); }
public string Save() { string error = ""; try { using (SQLDatabaseDataContext db = new SQLDatabaseDataContext()) { Evaluation evaluation = new Evaluation(); if (this.ID > 0) { evaluation = (from ev in db.Evaluations where ev.ID == this.ID select ev).FirstOrDefault(); } evaluation.SubjectID = this.SubjectID; evaluation.StudentID = this.StudentID; evaluation.SpecialityID = this.SpecialityID; evaluation.LectureID = this.LectureID; evaluation.Number = this.Number; evaluation.CourseID = this.CourseID; if (this.ID == 0) { db.Evaluations.InsertOnSubmit(evaluation); } db.SubmitChanges(); } } catch (Exception ex) { error = ex.Message; } return(error); }