// GET: School
public ActionResult Index(string languageCode, string location, string url)
{
pageReturnData data = new pageReturnData();
data.languageCode = languageCode;
using (ApplicationDbContext DB = new ApplicationDbContext())
{
try
{
Page page = new Page();
data.page = page.getPage(7, languageCode);
/// maybe add location, certianly add duplicate name check for schools edit and creation
var s = DB.Schools.FirstOrDefault(ss => ss.url == url);
if(s != null)
{
s.languageCode = languageCode;
s.loadContent(DB, true);
data.school = s;
data.courses = Functions.getSchoolCourses(s.id, languageCode, true);
}
return View("school", data);
}
catch (Exception ex)
{
data.message = "Error: " + ex.Message;
return View("school", data);
}
}
}
public ActionResult AddNewPage(Page page)
{
ajaxReturnData data = new ajaxReturnData();
using (ApplicationDbContext db = new ApplicationDbContext())
{
try
{
db.Pages.Add(page);
db.SaveChanges();
data.statusCode = (int)statusCodes.successRun;
data.callback = "getPageList";
data.message = "Page added";
}
catch (Exception ex)
{
data.statusCode = (int)statusCodes.fail;
data.message = "Error: " + ex.Message;
}
}
return Json(data);
}
// route japan-apartments-rent-guesthouse-homestay
public ActionResult accomodation(string languageCode)
{
pageReturnData data = new pageReturnData();
data.languageCode = languageCode;
using (ApplicationDbContext db = new ApplicationDbContext())
{
try
{
Page page = new Page();
data.page = page.getPage(3, languageCode);
}
catch (Exception ex)
{
data.message = "Error: " + ex.Message;
}
}
return View("Accomodation", data);
}
public Page getPage(int pageID, string languageCode, bool withAdminControls=true)
{
Page page = new Page();
using (ApplicationDbContext DB = new ApplicationDbContext()) {
page = DB.Pages
.Include("galleries.galleryImages.content")
.Include("galleries.content")
.Include("faqs.questions.content")
.Include("content")
.Where(p => p.pageID == pageID).FirstOrDefault();
}
page.getContentByLanguage(languageCode);
if (withAdminControls)
{
page.doAdminControls(languageCode);
}
return page;
}
public ActionResult editPage(Page page, string callback)
{
ajaxReturnData data = new ajaxReturnData();
using (ApplicationDbContext db = new ApplicationDbContext())
{
try
{
//db.Pages.Attach(page);
db.Entry(page).State = EntityState.Modified;
db.SaveChanges();
if (string.IsNullOrEmpty(callback))
{
data.statusCode = (int)statusCodes.success;
}
else
{
data.statusCode = (int)statusCodes.successRun;
data.callback = callback;
}
data.message = "Page updated";
}
catch (Exception ex)
{
data.statusCode = (int)statusCodes.fail;
data.message = "Error: " + ex.Message;
}
}
return Json(data);
}
public ActionResult deletePage(int pageID)
{
ajaxReturnData data = new ajaxReturnData();
using (ApplicationDbContext db = new ApplicationDbContext())
{
try
{
Page doomedPage = new Page();
doomedPage.pageID = pageID;
db.Pages.Attach(doomedPage);
db.Pages.Remove(doomedPage);
db.SaveChanges();
data.message = "Page removed";
data.statusCode = (int)statusCodes.successRun;
data.callback = "getPageList";
}
catch (Exception ex)
{
data.statusCode = (int)statusCodes.fail;
data.message = "Error: " + ex.Message;
}
}
return Json(data);
}
// route terms-and-conditions
public ActionResult careers(string languageCode)
{
pageReturnData data = new pageReturnData();
data.languageCode = languageCode;
data.page = new Page();
using (ApplicationDbContext DB = new ApplicationDbContext())
{
try
{
Page page = new Page();
data.page = page.getPage(5, languageCode);
}
catch (Exception ex)
{
data.message = "Error: " + ex.Message;
}
}
//return Json(data,JsonRequestBehavior.AllowGet);
return View("careers", data);
}
// route schools
public ActionResult schools(string languageCode)
{
pageReturnData data = new pageReturnData();
data.languageCode = languageCode;
Page page = new Page();
data.page = page.getPage(6, languageCode);
using (ApplicationDbContext DB = new ApplicationDbContext())
{
try
{
data.schools = DB.Schools.Include("schoolLocation").ToList();
foreach (School s in data.schools)
{
s.languageCode = languageCode;
s.loadContent(DB);
}
}
catch (Exception ex)
{
data.message = "Error: " + ex.Message;
}
}
//return Json(data,JsonRequestBehavior.AllowGet);
return View("schools", data);
}
