public static TemplateFieldValueViewModel CreateFromObject(TemplateFieldValue model) { // model.FormFieldReference.Load(); var templateFieldValueView = new TemplateFieldValueViewModel { TemplateFieldValueID = model.TemplateFieldValueID, TemplateFieldID = model.TemplateFieldID, EntryId = model.EntryId.ToString(), Value = model.Value, DateAdded = model.DateAdded, FieldType = (Constants.TemplateFieldType)Enum.Parse(typeof(Constants.TemplateFieldType), model.TemplateField.FieldType), FieldLabel = model.TemplateField.Label, FieldOrder = model.TemplateField.Order.Value, CreatedBy = model.CreatedBy, UpdatedBy = model.UpdatedBy }; if (model.CreatedDateTime.HasValue) { templateFieldValueView.CreatedDateTime = model.CreatedDateTime.Value; } if (model.UpdatedDateTime.HasValue) { templateFieldValueView.UpdatedDateTime = model.UpdatedDateTime.Value; } return(templateFieldValueView); }
public void UpdateTemplateFieldValue(TemplateFieldValue fieldValue, TemplateFieldViewModel field, string value, string userId = "") { if (field.FieldType != Constants.TemplateFieldType.HEADER) { dbContext.Entry(fieldValue).State = EntityState.Modified; fieldValue.Value = value; fieldValue.UpdatedBy = field.UpdatedBy; fieldValue.UpdatedDateTime = field.UpdatedDateTime; } }
public void InsertTemplateFieldValue(TemplateFieldViewModel field, string value, Guid entryId, string userId = "") { if (field.FieldType != Constants.TemplateFieldType.HEADER) { var fieldVal = new TemplateFieldValue { TemplateFieldID = field.TemplateFieldID.Value, Value = value, EntryId = entryId, DateAdded = DateTime.Now, CreatedBy = field.CreatedBy, CreatedDateTime = field.CreatedDateTime }; dbContext.Set <TemplateFieldValue>().Add(fieldVal); // this.SaveChanges(); } }
protected override void HandleTemplateFieldValue(TemplateFieldViewModel field, string value, Guid entryId) { ParticipantJourneyModality participantJourneyModality = FindParticipantJourneyModality(); if (participantJourneyModality != null) { if (participantJourneyModality.EntryId == Guid.Empty) { field.CreatedDateTime = DateTime.Now; field.CreatedBy = GetLoginUserName(); UnitOfWork.FormRepository.InsertTemplateFieldValue(field, value, entryId); } else { Guid existingEntryId = participantJourneyModality.EntryId; TemplateFieldValue fieldValue = UnitOfWork.FormRepository.GetTemplateFieldValue(field, existingEntryId); if (fieldValue != null) { field.UpdatedDateTime = DateTime.Now; field.UpdatedBy = GetLoginUserName(); UnitOfWork.FormRepository.UpdateTemplateFieldValue(fieldValue, field, value); } else { field.CreatedDateTime = DateTime.Now; field.CreatedBy = GetLoginUserName(); UnitOfWork.FormRepository.InsertTemplateFieldValue(field, value, existingEntryId); } } } else { throw new Exception("No participantJourneyModality found"); } }
public string InsertUploadDataToTemplate(byte[] data, int formId) { using (var unitOfWork = CreateUnitOfWork()) { Template template = FindLatestTemplate(formId); // byte[] fileByte = System.IO.File.ReadAllBytes(filePath); using (MemoryStream ms = new MemoryStream(data)) using (ExcelPackage package = new ExcelPackage(ms)) { if (package.Workbook.Worksheets.Count == 0) { return("Invalid File."); } else { foreach (ExcelWorksheet worksheet in package.Workbook.Worksheets) { int x = 1; // check if header match foreach (var field in template.TemplateFields) { if (field.FieldType == "ADDRESS") { if (worksheet.Cells[1, x].Value.Equals("Blk/Hse No")) { x++; } else { return("Invalid File."); } if (worksheet.Cells[1, x].Value.Equals("Unit")) { x++; } else { return("Invalid File."); } if (worksheet.Cells[1, x].Value.Equals("Street Address")) { x++; } else { return("Invalid File."); } if (worksheet.Cells[1, x].Value.Equals("Postal Code")) { x++; } else { return("Invalid File."); } } if (worksheet.Cells[1, x].Value.Equals(field.Label)) { x++; continue; } else { return("Invalid File."); } } int y = 1; foreach (var field in template.TemplateFields) { if (field.FieldType == "ADDRESS") { for (int row = worksheet.Dimension.Start.Row + 1; row <= worksheet.Dimension.End.Row; row++) { AddressViewModel address = new AddressViewModel(); address.Blk = worksheet.Cells[row, y].Value.ToString(); address.Unit = worksheet.Cells[row, y + 1].Value.ToString(); address.StreetAddress = worksheet.Cells[row, y + 2].Value.ToString(); address.ZipCode = worksheet.Cells[row, y + 3].Value.ToString(); string value1 = address.ToJson(); TemplateFieldValue value = new TemplateFieldValue(); value.Value = value1; value.EntryId = Guid.NewGuid(); value.DateAdded = DateTime.Now; value.TemplateFieldID = field.TemplateFieldID; field.TemplateFieldValues.Add(value); unitOfWork.TemplateFieldValues.Add(value); } y += 4; } else if (worksheet.Cells[1, y].Value.Equals(field.Label.StripHTML())) { for (int row = worksheet.Dimension.Start.Row + 1; row <= worksheet.Dimension.End.Row; row++) { if (worksheet.Cells[row, y].Value == null) { continue; } TemplateFieldValue value = new TemplateFieldValue(); value.Value = worksheet.Cells[row, y].Value.ToString(); value.EntryId = Guid.NewGuid(); value.DateAdded = DateTime.Now; value.TemplateFieldID = field.TemplateFieldID; field.TemplateFieldValues.Add(value); unitOfWork.TemplateFieldValues.Add(value); } y++; } } } } } unitOfWork.Complete(); } return(""); }