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]); }