public int InsertTeam(TeamsClass team) { try { return(Convert.ToInt32(dataProvider.ExecuteScalar("usp_InsertTeam", team.TeamName, team.ClubID, team.CompRegID, team.CompetitionGroupID, team.TeamHistory, team.TeamLogo, team.TeamPhoto, team.GoogleID, team.FaceBookID, team.TwitterID, team.CreatedBy, team.ModifyBy, team.IsNationalTeam, team.TeamMasterID))); } catch (Exception ex) { Exceptions.LogException(ex); } return(0); }
public int UpdateMasterTeam(TeamsClass team) { try { dataProvider.ExecuteNonQuery("usp_UpdateMasterTeam", team.TeamID, team.TeamName, 1, team.TeamHistory, team.TeamLogo, team.TeamPhoto, team.GoogleID, team.FaceBookID, team.TwitterID, team.ModifyBy); } catch (Exception ex) { Exceptions.LogException(ex); } return(0); }
public DataTable MasterTeamPhotoFile(TeamsClass Team) { using (DataTable dt = new DataTable()) { try { using (IDataReader reader = dataProvider.ExecuteReader("usp_MasterTeamPhotoFile", Team.TeamID)) { dt.Load(reader); return(dt); } } catch (Exception ex) { Exceptions.LogException(ex); } return(dt); } }