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"));
}
}
private void AddFormTemplateField(FormTemplateFieldVM item, int formTemplateId, DateTime dateTime, int labelFieldCounter)
{
var dataTypeName = formTemplateFieldService.GetDataType(item.ControlType);
FormTemplateFieldDefinition formTemplateFieldDefinition = new FormTemplateFieldDefinition();
formTemplateFieldDefinition.FormTemplateId = formTemplateId;
formTemplateFieldDefinition.GUID = item.Guid;
formTemplateFieldDefinition.ControlType = item.ControlType;
formTemplateFieldDefinition.LabelFieldName = item.LabelFieldName;
formTemplateFieldDefinition.SortOrder = item.SortOrder;
formTemplateFieldDefinition.FieldName = "FlexField" + labelFieldCounter;
formTemplateFieldDefinition.DateCreated = dateTime;
formTemplateFieldDefinition.DataTypeId = dataTypeService.Load(x => x.Name == dataTypeName).Select(x => x.DataTypeId).FirstOrDefault();
formTemplateFieldService.Add(formTemplateFieldDefinition);
}
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 string GetFormFields(int id)
{
var formTemplateFieldDefinitions = formTemplateFieldService.Load(x => x.DateDeleted == null && x.FormTemplateId == id).ToList();
List <FormTemplateFieldVM> formTemplateFields = new List <FormTemplateFieldVM>();
foreach (var item in formTemplateFieldDefinitions)
{
FormTemplateFieldVM formTemplateField = new FormTemplateFieldVM();
formTemplateField.ControlType = item.ControlType;
formTemplateField.LabelFieldName = item.LabelFieldName;
formTemplateField.SortOrder = item.SortOrder;
formTemplateField.Guid = item.GUID;
formTemplateField.FlexField = item.FieldName;
formTemplateFields.Add(formTemplateField);
}
return(JsonConvert.SerializeObject(formTemplateFields));
}
public List <FormTemplateFieldVM> GetFormTemplateFieldDefinitions(String guid)
{
FormTemplate formTemplateDB = formTemplateService.Load(x => x.DateDeleted == null && x.GUID == guid).FirstOrDefault();
List <FormTemplateFieldVM> formTemplateFieldVMs = new List <FormTemplateFieldVM>();
List <FormTemplateFieldDefinition> formTemplateFieldsDB = formTemplateFieldService.Load(x => x.DateDeleted == null && x.FormTemplateId == formTemplateDB.FormTemplateId).OrderBy(x => x.SortOrder).ToList();
foreach (var formTemplateFieldDB in formTemplateFieldsDB)
{
FormTemplateFieldVM formTemplateFieldVM = new FormTemplateFieldVM();
formTemplateFieldVM.ControlType = formTemplateFieldDB.ControlType;
formTemplateFieldVM.Guid = formTemplateFieldDB.GUID;
formTemplateFieldVM.SortOrder = formTemplateFieldDB.SortOrder;
formTemplateFieldVM.LabelFieldName = formTemplateFieldDB.LabelFieldName;
formTemplateFieldVMs.Add(formTemplateFieldVM);
}
return(formTemplateFieldVMs);
}
