public static void CreateFormPhaseRecord(int operationalLicensesFormID, string userName, int formState, int devPhase, int PUN)
{
OperationalLicensesFormPhase olfp;
// Query the database for the rows to be deleted.
using (var db = new Models.SmizeeContext())
{
olfp = new OperationalLicensesFormPhase();
olfp.DevelopmentPhaseID = devPhase;
olfp.ProductionUnitsNumber = PUN;
olfp.OperationalLicensesFormID = operationalLicensesFormID;
db.OperationalLicensesFormPhases.Add(olfp);
db.SaveChanges();
}
}
public static int?GetFormDevelopmentPhase(int operationalLicensesFormID, int developmentPhaseID)
{
int?productionUnitsNumber;
var db = new Models.SmizeeContext();
using (SmizeeContext Context = new SmizeeContext())
{
OperationalLicensesFormPhase formDevPhase = Context.OperationalLicensesFormPhases.FirstOrDefault(o => o.OperationalLicensesFormID == operationalLicensesFormID & o.DevelopmentPhaseID == developmentPhaseID);
if (formDevPhase == null)
{
return(null);
}
productionUnitsNumber = formDevPhase.ProductionUnitsNumber;
}
return(productionUnitsNumber);
}