public bool PostSuccsessStory(SuccessStoryViewModel successStory)
{
using (var connection = new SqlConnection(connectionString))
{
try
{
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@Name", successStory.name),
new SqlParameter("@Email", successStory.Email),
new SqlParameter("@Message", successStory.Message),
new SqlParameter("@UserId", successStory.UserId),
//new SqlParameter("@Tagline",successStory.Tagline),
};
var result =
SqlHelper.ExecuteNonQuery
(
connection,
CommandType.StoredProcedure,
"usp_PostSuccessStory",
parameters
);
if (result > 0)
{
return(true);
}
}
finally
{
SqlHelper.CloseConnection(connection);
}
}
throw new UserCanNotPostData("Unable to post data");
}
public IActionResult PostSucessStoryReview(SuccessStoryViewModel model)
{
bool isPosted = false;
var user = HttpContext.Session.Get <UserViewModel>(Constants.SessionKeyUserInfo);
var successStory = new SuccessStoryViewModel
{
name = user.FirstName,
Email = user.Email,
city = user.City,
Tagline = model.Tagline,
Message = model.Message,
UserId = user.UserId
};
try
{
isPosted = _homeHandler.PostSuccessStory(successStory);
if (isPosted)
{
TempData["Feedback"] = "Thank you for posting your feedback.";
}
else
{
TempData["Feedback"] = "Review could not post. Please try again.";
}
}
catch (UserCanNotPostData ex)
{
Logger.Logger.WriteLog(Logger.Logtype.Error, ex.Message, user == null ? 0 : user.UserId, typeof(HomeController), ex);
ModelState.AddModelError("ErrorMessage", string.Format("{0}", ex.Message));
isPosted = false;
}
return(RedirectToAction("SucessStoryAndReview"));
}
public List <SuccessStoryViewModel> GetSuccussStory()
{
DataTable successStories = _homeRepositories.GetSuccessStory();
List <SuccessStoryViewModel> lstsuccessStory = new List <SuccessStoryViewModel>();
if (successStories.Rows.Count > 0)
{
DataTable dt = successStories;
for (int i = 0; i < dt.Rows.Count; i++)
{
string picpath = System.IO.Path.GetFullPath(hostingEnviroment.WebRootPath + dt.Rows[i]["ProfilePic"]);
if (!System.IO.File.Exists(picpath))
{
string fName = $@"\ProfilePic\" + "Avatar.jpg";
dt.Rows[i]["ProfilePic"] = fName;
}
SuccessStoryViewModel successStory = new SuccessStoryViewModel
{
Email = Convert.ToString(dt.Rows[i]["Email"]),
//city = Convert.ToString(dt.Rows[i]["City"]),
name = Convert.ToString(dt.Rows[i]["FirstName"]),
Tagline = Convert.ToString(dt.Rows[i]["TagLine"]),
Message = Convert.ToString(dt.Rows[i]["Message"]),
CreatedDate = Convert.ToDateTime(dt.Rows[i]["CreatedDate"]),
ImgUrl = Convert.ToString(dt.Rows[i]["ProfilePic"]),
};
lstsuccessStory.Add(successStory);
}
}
return(lstsuccessStory);
}
public List <SuccessStoryViewModel> GetSuccussStory()
{
DataTable successStories = _homeRepositories.GetSuccessStory();
List <SuccessStoryViewModel> lstsuccessStory = new List <SuccessStoryViewModel>();
if (successStories.Rows.Count > 0)
{
DataTable dt = successStories;
for (int i = 0; i < dt.Rows.Count; i++)
{
SuccessStoryViewModel successStory = new SuccessStoryViewModel
{
Email = Convert.ToString(dt.Rows[i]["Email"]),
//city = Convert.ToString(dt.Rows[i]["City"]),
name = Convert.ToString(dt.Rows[i]["FirstName"]),
Tagline = Convert.ToString(dt.Rows[i]["TagLine"]),
Message = Convert.ToString(dt.Rows[i]["Message"]),
CreatedDate = Convert.ToDateTime(dt.Rows[i]["CreatedDate"]),
ImgUrl = Convert.ToString(dt.Rows[i]["ProfilePic"]),
};
lstsuccessStory.Add(successStory);
}
}
return(lstsuccessStory);
}
public void Create(SuccessStoryViewModel submittedStory)
{
if (ModelState.IsValid)
{
Message = _successStoryService.CreateSuccessStory(submittedStory, HttpContext.Request.Url.GetLeftPart(UriPartial.Authority));
_notificationService.CreateMessageJobAndSendForExecution(Message);
}
}
public bool PostSuccessStory(SuccessStoryViewModel model)
{
bool isSuccessStory = _homeRepositories.PostSuccsessStory(model);
if (isSuccessStory)
{
return(true);
}
throw new UserCanNotPostData("Unable to post data");
}
public async Task Create_CallsService()
{
var context = new Mock <HttpContextBase>();
var request = new Mock <HttpRequestBase>();
request.Setup(r => r.Url).Returns(new Uri("http://www.google.com"));
context
.Setup(c => c.Request)
.Returns(request.Object);
_successStoryServiceMock.Setup(x => x.CreateSuccessStory(It.IsAny <SuccessStoryViewModel>(), It.IsAny <string>()));
var story = new SuccessStoryViewModel();
var cntlr = new SubmitStoryController(_successStoryServiceMock.Object, _notificationServiceMock.Object);
cntlr.ControllerContext = new ControllerContext(context.Object, new RouteData(), cntlr);
cntlr.Create(story);
_successStoryServiceMock.Verify(x => x.CreateSuccessStory(It.IsAny <SuccessStoryViewModel>(), It.IsAny <string>()), Times.Once);
}
public string CreateSuccessStory(SuccessStoryViewModel submittedStory, string domain)
{
var message = String.Empty;
try
{
var providerName = String.Empty;
var transactionName = $"storyTransaction_{DateTime.Now}";
var versionManager = VersionManager.GetManager(null, transactionName);
DynamicModuleManager dynamicModuleManager = DynamicModuleManager.GetManager(providerName, transactionName);
Type successStoryType = TypeResolutionService.ResolveType("Telerik.Sitefinity.DynamicTypes.Model.SuccessStories.SuccessStory");
DynamicContent successStoryItem = dynamicModuleManager.CreateDataItem(successStoryType);
successStoryItem.SetValue("Title", submittedStory.Title);
successStoryItem.SetValue("Description", submittedStory.Description);
successStoryItem.SetValue("SummaryDescription", submittedStory.SummaryDescription);
successStoryItem.SetValue("ProductsUsed", submittedStory.ProductsUsed);
successStoryItem.SetValue("Company", submittedStory.Company);
successStoryItem.SetValue("CompanyWebsite", submittedStory.CompanyWebsite);
successStoryItem.SetValue("Industry", submittedStory.Industry);
LibrariesManager thumbnailManager = LibrariesManager.GetManager();
if (submittedStory.Thumbnail != null)
{
var fileStream = submittedStory.Thumbnail.InputStream;
var imgId = Guid.NewGuid();
CreateImageWithNativeAPI(imgId, submittedStory.Title, fileStream, submittedStory.Thumbnail.FileName, Path.GetExtension(submittedStory.Thumbnail.FileName));
var thumbnailItem = thumbnailManager.GetImage(imgId);
if (thumbnailItem != null)
{
successStoryItem.CreateRelation(thumbnailItem, "Thumbnail");
}
}
successStoryItem.SetString("UrlName", $"{submittedStory.Title}-{submittedStory.Company}");
successStoryItem.SetValue("Owner", SecurityManager.GetCurrentUserId());
successStoryItem.SetValue("PublicationDate", DateTime.UtcNow);
successStoryItem.SetWorkflowStatus(dynamicModuleManager.Provider.ApplicationName, "Draft");
versionManager.CreateVersion(successStoryItem, false);
ILifecycleDataItem publishedCarItem = dynamicModuleManager.Lifecycle.Publish(successStoryItem);
successStoryItem.SetWorkflowStatus(dynamicModuleManager.Provider.ApplicationName, "Published");
versionManager.CreateVersion(successStoryItem, true);
TransactionManager.CommitTransaction(transactionName);
message = $"A new Success Story has been submitted. Take a look <a style=\"font-weight:bold;color:blue;\" href=\"{domain}/success-story-details{successStoryItem.ItemDefaultUrl.Value}\">here</a>";
}
catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
}
return(message);
}
public ActionResult Index()
{
var story = new SuccessStoryViewModel();
return(View(story));
}
