public SurveyTemplateEditModel SaveTemplate(SurveyTemplateEditModel model, long organizationRoleUserId)
{
SurveyTemplate templateInDb = null;
var template = Mapper.Map <SurveyTemplateEditModel, SurveyTemplate>(model);
if (template.Id > 0)
{
templateInDb = _SurveyTemplateRepository.GetById(template.Id);
template.CreatedBy = templateInDb.CreatedBy;
template.DateCreated = templateInDb.DateCreated;
template.DateModified = DateTime.Now;
template.ModifiedBy = organizationRoleUserId;
}
else
{
template.CreatedBy = organizationRoleUserId;
template.DateCreated = DateTime.Now;
}
using (var scope = new TransactionScope())
{
template = _SurveyTemplateRepository.Save(template, model.Questions.Where(x => x.IsSelected));
scope.Complete();
}
model.Id = template.Id;
return(model);
}
public T1 GetView(ApplicationDbContext db)
{
int?id = Parameters as int?;
if (id == null)
{
return(null);
}
SurveyTemplate surveyTemplate = db.T_SurveyTemplate.Find(id);
db.Entry(surveyTemplate).Collection(p => p.SurveyPartTemplates).Load();
List <SurveyPartTemplate> surveyPartTemplates = surveyTemplate.SurveyPartTemplates;
if (surveyPartTemplates == null)
{
surveyPartTemplates = new List <SurveyPartTemplate>();
}
if (surveyTemplate.SurveyPartTemplates != null)
{
foreach (SurveyPartTemplate surveyPartTemplate in surveyTemplate.SurveyPartTemplates)
{
db.Entry(surveyPartTemplate).Collection(p => p.SurveyQuestionTemplates).Load();
}
}
return(surveyTemplate as T1);
}
public T1 GetView(ApplicationDbContext db)
{
int?id = Parameters as int?;
Survey survey = db.T_Survey.Find(id);
SurveyTemplate surveyTemplate = db.T_SurveyTemplate.Find(survey.SurveyTemplateId);
db.Entry(survey).Collection(p => p.SurveyParts).Load();
db.Entry(surveyTemplate).Collection(p => p.SurveyPartTemplates).Load();
foreach (SurveyPart surveyPart in survey.SurveyParts)
{
db.Entry(surveyPart).Collection(p => p.SurveyQuestions).Load();
}
foreach (SurveyPartTemplate surveyPartTemplate in surveyTemplate.SurveyPartTemplates)
{
db.Entry(surveyPartTemplate).Collection(p => p.SurveyQuestionTemplates).Load();
}
BrowseSurvey browseSurvey = new BrowseSurvey()
{
Survey = survey,
SurveyTemplate = surveyTemplate
};
return(browseSurvey as T1);
}
public async Task <int> CreateAsync(string title, string description)
{
var surveyTemplate = new SurveyTemplate(title, description);
await _surveyTemplateRepository.AddAsync(surveyTemplate);
return(surveyTemplate.Id);
}
public ActionResult DeleteConfirmed(int id)
{
SurveyTemplate surveytemplate = db.SurveyTemplates.Find(id);
db.SurveyTemplates.Remove(surveytemplate);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult DeleteSurvey(int?id)
{
SurveyTemplate surveyTemplate = db.T_SurveyTemplate.Find(id);
db.T_SurveyTemplate.Remove(surveyTemplate);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit(int id)
{
SurveyTemplate surveytemplate = db.SurveyTemplates.Find(id);
ViewBag.AllSurveyNodes = db.SurveyNodes.ToList();
ViewBag.TheseSurveyRecords = surveytemplate.SurveyRecords.ToList();
ViewBag.RequestTypeID = new SelectList(db.RequestTypes, "RequestTypeID", "Description", surveytemplate.RequestTypeID);
return(View(surveytemplate));
}
public IActionResult Edit(SurveyTemplate surveyTemplate)
{
if (ModelState.IsValid)
{
surveyTemplateService.Save(surveyTemplate);
return(RedirectToAction("Index"));
}
ViewData["OwnerId"] = surveyTemplate.OwnerId;
ViewData["SurveyTypeId"] = new SelectList(new[] { surveyTemplate.SurveyTypeId });
return(View(surveyTemplate));
}
public void EditSurveyTemplate(SurveyTemplateView view, int id)
{
SurveyTemplate oldTemplate = _SurveyTemplates.FindOne(template => template.SurveyTemplateId == id);
oldTemplate.Name = view.Name;
oldTemplate.Title = view.Title;
oldTemplate.Description = view.Description;
oldTemplate.Ending = view.Ending;
oldTemplate.Pages = view.Pages;
_SurveyTemplates.Delete(template => template.SurveyTemplateId == id);
_SurveyTemplates.Insert(oldTemplate);
}
public ActionResult Edit([Bind(Include = "Id,Name,SurveyDate,NewPart,SummaryTitle")] SurveyTemplate surveyTemplate)
{
if (ModelState.IsValid)
{
var surveyDate = Request["SurveyDate1"];
surveyTemplate.SurveyDate = CalculateDate.StringToDate(surveyDate, ".", "/", "-");
ISaveModel <SurveyTemplate> saveSurveyTemplate = new SaveSurveyTemplate <SurveyTemplate>();
saveSurveyTemplate.Save(surveyTemplate, db);
}
return(RedirectToAction("Index"));
}
public bool Save(SurveyTemplate template)
{
Data.SurveyTemplate st = new Data.SurveyTemplate(conn);
template.SurveyTemplateID = st.SaveTemplate(template.Name, template.Description, template.Category, template.IntroductionNote, template.ThanksNote, "");
if (template.SurveyTemplateID > 0)
{
return(true);
}
else
{
return(false);
}
}
public void Save(T model, ApplicationDbContext db)
{
SurveyTemplate surveyTemplate = model as SurveyTemplate;
if (surveyTemplate != null)
{
if (surveyTemplate.PublishDate.Year < 1900)
{
surveyTemplate.PublishDate = new DateTime(1900, 1, 1);
}
db.Entry(surveyTemplate).State = EntityState.Modified;
db.SaveChanges();
}
}
// GET: SurveyTemplates/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SurveyTemplate surveyTemplate = db.T_SurveyTemplate.Find(id);
if (surveyTemplate == null)
{
return(HttpNotFound());
}
return(View(surveyTemplate));
}
public void CreatesurveyTemplate(Survey survey)
{
Random RandomID = new Random();
SurveyTemplate template = SurveyToSurveyTemplate(survey);
while (true)
{
template.SurveyTemplateId = RandomID.Next(1, 1000);
if (_SurveyTemplates.FindOne(element => element.SurveyTemplateId == template.SurveyTemplateId) == null)
{
break;
}
}
_SurveyTemplates.Insert(template);
}
public IActionResult Delete(int?id)
{
if (id == null)
{
return(HttpNotFound());
}
SurveyTemplate surveyTemplate = surveyTemplateService.GetById(id.Value);
if (surveyTemplate == null)
{
return(HttpNotFound());
}
return(View(surveyTemplate));
}
public void Save(T model, ApplicationDbContext db)
{
SurveyPartData modelData = model as SurveyPartData;
int id = StringToValue.ParseInt(modelData.Id);
SurveyTemplate surveyTemplate = db.T_SurveyTemplate.Find(id);
if (surveyTemplate != null)
{
SurveyTemplate newSurveyTemplate = new SurveyTemplate()
{
Name = modelData.Name,
SurveyDate = DateTime.Now,
PublishDate = new DateTime(1900, 1, 1),
SurveyPartTemplates = new List <SurveyPartTemplate>()
};
db.Entry(surveyTemplate).Collection(p => p.SurveyPartTemplates).Load();
if (surveyTemplate.SurveyPartTemplates != null)
{
foreach (SurveyPartTemplate surveyPartTemplate in surveyTemplate.SurveyPartTemplates)
{
SurveyPartTemplate newSurveyPartTemplate = new SurveyPartTemplate()
{
Name = surveyPartTemplate.Name,
SummaryTitle = surveyPartTemplate.SummaryTitle,
SurveyQuestionTemplates = new List <SurveyQuestionTemplate>()
};
newSurveyTemplate.SurveyPartTemplates.Add(newSurveyPartTemplate);
db.Entry(surveyPartTemplate).Collection(p => p.SurveyQuestionTemplates).Load();
foreach (SurveyQuestionTemplate surveyQuestionTemplate in surveyPartTemplate.SurveyQuestionTemplates)
{
SurveyQuestionTemplate newSurveyQuestionTemplate = new SurveyQuestionTemplate()
{
Name = surveyQuestionTemplate.Name,
Definition = surveyQuestionTemplate.Definition,
QuestionType = surveyQuestionTemplate.QuestionType
};
newSurveyPartTemplate.SurveyQuestionTemplates.Add(newSurveyQuestionTemplate);
}
}
}
db.T_SurveyTemplate.Add(newSurveyTemplate);
db.SaveChanges();
}
}
private SurveyTemplateView ToSurveyTemplateView(SurveyTemplate template)
{
var view = new SurveyTemplateView()
{
SurveyTemplateId = template.SurveyTemplateId,
CreatedSurveys = template.CreatedSurveys,
Name = template.Name,
Used = template.Used,
Title = template.Title,
Description = template.Description,
Ending = template.Ending,
CreateDate = template.CreateDate,
Pages = template.Pages
};
return(view);
}
// GET: SurveyTemplates/Edit/5
public IActionResult Edit(int?id)
{
if (id == null)
{
return(HttpNotFound());
}
SurveyTemplate surveyTemplate = surveyTemplateService.GetById(id.Value);
if (surveyTemplate == null)
{
return(HttpNotFound());
}
ViewData["OwnerId"] = surveyTemplate.OwnerId;
ViewData["SurveyTypeId"] = new SelectList(surveyTypeService.GetAll());
return(View(surveyTemplate));
}
public ActionResult _AjaxBindingDetails(int surveyID)
{
int mysurvtemplateID = db.SurveyTables.Find(surveyID).SurveyTemplateID;
SurveyTemplate survtemplate = db.SurveyTemplates.Include(u => u.SurveyRecords).Where(i => i.SurveyTemplateID == mysurvtemplateID).SingleOrDefault();
var surveyrecords = from e in survtemplate.SurveyRecords
select new SurveyTableDetailViewModel
{
SurveyNodeDescription = e.SurveyNode.Description,
SurveyRecordTypeDescription = e.SurveyRecordType.Description,
ApprovalStatus = e.ApprovalStatus,
Score = int.Parse(e.Score.GetValueOrDefault(0).ToString()),
Note = e.Note
};
return(View(new GridModel(surveyrecords)));
}
private SurveyTemplate SurveyToSurveyTemplate(Survey survey)
{
SurveyTemplate template = new SurveyTemplate()
{
SurveyTemplateId = survey.SurveyId,
CreatedSurveys = new List <int>(),
Title = survey.Title,
Name = "Untitled",
Used = 0,
Description = survey.Description,
Ending = survey.Ending,
Pages = survey.Pages,
CreateDate = DateTime.Now.ToString(),
Creator = survey.Creator
};
return(template);
}
public ActionResult Create([Bind(Include = "Id,Name,SurveyDate")] SurveyTemplate surveyTemplate)
{
var surveyDate = Request["SurveyDate1"];
surveyTemplate.SurveyDate = CalculateDate.StringToDate(surveyDate, ".", "/", "-");
if (ModelState.IsValid)
{
if (surveyTemplate.PublishDate.Year < 1900)
{
surveyTemplate.PublishDate = new DateTime(1900, 1, 1);
}
db.T_SurveyTemplate.Add(surveyTemplate);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(surveyTemplate));
}
public int Check(T model, out string message, ApplicationDbContext db)
{
SurveyPartData modelData = model as SurveyPartData;
int errorCode = 0;
message = "";
int id = StringToValue.ParseInt(modelData.Id);
SurveyTemplate surveyTemplate = db.T_SurveyTemplate.Find(id);
if (surveyTemplate != null)
{
db.Entry(surveyTemplate).Collection(p => p.SurveyPartTemplates).Load();
List <SurveyPartTemplate> surveyPartTemplates = surveyTemplate.SurveyPartTemplates;
if (surveyPartTemplates == null || surveyPartTemplates.Count() == 0)
{
errorCode = 2;
message = "Brak przynajmniej jednej sekcji ankiety.";
return(errorCode);
}
foreach (SurveyPartTemplate surveyPartTemplate in surveyTemplate.SurveyPartTemplates)
{
db.Entry(surveyPartTemplate).Collection(p => p.SurveyQuestionTemplates).Load();
if (surveyPartTemplate.SurveyQuestionTemplates == null || surveyPartTemplate.SurveyQuestionTemplates.Count() == 0)
{
errorCode = 2;
message = "Sekcja '" + surveyPartTemplate.Name + "' nie zawiera ani jednego pytania.";
return(errorCode);
}
}
}
else
{
errorCode = 1;
message = "Nie znaleziono wzorca ankiety.";
}
return(errorCode);
}
public ActionResult Create(SurveyTemplate surveytemplate, FormCollection formcollection)
{
if (ModelState.IsValid)
{
db.SurveyTemplates.Add(surveytemplate);
surveytemplate.PreDefined = true;
db.SaveChanges();
surveytemplate.SurveyRecords = new List <SurveyRecord>();
int xindex = 0;
foreach (SurveyNode snode_ in db.SurveyNodes.ToList())
{
try
{
if (bool.Parse(formcollection[snode_.SurveyNodeID.ToString() + "_Check"].Split(',')[0]))
{
SurveyRecord newsurvrec = new SurveyRecord {
SurveyNodeID = snode_.SurveyNodeID, OrderNum = xindex, SurveyRecordTypeID = int.Parse(formcollection[snode_.SurveyNodeID.ToString() + "_survrectype"])
};
surveytemplate.SurveyRecords.Add(newsurvrec);
db.SaveChanges();
xindex++;
}
}
catch (Exception exx)
{
ViewBag.CustomErr = exx.Message;
}
}
return(RedirectToAction("Index"));
}
ViewBag.AllSurveyNodes = db.SurveyNodes.ToList();
var query = db.RequestTypes.Where(u => db.SurveyTemplates.Where(i => i.PreDefined == true).Select(s => s.RequestTypeID).Contains(u.RequestTypeID));
var emptyReqTypes = db.RequestTypes.Except(query);
ViewBag.RequestTypeID = new SelectList(emptyReqTypes, "RequestTypeID", "Description", surveytemplate.RequestTypeID);
return(View(surveytemplate));
}
public void Save(T model, ApplicationDbContext db)
{
SurveyPartData modelData = model as SurveyPartData;
int id;
int.TryParse(modelData.Id, out id);
SurveyTemplate surveyTemplate = db.T_SurveyTemplate.Find(id);
if (surveyTemplate != null)
{
SurveyPartTemplate surveyPartTemplate = new SurveyPartTemplate()
{
Name = modelData.Name,
SummaryTitle = modelData.Summary,
SurveyTemplateId = id
};
db.T_SurveyPartTemplate.Add(surveyPartTemplate);
db.Entry(surveyTemplate).State = EntityState.Modified;
db.SaveChanges();
}
}
public SurveyTemplate Save(SurveyTemplate SurveyTemplate, IEnumerable <SurveyQuestionEditModel> questions)
{
using (var adapter = PersistenceLayer.GetDataAccessAdapter())
{
using (var scope = new TransactionScope())
{
var entity = Mapper.Map <SurveyTemplate, SurveyTemplateEntity>(SurveyTemplate);
if (!adapter.SaveEntity(entity, true))
{
throw new PersistenceFailureException();
}
DeleteSurveyTemplateQuestion(entity.Id);
SaveSurveyTemplateQuestion(entity.Id, questions);
var template = GetById(entity.Id);
scope.Complete();
return(template);
}
}
}
public async Task UpdateAsync(SurveyTemplate surveyTemplate)
{
_context.SurveyTemplates.Update(surveyTemplate);
await _context.SaveChangesAsync();
}
public bool Update(SurveyTemplate template)
{
Data.SurveyTemplate st = new Data.SurveyTemplate(conn);
return(st.UpdateTemplate(template.SurveyTemplateID, template.Name, template.Description, template.Category, template.IntroductionNote, template.ThanksNote));
}
public async Task DeleteAsync(SurveyTemplate surveyTemplate)
{
_context.SurveyTemplates.Remove(surveyTemplate);
await _context.SaveChangesAsync();
}
public bool Save(SurveyTemplate element)
{
throw new NotImplementedException();
}
public async Task AddAsync(SurveyTemplate surveyTemplate)
{
await _context.SurveyTemplates.AddAsync(surveyTemplate);
await _context.SaveChangesAsync();
}
