public IHttpActionResult actionPost(ChampionshipCommentMatchDetailsModel model)
{
db.openConnection();
DataTable dt = null;
try
{
if (model.actionUser.ToLower() == "save_comment")
{
paramName = new string[] { "pIdJogo", "pIdUsu", "pDsComentario" };
paramValue = new string[] { Convert.ToString(model.matchID), Convert.ToString(model.userID), model.comment };
dt = db.executePROC("spAddComentarioJogo", paramName, paramValue);
model.returnMessage = "ModeratorSuccessfully";
return(CreatedAtRoute("DefaultApi", new { id = 0 }, model));
}
else
{
return(StatusCode(HttpStatusCode.NotAcceptable));
}
}
catch (Exception ex)
{
model.returnMessage = "errorPostChampionshipCommentMatch_" + ex.Message;
return(CreatedAtRoute("DefaultApi", new { id = 0 }, model));
}
finally
{
db.closeConnection();
dt = null;
}
}
public IHttpActionResult GetAllForMatch(int id)
{
ChampionshipCommentMatchDetailsModel modelDetails = new ChampionshipCommentMatchDetailsModel();
ChampionshipCommentMatchListViewModel mainModel = new ChampionshipCommentMatchListViewModel();
List <ChampionshipCommentMatchDetailsModel> listOfModel = new List <ChampionshipCommentMatchDetailsModel>();
DataTable dt = null;
db.openConnection();
try
{
paramName = new string[] { "pIdJogo" };
paramValue = new string[] { id.ToString() };
dt = db.executePROC("spGetAllComentarioJogoByJogo", paramName, paramValue);
for (var i = 0; i < dt.Rows.Count; i++)
{
modelDetails = new ChampionshipCommentMatchDetailsModel();
modelDetails.id = Convert.ToInt32(dt.Rows[i]["ID_COMENTARIO"].ToString());
modelDetails.matchID = Convert.ToInt32(dt.Rows[i]["ID_TABELA_JOGO"].ToString());
// modelDetails.championshipID = Convert.ToInt16(dt.Rows[i]["ID_CAMPEONATO"].ToString());
modelDetails.userID = Convert.ToInt32(dt.Rows[i]["ID_USUARIO"].ToString());
modelDetails.userName = dt.Rows[i]["NM_USUARIO"].ToString();
modelDetails.psnID = dt.Rows[i]["PSN_ID"].ToString();
modelDetails.commentDate = Convert.ToDateTime(dt.Rows[i]["DT_COMENTARIO"].ToString());
modelDetails.commentHour = dt.Rows[i]["HR_COMENTARIO"].ToString();
modelDetails.comment = dt.Rows[i]["DS_COMENTARIO"].ToString();
modelDetails.teamName = dt.Rows[i]["NM_TIME"].ToString();
listOfModel.Add(modelDetails);
}
mainModel.listOfCommentMatch = listOfModel;
mainModel.returnMessage = "ModeratorSuccessfully";
return(CreatedAtRoute("DefaultApi", new { id = 0 }, mainModel));
}
catch (Exception ex)
{
mainModel = new ChampionshipCommentMatchListViewModel();
mainModel.listOfCommentMatch = new List <ChampionshipCommentMatchDetailsModel>();
mainModel.returnMessage = "errorGetAllCommentMatchForMatch_" + ex.Message;
return(CreatedAtRoute("DefaultApi", new { id = 0 }, mainModel));
}
finally
{
db.closeConnection();
modelDetails = null;
mainModel = null;
listOfModel = null;
dt = null;
}
}
