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