public ActionResult getShortCourseGalleries(int courseID, string callback)
{
ajaxReturnData data = new ajaxReturnData();
try
{
using (ApplicationDbContext DB = new ApplicationDbContext())
{
ShortCourse sc = DB.shortCourses.Where(s => s.id == courseID)
.Include("featureGallery")
.Include("schoolGallery")
.Include("accommodationGallery")
.Include("staffGallery")
.FirstOrDefault();
bool featureGalleryNew = false;
if (sc.featureGallery == null)
{
ImageGallery gal = new ImageGallery();
sc.featureGallery = gal;
featureGalleryNew = true;
}
bool schoolGalleryNew = false;
if (sc.schoolGallery == null)
{
ImageGallery gal = new ImageGallery();
sc.schoolGallery = gal;
schoolGalleryNew = true;
}
bool accommodationGalleryNew = false;
if (sc.accommodationGallery == null)
{
ImageGallery gal = new ImageGallery();
sc.accommodationGallery = gal;
accommodationGalleryNew = true;
}
bool staffGalleryNew = false;
if (sc.staffGallery == null)
{
ImageGallery gal = new ImageGallery();
sc.staffGallery = gal;
staffGalleryNew = true;
}
DB.SaveChanges();
sc = DB.shortCourses.Where(s => s.id == courseID)
.Include("featureGallery")
.Include("schoolGallery")
.Include("accommodationGallery")
.Include("staffGallery")
.FirstOrDefault();
if(featureGalleryNew)
{
sc.featureGallery.addTitle(DB, "short course feature gallery");
}
if (staffGalleryNew)
{
sc.staffGallery.addTitle(DB, "short course staff gallery");
}
if (accommodationGalleryNew)
{
sc.accommodationGallery.addTitle(DB, "short course accommodation gallery");
}
if (schoolGalleryNew)
{
sc.schoolGallery.addTitle(DB, "schort course school gallery");
}
sc.featureGallery.loadContent(DB);
sc.staffGallery.loadContent(DB);
sc.accommodationGallery.loadContent(DB);
sc.schoolGallery.loadContent(DB);
List<ImageGallery> galleries = new List<ImageGallery>();
galleries.Add(sc.featureGallery);
galleries.Add(sc.schoolGallery);
galleries.Add(sc.accommodationGallery);
galleries.Add(sc.staffGallery);
data.data = galleries;
}
if (string.IsNullOrEmpty(callback))
{
data.statusCode = (int)statusCodes.success;
}
else
{
data.statusCode = (int)statusCodes.successRun;
data.callback = callback;
}
return Json(data);
}
catch (Exception ex)
{
data.statusCode = (int)statusCodes.fail;
data.message = "Failed to get general short course galleries; " + ex.Message;
return Json(data);
}
}
public ActionResult addPageGallery(int pageID, string callback, string name)
{
ajaxReturnData data = new ajaxReturnData();
try
{
using (ApplicationDbContext DB = new ApplicationDbContext())
{
ImageGallery gal = new ImageGallery();
DB.gallerys.Add(gal);
DB.SaveChanges();
gal.addTitle(DB, name);
Page page = DB.Pages.Where(p => p.pageID == pageID).Include("galleries").FirstOrDefault();
page.galleries.Add(gal);
DB.SaveChanges();
}
if (string.IsNullOrEmpty(callback))
{
data.statusCode = (int)statusCodes.success;
}
else
{
data.statusCode = (int)statusCodes.successRun;
data.callback = callback;
}
data.message = "page gallery added";
return Json(data);
}
catch (Exception ex)
{
data.statusCode = (int)statusCodes.fail;
data.message = "failed to add page gallery; " + ex.Message;
return Json(data);
}
}
public ActionResult addShortCourseCulturalGallery(int courseID, string callback, string name)
{
ajaxReturnData data = new ajaxReturnData();
try
{
using (ApplicationDbContext DB = new ApplicationDbContext())
{
ImageGallery gal = new ImageGallery();
DB.gallerys.Add(gal);
DB.SaveChanges();
gal.addTitle(DB, name);
ShortCourse sc = DB.shortCourses.Where(s => s.id == courseID).Include("culturalGalleries").FirstOrDefault();
sc.culturalGalleries.Add(gal);
DB.SaveChanges();
}
if (string.IsNullOrEmpty(callback))
{
data.statusCode = (int)statusCodes.success;
}
else
{
data.statusCode = (int)statusCodes.successRun;
data.callback = callback;
}
data.message = "cultural activity gallery added";
return Json(data);
}
catch (Exception ex)
{
data.statusCode = (int)statusCodes.fail;
data.message = "failed to add short course cultrual gallery; " + ex.Message;
return Json(data);
}
}
