public ActionResult Create(string lookuptablename)
{
ViewBag.CategoryName = "";
ViewBag.PurposeOrTypeName = "";
LookupTableViewModel LookupTableVM = new LookupTableViewModel()
{
LookupTableName = lookuptablename,
};
switch (lookuptablename)
{
case "AnimalSuppliers":
ViewBag.ContentName = "Animal Suppliers";
break;
case "Species":
ViewBag.ContentName = "Species";
break;
case "Strains":
LookupTableVM.Categories = new SelectList(db.Species.Where(s => s.Status == "Current").AsEnumerable(), "SpeciesID", "SpeciesName");
ViewBag.ContentName = "Strains";
ViewBag.CategoryName = "Species";
break;
case "AnimalHusbandryFields":
LookupTableVM.Categories = new SelectList(db.Options.Where(s => s.Status == "Current" && s.OptionFields.OptionFieldName == "Field Type").AsEnumerable(), "OptionID", "OptionValue");
ViewBag.ContentName = "Animal Husbandry Form Fields";
ViewBag.CategoryName = "Field Type";
break;
case "AnimalHusbandryOptions":
LookupTableVM.Categories = new SelectList(db.AnimalHusbandryFields.Where(s => s.Status == "Current" && s.Options.OptionValue == "lookup").AsEnumerable(),
"AnimalHusbandryFieldID", "AnimalHusbandryFieldName");
ViewBag.ContentName = "Animal Husbandry Lookup Options";
ViewBag.CategoryName = "Lookup Field";
break;
case "ProcedureDetailFields":
LookupTableVM.Categories = new SelectList(db.Options.Where(s => s.Status == "Current" && s.OptionFields.OptionFieldName == "Field Type").AsEnumerable(), "OptionID", "OptionValue");
LookupTableVM.PurposesTypes = new SelectList(db.Options.Where(s => s.Status == "Current" && (s.OptionFields.OptionFieldName == "Procedure Type" || s.OptionFields.OptionFieldName == "Procedure Purpose")).AsEnumerable(), "OptionID", "OptionValue");
ViewBag.ContentName = "Procedure Detail Form Fields";
ViewBag.CategoryName = "Field Type";
ViewBag.PurposeOrTypeName = "Purpose Or Type of the Procedure";
break;
case "ProcedureDetailOptions":
LookupTableVM.Categories = new SelectList(db.ProcedureDetailOptionFields.Where(s => s.Status == "Current" && s.ProcedureDetailFieldType.OptionValue == "lookup").AsEnumerable(),
"ProcedureDetailOptionFieldID", "ProcedureDetailOptionFieldName");
ViewBag.ContentName = "Procedure Detail Lookup Options";
ViewBag.CategoryName = "Lookup Field";
break;
case "DataEntryFields":
LookupTableVM.Categories = new SelectList(db.Options.Where(s => s.Status == "Current" && s.OptionFields.OptionFieldName == "Field Type").AsEnumerable(), "OptionID", "OptionValue");
ViewBag.ContentName = "Data Entry Form Fields";
ViewBag.CategoryName = "Field Type";
break;
case "DataEntryOptions":
LookupTableVM.Categories = new SelectList(db.DataEntryFields.Where(s => s.Status == "Current" && s.FieldType.OptionValue == "lookup").AsEnumerable(), "DataEntryFieldID", "DataEntryFieldName");
ViewBag.ContentName = "Data Entry Lookup Options";
ViewBag.CategoryName = "Lookup Field";
break;
//case "OptionFields":
// ViewBag.ContentName = "General Lookup Fields";
// break;
//case "Options":
// LookupTableVM.Categories = new SelectList(db.OptionFields.Where(s => s.Status == "Current").AsEnumerable(), "OptionFieldID", "OptionFieldName");
// ViewBag.ContentName = "General Lookup Options";
// ViewBag.CategoryName = "Lookup Field";
// break;
}
return(View("Create", LookupTableVM));
}
public ActionResult Create(LookupTableViewModel lookupVM)
{
switch (lookupVM.LookupTableName)
{
case "AnimalSuppliers":
db.AnimalSuppliers.Add(
new AnimalSupplier()
{
AnimalSupplierName = lookupVM.Name,
}
);
break;
case "Species":
db.Species.Add(
new Species()
{
SpeciesName = lookupVM.Name,
}
);
break;
case "Strains":
db.Strains.Add(
new Strain()
{
StrainName = lookupVM.Name,
SpeciesID = lookupVM.CategoryID,
}
);
break;
case "AnimalHusbandryFields":
db.AnimalHusbandryFields.Add(
new AnimalHusbandryField()
{
AnimalHusbandryFieldName = lookupVM.Name,
AnimalHusbandryFieldTypeID = lookupVM.CategoryID,
}
);
break;
case "AnimalHusbandryOptions":
db.AnimalHusbandryOptions.Add(
new AnimalHusbandryOption()
{
AnimalHusbandryOptionName = lookupVM.Name,
AnimalHusbandryFieldID = lookupVM.CategoryID,
}
);
break;
case "ProcedureDetailFields":
db.ProcedureDetailOptionFields.Add(
new ProcedureDetailOptionField()
{
ProcedureDetailOptionFieldName = lookupVM.Name,
ProcedureDetailFieldTypeID = lookupVM.CategoryID,
ProcedurePurposeOrTypeID = lookupVM.PurposeOrTypeID,
}
);
break;
case "ProcedureDetailOptions":
db.ProcedureDetailOptions.Add(
new ProcedureDetailOption()
{
ProcedureDetailOptionName = lookupVM.Name,
ProcedureDetailOptionFieldID = lookupVM.CategoryID,
}
);
break;
case "DataEntryFields":
db.DataEntryFields.Add(
new DataEntryField()
{
DataEntryFieldName = lookupVM.Name,
FieldTypeID = lookupVM.CategoryID,
}
);
break;
case "DataEntryOptions":
db.DataEntryOptions.Add(
new DataEntryOption()
{
DataEntryOptionName = lookupVM.Name,
DataEntryFieldDataEntryFieldID = lookupVM.CategoryID,
}
);
break;
//case "OptionFields":
// db.OptionFields.Add(
// new OptionField()
// {
// OptionFieldName = lookupVM.Name,
// }
// );
// break;
//case "Options":
// db.Options.Add(
// new Option()
// {
// OptionValue = lookupVM.Name,
// OptionFieldOptionFieldID = lookupVM.CategoryID
// }
// );
// break;
}
db.SaveChanges();
return(RedirectToAction("Index", new { lookuptablename = lookupVM.LookupTableName }));
}
public LookupTableController(LookupTableViewModel vm)
{
_ViewModel = vm;
}
