public string DeleteVideoAlbum(long id)
{
try
{
utblVideoAlbum model = db.utblVideoAlbums.Find(id);
db.utblVideoAlbums.Remove(model);
db.SaveChanges();
return("Video Album Removed");
}
catch (Exception)
{
return("Error: Server error, try again later");
}
}
public ActionResult VideoList(long id)
{
VideoAlbumManageModel model = new VideoAlbumManageModel();
utblVideoAlbum _vmodel = new utblVideoAlbum();
model.Videolist = ObjVideo.GetVideoByAlbumID(id);
_vmodel = ObjVideoAlbum.GetVideoAlbumByID(id);
model.VideoAlbum = _vmodel;
if (Request.IsAjaxRequest())
{
return(PartialView("_pvVideoList", model));
}
return(View(model));
}
public string SaveVideoAlbum(utblVideoAlbum model)
{
var parVideoAlbumID = new SqlParameter("@VideoAlbumID", model.VideoAlbumID);
var parVideoAlbumTitle = new SqlParameter("@VideoAlbumTitle", model.VideoAlbumTitle);
var parVideoAlbumDesc = new SqlParameter("@VideoAlbumDesc", model.VideoAlbumDesc);
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>("udspVideoAlbumSave @VideoAlbumID,@VideoAlbumTitle, @VideoAlbumDesc, @ProgramDate,@ComponentID,@SubComponentID,@SchoolID,@IsPublished,@PublishDate, @TransDate, @UserID",
parVideoAlbumID, parVideoAlbumTitle, parVideoAlbumDesc, parProgramDate, parComponentID, parSubComponentID, parSchoolID, parIsPublished, parPublishDate, parTransDate, parUserID).FirstOrDefault());
}
