public int InsertPlayerCardDetail(clsMatchPlayerPerfomance mp)
{
try
{
dataProvider.ExecuteNonQuery("[usp_InsertPlayerCardDetail]", mp.MatchPlayerPerfomanceID, mp.CardName, mp.Remark);
}
catch (Exception ex)
{
Exceptions.LogException(ex);
}
return(0);
}
public int InsertMatchPlayerPerfomance(clsMatchPlayerPerfomance mp)
{
try
{
dataProvider.ExecuteNonQuery("[usp_InsertMatchPlayerPerfomance]", mp.CompetitionID, mp.MatchId, mp.TeamID, mp.PlayerID, mp.Goal, mp.Assist, mp.Red, mp.Yellow, mp.IsPlayed, mp.OwnGoal, mp.PlayerSuspended, mp.PortalID, mp.CreatedById, mp.ModifiedById);
}
catch (Exception ex)
{
Exceptions.LogException(ex);
}
return(0);
}
public int UpdateMatchResultPlayerPerformance(clsMatchPlayerPerfomance mr)
{
try
{
dataProvider.ExecuteNonQuery("usp_UpdateMatchResultPlayerPerformance", mr.MatchPlayerPerfomanceID, mr.CompetitionID, mr.MatchId, mr.PlayerID, mr.Goal, mr.Assist, mr.PortalID, mr.CreatedById, mr.ModifiedById, mr.Yellow, mr.Red, mr.OwnGoal, mr.TeamID);
}
catch (Exception ex)
{
Exceptions.LogException(ex);
}
return(0);
}
public DataTable getYelloowRed(clsMatchPlayerPerfomance mr)
{
DataTable dt = new DataTable();
try
{
using (IDataReader rdr = dataProvider.ExecuteReader("usp_getYelloowRed", mr.CompetitionID, mr.MatchId, mr.PlayerID))
{
dt.Load(rdr);
}
return(dt);
}
catch (Exception ex)
{
return(null);
}
}
public DataTable getPlayerGoal(clsMatchPlayerPerfomance mr)
{
using (DataTable dt = new DataTable())
{
try
{
using (IDataReader reader = dataProvider.ExecuteReader("usp_GetPlayerGoalByMatchPlayerID", mr.CompetitionID, mr.MatchId, mr.PlayerID))
{
dt.Load(reader);
return(dt);
}
}
catch (Exception ex)
{
Exceptions.LogException(ex);
}
return(dt);
}
}
