public ActionResult Delete(int?id)
{
if (!string.IsNullOrEmpty(id.ToString()))
{
db = new DenimEntities();
try
{
if (!string.IsNullOrWhiteSpace(Convert.ToString(id)))
{
News obj = db.News.Find(id);
db.News.Remove(obj);
db.SaveChanges();
}
}
catch
{
}
News objEvents = new News();
objEvents.NewsList = db.News.ToList();
return(View("Index", objEvents.NewsList));
}
else
{
return(View("~/Areas/Admin/Views/Shared/Error.cshtml"));
}
}
public ActionResult Save(Event objEvnt)
{
ViewBag.IsSaved = false;
db = new DenimEntities();
if (ModelState.IsValid)
{
try
{
objEvent.Note = objEvnt.Note;
objEvent.Date = objEvnt.Date;
objEvent.Status = objEvnt.Status;
db.Events.Add(objEvent);
db.SaveChanges();
ModelState.Clear();
ViewBag.IsSaved = true;
}
catch (Exception)
{
}
}
Event objEvents = new Event();
objEvents.eventList = db.Events.ToList();
return(View("Index", objEvents.eventList));
}
public ActionResult Save(News objNews)
{
ViewBag.IsSaved = false;
db = new DenimEntities();
if (ModelState.IsValid)
{
try
{
obj.Title = objNews.Title;
obj.Date = objNews.Date;
obj.Description = objNews.Description;
db.News.Add(obj);
db.SaveChanges();
ModelState.Clear();
ViewBag.IsSaved = true;
}
catch (Exception)
{
}
}
News objEvents = new News();
objEvents.NewsList = db.News.ToList();
return(View("Index", objEvents.NewsList));
}
public ActionResult Update(Gallery objgal, int id)
{
try {
db = new DenimEntities();
Gallery gal = db.Galleries.Find(id);
gal.EventId = objgal.EventId;
gal.ImageName = objgal.ImageName;
db.Entry(gal);
db.SaveChanges();
}
catch
{
}
Gallery objEvents = new Gallery();
objEvents.imageList = db.Galleries.ToList();
return(View("Index", objEvents.imageList));
//objGallery = new Gallery();
//ViewBag.Event = new SelectList(db.Events, "Id", "Note", objGallery.EventId);
//return View();
}
// GET: Admin/News
public ActionResult Index()
{
db = new DenimEntities();
//News objEvents = new News();
obj.NewsList = db.News.ToList();
return(View(obj.NewsList));
}
public ActionResult Index()
{
db = new DenimEntities();
Denim.Models.File objEvents = new Denim.Models.File();
objFile.FileList = db.Files.ToList();
return(View(objFile.FileList));
}
public ActionResult AddGalleryImage()
{
db = new DenimEntities();
ViewBag.EventId = new SelectList(db.Events, "Id", "Note");
return(View());
}
public ActionResult Index()
{
db = new DenimEntities();
Event objEvents = new Event();
objEvents.eventList = db.Events.ToList();
return(View(objEvents.eventList));
}
public ActionResult Index()
{
db = new DenimEntities();
objGallery = new Gallery();
objGallery.imageList = db.Galleries.ToList();
return(View(objGallery.imageList));
}
public ActionResult DeleteEvent(int?Id)
{
if (!string.IsNullOrEmpty(Id.ToString()))
{
db = new DenimEntities();
News obj = db.News.Find(Id);
return(View(obj));
}
else
{
return(View("~/Areas/Admin/Views/Shared/Error.cshtml"));
}
}
public ActionResult EditEvent(Event objEvent, int?id)
{
if (!string.IsNullOrEmpty(id.ToString()))
{
db = new DenimEntities();
Event objEvnt = db.Events.Find(id);
return(View(objEvnt));
}
else
{
return(View("~/Areas/Admin/Views/Shared/Error.cshtml"));
}
}
public ActionResult EditGalleryImage(int id)
{
if (!string.IsNullOrEmpty(id.ToString()))
{
db = new DenimEntities();
Gallery objEvnt = db.Galleries.Find(id);
return(View(objEvnt));
}
else
{
return(View("~/Views/Shared/ErrorAdmin.cshtml"));
}
}
public ActionResult DeleteGalleryImage(int id)
{
if (!string.IsNullOrEmpty(id.ToString()))
{
db = new DenimEntities();
Gallery objGallery = db.Galleries.Find(id);
db.Galleries.Remove(objGallery);
db.SaveChanges();
objGallery.imageList = db.Galleries.ToList();
return(View("Index", objGallery.imageList));
}
else
{
return(View("~/Areas/Admin/Views/Shared/Error.cshtml"));
}
}
public ActionResult Update(News objEvnt, int id)
{
try
{
db = new DenimEntities();
News obj = db.News.Find(id);
obj.Title = objEvnt.Title;
obj.Date = objEvnt.Date;
obj.Description = objEvnt.Description;
db.Entry(obj);
db.SaveChanges();
}
catch
{
}
obj.NewsList = db.News.ToList();
return(View("Index", obj.NewsList));
}
public ActionResult Update(Event objEvnt, int id)
{
try
{
db = new DenimEntities();
Event objEvent = db.Events.Find(id);
objEvent.Note = objEvnt.Note;
objEvent.Date = objEvnt.Date;
objEvent.Status = objEvnt.Status;
db.Entry(objEvent);
db.SaveChanges();
}
catch
{
}
Event objEvents = new Event();
objEvents.eventList = db.Events.ToList();
return(View("Index", objEvents.eventList));
}
/* select e.id,e.note,e.date,g.ImagePath
* from Gallery g join Events e on g.EventId = e.Id group by e.Id, e.Note, e.Date, g.ImagePath order by e.id
*/
public ActionResult Gallery()
{
Db = new DenimEntities();
var events = (from g in Db.Galleries join e in Db.Events on g.EventId equals e.Id select new { e.Id, e.Note, e.Date, g.ImagePath });
// var groupedEvents = events.GroupBy(e => e.Id).ToList();
List <GalleryEventView> model = new List <GalleryEventView>();
foreach (var item in events)
{
model.Add(new GalleryEventView()
{
Id = item.Id,
Date = item.Date,
Note = item.Note,
ImagePath = item.ImagePath
});
}
return(View(model));
}
public ActionResult SaveGallery(Gallery objGal, HttpPostedFileBase file)
{
ViewBag.IsSaved = false;
db = new DenimEntities();
if (ModelState.IsValid)
{
try
{
var fileName = "";
if (file.ContentLength > 0)
{
fileName = Path.GetFileName(file.FileName);
var path = Path.Combine(Server.MapPath("~/Gallery/Events"), fileName);
string[] file_name = fileName.Split('.');
file.SaveAs(path);
}
string ImageName = fileName.Split('.')[0].ToString();
string ImagePath = "Gallery/Events/" + fileName;
objGallery = new Gallery();
objGallery.EventId = objGal.EventId;
objGallery.ImageName = ImageName;
objGallery.ImagePath = ImagePath;
db.Galleries.Add(objGallery);
db.SaveChanges();
ModelState.Clear();
ViewBag.IsSaved = true;
}
catch (Exception)
{
}
}
ViewBag.EventId = new SelectList(db.Events, "Id", "Note");
objGallery.imageList = db.Galleries.ToList();
return(View("Index", objGallery.imageList));
}
