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