public ActionResult Edit(TB_APPLICATION_STAFF tb_application_staff)
{
if (ModelState.IsValid)
{
int schoolId = (int)Session["Phet10ManagementSchoolId"];
var _update = db.TB_APPLICATION_STAFF.FirstOrDefault(f => f.STAFF_ID == tb_application_staff.STAFF_ID);
if (_update != null)
{
_update.STAFF_SCHOOL_ID = schoolId;
_update.STAFF_POSITION = tb_application_staff.STAFF_POSITION;
_update.STAFF_NAME = tb_application_staff.STAFF_NAME;
_update.STAFF_SURNAME = tb_application_staff.STAFF_SURNAME;
_update.STAFF_PHONE = tb_application_staff.STAFF_PHONE;
_update.STAFF_TITLE_ID = tb_application_staff.STAFF_TITLE_ID;
_update.STAFF_FOR_LEVEL = tb_application_staff.STAFF_FOR_LEVEL;
_update.STAFF_NATION = tb_application_staff.STAFF_NATION;
}
db.SaveChanges();
return(RedirectToAction("Index/" + schoolId));
}
ViewBag.STAFF_TITLE_ID = new SelectList(db.TB_M_TITLE, "TITLE_ID", "TITLE_NAME_TH", tb_application_staff.STAFF_TITLE_ID);
ViewBag.STAFF_FOR_LEVEL = new SelectList(db.TB_M_LEVEL, "LEVEL_ID", "LEVEL_NAME_TH", tb_application_staff.STAFF_FOR_LEVEL);
return(View(tb_application_staff));
}
/* CUSTOM EVENT*/
public JsonResult DeleteStaff(int ID)
{
TB_APPLICATION_STAFF tb_application_staff = db.TB_APPLICATION_STAFF.Single(t => t.STAFF_ID == ID);
db.TB_APPLICATION_STAFF.Remove(tb_application_staff);
db.SaveChanges();
// delete the record from ID and return true else false
return(Json(true, JsonRequestBehavior.AllowGet));
}
public JsonResult deleteStaff(String id)
{
int deleteId = Convert.ToInt16(id);
TB_APPLICATION_STAFF staff = db.TB_APPLICATION_STAFF.Where(s => s.STAFF_ID == deleteId).FirstOrDefault();
db.TB_APPLICATION_STAFF.Remove(staff);
int result = db.SaveChanges();
return(Json(true));
}
//
// GET: /Staff/Edit/5
public ActionResult Edit(int id = 0)
{
TB_APPLICATION_STAFF tb_application_staff = db.TB_APPLICATION_STAFF.Single(t => t.STAFF_ID == id);
if (tb_application_staff == null)
{
return(HttpNotFound());
}
ViewBag.STAFF_TITLE_ID = new SelectList(db.TB_M_TITLE, "TITLE_ID", "TITLE_NAME_TH", tb_application_staff.STAFF_TITLE_ID);
ViewBag.STAFF_FOR_LEVEL = new SelectList(db.TB_M_LEVEL, "LEVEL_ID", "LEVEL_NAME_TH", tb_application_staff.STAFF_FOR_LEVEL);
return(View(tb_application_staff));
}
public ActionResult Create(TB_APPLICATION_STAFF tb_application_staff)
{
if (ModelState.IsValid)
{
int schoolId = (int)Session["Phet10ManagementSchoolId"];
tb_application_staff.STAFF_SCHOOL_ID = schoolId;
db.TB_APPLICATION_STAFF.Add(tb_application_staff);
db.SaveChanges();
return(RedirectToAction("Index/" + schoolId));
}
ViewBag.STAFF_TITLE_ID = new SelectList(db.TB_M_TITLE, "TITLE_ID", "TITLE_NAME_TH", tb_application_staff.STAFF_TITLE_ID);
ViewBag.STAFF_FOR_LEVEL = new SelectList(db.TB_M_LEVEL, "LEVEL_ID", "LEVEL_NAME_TH", tb_application_staff.STAFF_FOR_LEVEL);
return(View(tb_application_staff));
}
//public static DataSet ToDataSet<T>(this IEnumerable<T> collection, string dataTableName)
//{
// if (collection == null)
// {
// throw new ArgumentNullException("collection");
// }
// if (string.IsNullOrEmpty(dataTableName))
// {
// throw new ArgumentNullException("dataTableName");
// }
// DataSet data = new DataSet("NewDataSet");
// data.Tables.Add(FillDataTable(dataTableName, collection));
// return data;
//}
public String getStaffFullName(TB_APPLICATION_STAFF school)
{
return(school.TB_M_TITLE.TITLE_NAME_TH + "" + school.STAFF_NAME + " " + school.STAFF_SURNAME);
}
