public void Insert(StudentModel studentModel)
{
studentModel.StudentId = Guid.NewGuid();
if (studentModel != null)
{
Models.DBObjects.Student dbStudentModel = new Models.DBObjects.Student();
dbStudentModel.StudentId = studentModel.StudentId;
dbStudentModel.Name = studentModel.Name;
dbStudentModel.BirthDate = studentModel.BirthDate;
dbStudentModel.Age = studentModel.Age;
dbStudentModel.Address = studentModel.Address;
dbStudentModel.Email = studentModel.Email;
dbStudentModel.Phone = studentModel.Phone;
dbStudentModel.ProgramId = studentModel.ProgramId;
dbStudentModel.TeacherId = studentModel.TeacherId;
dbStudentModel.ParentId = studentModel.ParentId;
dbContext.Students.InsertOnSubmit(dbStudentModel);
dbContext.SubmitChanges();
}
}
public void Insert(ClassModel classModel)
{
classModel.ClassId = Guid.NewGuid();
if (classModel != null)
{
Models.DBObjects.Class dbClassModel = new Models.DBObjects.Class();
dbClassModel.ClassId = classModel.ClassId;
dbClassModel.Name = classModel.Name;
dbContext.Classes.InsertOnSubmit(dbClassModel);
dbContext.SubmitChanges();
}
}
public void InsertCourse(CourseModel courseModel)
{
courseModel.CourseId = Guid.NewGuid();
if (courseModel != null)
{
Models.DBObjects.Course dbCourseModel = new Models.DBObjects.Course();
dbCourseModel.CourseId = courseModel.CourseId;
dbCourseModel.Name = courseModel.Name;
dbCourseModel.Price = courseModel.Price;
dbContext.Courses.InsertOnSubmit(dbCourseModel);
dbContext.SubmitChanges();
}
}
public void Insert(ProgramModel programModel)
{
programModel.ProgramId = Guid.NewGuid();
if (programModel != null)
{
Models.DBObjects.Program dbProgram = new Models.DBObjects.Program();
dbProgram.ProgramId = programModel.ProgramId;
dbProgram.Name = programModel.Name;
dbProgram.Hours_Mounth = programModel.Hours_Mounth;
dbContext.Programs.InsertOnSubmit(dbProgram);
dbContext.SubmitChanges();
}
}
public void Insert(ParentModel parentModel)
{
parentModel.ParentId = Guid.NewGuid();
if (parentModel != null)
{
Models.DBObjects.Parent dbParentModel = new Models.DBObjects.Parent();
dbParentModel.ParentId = parentModel.ParentId;
dbParentModel.Name = parentModel.Name;
dbParentModel.Phone = parentModel.Phone;
dbParentModel.Email = parentModel.Email;
dbContext.Parents.InsertOnSubmit(dbParentModel);
dbContext.SubmitChanges();
}
}
public void InsertTeacher(TeacherModel teacherModel)
{
teacherModel.TeacherId = Guid.NewGuid();
if (teacherModel != null)
{
Models.DBObjects.Teacher dbTeacherModel = new Models.DBObjects.Teacher();
dbTeacherModel.TeacherId = teacherModel.TeacherId;
dbTeacherModel.Name = teacherModel.Name;
dbTeacherModel.Phone = teacherModel.Phone;
dbTeacherModel.CourseId = teacherModel.CourseId;
dbContext.Teachers.InsertOnSubmit(dbTeacherModel);
dbContext.SubmitChanges();
}
}
public void Insert(ScheduleModel scheduleModel)
{
scheduleModel.ScheduleId = Guid.NewGuid();
if (scheduleModel != null)
{
Models.DBObjects.Schedule dbScheduleModel = new Models.DBObjects.Schedule();
dbScheduleModel.ScheduleId = scheduleModel.ScheduleId;
dbScheduleModel.Day = scheduleModel.Day;
dbScheduleModel.StudentId = scheduleModel.StudentId;
dbScheduleModel.TeacherId = scheduleModel.TeacherId;
dbScheduleModel.ClassId = scheduleModel.ClassId;
dbContext.Schedules.InsertOnSubmit(dbScheduleModel);
dbContext.SubmitChanges();
}
}
public void Insert(InvoiceModel invoiceModel)
{
if (invoiceModel != null)
{
Models.DBObjects.Invoice dbInvoiceModel = new Models.DBObjects.Invoice();
dbInvoiceModel.InvoiceId = invoiceModel.InvoiceId;
dbInvoiceModel.Invoice_Series = invoiceModel.Invoice_Series;
dbInvoiceModel.Create_Date = invoiceModel.Create_Date;
dbInvoiceModel.Contractor = invoiceModel.Contractor;
dbInvoiceModel.StudentId = invoiceModel.StudentId;
dbInvoiceModel.Quantity = invoiceModel.Quantity;
List <StudentModel> students = studentRepository.GetAllStudents();
foreach (StudentModel student in students)
{
if (dbInvoiceModel.StudentId == student.StudentId)
{
List <TeacherWithCourseNameViewModel> teachers = teacherRepository.GetAllTeachersWithCourseNames();
foreach (TeacherWithCourseNameViewModel teacher in teachers)
{
if (student.TeacherId == teacher.TeacherId)
{
dbInvoiceModel.StudentCourse = teacher.CourseName;
List <CourseModel> courses = courseRepository.GetAllCourses();
foreach (CourseModel course in courses)
{
if (dbInvoiceModel.StudentCourse == course.Name)
{
dbInvoiceModel.StudentPrice = course.Price;
}
}
}
}
}
}
dbContext.Invoices.InsertOnSubmit(dbInvoiceModel);
dbContext.SubmitChanges();
}
}
