public void CreateStory(CreateStory createStory)
{
using (var transaction = _dbConnection.BeginTransaction())
{
var storyId = _storyRepository.CreateStory(_dbConnection, createStory);
_storyRepository.AddUserToStory(_dbConnection, new AddUserToStory()
{
IsCurrentTurn = false, StoryId = storyId, TurnOrder = 1, UserId = createStory.UserId
});
int counter = 1;
foreach (var email in createStory.Emails)
{
counter++;
var friendId = _userRepository.CreateUser(_dbConnection, new User()
{
Email = email
});
_userRepository.AddFriend(_dbConnection, createStory.UserId, friendId);
_storyRepository.AddUserToStory(_dbConnection, new AddUserToStory()
{
IsCurrentTurn = counter == 2, UserId = friendId, StoryId = storyId, TurnOrder = counter
});
}
}
}
public JsonResult CreateEditorStory(StoryModel data)
{
if (data != null)
{
var username = "******";
CreateStory story = new CreateStory();
ResultCode result = story.CreateEditorStory(data, username);
return(Json(result.Message));
}
return(Json("Error !! Data is null."));
}
public ActionResult ContributeStorySave(string[] textAnswer)
{
ContributeStoryModel obj = new ContributeStoryModel();
obj.StoryID = Convert.ToInt32(Session["StoryID"]);
obj.ContributorID = Session["username"].ToString();
obj.ContributionText = textAnswer[0];
//Save the data
var result = new CreateStory().SaveContributionForStory(obj);
//Retrieve the data
obj = HomeControllerUtilities.GetContributeStoryData(Convert.ToInt32(Session["StoryID"]));
return(View("ContributeToStory", obj));
}
public async Task <IActionResult> Create(CreateStory createStory)
{
if (!ModelState.IsValid)
{
return(RedirectToAction("Index", "Board"));
}
bool successful = await StoryService.Create(createStory);
if (!successful)
{
return(BadRequest("Could not create Story"));
}
return(RedirectToAction("Board", "Board"));
}
public async Task <bool> Create(CreateStory createStory)
{
Story story = new Story
{
StoryTitle = createStory.StoryTitle,
StoryDescription = createStory.StoryDescription,
StorySlug = createStory.StoryTitle.ToLower().Replace(" ", "-"),
BoardColumn = context.BoardColumns.Find(createStory.BoardColumnId),
StorySorting = 100
};
await context.Stories.AddAsync(story);
int saveResult = context.SaveChanges();
return(saveResult == 1);
}
public JsonResult CreateEditorStory(StoryModel data)
{
if (data != null)
{
if (Session["username"] != null & Session["password"] != null)
{
var username = Session["username"].ToString();
CreateStory story = new CreateStory();
ResultCode result = story.CreateEditorStory(data, username);
return(Json(result.Message));
}
else
{
return(Json("Invalid Session . Please Login"));
}
}
return(Json("Error !! Data is null."));
}
public int CreateStory(IDbConnection conn, CreateStory story)
{
return(conn.Query <int>(_storySql.CreateStory, new { story.Title }).FirstOrDefault());
}
