public BaseSearchViewModel()
{
State = new State();
TeacherType = new TeacherType();
Qualification = new QualificationCategory();
StudentCategory = new StudentCategory();
}
public Teacher Create_Teacher(TeacherType type)
{
if (type == Kindergarten)
{
return(new Kindergarten());
}
}
public ActionResult DeleteConfirmed(int id)
{
TeacherType teacherType = db.TeacherTypes.Find(id);
String sql = "Delete From TeacherTypes where TeacherTypeID = " + teacherType.TeacherTypeID;
db.Delete(sql);
return(RedirectToAction("Index"));
}
public TeacherQueryDto(long teacherId, TeacherType teacherType, long personId)
{
TeacherId = teacherId;
TeacherType = teacherType;
Person = new PersonQueryDto {
PersonId = personId
};
}
public IHttpActionResult GetTeacherType(int id)
{
TeacherType result = BusinessLayer.GetRow <TeacherType>(id);
if (result == null)
{
return(NotFound());
}
return(Ok(result));
}
// GET: TeacherTypes
public ActionResult Index()
{
String sql = "SELECT * FROM TeacherTypes";
db.List(sql);
var dt = db.List(sql);
var model = new TeacherType().List(dt);
return(View(model));
}
public IHttpActionResult PostTeacherType(TeacherType item)
{
int newID = BusinessLayer.AddModel(item);
if (newID == 0)
{
return(Conflict());
}
return(Ok());
}
public ActionResult Edit(TeacherType teacherType)
{
if (ModelState.IsValid)
{
String sql = "Update TeacherTypes set TypeName = '" + teacherType.TypeName + "' where TeacherTypeID = " + teacherType.TeacherTypeID;
db.Edit(sql);
return(RedirectToAction("Index"));
}
return(View(teacherType));
}
public ActionResult Create(TeacherType teacherType)
{
if (ModelState.IsValid)
{
String sql = "Insert into TeacherTypes (TypeName) values ('" + teacherType.TypeName + "')";
db.Create(sql);
return(RedirectToAction("Index"));
}
return(View(teacherType));
}
public List <Teacher> GetBy(TeacherType teacherType)
{
try
{
List <Teacher> teachers = _da.GetModelsBy <Teacher, TEACHER>(t => t.Teacher_Type_Id == teacherType.Id);
return(GetByHelper(teachers));
}
catch (Exception)
{
throw;
}
}
// GET: TeacherTypes/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TeacherType teacherType = db.TeacherTypes.Find(id);
if (teacherType == null)
{
return(HttpNotFound());
}
return(View(teacherType));
}
private void InitControlValuesForEdit(int id)
{
train_course_view info = context.train_course_view.Single(i => i.Id == id);
Name.Text = info.Name;
Name.Enabled = false;
Number.Text = info.Number;
Number.Enabled = false;
Time.Text = info.Time.ToString();
Time.Enabled = false;
Description.Text = info.Description;
Description.Enabled = false;
Type.Value = info.Type;
Type.DataBind();
Type.Enabled = false;
lessonType.DataBind();
ContentType.Value = info.ContentTypeId;
ContentType.DataBind();
ContentType.Enabled = false;
LinqContentType.DataBind();
Place.Text = info.Place;
Place.Enabled = false;
Class_time.Text = info.Class_time;
Class_time.Enabled = false;
start_date.Date = info.Start_date;
start_date.Enabled = false;
end_date.Date = info.End_date;
end_date.Enabled = false;
EndChooseDate.Date = info.End_choose_date;
EndChooseDate.Enabled = false;
Teacher.Value = info.Teacher;
TeacherType.DataBind();
//TeacherType.Enabled = false;
Status.Value = info.Status;
Status.DataBind();
Status.Enabled = false;
CourseStatus.DataBind();
Create_time.Text = info.Create_time.ToString();
Create_time.Enabled = false;
}
public List <Teacher> GetBy(TeacherType teacherType, QualificationCategory qualification)
{
try
{
List <TEACHER> entities = (from teacher in _da.DbContext.Set <TEACHER>()
where teacher.Teacher_Type_Id == teacherType.Id &&
teacher.TEACHER_EDUCATIONAL_QUALIFICATION.Any(x => x.QUALIFICATION.Qualification_Category_Id == qualification.Id)
select teacher).ToList();
List <Teacher> teachers = Translate(entities);
return(GetByHelper(teachers));
}
catch (Exception)
{
throw;
}
}
public List <Teacher> GetBy(TeacherType teacherType, State state)
{
try
{
List <TEACHER> entities = (from teacher in _da.DbContext.Set <TEACHER>()
where teacher.PERSON.State_Id == state.Id &&
teacher.Teacher_Type_Id == teacherType.Id
select teacher).ToList();
List <Teacher> teachers = Translate(entities);
return(GetByHelper(teachers));
}
catch (Exception)
{
throw;
}
}
public List <Teacher> GetBy(TeacherType teacherType, StudentCategory childCategory)
{
try
{
List <TEACHER> entities = (from teacher in _da.DbContext.Set <TEACHER>()
where teacher.Teacher_Type_Id == teacherType.Id &&
teacher.TEACHER_STUDENT_CATEGORY.Any(x => x.Student_Category_Id == childCategory.Id)
select teacher).ToList();
List <Teacher> teachers = Translate(entities);
return(GetByHelper(teachers));
}
catch (Exception)
{
throw;
}
}
public List <Teacher> GetBy(TeacherType teacherType, StudentCategory childCategory, QualificationCategory qualification, State state)
{
try
{
List <TEACHER> entities = (from teacher in _da.DbContext.Set <TEACHER>()
where teacher.PERSON.State_Id == state.Id &&
teacher.Teacher_Type_Id == teacherType.Id &&
teacher.TEACHER_STUDENT_CATEGORY.Any(x => x.Student_Category_Id == childCategory.Id) &&
teacher.TEACHER_EDUCATIONAL_QUALIFICATION.Any(x => x.QUALIFICATION.Qualification_Category_Id == qualification.Id)
select teacher).ToList();
List <Teacher> teachers = Translate(entities);
return(GetByHelper(teachers));
}
catch (Exception)
{
throw;
}
}
private List <Teacher> CheckTeaher(string name, int age, QualificationsResult result, int hour, TeacherType type)
{
_stubTeacher.SelectTeachers().Returns(new List <Teacher>
{
new Teacher {
Name = name, Age = age, CheckResult = result, Hour = hour, Type = type
}
});
return(_teacher.CheckTeacherQualifications());
}
protected List <Teacher> FindTeacherByHelper(TeacherType teacherType, StudentCategory studentCategory, QualificationCategory qualification, State location)
{
List <Teacher> teachers = null;
try
{
if ((teacherType != null && teacherType.Id > 0) && (studentCategory == null || studentCategory.Id <= 0) && (qualification == null || qualification.Id <= 0) && (location == null || string.IsNullOrWhiteSpace(location.Id)))
{
teachers = _teacherFinder.GetBy(teacherType);
}
else if ((teacherType == null || teacherType.Id <= 0) && (studentCategory != null && studentCategory.Id > 0) && (qualification == null || qualification.Id <= 0) && (location == null || string.IsNullOrWhiteSpace(location.Id)))
{
teachers = _teacherFinder.GetBy(studentCategory);
}
else if ((teacherType == null || teacherType.Id <= 0) && (studentCategory == null || studentCategory.Id <= 0) && (qualification != null && qualification.Id > 0) && (location == null || string.IsNullOrWhiteSpace(location.Id)))
{
teachers = _teacherFinder.GetBy(qualification);
}
else if ((teacherType == null || teacherType.Id <= 0) && (studentCategory == null || studentCategory.Id <= 0) && (qualification == null || qualification.Id <= 0) && (location != null && !string.IsNullOrWhiteSpace(location.Id)))
{
teachers = _teacherFinder.GetBy(location);
}
else if ((teacherType != null && teacherType.Id > 0) && (studentCategory != null && studentCategory.Id > 0) && (qualification == null || qualification.Id <= 0) && (location == null || string.IsNullOrWhiteSpace(location.Id)))
{
teachers = _teacherFinder.GetBy(teacherType, studentCategory);
}
else if ((teacherType != null && teacherType.Id > 0) && (studentCategory == null || studentCategory.Id <= 0) && (qualification != null && qualification.Id > 0) && (location == null || string.IsNullOrWhiteSpace(location.Id)))
{
teachers = _teacherFinder.GetBy(teacherType, qualification);
}
else if ((teacherType != null && teacherType.Id > 0) && (studentCategory == null || studentCategory.Id <= 0) && (qualification == null || qualification.Id <= 0) && (location != null && !string.IsNullOrWhiteSpace(location.Id)))
{
teachers = _teacherFinder.GetBy(teacherType, location);
}
else if ((teacherType == null || teacherType.Id <= 0) && (studentCategory != null && studentCategory.Id > 0) && (qualification != null && qualification.Id > 0) && (location == null || string.IsNullOrWhiteSpace(location.Id)))
{
teachers = _teacherFinder.GetBy(studentCategory, qualification);
}
else if ((teacherType == null || teacherType.Id <= 0) && (studentCategory != null && studentCategory.Id > 0) && (qualification == null || qualification.Id <= 0) && (location != null && !string.IsNullOrWhiteSpace(location.Id)))
{
teachers = _teacherFinder.GetBy(studentCategory, location);
}
else if ((teacherType == null || teacherType.Id <= 0) && (studentCategory == null || studentCategory.Id <= 0) && (qualification != null && qualification.Id > 0) && (location != null && !string.IsNullOrWhiteSpace(location.Id)))
{
teachers = _teacherFinder.GetBy(qualification, location);
}
else if ((teacherType != null && teacherType.Id > 0) && (studentCategory != null && studentCategory.Id > 0) && (qualification != null && qualification.Id > 0) && (location == null || string.IsNullOrWhiteSpace(location.Id)))
{
teachers = _teacherFinder.GetBy(teacherType, studentCategory, qualification);
}
else if ((teacherType != null && teacherType.Id > 0) && (studentCategory != null && studentCategory.Id > 0) && (qualification == null || qualification.Id <= 0) && (location != null && !string.IsNullOrWhiteSpace(location.Id)))
{
teachers = _teacherFinder.GetBy(teacherType, studentCategory, location);
}
else if ((teacherType != null && teacherType.Id > 0) && (studentCategory == null || studentCategory.Id <= 0) && (qualification != null && qualification.Id > 0) && (location != null && !string.IsNullOrWhiteSpace(location.Id)))
{
teachers = _teacherFinder.GetBy(teacherType, qualification, location);
}
else if ((teacherType == null || teacherType.Id <= 0) && (studentCategory != null && studentCategory.Id > 0) && (qualification != null && qualification.Id > 0) && (location != null && !string.IsNullOrWhiteSpace(location.Id)))
{
teachers = _teacherFinder.GetBy(studentCategory, qualification, location);
}
else if ((teacherType != null && teacherType.Id > 0) && (studentCategory != null && studentCategory.Id > 0) && (qualification != null && qualification.Id > 0) && (location != null && !string.IsNullOrWhiteSpace(location.Id)))
{
teachers = _teacherFinder.GetBy(teacherType, studentCategory, qualification, location);
}
return(teachers);
}
catch (Exception)
{
throw;
}
}
