//
// GET: /ExamAbsent/
public ActionResult Index(TB_APPLICATION_STUDENT _model)
{
var varListOfConcern = from sch in db.TB_APPLICATION_SCHOOL
join std in db.TB_APPLICATION_STUDENT on sch.SCHOOL_ID equals std.STD_SCHOOL_ID
join staff in db.TB_APPLICATION_STAFF on sch.SCHOOL_ID equals staff.STAFF_SCHOOL_ID
join lv in db.TB_M_LEVEL on std.STD_LEVEL_ID equals lv.LEVEL_ID
where std.STD_IS_CONCERN == "1" && std.STD_BIRTH_DAY != null
select new ConcernView()
{
SCHOOL_NAME = sch.SCHOOL_NAME,
STD_NAME = std.STD_NAME,
STD_SURNAME = std.STD_SURNAME,
STAFF_NAME = staff.STAFF_NAME,
STAFF_PHONE = staff.STAFF_PHONE,
LEVEL_NAME = lv.LEVEL_NAME_TH
};
List <ConcernView> reportLists = varListOfConcern.ToList();
int seq = 1;
foreach (ConcernView std in reportLists)
{
std.seq = seq;
seq++;
}
if (reportLists != null)
{
var pageIndex = _model.Page ?? 1;
_model.reports = reportLists.ToPagedList(pageIndex, 20);
}
return(View(_model));
}
public ActionResult Edit(TB_APPLICATION_STUDENT tb_application_student)
{
if (ModelState.IsValid)
{
int schoolId = (int)Session["Phet10ManagementSchoolId"];
var _update = db.TB_APPLICATION_STUDENT.FirstOrDefault(f => f.STD_ID == tb_application_student.STD_ID);
if (_update != null)
{
_update.STD_SCHOOL_ID = schoolId;
_update.STD_TITLE_ID = tb_application_student.STD_TITLE_ID;
_update.STD_NAME = tb_application_student.STD_NAME;
_update.STD_SURNAME = tb_application_student.STD_SURNAME;
_update.STD_LEVEL_ID = tb_application_student.STD_LEVEL_ID;
_update.STD_SCHOOL_ID = tb_application_student.STD_SCHOOL_ID;
_update.STD_PICTURE_PATH = tb_application_student.STD_PICTURE_PATH;
_update.STD_PHONE = tb_application_student.STD_PHONE;
_update.STD_EMAIL = tb_application_student.STD_EMAIL;
_update.STD_ID_CARD = tb_application_student.STD_ID_CARD;
_update.STD_PASSPORT_ID = tb_application_student.STD_PASSPORT_ID;
_update.STD_GRADE = tb_application_student.STD_GRADE;
_update.STD_PHONE_PROVIDER = tb_application_student.STD_PHONE_PROVIDER;
_update.STD_APPROVED_STATUS = tb_application_student.STD_APPROVED_STATUS;
_update.STD_BIRTH_DAY = tb_application_student.STD_BIRTH_DAY;
_update.STD_IS_CONCERN = tb_application_student.STD_IS_CONCERN;
}
db.SaveChanges();
return(RedirectToAction("Index/" + schoolId));
}
ViewBag.STD_LEVEL_ID = new SelectList(db.TB_M_LEVEL, "LEVEL_ID", "LEVEL_NAME_TH", tb_application_student.STD_LEVEL_ID);
ViewBag.STD_TITLE_ID = new SelectList(db.TB_M_TITLE, "TITLE_ID", "TITLE_NAME_TH", tb_application_student.STD_TITLE_ID);
return(View(tb_application_student));
}
public JsonResult deleteStudent(String id)
{
int deleteId = Convert.ToInt16(id);
TB_APPLICATION_STUDENT student = db.TB_APPLICATION_STUDENT.Where(s => s.STD_ID == deleteId).FirstOrDefault();
db.TB_APPLICATION_STUDENT.Remove(student);
int result = db.SaveChanges();
return(Json(true));
}
//
// GET: /Student/Edit/5
public ActionResult Edit(int id = 0)
{
TB_APPLICATION_STUDENT tb_application_student = db.TB_APPLICATION_STUDENT.Single(t => t.STD_ID == id);
if (tb_application_student == null)
{
return(HttpNotFound());
}
ViewBag.STD_LEVEL_ID = new SelectList(db.TB_M_LEVEL, "LEVEL_ID", "LEVEL_NAME_TH", tb_application_student.STD_LEVEL_ID);
ViewBag.STD_TITLE_ID = new SelectList(db.TB_M_TITLE, "TITLE_ID", "TITLE_NAME_TH", tb_application_student.STD_TITLE_ID);
ViewBag.STD_APPROVED_STATUS = new SelectList(db.TB_M_STATUS, "STATUS_ID", "STATUS_NAME_TH", tb_application_student.STD_APPROVED_STATUS);
return(View(tb_application_student));
}
/* CUSTOM EVENT*/
public JsonResult DeleteStudent(int ID)
{
TB_APPLICATION_STUDENT tb_application_student = db.TB_APPLICATION_STUDENT.Single(t => t.STD_ID == ID);
if (tb_application_student != null)
{
db.TB_APPLICATION_STUDENT.Remove(tb_application_student);
db.SaveChanges();
}
// delete the record from ID and return true else false
return(Json(true, JsonRequestBehavior.AllowGet));
}
public ActionResult Create(TB_APPLICATION_STUDENT tb_application_student)
{
if (ModelState.IsValid)
{
int schoolId = (int)Session["Phet10ManagementSchoolId"];
tb_application_student.STD_SCHOOL_ID = schoolId;
db.TB_APPLICATION_STUDENT.Add(tb_application_student);
db.SaveChanges();
return(RedirectToAction("Index/" + schoolId));
}
ViewBag.STD_LEVEL_ID = new SelectList(db.TB_M_LEVEL, "LEVEL_ID", "LEVEL_NAME_TH", tb_application_student.STD_LEVEL_ID);
ViewBag.STD_TITLE_ID = new SelectList(db.TB_M_TITLE, "TITLE_ID", "TITLE_NAME_TH", tb_application_student.STD_TITLE_ID);
return(View(tb_application_student));
}
public String getStudentFullName(TB_APPLICATION_STUDENT student)
{
return(student.TB_M_TITLE.TITLE_NAME_TH + "" + student.STD_NAME + " " + student.STD_SURNAME);
}
