public int CreateProjectChoice(ProjectChoice projectChoice)
{
try
{
using (var connection = GetConnection())
{
var p = new DynamicParameters();
p.Add("@" + ProjectChoice.StudentIdDatabaseColumnName, value: projectChoice.student_id, dbType: DbType.Int32);
p.Add("@" + ProjectChoice.ProjectIdDatabaseColumnName, value: projectChoice.project_id, dbType: DbType.Int32);
p.Add("@" + ProjectChoice.RankingPrecedenceDatabaseColumnName, value: projectChoice.ranking_precedence, dbType: DbType.Int32);
p.Add("@" + ProjectChoice.SubmittedDateDatabaseColumnName, value: projectChoice.submitted_date, dbType: DbType.DateTime);
var numberOfRowsAffected = connection.Execute("createProjectChoiceSP", p, commandType: CommandType.StoredProcedure);
return(numberOfRowsAffected);
}
}
catch
{
throw;
}
}
public static void SaveProjectData(ProjectChoice pc = ProjectChoice.Aritiafel, string backupDrive = DefaultBackupDrive)
{
Residence rs = new Residence($"{backupDrive}:\\Backup");
rs.SaveVSSolutionData(ProjectFolderPath[pc]);
}
