public BusinessEntity.Result DeleteGradeCourse(BusinessEntity.ClassTeacherSchedule.GradeCourseEntity GradeCourse) { BusinessEntity.Result result = new BusinessEntity.Result(); try { SchoolInformationManagementSystemDBEntities e = new SchoolInformationManagementSystemDBEntities(); var original = e.tblGradeCourses.Find(GradeCourse.ID); if (original != null) { e.tblGradeCourses.Remove(e.tblGradeCourses.Where(x => x.ID == GradeCourse.ID).First()); e.SaveChanges(); result.Message = "Deleted Successfully."; result.Status = true; return(result); } else { result.Message = "Failed to delete"; result.Status = false; return(result); } } catch (Exception) { result.Message = "Failed to delete"; result.Status = false; return(result); } }
public BusinessEntity.Result DeleteExamType(BusinessEntity.Lookup.ExamTypeEntity ExamType) { BusinessEntity.Result result = new BusinessEntity.Result(); try { SchoolInformationManagementSystemDBEntities e = new SchoolInformationManagementSystemDBEntities(); var original = e.tblExamTypes.Find(ExamType.ID); if (original != null) { e.tblExamTypes.Remove(e.tblExamTypes.Where(x => x.ID == ExamType.ID).First()); e.SaveChanges(); result.Message = "Deleted Successfully."; result.Status = true; return(result); } else { result.Message = "Failed to delete"; result.Status = false; return(result); } } catch (Exception) { result.Message = "Failed to delete"; result.Status = false; return(result); } }
public BusinessEntity.Result DeleteStudentPayment(BusinessEntity.TeacherEvaluation.StudentPaymentEntity StudentPayment) { BusinessEntity.Result result = new BusinessEntity.Result(); try { SchoolInformationManagementSystemDBEntities e = new SchoolInformationManagementSystemDBEntities(); var original = e.tblStudentPayments.Find(StudentPayment.ID); if (original != null) { e.tblStudentPayments.Remove(e.tblStudentPayments.Where(x => x.ID == StudentPayment.ID).First()); e.SaveChanges(); result.Message = "Deleted Successfully."; result.Status = true; return(result); } else { result.Message = "Failed to delete"; result.Status = false; return(result); } } catch (Exception) { result.Message = "Failed to delete"; result.Status = false; return(result); } }
public BusinessEntity.Result UpdateExamType(BusinessEntity.Lookup.ExamTypeEntity ExamType) { BusinessEntity.Result result = new BusinessEntity.Result(); try { SchoolInformationManagementSystemDBEntities e = new SchoolInformationManagementSystemDBEntities(); var original = e.tblExamTypes.Find(ExamType.ID); if (original != null) { e.Entry(original).CurrentValues.SetValues(ExamType); e.SaveChanges(); result.Message = "Updated Successfully."; result.Status = true; return(result); } else { result.Message = "Failed to update"; result.Status = false; return(result); } } catch (Exception) { result.Message = "Failed to update"; result.Status = false; return(result); } }
public BusinessEntity.Result UpdateGradeCourse(BusinessEntity.ClassTeacherSchedule.GradeCourseEntity GradeCourse) { BusinessEntity.Result result = new BusinessEntity.Result(); try { SchoolInformationManagementSystemDBEntities e = new SchoolInformationManagementSystemDBEntities(); var original = e.tblGradeCourses.Find(GradeCourse.ID); if (original != null) { e.Entry(original).CurrentValues.SetValues(GradeCourse); e.SaveChanges(); result.Message = "Updated Successfully."; result.Status = true; return(result); } else { result.Message = "Failed to update"; result.Status = false; return(result); } } catch (Exception) { result.Message = "Failed to update"; result.Status = false; return(result); } }
public BusinessEntity.Result UpdateMeetingFollowup(BusinessEntity.Meeting.MeetingFollowupEntity MeetingFollowup) { BusinessEntity.Result result = new BusinessEntity.Result(); try { SchoolInformationManagementSystemDBEntities e = new SchoolInformationManagementSystemDBEntities(); var original = e.tblMeetingFollowups.Find(MeetingFollowup.ID); if (original != null) { e.Entry(original).CurrentValues.SetValues(MeetingFollowup); e.SaveChanges(); result.Message = "Updated Successfully."; result.Status = true; return(result); } else { result.Message = "Failed to update"; result.Status = false; return(result); } } catch (Exception) { result.Message = "Failed to update"; result.Status = false; return(result); } }
public BusinessEntity.Result UpdateStudentPayment(BusinessEntity.TeacherEvaluation.StudentPaymentEntity StudentPayment) { BusinessEntity.Result result = new BusinessEntity.Result(); try { SchoolInformationManagementSystemDBEntities e = new SchoolInformationManagementSystemDBEntities(); var original = e.tblStudentPayments.Find(StudentPayment.ID); if (original != null) { e.Entry(original).CurrentValues.SetValues(StudentPayment); e.SaveChanges(); result.Message = "Updated Successfully."; result.Status = true; return(result); } else { result.Message = "Failed to update"; result.Status = false; return(result); } } catch (Exception) { result.Message = "Failed to update"; result.Status = false; return(result); } }
public BusinessEntity.ExtraCurricular.ExtraCurricularActivityEntity GetExtraCurricularActivityByID(int ExtraCurricularActivityID) { SchoolInformationManagementSystemDBEntities e = new SchoolInformationManagementSystemDBEntities(); List <DataAccessLogic.tblExtraCurricularActivity> results = e.tblExtraCurricularActivities.Where(x => x.ID == ExtraCurricularActivityID).ToList(); List <BusinessEntity.ExtraCurricular.ExtraCurricularActivityEntity> entities = new List <BusinessEntity.ExtraCurricular.ExtraCurricularActivityEntity>(); foreach (DataAccessLogic.tblExtraCurricularActivity ExtraCurricularActivity in results) { entities.Add(new BusinessEntity.ExtraCurricular.ExtraCurricularActivityEntity(ExtraCurricularActivity)); } return(entities.FirstOrDefault()); }
public List <BusinessEntity.ExtraCurricular.ExtraCurricularActivityEntity> GetExtraCurricularActivitys() { SchoolInformationManagementSystemDBEntities e = new SchoolInformationManagementSystemDBEntities(); List <DataAccessLogic.tblExtraCurricularActivity> results = e.tblExtraCurricularActivities.ToList(); List <BusinessEntity.ExtraCurricular.ExtraCurricularActivityEntity> entities = new List <BusinessEntity.ExtraCurricular.ExtraCurricularActivityEntity>(); foreach (DataAccessLogic.tblExtraCurricularActivity ExtraCurricularActivity in results) { entities.Add(new BusinessEntity.ExtraCurricular.ExtraCurricularActivityEntity(ExtraCurricularActivity)); } return(entities); }
public BusinessEntity.Lookup.SubCityEntity GetSubCityByID(int SubCityID) { SchoolInformationManagementSystemDBEntities e = new SchoolInformationManagementSystemDBEntities(); List <DataAccessLogic.tblSubCity> results = e.tblSubCities.Where(x => x.ID == SubCityID).ToList(); List <BusinessEntity.Lookup.SubCityEntity> entities = new List <BusinessEntity.Lookup.SubCityEntity>(); foreach (DataAccessLogic.tblSubCity SubCity in results) { entities.Add(new BusinessEntity.Lookup.SubCityEntity(SubCity)); } return(entities.FirstOrDefault()); }
public BusinessEntity.Lookup.AcademicQuarterEntity GetAcademicQuarterByID(int AcademicQuarterID) { SchoolInformationManagementSystemDBEntities e = new SchoolInformationManagementSystemDBEntities(); List <DataAccessLogic.tblAcademicQuarter> results = e.tblAcademicQuarters.Where(x => x.ID == AcademicQuarterID).ToList(); List <BusinessEntity.Lookup.AcademicQuarterEntity> entities = new List <BusinessEntity.Lookup.AcademicQuarterEntity>(); foreach (DataAccessLogic.tblAcademicQuarter AcademicQuarter in results) { entities.Add(new BusinessEntity.Lookup.AcademicQuarterEntity(AcademicQuarter)); } return(entities.FirstOrDefault()); }
public List <BusinessEntity.ClassTeacherSchedule.GradeCourseEntity> GetGradeCourses() { SchoolInformationManagementSystemDBEntities e = new SchoolInformationManagementSystemDBEntities(); List <DataAccessLogic.tblGradeCourse> results = e.tblGradeCourses.ToList(); List <BusinessEntity.ClassTeacherSchedule.GradeCourseEntity> entities = new List <BusinessEntity.ClassTeacherSchedule.GradeCourseEntity>(); foreach (DataAccessLogic.tblGradeCourse GradeCourse in results) { entities.Add(new BusinessEntity.ClassTeacherSchedule.GradeCourseEntity(GradeCourse)); } return(entities); }
public BusinessEntity.Lookup.PaymentReasonEntity GetPaymentReasonByID(int PaymentReasonID) { SchoolInformationManagementSystemDBEntities e = new SchoolInformationManagementSystemDBEntities(); List <DataAccessLogic.tblPaymentReason> results = e.tblPaymentReasons.Where(x => x.ID == PaymentReasonID).ToList(); List <BusinessEntity.Lookup.PaymentReasonEntity> entities = new List <BusinessEntity.Lookup.PaymentReasonEntity>(); foreach (DataAccessLogic.tblPaymentReason PaymentReason in results) { entities.Add(new BusinessEntity.Lookup.PaymentReasonEntity(PaymentReason)); } return(entities.FirstOrDefault()); }
public BusinessEntity.Lookup.CampusEntity GetCampusByID(int CampusID) { SchoolInformationManagementSystemDBEntities e = new SchoolInformationManagementSystemDBEntities(); List <DataAccessLogic.tblCampu> results = e.tblCampus.Where(x => x.ID == CampusID).ToList(); List <BusinessEntity.Lookup.CampusEntity> entities = new List <BusinessEntity.Lookup.CampusEntity>(); foreach (DataAccessLogic.tblCampu Campus in results) { entities.Add(new BusinessEntity.Lookup.CampusEntity(Campus)); } return(entities.FirstOrDefault()); }
public List <BusinessEntity.Lookup.CampusEntity> GetCampuss() { SchoolInformationManagementSystemDBEntities e = new SchoolInformationManagementSystemDBEntities(); List <DataAccessLogic.tblCampu> results = e.tblCampus.ToList(); List <BusinessEntity.Lookup.CampusEntity> entities = new List <BusinessEntity.Lookup.CampusEntity>(); foreach (DataAccessLogic.tblCampu Campus in results) { entities.Add(new BusinessEntity.Lookup.CampusEntity(Campus)); } return(entities); }
public List <BusinessEntity.Tutorial.TeacherTutorialEntity> GetTeacherTutorials() { SchoolInformationManagementSystemDBEntities e = new SchoolInformationManagementSystemDBEntities(); List <DataAccessLogic.tblTeacherTutorial> results = e.tblTeacherTutorials.ToList(); List <BusinessEntity.Tutorial.TeacherTutorialEntity> entities = new List <BusinessEntity.Tutorial.TeacherTutorialEntity>(); foreach (DataAccessLogic.tblTeacherTutorial TeacherTutorial in results) { entities.Add(new BusinessEntity.Tutorial.TeacherTutorialEntity(TeacherTutorial)); } return(entities); }
public List <BusinessEntity.Admission.StudentEntity> GetStudents() { SchoolInformationManagementSystemDBEntities e = new SchoolInformationManagementSystemDBEntities(); List <DataAccessLogic.tblStudent> results = e.tblStudents.ToList(); List <BusinessEntity.Admission.StudentEntity> entities = new List <BusinessEntity.Admission.StudentEntity>(); foreach (DataAccessLogic.tblStudent Student in results) { entities.Add(new BusinessEntity.Admission.StudentEntity(Student)); } return(entities); }
public List <BusinessEntity.Lookup.GradeSectionEntity> GetGradeSections() { SchoolInformationManagementSystemDBEntities e = new SchoolInformationManagementSystemDBEntities(); List <DataAccessLogic.tblGradeSection> results = e.tblGradeSections.ToList(); List <BusinessEntity.Lookup.GradeSectionEntity> entities = new List <BusinessEntity.Lookup.GradeSectionEntity>(); foreach (DataAccessLogic.tblGradeSection GradeSection in results) { entities.Add(new BusinessEntity.Lookup.GradeSectionEntity(GradeSection)); } return(entities); }
public BusinessEntity.Admission.StudentEntity GetStudentByID(int StudentID) { SchoolInformationManagementSystemDBEntities e = new SchoolInformationManagementSystemDBEntities(); List <DataAccessLogic.tblStudent> results = e.tblStudents.Where(x => x.ID == StudentID).ToList(); List <BusinessEntity.Admission.StudentEntity> entities = new List <BusinessEntity.Admission.StudentEntity>(); foreach (DataAccessLogic.tblStudent Student in results) { entities.Add(new BusinessEntity.Admission.StudentEntity(Student)); } return(entities.FirstOrDefault()); }
public List <BusinessEntity.Lookup.WoredaEntity> GetWoredas() { SchoolInformationManagementSystemDBEntities e = new SchoolInformationManagementSystemDBEntities(); List <DataAccessLogic.tblWoreda> results = e.tblWoredas.ToList(); List <BusinessEntity.Lookup.WoredaEntity> entities = new List <BusinessEntity.Lookup.WoredaEntity>(); foreach (DataAccessLogic.tblWoreda Woreda in results) { entities.Add(new BusinessEntity.Lookup.WoredaEntity(Woreda)); } return(entities); }
public BusinessEntity.ClassTeacherSchedule.GradeCourseEntity GetGradeCourseByID(int GradeCourseID) { SchoolInformationManagementSystemDBEntities e = new SchoolInformationManagementSystemDBEntities(); List <DataAccessLogic.tblGradeCourse> results = e.tblGradeCourses.Where(x => x.ID == GradeCourseID).ToList(); List <BusinessEntity.ClassTeacherSchedule.GradeCourseEntity> entities = new List <BusinessEntity.ClassTeacherSchedule.GradeCourseEntity>(); foreach (DataAccessLogic.tblGradeCourse GradeCourse in results) { entities.Add(new BusinessEntity.ClassTeacherSchedule.GradeCourseEntity(GradeCourse)); } return(entities.FirstOrDefault()); }
public List <BusinessEntity.Lookup.ExamTypeEntity> GetExamTypes() { SchoolInformationManagementSystemDBEntities e = new SchoolInformationManagementSystemDBEntities(); List <DataAccessLogic.tblExamType> results = e.tblExamTypes.ToList(); List <BusinessEntity.Lookup.ExamTypeEntity> entities = new List <BusinessEntity.Lookup.ExamTypeEntity>(); foreach (DataAccessLogic.tblExamType ExamType in results) { entities.Add(new BusinessEntity.Lookup.ExamTypeEntity(ExamType)); } return(entities); }
public List <BusinessEntity.Meeting.MeetingScheduleEntity> GetMeetingSchedules() { SchoolInformationManagementSystemDBEntities e = new SchoolInformationManagementSystemDBEntities(); List <DataAccessLogic.tblMeetingSchedule> results = e.tblMeetingSchedules.ToList(); List <BusinessEntity.Meeting.MeetingScheduleEntity> entities = new List <BusinessEntity.Meeting.MeetingScheduleEntity>(); foreach (DataAccessLogic.tblMeetingSchedule MeetingSchedule in results) { entities.Add(new BusinessEntity.Meeting.MeetingScheduleEntity(MeetingSchedule)); } return(entities); }
public List <BusinessEntity.Lookup.AcademicQuarterEntity> GetAcademicQuarters() { SchoolInformationManagementSystemDBEntities e = new SchoolInformationManagementSystemDBEntities(); List <DataAccessLogic.tblAcademicQuarter> results = e.tblAcademicQuarters.ToList(); List <BusinessEntity.Lookup.AcademicQuarterEntity> entities = new List <BusinessEntity.Lookup.AcademicQuarterEntity>(); foreach (DataAccessLogic.tblAcademicQuarter AcademicQuarter in results) { entities.Add(new BusinessEntity.Lookup.AcademicQuarterEntity(AcademicQuarter)); } return(entities); }
public BusinessEntity.Lookup.WoredaEntity GetWoredaByID(int WoredaID) { SchoolInformationManagementSystemDBEntities e = new SchoolInformationManagementSystemDBEntities(); List <DataAccessLogic.tblWoreda> results = e.tblWoredas.Where(x => x.ID == WoredaID).ToList(); List <BusinessEntity.Lookup.WoredaEntity> entities = new List <BusinessEntity.Lookup.WoredaEntity>(); foreach (DataAccessLogic.tblWoreda Woreda in results) { entities.Add(new BusinessEntity.Lookup.WoredaEntity(Woreda)); } return(entities.FirstOrDefault()); }
public BusinessEntity.Meeting.MeetingScheduleEntity GetMeetingScheduleByID(int MeetingScheduleID) { SchoolInformationManagementSystemDBEntities e = new SchoolInformationManagementSystemDBEntities(); List <DataAccessLogic.tblMeetingSchedule> results = e.tblMeetingSchedules.Where(x => x.ID == MeetingScheduleID).ToList(); List <BusinessEntity.Meeting.MeetingScheduleEntity> entities = new List <BusinessEntity.Meeting.MeetingScheduleEntity>(); foreach (DataAccessLogic.tblMeetingSchedule MeetingSchedule in results) { entities.Add(new BusinessEntity.Meeting.MeetingScheduleEntity(MeetingSchedule)); } return(entities.FirstOrDefault()); }
public BusinessEntity.Lookup.ExamTypeEntity GetExamTypeByID(int ExamTypeID) { SchoolInformationManagementSystemDBEntities e = new SchoolInformationManagementSystemDBEntities(); List <DataAccessLogic.tblExamType> results = e.tblExamTypes.Where(x => x.ID == ExamTypeID).ToList(); List <BusinessEntity.Lookup.ExamTypeEntity> entities = new List <BusinessEntity.Lookup.ExamTypeEntity>(); foreach (DataAccessLogic.tblExamType ExamType in results) { entities.Add(new BusinessEntity.Lookup.ExamTypeEntity(ExamType)); } return(entities.FirstOrDefault()); }
public List <BusinessEntity.TeacherEvaluation.TeacherEvaluationEntity> GetTeacherEvaluations() { SchoolInformationManagementSystemDBEntities e = new SchoolInformationManagementSystemDBEntities(); List <DataAccessLogic.tblTeacherEvaluation> results = e.tblTeacherEvaluations.ToList(); List <BusinessEntity.TeacherEvaluation.TeacherEvaluationEntity> entities = new List <BusinessEntity.TeacherEvaluation.TeacherEvaluationEntity>(); foreach (DataAccessLogic.tblTeacherEvaluation TeacherEvaluation in results) { entities.Add(new BusinessEntity.TeacherEvaluation.TeacherEvaluationEntity(TeacherEvaluation)); } return(entities); }
public BusinessEntity.TeacherEvaluation.TeacherEvaluationEntity GetTeacherEvaluationByID(int TeacherEvaluationID) { SchoolInformationManagementSystemDBEntities e = new SchoolInformationManagementSystemDBEntities(); List <DataAccessLogic.tblTeacherEvaluation> results = e.tblTeacherEvaluations.Where(x => x.ID == TeacherEvaluationID).ToList(); List <BusinessEntity.TeacherEvaluation.TeacherEvaluationEntity> entities = new List <BusinessEntity.TeacherEvaluation.TeacherEvaluationEntity>(); foreach (DataAccessLogic.tblTeacherEvaluation TeacherEvaluation in results) { entities.Add(new BusinessEntity.TeacherEvaluation.TeacherEvaluationEntity(TeacherEvaluation)); } return(entities.FirstOrDefault()); }
public List <BusinessEntity.Lookup.SubCityEntity> GetSubCitys() { SchoolInformationManagementSystemDBEntities e = new SchoolInformationManagementSystemDBEntities(); List <DataAccessLogic.tblSubCity> results = e.tblSubCities.ToList(); List <BusinessEntity.Lookup.SubCityEntity> entities = new List <BusinessEntity.Lookup.SubCityEntity>(); foreach (DataAccessLogic.tblSubCity SubCity in results) { entities.Add(new BusinessEntity.Lookup.SubCityEntity(SubCity)); } return(entities); }