public bool AddModule(Module module)
{
var idParam = new SqlParameter { ParameterName = "Name", Value = module.Name };
var idParam1 = NullChecker(new SqlParameter { ParameterName = "Description", Value = module.Description });
var idParam2 = new SqlParameter { ParameterName = "CategoryID", Value = module.CategoryId };
var idParam3 = new SqlParameter { ParameterName = "DefaultNumAnswers", Value = module.DefaultNumAnswers };
var idParam4 = new SqlParameter { ParameterName = "DefaultTime", Value = module.DefaultTime };
var idParam5 = new SqlParameter { ParameterName = "DefaultNumQuestions", Value = module.DefaultNumQuestions };
var idParam6 = new SqlParameter { ParameterName = "isPrivate", Value = module.isPrivate };
var idParam7 = new SqlParameter { ParameterName = "user_Id", Value = module.User.Id };
var idParam8 = NullChecker(new SqlParameter { ParameterName = "rightAnswerString", Value = module.rightAnswerString });
var idParam9 = NullChecker(new SqlParameter { ParameterName = "wrongAnswerString", Value = module.wrongAnswerString });
var idParam10 = new SqlParameter { ParameterName = "isDisabled", Value = module.isDisabled };
var idParam11 = NullChecker(new SqlParameter { ParameterName = "DisableModuleNote", Value = module.DisableModuleNote });
var idParam12 = NullChecker(new SqlParameter { ParameterName = "DisableReason", Value = module.DisableReason });
try
{
_dc.Database.ExecuteSqlCommand(
"INSERT INTO Modules(Name, Description, CategoryId, DefaultNumAnswers, DefaultTime, DefaultNumQuestions, isPrivate, User_Id, rightAnswerString, wrongAnswerString, isDisabled, DisableModuleNote, DisableReason) VALUES (@Name, @Description, @CategoryId, @DefaultNumAnswers, @DefaultTime, @DefaultNumQuestions, @isPrivate, @User_Id, @rightAnswerString, @wrongAnswerString, @isDisabled, @DisableModuleNote, @DisableReason)",
idParam, idParam1, idParam2, idParam3, idParam4, idParam5, idParam6, idParam7, idParam8, idParam9, idParam10, idParam11, idParam12
);
}
catch (Exception)
{
return false;
}
return true;
}
public static void CreateDirectory(Module module)
{
if (!Directory.Exists(DevPro.baseFileDirectory + "PLM/" + module.GetModuleDirectory()))
{
Directory.CreateDirectory(DevPro.baseFileDirectory + "PLM/" + module.GetModuleDirectory());
}
}
public DisableModuleViewModel(Module module)
{
ModuleID = module.ModuleID;
Name = module.Name;
DisableReason = module.DisableReason;
DisableModuleNote = module.DisableModuleNote;
isDisabled = module.isDisabled;
}
public UserGameSession()
{
//NEW
GameSettings = new GameSettings();
Score = 0;
// OLD
currentModule = new Module();
numCorrect = 0;
PictureIndices = new List<AnsPicIndex>();
}
public GameModule(Module module)
{
ModuleID = module.ModuleID;
Name = module.Name;
DefaultNumAnswers = module.DefaultNumAnswers;
DefaultNumQuestions = module.DefaultNumQuestions;
DefaultTime = module.DefaultTime;
using (Repos repo = new Repos())
{
module.Answers = repo.GetAnswerList(module.ModuleID).ToList();
}
Answers = ConvertAnswers(module.Answers);
rightAnswerString = module.rightAnswerString;
wrongAnswerString = module.wrongAnswerString;
}
public bool UpdateModule(Module module)
{
var idParam = new SqlParameter { ParameterName = "Name", Value = module.Name };
var idParam1 = new SqlParameter { ParameterName = "Description", Value = module.Description };
var idParam2 = new SqlParameter { ParameterName = "CategoryID", Value = module.CategoryId };
var idParam3 = new SqlParameter { ParameterName = "DefaultNumAnswers", Value = module.DefaultNumAnswers };
var idParam4 = new SqlParameter { ParameterName = "DefaultTime", Value = module.DefaultTime };
var idParam5 = new SqlParameter { ParameterName = "DefaultNumQuestions", Value = module.DefaultNumQuestions };
var idParam6 = new SqlParameter { ParameterName = "isPrivate", Value = module.isPrivate };
var idParam7 = new SqlParameter { ParameterName = "user_Id", Value = module.User.Id };
var idParam8 = new SqlParameter { ParameterName = "rightAnswerString", Value = module.rightAnswerString };
var idParam9 = new SqlParameter { ParameterName = "wrongAnswerString", Value = module.wrongAnswerString };
var idParam10 = new SqlParameter { ParameterName = "isDisabled", Value = module.isDisabled };
var idParam11 = new SqlParameter { ParameterName = "DisableModuleNote", Value = module.DisableModuleNote };
var idParam12 = new SqlParameter { ParameterName = "DisableReason", Value = module.DisableReason };
var idParam13 = new SqlParameter { ParameterName = "ModuleID", Value = module.ModuleID };
try
{
_dc.Database.ExecuteSqlCommand(
"Update Modules SET Name = @Name, Description = @Description, CategoryId = @CategoryID, DefaultNumAnswers = @DefaultNumAnswers, DefaultTime = @DefaultTime, DefaultNumQuestions = @DefaultNumQuestions, isPrivate = @isPrivate, User_Id = @User_Id, rightAnswerString = @rightAnswerString, wrongAnswerString = @wrongAnswerString, isDisabled = @isDisabled, DisableModuleNote = @DisableModuleNote, DisableReason = @DisableReason where ModuleID = @ModuleID",
idParam, idParam1, idParam2, idParam3, idParam4, idParam5, idParam6, idParam7, idParam8, idParam9, idParam10, idParam11, idParam12, idParam13
);
}
catch (Exception)
{
return false;
}
return true;
}
public ModuleRepository()
{
module = new Module();
module.Pictures = new List<Picture>();
}
