public List <TeamModel> GetTeam_All() { List <TeamModel> output; using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConfig.CncString(dbName))) { output = connection.Query <TeamModel>("dbo.spTeam_GetAll").ToList(); foreach (TeamModel team in output) { var p = new DynamicParameters(); p.Add("@TeamId", team.Id); team.TeamMembers = connection.Query <PersonModel>("dbo.spTeamMembers_GetByTeam", p, commandType: CommandType.StoredProcedure).ToList(); } } return(output); }
/// <summary> /// Returns a list of all people in the sql database /// </summary> /// <returns></returns> public List <PersonModel> GetPerson_All() { List <PersonModel> output; using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConfig.CncString(dbName))) { output = connection.Query <PersonModel>("dbo.spPeople_GetAll").ToList(); } return(output); }
/// <summary> /// Saves a new prize to the database /// </summary> /// <param name="model">The prize info.</param> /// <returns>The prize information, including the unique id</returns> public PrizeModel CreatePrize(PrizeModel model) { using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConfig.CncString(dbName))) { var p = new DynamicParameters(); p.Add("@PlaceNumber", model.PlaceNumber); p.Add("@PlaceName", model.PlaceName); p.Add("@PrizeAmount", model.PrizeAmount); p.Add("@PrizePercentage", model.PrizePercentage); p.Add("@id", 0, dbType: DbType.Int32, direction: ParameterDirection.Output); connection.Execute("dbo.spPrize_Insert", p, commandType: CommandType.StoredProcedure); model.Id = p.Get <int>("@id"); return(model); } }
public TeamModel CreateTeam(TeamModel model) { using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConfig.CncString(dbName))) { var p = new DynamicParameters(); p.Add("@TeamName", model.TeamName); p.Add("@id", 0, dbType: DbType.Int32, direction: ParameterDirection.Output); connection.Execute("dbo.spTeams_Insert", p, commandType: CommandType.StoredProcedure); model.Id = p.Get <int>("@id"); foreach (PersonModel pm in model.TeamMembers) { p = new DynamicParameters(); p.Add("@TeamId", model.Id); p.Add("@PersonId", pm.Id); connection.Execute("dbo.spTeamMembers_Insert", p, commandType: CommandType.StoredProcedure); } return(model); } }
/// <summary> /// Saves a new person to the database /// </summary> /// <param name="model">The person model</param> /// <returns></returns> public PersonModel CreatePerson(PersonModel model) { using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConfig.CncString(dbName))) { var p = new DynamicParameters(); p.Add("@FirstName", model.FirstName); p.Add("@LastName", model.LastName); p.Add("@EmailAddress", model.EmailAddress); p.Add("@PhoneNumber", model.PhoneNumber); p.Add("@id", 0, dbType: DbType.Int32, direction: ParameterDirection.Output); connection.Execute("dbo.spPeople_Insert", p, commandType: CommandType.StoredProcedure); model.Id = p.Get <int>("@id"); return(model); } }