public async Task <IActionResult> MyForms()
{
var user = await _userManager.GetUserAsync(HttpContext.User);
var owner = _context.Owner.Find(user.OwnerId);
var forms = await _context.FormResponse
.Include(u => u.Owner)
.Where(u => u.OwnerId == owner.OwnerId)
.ToListAsync();
var vm = new FormIndexVM();
foreach (var form in forms)
{
if (form.Resolved)
{
vm.Resolved.Add(form);
}
else
{
vm.Unresolved.Add(form);
}
}
return(View(vm));
}
public ActionResult Index()
{
if (Session["UserName"] != null)
{
List <FormIndexVM> FormIndexVMs = new List <FormIndexVM>();
List <Form> forms = formService.Load(x => x.DateDeleted == null).OrderByDescending(x => x.DateCreated).ToList();
foreach (var item in forms)
{
FormIndexVM formIndexVM = new FormIndexVM();
formIndexVM.FormId = item.FormId;
formIndexVM.FormTemplateName = item.FormTemplate.Name;
formIndexVM.Status = item.FormStatu.FormStatus;
formIndexVM.CreatedBy = item.User.UserName;
formIndexVM.FormDataId = item.FormDatas.FirstOrDefault().FormDataId;
FormData currentFormData = item.FormDatas.FirstOrDefault();
var formTemplateFieldDefinitions = formTemplateFieldService.Load(x => x.DateDeleted == null && x.FormTemplateId == item.FormTemplateId).OrderBy(x => x.SortOrder).ToList();
List <FormTemplateFieldVM> formTemplateFields = new List <FormTemplateFieldVM>();
foreach (var formTemplateField in formTemplateFieldDefinitions)
{
FormTemplateFieldVM formTemplateFieldVM = new FormTemplateFieldVM();
formTemplateFieldVM.ControlType = formTemplateField.ControlType;
formTemplateFieldVM.LabelFieldName = formTemplateField.LabelFieldName;
formTemplateFieldVM.SortOrder = formTemplateField.SortOrder;
formTemplateFieldVM.FlexField = formTemplateField.FieldName;
String fieldname = formTemplateField.FieldName;
String Value = Convert.ToString(currentFormData[fieldname]);
formTemplateFieldVM.FlexFieldValue = Value;
formTemplateFields.Add(formTemplateFieldVM);
}
formIndexVM.FormTemplateFields = formTemplateFields;
FormIndexVMs.Add(formIndexVM);
}
var datas = JsonConvert.SerializeObject(FormIndexVMs);
ViewBag.Datas = datas;
//var array = FormIndexVMs.Select(x => x.FormTemplateName).Distinct();
var array = formTemplateService.Load(x => x.DateDeleted == null).Select(x => x.Name).ToList();
ViewBag.UniqueTemplates = JsonConvert.SerializeObject(array);
return(View(FormIndexVMs));
}
else
{
TempData["name"] = "You need to be LoggedIn to access this Page";
return(RedirectToAction("Login", "Users"));
}
}
public ActionResult Edit(int?id)
{
if (Session["UserName"] != null)
{
int SelectedStatus = formService.LoadByID(id).FormStatus;
ViewBag.StatusId = new SelectList(formStatusService.Load(x => x.DateDeleted == null).ToList(), "FormStatusId", "FormStatus", SelectedStatus);
Form form = formService.Load(x => x.DateDeleted == null && x.FormId == id).FirstOrDefault();
FormIndexVM formIndexVM = new FormIndexVM();
formIndexVM.FormId = form.FormId;
formIndexVM.FormTemplateName = form.FormTemplate.Name;
formIndexVM.Status = form.FormStatu.FormStatus;
formIndexVM.CreatedBy = form.User.UserName;
formIndexVM.FormDataId = form.FormDatas.FirstOrDefault().FormDataId;
FormData currentFormData = form.FormDatas.FirstOrDefault();
var formTemplateFieldDefinitions = formTemplateFieldService.Load(x => x.DateDeleted == null && x.FormTemplateId == form.FormTemplateId).ToList();
List <FormTemplateFieldVM> formTemplateFields = new List <FormTemplateFieldVM>();
foreach (var formTemplateField in formTemplateFieldDefinitions)
{
FormTemplateFieldVM formTemplateFieldVM = new FormTemplateFieldVM();
formTemplateFieldVM.ControlType = formTemplateField.ControlType;
formTemplateFieldVM.LabelFieldName = formTemplateField.LabelFieldName;
formTemplateFieldVM.SortOrder = formTemplateField.SortOrder;
formTemplateFieldVM.FlexField = formTemplateField.FieldName;
String fieldname = formTemplateField.FieldName;
String Value = Convert.ToString(currentFormData[fieldname]);
formTemplateFieldVM.FlexFieldValue = Value;
formTemplateFields.Add(formTemplateFieldVM);
}
formIndexVM.FormTemplateFields = formTemplateFields;
var datas = JsonConvert.SerializeObject(formIndexVM);
ViewBag.Datas = datas;
return(View());
}
else
{
TempData["name"] = "You need to be LoggedIn to access this Page";
return(RedirectToAction("Login", "Users"));
}
}
public IActionResult Index()
{
var forms = _context.FormResponse.Include(u => u.Owner).ToList();
var vm = new FormIndexVM();
foreach (var form in forms)
{
if (form.Resolved)
{
vm.Resolved.Add(form);
}
else
{
vm.Unresolved.Add(form);
}
}
return(View(vm));
}
public JsonResult Edit(FormIndexVM formIndexVM)
{
JsonResult jsonResult = new JsonResult();
Form form = formService.LoadByID(formIndexVM.FormId);
FormData formData = formDataService.LoadByID(formIndexVM.FormDataId);
form.DateModfied = DateTime.Now;
form.FormStatus = formIndexVM.StatusId;
foreach (var item in formIndexVM.FormTemplateFields)
{
String flexField = item.FlexField;
formData[flexField] = item.FlexFieldValue;
}
formData.DateModfied = form.DateModfied;
formService.Save();
formDataService.Save();
jsonResult.Data = new { Success = "true", Message = "Form was Updated Successfully" };
return(jsonResult);
}
