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);
}
