コード例 #1
0
 public int InsertSport(clsSport cs)
 {
     try
     {
         dataProvider.ExecuteNonQuery("usp_InsertSport", cs.SportName, cs.SportDesc, cs.SportMainImageFile, cs.SportMainImageDesc, cs.SportLogoImageFile, cs.SportLogoImageDesc, cs.SportSmallImageFile, cs.SportSmallImageDesc, cs.ActiveFlagID, cs.ShowFlagID, cs.PortalID, cs.CreatedByID, cs.ModifiedByID);
     }
     catch (Exception ex)
     {
         Exceptions.LogException(ex);
     }
     return(0);
 }
コード例 #2
0
        public int UpdateSport(clsSport cs)
        {
            int i = 0;

            try
            {
                //CompReg.CreatedBy,
                dataProvider.ExecuteNonQuery("usp_UpdateSport", cs.SportID, cs.SportName, cs.SportDesc, cs.SportMainImageFile, cs.SportMainImageDesc, cs.SportLogoImageFile, cs.SportLogoImageDesc, cs.SportSmallImageFile, cs.SportSmallImageDesc, cs.ActiveFlagID, cs.ShowFlagID, cs.PortalID, cs.ModifiedByID);
            }
            catch (Exception ex)
            {
                return(i);
            }
            return(i);
        }
コード例 #3
0
        public DataTable GetSportSmallImageBySportID(clsSport cs)
        {
            using (DataTable dt = new DataTable())
            {
                try
                {
                    using (IDataReader reader = dataProvider.ExecuteReader("usp_GetSportSmallImageBySportID", cs.SportID))
                    {
                        dt.Load(reader);
                        return(dt);
                    }
                }

                catch (Exception ex)
                {
                    Exceptions.LogException(ex);
                }
                return(dt);
            }
        }