public TeamDetail getTeamMember(SqlConnection con, int memberID) { DataTable dt = new DataTable(); TeamDetail objTeamMember = null; try { SqlDataAdapter da = new SqlDataAdapter("select * from T_Team_Detail WHERE memberID=" + memberID.ToString(), con); da.Fill(dt); da.Dispose(); if (dt.Rows.Count == 0) { return(null); } objTeamMember = new TeamDetail(); objTeamMember.intMemberID = dt.Rows[0].Field <int>("MemberID"); objTeamMember.intTeamID = dt.Rows[0].Field <int>("TeamID"); objTeamMember.strMemberName = dt.Rows[0].Field <string>("MemberName"); objTeamMember.strRemarks = dt.Rows[0].Field <string>("Remarks"); objTeamMember.strContactNo = dt.Rows[0].Field <string>("ContactNo"); objTeamMember.intDesignationID = dt.Rows[0].Field <int>("DesignationID"); objTeamMember.intDeptID = dt.Rows[0].Field <int>("DeptID"); } catch (Exception ex) { throw ex; } return(objTeamMember); }
public int SaveOrUpdateDetail(TeamDetail objTeamDetail, SqlConnection con) { SqlCommand com = null; SqlTransaction trans = null; try { com = new SqlCommand(); trans = con.BeginTransaction(); com.Transaction = trans; com.Connection = con; com.CommandText = "spInsertUpdateTeamDetail"; com.Parameters.Add("@memberID", SqlDbType.Int).Value = objTeamDetail.intMemberID; com.Parameters.Add("@TeamID", SqlDbType.Int).Value = objTeamDetail.intTeamID; com.Parameters.Add("@MemberName", SqlDbType.VarChar, 100).Value = objTeamDetail.strMemberName; com.Parameters.Add("@DesignationID", SqlDbType.Int).Value = objTeamDetail.intDesignationID; com.Parameters.Add("@DeptID", SqlDbType.Int).Value = objTeamDetail.intDeptID; com.Parameters.Add("@ContactNo", SqlDbType.VarChar, 100).Value = objTeamDetail.strContactNo; com.Parameters.Add("@Remarks", SqlDbType.VarChar, 500).Value = objTeamDetail.strRemarks; com.CommandType = CommandType.StoredProcedure; com.ExecuteNonQuery(); trans.Commit(); } catch (Exception ex) { throw new Exception("Unable to Save or Update " + ex.Message); } return(0); }
public IActionResult Patch(string id, [FromBody] JsonPatchDocument <TeamDet> teamDetPatch) { try { if (Guid.TryParse(id, out Guid parsedId)) { //var userId = User.FindFirstValue("sub"); TeamDetail teamDetail = _unitOfWork.TeamDetails.Get(parsedId); TeamDet teamDet = _mapper.Map <TeamDet>(teamDetail); teamDetPatch.ApplyTo(teamDet); _mapper.Map(teamDet, teamDetail); _unitOfWork.Complete(); return(CreatedAtRoute("Get", new { id = _mapper.Map <TeamDet>(teamDetail).Id }, _mapper.Map <TeamDet>(teamDetail))); } } catch (Exception e) { string message = e.Message; } return(BadRequest()); }
public IHttpActionResult PutTeamDetail(int id, TeamDetail teamDetail) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != teamDetail.Id) { return(BadRequest()); } db.Entry(teamDetail).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!TeamDetailExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public TeamDetail GetTeamDetailByTeamResponse(IStat stat, TeamResponse team, IList <StatResponse> matchStats) { var teamDetail = new TeamDetail { TeamInfo = team }; var teamTotalAge = 0; var teamStats = new StatResponse(); var players = matchStats.Where(p => p.TeamId == team.Id).Select(p => p.Player).ToList(); foreach (var player in players) { var playerStat = stat.GetPlayerStatByMatchIdAndTeamId(player.Id, team.Id, matchStats); if (playerStat == null) { continue; } teamStats = stat.AddPlayerStatToTeamStats(teamStats, playerStat); teamDetail.PlayerStats.Add(new PlayerMatchStat { Player = player, Stat = playerStat }); teamTotalAge = teamTotalAge + player.BirthDate.GetAge(); } teamDetail.AgeRatio = ConvertFunctions.GetTeamAgeRatio(players.Count, teamTotalAge); teamDetail.TeamStats = teamStats; return(teamDetail); }
public static string NextGameSummary(GameScheduleData nextGame, TeamDetail teamData) { var game = nextGame.Dates[0].Games[0]; var gamelocaltime = game.GameDate.AddHours(teamData.Venue.TimeZone.Offset); var gameTime = gamelocaltime.ToLongDateString() + " at " + gamelocaltime.ToShortTimeString() + " " + teamData.Venue.TimeZone.TZ; return(string.Format("The next {0} game is {1}, {2} @ {3} at {4}", teamData.Name, gameTime, game.Teams.Away.Team.Name, game.Teams.Home.Team.Name, game.Venue.Name)); }
public async Task <bool> UpdateTeamDetail(PlayerCardDto teamDetail) { TeamDetail td = _content.TeamDetails.FirstOrDefault(x => x.UserId == teamDetail.userId && x.Position == teamDetail.CardPosition); td.PlayerId = teamDetail.PlayerId; _content.TeamDetails.Update(td); return(await _content.SaveChangesAsync() > 0); }
///<inheritdoc/> public Uri SaveTeam(TeamDetail team) { if (team == null) { throw new ArgumentNullException(nameof(team)); } return(SaveResource(team, "team")); }
///*[ProjectManagerRequired]*/ public ActionResult ConfirmAssignTeam(int taskId, int teamId) { TeamService repoTeam = new TeamService(); EmployeeService repoEmployee = new EmployeeService(); Team team = repoTeam.Get(teamId); TeamDetail teamDetail = new TeamDetail(team, repoEmployee.Get(team.TeamManagerId), repoEmployee.GetByTeamId(teamId).Select(e => new EmployeeListItem(e))); return(View(teamDetail)); }
/// <summary> /// This method delete the team detail record from table. /// </summary> /// <param name="teamEntity">Team configuration table entity.</param> /// <returns>A <see cref="Task"/> of type bool where true represents entity record is successfully deleted from table while false indicates failure in deleting data.</returns> public async Task <bool> DeleteTeamDetailAsync(TeamDetail teamEntity) { await this.EnsureInitializedAsync(); TableOperation insertOrMergeOperation = TableOperation.Delete(teamEntity); TableResult result = await this.CloudTable.ExecuteAsync(insertOrMergeOperation); return(result.HttpStatusCode == (int)HttpStatusCode.NoContent); }
///<inheritdoc/> public bool UpdateTeam(TeamDetail team) { if (team == null) { throw new ArgumentNullException(nameof(team)); } return(UpdateResource(team, "team/" + team.Id)); }
/// <summary> /// Store or update team detail in Azure table storage. /// </summary> /// <param name="teamEntity">Represents team entity used for storage and retrieval.</param> /// <returns><see cref="Task"/> that represents team entity is saved or updated.</returns> public async Task <bool> StoreOrUpdateTeamDetailAsync(TeamDetail teamEntity) { await this.EnsureInitializedAsync(); teamEntity = teamEntity ?? throw new ArgumentNullException(nameof(teamEntity)); TableOperation addOrUpdateOperation = TableOperation.InsertOrReplace(teamEntity); var result = await this.CloudTable.ExecuteAsync(addOrUpdateOperation); return(result.HttpStatusCode == (int)HttpStatusCode.NoContent); }
public IHttpActionResult GetTeamDetail(int id) { TeamDetail teamDetail = db.TeamDetails.Find(id); if (teamDetail == null) { return(NotFound()); } return(Ok(teamDetail)); }
public IHttpActionResult PostTeamDetail(TeamDetail teamDetail) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.TeamDetails.Add(teamDetail); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = teamDetail.Id }, teamDetail)); }
public async Task AddMemberAsync(TeamMemberBindingModel model, int teamId) { var mem = new TeamDetail { TeamId = teamId, UserId = model.UserId, RoleInTeam = "Member" }; await _db.TeamDetails.AddAsync(mem); await _db.SaveChangesAsync(); }
public IHttpActionResult DeleteTeamDetail(int id) { TeamDetail teamDetail = db.TeamDetails.Find(id); if (teamDetail == null) { return(NotFound()); } db.TeamDetails.Remove(teamDetail); db.SaveChanges(); return(Ok(teamDetail)); }
public async Task <IActionResult> UpdateTeamDetailRecord(PlayerCardDto playerDto) { // _logger.LogInformation("Demo Logging Information in Index Method"); // Need to get the correct Id for the current cardPosition for the User var existingTeamDetailForPosition = _repo.GetTeamDetailForPosition(playerDto.userId, playerDto.CardPosition); // _logger.LogInformation("existing teamDetail for position is now being set"); if (existingTeamDetailForPosition != null) { // This needs to be updated var teamDetailToUpdate = new TeamDetail { Active = 1, Captain = playerDto.isCaptain, Emergency = playerDto.isEmergency, Id = existingTeamDetailForPosition.Id, PlayerId = playerDto.PlayerId, Position = playerDto.CardPosition, SixthMan = playerDto.isSixthMan, UserId = playerDto.userId }; // Now need to call the update method of the TeamDetail // _logger.LogInformation("About to call to the Update Team Detail Repo"); var updateSalary = await _repo.UpdateTeamDetail(teamDetailToUpdate); // _logger.LogInformation("Returned from the Update Team Detail repo - with status of: " + updateSalary); return(StatusCode(201)); } else { // This is a new Team Detail record - realistically it should never get here var teamDetailToCreate = new TeamDetail { Captain = playerDto.isCaptain, Emergency = playerDto.isEmergency, SixthMan = playerDto.isSixthMan, Active = 1, PlayerId = playerDto.PlayerId, Position = playerDto.CardPosition, UserId = playerDto.userId }; var createdTeamDetail = await _repo.CreateTeamDetailRecord(teamDetailToCreate); return(StatusCode(201)); } }
public string AddTeam(Team newTeam) { if (newTeam == null) { throw new ArgumentNullException($"Team is null"); } var teamAddKey = _teamRepository.Create(newTeam); var newuserteam = new TeamDetail { Name = newTeam.Name }; _teamdetailRepository.CreateWithId(teamAddKey, newuserteam); return(teamAddKey); }
public async Task <IActionResult> CreateTeamDetail(TeamDetailForPlayerDto teamDetailDto) { var teamDetailToCreate = new TeamDetail { Captain = teamDetailDto.Captain, Emergency = teamDetailDto.Emergency, SixthMan = teamDetailDto.SixthMan, Active = 1, PlayerId = teamDetailDto.PlayerId, Position = teamDetailDto.Position, UserId = teamDetailDto.UserId }; var createdTeamDetail = await _repo.CreateTeamDetailRecord(teamDetailToCreate); return(StatusCode(201)); }
public IHttpActionResult Put(TeamDetail team) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var service = new TeamService(Guid.Parse(User.Identity.GetUserId())); if (!service.EditTeam(team)) { return(InternalServerError()); } return(Ok()); }
public IActionResult Get(string id) { try { if (Guid.TryParse(id, out Guid parsedId)) { TeamDetail teamDetail = _unitOfWork.TeamDetails.GetDetail(parsedId, true); return(Ok(_mapper.Map <TeamDet>(teamDetail))); } } catch (Exception e) { string message = e.Message; } return(NotFound()); }
public void UpdateTeam(string teamId, TeamDetail updateTeamDetail) { if (updateTeamDetail == null) { throw new ArgumentNullException($"Team is null"); } if (string.IsNullOrEmpty(teamId)) { throw new ArgumentException($"Team ID is null"); } var updateteam = new Team { Name = updateTeamDetail.Name }; _teamRepository.CreateWithId(teamId, updateteam); _teamdetailRepository.CreateWithId(teamId, updateTeamDetail); }
public ActionResult ConfirmAssignTeam(int taskId, TeamDetail collection) { try { if (ModelState.IsValid) { TaskService repoTask = new TaskService(); if (repoTask.AssignTeam(taskId, collection.Id)) { return(RedirectToAction("Details", new { id = taskId })); } return(RedirectToAction("AssignTeam", new { id = taskId })); } return(RedirectToAction("AssignTeam", new { id = taskId })); } catch (Exception) { return(RedirectToAction("AssignTeam", new { id = taskId })); } }
// GET: Team/Details/5 public ActionResult Details(int id) { TeamService teamRepo = new TeamService(); CD.Team team = teamRepo.Get(id); EmployeeService employeeRepo = new EmployeeService(); DocumentService repoDoc = new DocumentService(); IEnumerable <CD.Employee> employees = employeeRepo.GetByTeamId(id); List <EmployeeListItem> finalList = new List <EmployeeListItem>(); foreach (CD.Employee employee in employees) { finalList.Add(new EmployeeListItem(employee)); } MessageService repoMessage = new MessageService(); IEnumerable <ConversationListItem> conversations = repoMessage.GetTeamMessages(id).Select(m => new ConversationListItem(new M.Message(m), new M.Message(repoMessage.GetLastMessage(m.Id)), team)); IEnumerable <DocumentList> docs = repoDoc.GetByTeam(id).Select(d => new DocumentList(d)); TeamDetail teamDetail = new TeamDetail(team, employeeRepo.Get(team.TeamManagerId), finalList, conversations, docs); return(View(teamDetail)); }
public static void ClassInit(TestContext context) { //Arrange Team = new Team { Name = "TeamName" }; TeamDetail = new TeamDetail { Name = Team.Name }; var teams = new List <Team> { Team }; var mockTeamRepo = new Mock <IRepository <Team> >(); mockTeamRepo.Setup(x => x.Create(It.IsAny <Team>())).Returns("TeamId"); mockTeamRepo.Setup(x => x.GetList()).Returns(teams); var mockTeamDetailRepo = new Mock <IRepository <TeamDetail> >(); mockTeamDetailRepo.Setup(x => x.GetItem(It.IsAny <string>())).Returns(TeamDetail); TeamService = new TeamService(mockTeamRepo.Object, mockTeamDetailRepo.Object); }
public static string PeriodSummary(LineScorePeriod lineScorePeriod, TeamDetail home, TeamDetail away, NHLApi.GameDetail gameDetail) { /* * Period X: * Shots: <HomeTeam> X, <AwayTeam> Y * Goals: <HomeTeam> X, <AwayTeam> Y * Scoring Plays: * . * . * . */ var playIndexStart = gameDetail.LiveData.Plays.PlaysByPeriod[lineScorePeriod.Num - 1].StartIndex; var playIndexEnd = gameDetail.LiveData.Plays.PlaysByPeriod[lineScorePeriod.Num - 1].EndIndex; var builder = new StringBuilder(); builder.AppendLine(String.Format("**Period {0}:**", lineScorePeriod.Num)); builder.AppendLine(String.Format("__Shots:__ {0} {1}, {2} {3}", home.Abbreviation, lineScorePeriod.Home.ShotsOnGoal, away.Abbreviation, lineScorePeriod.Away.ShotsOnGoal)); builder.AppendLine(String.Format("__Goals:__ {0} {1}, {2} {3}", home.Abbreviation, lineScorePeriod.Home.Goals, away.Abbreviation, lineScorePeriod.Away.Goals)); var scoringPlays = GetScoringPlaysForPeriod(gameDetail, playIndexStart, playIndexEnd); if (scoringPlays.Count() > 0) { builder.AppendLine("__Scoring Plays:__"); foreach (var play in scoringPlays) { builder.AppendLine(" - " + play); } } else { builder.AppendLine(" - No Goals were scored this period."); } return(builder.ToString()); }
public async Task AddTeamAsync(TeamViewModel model) { var team = new UserTeam { TeamName = model.TeamName, TeamLeadId = model.UserId }; var addteam = await _db.UserTeams.AddAsync(team); if (addteam != null && team.TeamLeadId != null) { var teamlead = new TeamDetail { TeamId = team.Id, RoleInTeam = "Team Lead", UserId = model.UserId, }; await _db.TeamDetails.AddAsync(teamlead); } await _db.SaveChangesAsync(); }
public bool EditTeam(TeamDetail model) { using (var ctx = new ApplicationDbContext()) { var entity = ctx .Teams .Single(e => e.TeamId == model.TeamId); if (entity.UserId == _userId) { entity.TeamId = model.TeamId; entity.TeamName = model.TeamName; entity.TotalPoints = model.TotalPoints; return(ctx.SaveChanges() == 1); } else { return(false); } } }
public async Task <IActionResult> GetTeamDetailsAsync(string teamId) { try { var userClaims = this.GetUserClaims(); var teamsChannelAccounts = new List <TeamsChannelAccount>(); IEnumerable <ChannelInfo> teamsChannelInfo = new List <ChannelInfo>(); var conversationReference = new ConversationReference { ChannelId = teamId, ServiceUrl = userClaims.ServiceUrl, Bot = new ChannelAccount() { Id = $"28:{this.appId}" }, Conversation = new ConversationAccount() { ConversationType = Constants.ChannelConversationType, IsGroup = true, Id = teamId, TenantId = this.options.Value.TenantId }, }; await this.botAdapter.ContinueConversationAsync( this.appId, conversationReference, async (context, token) => { string continuationToken = null; do { var currentPage = await TeamsInfo.GetPagedMembersAsync(context, 100, continuationToken, CancellationToken.None); continuationToken = currentPage.ContinuationToken; teamsChannelAccounts.AddRange(currentPage.Members); }while (continuationToken != null); teamsChannelInfo = await TeamsInfo.GetTeamChannelsAsync(context, teamId, CancellationToken.None); }, default); this.logger.LogInformation("GET call for fetching team members and channels from team roster is successful"); teamsChannelInfo.First(channel => channel.Name == null).Name = Strings.GeneralChannel; var teamDetails = new TeamDetail { TeamMembers = teamsChannelAccounts .Select( member => new TeamMember { Content = member.Email, Header = member.Name, AzureAdObjectId = member.AadObjectId, }), Channels = teamsChannelInfo .Select( member => new TeamAccount { ChannelId = member.Id, Header = member.Name, }), }; return(this.Ok(teamDetails)); } catch (Exception ex) { this.logger.LogError(ex, "Error occurred while getting team member list."); throw; } }
public static string GameSummary(ScheduleData scheduleData, GameScheduleData nextGame, TeamDetail teamData) { // Final Score: <Home Team> X, <Away Team> Y // Next Game: <Next Game for Config'd Team> var builder = new StringBuilder(); builder.AppendLine(String.Format("Final Score: {0} {1}, {2} {3}", scheduleData.Dates[0].Games[0].Teams.Home.Team.Name, scheduleData.Dates[0].Games[0].Teams.Home.Score, scheduleData.Dates[0].Games[0].Teams.Away.Team.Name, scheduleData.Dates[0].Games[0].Teams.Away.Score)); builder.AppendLine(NextGameSummary(nextGame, teamData)); return(builder.ToString()); }