public string DeleteImgAlbum(long id)
{
try
{
utblImageAlbum model = db.utblImageAlbums.Find(id);
db.utblImageAlbums.Remove(model);
db.SaveChanges();
return("Image Album Removed");
}
catch (Exception)
{
return("Error: Server error, try again later");
}
}
public ActionResult Photo(long id)
{
ImageAlbumManageModel model = new ImageAlbumManageModel();
utblImageAlbum _imodel = new utblImageAlbum();
model.Imageslist = ObjImage.GetImageByAlbumID(id);
_imodel = ObjImgAlbum.GetImgAlbumByID(id);
model.ImageAlbum = _imodel;
if (Request.IsAjaxRequest())
{
return(PartialView("_pvImageList", model));
}
return(View(model));
}
public string SaveImgAlbum(utblImageAlbum model)
{
var parImageAlbumID = new SqlParameter("@ImageAlbumID", model.ImageAlbumID);
var parImageAlbumTitle = new SqlParameter("@ImageAlbumTitle", model.ImageAlbumTitle);
var parImageAlbumDesc = new SqlParameter("@ImageAlbumDesc", model.ImageAlbumDesc);
var parProgramDate = new SqlParameter("@ProgramDate", model.ProgramDate);
var parComponentID = new SqlParameter("@ComponentID", model.ComponentID);
var parSubComponentID = new SqlParameter("@SubComponentID", model.SubComponentID);
var parSchoolID = new SqlParameter("@SchoolID", model.SchoolID);
var parIsPublished = new SqlParameter("@IsPublished", model.IsPublished);
var parPublishDate = new SqlParameter("@PublishDate", DBNull.Value);
if (model.PublishDate != null)
{
parPublishDate = new SqlParameter("@PublishDate", model.PublishDate);
}
var parTransDate = new SqlParameter("@TransDate", model.TransDate);
var parUserID = new SqlParameter("@UserID", model.UserID);
return(db.Database.SqlQuery <string>("udspImageAlbumSave @ImageAlbumID,@ImageAlbumTitle, @ImageAlbumDesc, @ProgramDate,@ComponentID,@SubComponentID,@SchoolID, @IsPublished,@PublishDate, @TransDate, @UserID",
parImageAlbumID, parImageAlbumTitle, parImageAlbumDesc, parProgramDate, parComponentID, parSubComponentID, parSchoolID, parIsPublished, parPublishDate, parTransDate, parUserID).FirstOrDefault());
}
