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