public IActionResult InsertUpdateSuccessStoryVideo([FromBody] SuccessStoryVideoViewModel model) { int id = 0; var result = false; try { { var user = HttpContext.Session.Get <UserViewModel>(Constants.SessionKeyUserInfo); result = _successStoryVideoHandler.InsertUpdateSuccessStoryVid(model, user.FirstName); }; } catch (DataNotUpdatedException ex) { return(Json(ex)); } if (result && id != 0) { //return View(); return(Json("Record Updated")); } else if (result && id == 0) { return(Json("Record Added")); } return(Json("Unable to do this action")); }
public bool InsertUpdateSuccessStoryVid(SuccessStoryVideoViewModel successStory) { using (var connection = new SqlConnection(connectionString)) { try { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@SSId", successStory.Id), new SqlParameter("@SSTitle", successStory.Title), new SqlParameter("@SSFileName", successStory.VideoFile), new SqlParameter("@SSType", successStory.Type), new SqlParameter("@UpdatedBy", successStory.UpdatedBy), new SqlParameter("@DisplayOrder", successStory.DisplayOrder), }; var data = SqlHelper.ExecuteNonQuery ( connection, CommandType.StoredProcedure, "usp_InsertUpdateSuccessStoryVid", parameters ); if (data > 0) { return(true); } } finally { SqlHelper.CloseConnection(connection); } } throw new DataNotUpdatedException("Unable to update data"); }
public bool InsertUpdateSuccessStoryVid(SuccessStoryVideoViewModel successStory, string updatedBy) { SuccessStoryVideoViewModel ssVid = new SuccessStoryVideoViewModel { Id = successStory.Id, Title = successStory.Title, Type = successStory.Type, VideoFile = successStory.VideoFile, DisplayOrder = successStory.DisplayOrder, UpdatedBy = Convert.ToString(updatedBy) }; var result = successStoryVideoRepository.InsertUpdateSuccessStoryVid(ssVid); if (result) { return(true); } throw new DataNotUpdatedException("Unable to update data"); }
public List <SuccessStoryVideoViewModel> GetSuccessStoryVid() { DataTable dt = successStoryVideoRepository.GetSuccessStoryVid(); List <SuccessStoryVideoViewModel> ssVideoList = new List <SuccessStoryVideoViewModel>(); for (int i = 0; i < dt.Rows.Count; i++) { SuccessStoryVideoViewModel ssVideo = new SuccessStoryVideoViewModel() { Id = Convert.ToInt32(dt.Rows[i]["Id"]), Title = Convert.ToString(dt.Rows[i]["Title"]), Type = Convert.ToString(dt.Rows[i]["Type"]), VideoFile = Convert.ToString(dt.Rows[i]["FileName"]), //SerialNo = Convert.ToString(dt.Rows[i]["SerialNo"]), DisplayOrder = Convert.ToInt16(dt.Rows[i]["DisplayOrder"]), }; ssVideoList.Add(ssVideo); } return(ssVideoList); }
public List <SuccessStoryVideoViewModel> GetSuccussStoryVideos() { DataTable successStoriesVideo = _homeRepositories.GetSuccessStoryVideo(); List <SuccessStoryVideoViewModel> lstsuccessStoryvideo = new List <SuccessStoryVideoViewModel>(); if (successStoriesVideo.Rows.Count > 0) { DataTable dt = successStoriesVideo; for (int i = 0; i < dt.Rows.Count; i++) { SuccessStoryVideoViewModel successStory = new SuccessStoryVideoViewModel { Title = Convert.ToString(dt.Rows[i]["title"]), Video = Convert.ToString(dt.Rows[i]["filename"]), Type = Convert.ToString(dt.Rows[i]["type"]), UpdatedBy = Convert.ToString(dt.Rows[i]["createdby"]), CreatedDate = Convert.ToDateTime(dt.Rows[i]["CreatedDate"]) }; lstsuccessStoryvideo.Add(successStory); } } return(lstsuccessStoryvideo); }