private int CreateConfigIfNotExist(int franchiseID)
{
var context = new EightHundredEntities();
if (context.tbl_HVAC_ConfigFranchise.Any(item => item.FranchiseID == franchiseID))
{
return(context.tbl_HVAC_ConfigFranchise.First(item => item.FranchiseID == franchiseID).ConfigID);
}
var config = new tbl_HVAC_ConfigsApp {
ConfigName = "Config for Franchise " + franchiseID.ToString()
};
context.tbl_HVAC_ConfigsApp.AddObject(config);
context.SaveChanges();
var configFranchise = new tbl_HVAC_ConfigFranchise {
ConfigID = config.ConfigID, FranchiseID = franchiseID
};
context.tbl_HVAC_ConfigFranchise.AddObject(configFranchise);
SetQuestionsForNewConfig(context, config);
context.SaveChanges();
return(config.ConfigID);
}
private void SetQuestionsForNewConfig(EightHundredEntities context, tbl_HVAC_ConfigsApp configID)
{
var defaultConfig = context.tbl_HVAC_ConfigsApp.First(item => item.ConfigID == 1);
foreach (var question in defaultConfig.tbl_HVAC_ConfigQuestions)
{
configID.tbl_HVAC_ConfigQuestions.Add(new tbl_HVAC_ConfigQuestions {
QuestionID = question.QuestionID, OrderNum = question.OrderNum
});
}
}
