public IActionResult selectTeamById(int teamId) { List <getTeam> teamList = new List <getTeam>(); try { DataSet ds = Data.Team.selectTeamById(teamId); DataTable dt0 = ds.Tables[0]; DataTable dt = ds.Tables[1]; List <updateTeam> teamDetailsList = new List <updateTeam>(); if (dt0.Rows[0]["status"] != "TeamDetails") { for (int i = 0; i < dt.Rows.Count; i++) { getTeam team = new getTeam(); team.teamPlayerListId = (int)dt.Rows[i]["teamPlayerListId"]; team.teamId = (int)dt.Rows[i]["teamId"]; team.playerName = (dt.Rows[i]["playerName"] == DBNull.Value ? "" : dt.Rows[i]["playerName"].ToString()); team.gender = (dt.Rows[i]["gender"] == DBNull.Value ? "" : dt.Rows[i]["gender"].ToString()); team.RoleType = (dt.Rows[i]["RoleType"] == DBNull.Value ? "" : dt.Rows[i]["RoleType"].ToString()); teamList.Add(team); } return(StatusCode((int)HttpStatusCode.OK, teamList)); } else if (dt0.Rows[0]["status"] == "TeamDetails") { //for (int i = 0; i < dt.Rows.Count; i++) //{ updateTeam team = new updateTeam(); team.teamId = (dt.Rows[0]["teamId"] == DBNull.Value ? 0 : (int)dt.Rows[0]["teamId"]); team.scoreKeeperID = (dt.Rows[0]["scoreKeeperID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["scoreKeeperID"]); team.teamName = (dt.Rows[0]["teamName"] == DBNull.Value ? "" : dt.Rows[0]["teamName"].ToString()); team.teamIcon = (dt.Rows[0]["teamIcon"] == DBNull.Value ? "" : dt.Rows[0]["teamIcon"].ToString()); team.CreatedOn = (dt.Rows[0]["createdOn"] == DBNull.Value ? "" : dt.Rows[0]["createdOn"].ToString()); team.createdBy = (dt.Rows[0]["createdBy"] == DBNull.Value ? 0 : (int)dt.Rows[0]["createdBy"]); team.startingHole = (dt.Rows[0]["startingHole"] == DBNull.Value ? 0 : (int)dt.Rows[0]["startingHole"]); teamDetailsList.Add(team); // } return(StatusCode((int)HttpStatusCode.OK, team)); } else { return(StatusCode((int)HttpStatusCode.OK, teamList)); } } catch (Exception e) { string SaveErrorLog = Data.Common.SaveErrorLog("selectTeamById", e.Message); return(StatusCode((int)HttpStatusCode.InternalServerError, new { error = new { message = e.Message } })); } }
public static int UpdateTeam(updateTeam updateteam) { try { string ConnectionString = Common.GetConnectionString(); List <SqlParameter> parameters = new List <SqlParameter>(); parameters.Add(new SqlParameter("@teamId", updateteam.teamId)); parameters.Add(new SqlParameter("@teamName", updateteam.teamName)); parameters.Add(new SqlParameter("@teamIcon", updateteam.teamIcon)); parameters.Add(new SqlParameter("@scoreKeeperID", updateteam.scoreKeeperID)); parameters.Add(new SqlParameter("@startingHole", updateteam.startingHole)); int rowsAffected = SqlHelper.ExecuteNonQuery(ConnectionString, CommandType.StoredProcedure, "spUpdateTeam", parameters.ToArray()); return(rowsAffected); } catch (Exception e) { //loggerErr.Error(e.Message + " - " + e.StackTrace); throw e; } }
public IActionResult updateTeam(updateTeam updateteam) { updateTeam team = new updateTeam(); try { if (updateteam.scoreKeeperID <= 0 || updateteam.scoreKeeperID == null) { return(StatusCode((int)HttpStatusCode.BadRequest, new { error = new { message = "Please enter scoreKeeperID" } })); } else if (updateteam.teamId <= 0 || updateteam.teamId == null) { return(StatusCode((int)HttpStatusCode.BadRequest, new { error = new { message = "Please enter teamId" } })); } //else if (updateteam.teamName == "" || updateteam.teamName == null) //{ // return StatusCode((int)HttpStatusCode.BadRequest, new { error = new { message = "Please enter teamName" } }); //} else { int row = Data.Team.UpdateTeam(updateteam); if (row > 0) { return(StatusCode((int)HttpStatusCode.OK, "Updated Successfully")); } else { return(StatusCode((int)HttpStatusCode.InternalServerError, new { error = new { message = "Error while Updating the team" } })); } } } catch (Exception e) { string SaveErrorLog = Data.Common.SaveErrorLog("updateTeam", e.Message.ToString()); return(StatusCode((int)HttpStatusCode.InternalServerError, new { error = new { message = e.Message.ToString() } })); } }
public IActionResult listTeam() { List <updateTeam> teamList = new List <updateTeam>(); try { DataTable dt = Data.Team.listTeam(); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { updateTeam team = new updateTeam(); team.teamId = (dt.Rows[i]["teamId"] == DBNull.Value ? 0 : (int)dt.Rows[i]["teamId"]); team.scoreKeeperID = (dt.Rows[i]["scoreKeeperID"] == DBNull.Value ? 0 : (int)dt.Rows[i]["scoreKeeperID"]); team.teamName = (dt.Rows[i]["teamName"] == DBNull.Value ? "" : dt.Rows[i]["teamName"].ToString()); team.teamIcon = (dt.Rows[i]["teamIcon"] == DBNull.Value ? "" : dt.Rows[i]["teamIcon"].ToString()); team.CreatedOn = (dt.Rows[i]["CreatedOn"] == DBNull.Value ? "" : dt.Rows[i]["CreatedOn"].ToString()); team.createdBy = (dt.Rows[i]["createdBy"] == DBNull.Value ? 0 : (int)dt.Rows[i]["createdBy"]); team.startingHole = (dt.Rows[i]["startingHole"] == DBNull.Value ? 0 : (int)dt.Rows[i]["startingHole"]); team.noOfPlayers = (dt.Rows[i]["noOfPlayers"] == DBNull.Value ? 0 : (int)dt.Rows[i]["noOfPlayers"]); teamList.Add(team); } return(StatusCode((int)HttpStatusCode.OK, teamList)); } else { return(StatusCode((int)HttpStatusCode.OK, teamList)); } } catch (Exception e) { string SaveErrorLog = Data.Common.SaveErrorLog("listTeam", e.Message); return(StatusCode((int)HttpStatusCode.InternalServerError, new { error = new { message = e.Message } })); } }