/// <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 })); }