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);
}
