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("");
}
