public static void SetAccess(PollWrapper poll, int projectId)
{
var id = poll.PollAccess;
using (var Db = new Repository())
{
var access = Db.Context.PollAccesses.Where(x => x.Id == id).Select(x => x.Value).FirstOrDefault();
if (access == (Int32)DbEnum.PollAccess.CodeSet)
{
SetCodeArray(poll.CodeSet, projectId);
}
else
if (access == (Int32)DbEnum.PollAccess.UserSet)
{
SetUserArray(poll.UserSet, projectId);
}
}
}
public ActionResult SavePoll(PollWrapper configPoll, List <PollUnit> poll, Boolean?hasUser)
{
try
{
if (Session["user"] != null)
{
configPoll.UserId = ((dynamic)Session["user"]).Id;
}
var project = ConstructorHelper.Save(configPoll, poll);
return(new JsonResult()
{
Data = new { project.UrlCode }
});
}
catch (Exception ex)
{
Response.StatusCode = 400;
return(new JsonResult()
{
Data = null
});
}
}
/// <summary>
/// Save new project and return Project data
/// </summary>
public static Project Save(PollWrapper configPoll, List <PollUnit> poll)
{
using (var Db = new Repository())
{
Db.Context.Configuration.ProxyCreationEnabled = false;
using (var dbContextTransaction = Db.Context.Database.BeginTransaction())
{
try
{
if (configPoll == null)
{
throw new Exception("Poll null");
}
var pollShare = Db.Context.PollShares.Where(x => x.Value == configPoll.PollShare).Select(x => x.Id).First();
var pollAccess = Db.Context.PollAccesses.Where(x => x.Value == configPoll.PollAccess).Select(x => x.Id).First();
var pollTypes = Db.Context.PollTypes.Where(x => x.Value == configPoll.PollType).Select(x => x.Id).First();
Project newProj = new Project();
newProj.UserId = configPoll.UserId;
newProj.Name = configPoll.PollName;
newProj.ShareId = pollShare;
newProj.AccessId = pollAccess;
newProj.TypeId = pollTypes;
newProj.CreatedOn = DateTime.Now;
newProj.ModifiedOn = DateTime.Now;
newProj.IsActive = true;
newProj.UrlCode = GenerateProjectCode();
if (pollTypes == (Int32)DbEnum.PollType.Quiz)
{
newProj.QuizConfigurator = configPoll.QuizConfigurator;
}
Db.Add(newProj);
Db.Save();
if (poll != null)
{
foreach (var el in poll)
{
var questionType = Db.Context.QuestionTypes.Where(x => x.Value == el.QuestionType).Select(x => x.Id).First();
el.Question.ProjectId = newProj.Id;
el.Question.QuestionTypeId = questionType;
Db.Add(el.Question);
Db.Save();
int order = 1;
List <Answer> answList = new List <Answer>();
foreach (var answerString in el.Answers)
{
var answer = new Answer();
answer.QuestionId = el.Question.Id;
answer.OrderValue = order;
answer.Value = answerString;
order++;
answList.Add(answer);
}
Db.AddRange(answList);
Db.Save();
}
}
dbContextTransaction.Commit();
SetAccess(configPoll, newProj.Id);
return(newProj);
}
catch (Exception ex)
{
dbContextTransaction.Rollback();
return(null);
}
}
}
}
