private bool ProcedureDetailFieldIsValid(int procedurefieldid)
{
ProcedureDetailOptionField proceduredetailfield = db.ProcedureDetailOptionFields.Find(procedurefieldid);
if (proceduredetailfield == null)
{
return(false);
}
if (proceduredetailfield.Status == "Deleted")
{
return(false);
}
return(true);
}
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 }));
}
