/// <summary>
/// Get the Layout Information for a specific Field.
/// </summary>
private FieldLayout GetFieldLayout(Field field, DataEntryField dataEntryField, string subSectionName = null)
{
return(new FieldLayout
{
DataEntryFieldName = dataEntryField.Name,
SubSectionName = subSectionName,
Path = dataEntryField.Path,
AgencyValidation = field.AgencyValidation,
ColumnSpan = field.ColumnSpan,
DefaultValue = field.DefaultValue,
Description = field.Description,
Label = field.Label,
OrderBy = field.OrderBy
});
}
private void UpdateMetadata(DataEntryField sourceField, DataEntryField destinationField)
{
destinationField.Cascades = sourceField.Cascades;
destinationField.Category = sourceField.Category;
destinationField.ColumnSpan = sourceField.ColumnSpan;
destinationField.ChangeControlType(sourceField.ControlType);
destinationField.DefaultMask = sourceField.DefaultMask;
destinationField.DefaultValue = sourceField.DefaultValue;
destinationField.Description = sourceField.Description;
destinationField.ChangeFieldType(sourceField.FieldType);
destinationField.Label = sourceField.Label;
destinationField.MasterIndexSearchable = sourceField.MasterIndexSearchable;
destinationField.MaxLength = sourceField.MaxLength;
destinationField.ChangeName(sourceField.Name);
destinationField.OrderBy = sourceField.OrderBy;
//destinationField.Path = sourceField.Path; Path is how we matched the fields
destinationField.SetCurrentDate = sourceField.SetCurrentDate;
destinationField.SubSectionName = sourceField.SubSectionName;
}
public ActionResult Index(ICollection <LookupTableViewModel> lookupVM, string lookuptablename)
{
if (lookuptablename == "Species")
{
foreach (var lookupVMitem in lookupVM)
{
if (lookupVMitem.ID == 0)
{
Species record = new Species()
{
SpeciesID = lookupVMitem.ID,
SpeciesName = lookupVMitem.Name,
};
db.Species.Add(record);
}
else if (lookupVMitem.ID > 0)
{
Species record = db.Species.Find(lookupVMitem.ID);
record.SpeciesName = lookupVMitem.Name;
}
else
{
return(View("Error"));
}
db.SaveChanges();
}
}
else if (lookuptablename == "Strains")
{
foreach (var lookupVMitem in lookupVM)
{
if (lookupVMitem.ID == 0)
{
Strain record = new Strain()
{
StrainID = lookupVMitem.ID,
StrainName = lookupVMitem.Name,
SpeciesID = lookupVMitem.CategoryID,
};
db.Strains.Add(record);
}
else if (lookupVMitem.ID > 0)
{
Strain record = db.Strains.Find(lookupVMitem.ID);
record.StrainName = lookupVMitem.Name;
record.SpeciesID = lookupVMitem.CategoryID;
}
else
{
return(View("Error"));
}
db.SaveChanges();
}
}
else if (lookuptablename == "AnimalHusbandryFields")
{
foreach (var lookupVMitem in lookupVM)
{
if (lookupVMitem.ID == 0)
{
AnimalHusbandryField record = new AnimalHusbandryField()
{
AnimalHusbandryFieldID = lookupVMitem.ID,
AnimalHusbandryFieldName = lookupVMitem.Name,
AnimalHusbandryFieldTypeID = lookupVMitem.CategoryID,
};
db.AnimalHusbandryFields.Add(record);
}
else if (lookupVMitem.ID > 0)
{
AnimalHusbandryField record = db.AnimalHusbandryFields.Find(lookupVMitem.ID);
record.AnimalHusbandryFieldName = lookupVMitem.Name;
record.AnimalHusbandryFieldTypeID = lookupVMitem.CategoryID;
}
else
{
return(View("Error"));
}
db.SaveChanges();
}
}
else if (lookuptablename == "AnimalHusbandryOptions")
{
foreach (var lookupVMitem in lookupVM)
{
if (lookupVMitem.ID == 0)
{
AnimalHusbandryOption record = new AnimalHusbandryOption()
{
AnimalHusbandryOptionID = lookupVMitem.ID,
AnimalHusbandryOptionName = lookupVMitem.Name,
AnimalHusbandryFieldID = lookupVMitem.CategoryID,
};
db.AnimalHusbandryOptions.Add(record);
}
else if (lookupVMitem.ID > 0)
{
AnimalHusbandryOption record = db.AnimalHusbandryOptions.Find(lookupVMitem.ID);
record.AnimalHusbandryOptionName = lookupVMitem.Name;
record.AnimalHusbandryFieldID = lookupVMitem.CategoryID;
}
else
{
return(View("Error"));
}
db.SaveChanges();
}
}
else if (lookuptablename == "ProcedureDetailFields")
{
foreach (var lookupVMitem in lookupVM)
{
if (lookupVMitem.ID == 0)
{
ProcedureDetailOptionField record = new ProcedureDetailOptionField()
{
ProcedureDetailOptionFieldID = lookupVMitem.ID,
ProcedureDetailOptionFieldName = lookupVMitem.Name,
ProcedureDetailFieldTypeID = lookupVMitem.CategoryID,
ProcedurePurposeOrTypeID = lookupVMitem.PurposeOrTypeID,
Multiple = lookupVMitem.Multiple,
};
db.ProcedureDetailOptionFields.Add(record);
}
else if (lookupVMitem.ID > 0)
{
ProcedureDetailOptionField record = db.ProcedureDetailOptionFields.Find(lookupVMitem.ID);
record.ProcedureDetailOptionFieldName = lookupVMitem.Name;
record.ProcedureDetailFieldTypeID = lookupVMitem.CategoryID;
record.ProcedurePurposeOrTypeID = lookupVMitem.PurposeOrTypeID;
record.Multiple = lookupVMitem.Multiple;
}
else
{
return(View("Error"));
}
db.SaveChanges();
}
}
else if (lookuptablename == "ProcedureDetailOptions")
{
foreach (var lookupVMitem in lookupVM)
{
if (lookupVMitem.ID == 0)
{
ProcedureDetailOption record = new ProcedureDetailOption()
{
ProcedureDetailOptionID = lookupVMitem.ID,
ProcedureDetailOptionName = lookupVMitem.Name,
ProcedureDetailOptionFieldID = lookupVMitem.CategoryID,
};
db.ProcedureDetailOptions.Add(record);
}
else if (lookupVMitem.ID > 0)
{
ProcedureDetailOption record = db.ProcedureDetailOptions.Find(lookupVMitem.ID);
record.ProcedureDetailOptionName = lookupVMitem.Name;
record.ProcedureDetailOptionFieldID = lookupVMitem.CategoryID;
}
else
{
return(View("Error"));
}
db.SaveChanges();
}
}
else if (lookuptablename == "DataEntryFields")
{
foreach (var lookupVMitem in lookupVM)
{
if (lookupVMitem.ID == 0)
{
DataEntryField record = new DataEntryField()
{
DataEntryFieldID = lookupVMitem.ID,
DataEntryFieldName = lookupVMitem.Name,
FieldTypeID = lookupVMitem.CategoryID,
};
db.DataEntryFields.Add(record);
}
else if (lookupVMitem.ID > 0)
{
DataEntryField record = db.DataEntryFields.Find(lookupVMitem.ID);
record.DataEntryFieldName = lookupVMitem.Name;
record.FieldTypeID = lookupVMitem.CategoryID;
}
else
{
return(View("Error"));
}
db.SaveChanges();
}
}
else if (lookuptablename == "DataEntryOptions")
{
foreach (var lookupVMitem in lookupVM)
{
if (lookupVMitem.ID == 0)
{
DataEntryOption record = new DataEntryOption()
{
DataEntryOptionID = lookupVMitem.ID,
DataEntryOptionName = lookupVMitem.Name,
DataEntryFieldDataEntryFieldID = lookupVMitem.CategoryID,
};
db.DataEntryOptions.Add(record);
}
else if (lookupVMitem.ID > 0)
{
DataEntryOption record = db.DataEntryOptions.Find(lookupVMitem.ID);
record.DataEntryOptionName = lookupVMitem.Name;
record.DataEntryFieldDataEntryFieldID = lookupVMitem.CategoryID;
}
else
{
return(View("Error"));
}
db.SaveChanges();
}
}
//else if (lookuptablename == "OptionFields")
//{
// foreach (var lookupVMitem in lookupVM)
// {
// if (lookupVMitem.ID == 0)
// {
// OptionField record = new OptionField()
// {
// OptionFieldID = lookupVMitem.ID,
// OptionFieldName = lookupVMitem.Name,
// };
// db.OptionFields.Add(record);
// }
// else if (lookupVMitem.ID > 0)
// {
// OptionField record = db.OptionFields.Find(lookupVMitem.ID);
// record.OptionFieldName = lookupVMitem.Name;
// }
// else
// {
// return View("Error");
// }
// db.SaveChanges();
// }
//}
//else if (lookuptablename == "Options")
//{
// foreach (var lookupVMitem in lookupVM)
// {
// if (lookupVMitem.ID == 0)
// {
// Option record = new Option()
// {
// OptionID = lookupVMitem.ID,
// OptionValue = lookupVMitem.Name,
// OptionFieldOptionFieldID = lookupVMitem.CategoryID,
// };
// db.Options.Add(record);
// }
// else if (lookupVMitem.ID > 0)
// {
// Option record = db.Options.Find(lookupVMitem.ID);
// record.OptionValue = lookupVMitem.Name;
// record.OptionFieldOptionFieldID = lookupVMitem.CategoryID;
// }
// else
// {
// return View("Error");
// }
// db.SaveChanges();
// }
//}
return(RedirectToAction("Index", new { lookuptablename = lookuptablename }));
}
