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