예제 #1
0
 public int InsertClub(clsClub cc)
 {
     try
     {
         dataProvider.ExecuteNonQuery("usp_InsertClub", cc.ClubName, cc.ClubAbbr, cc.ClubDesc, cc.ClubFamousName, cc.ClubLogoName, cc.ClubLogoFile, cc.ClubPhotoFile, Convert.ToDateTime(cc.ClubEstablishedYear), cc.ActiveFlagId, cc.ShowFlagId, cc.PortalID, cc.CreatedById, cc.ModifiedById);
     }
     catch (Exception ex)
     {
         Exceptions.LogException(ex);
     }
     return(0);
 }
예제 #2
0
        public int UpdateClub(clsClub cc)
        {
            int i = 0;

            try
            {
                //CompReg.CreatedBy,
                dataProvider.ExecuteNonQuery("usp_UpdateClub", cc.ClubId, cc.ClubName, cc.ClubAbbr, cc.ClubDesc, cc.ClubFamousName, cc.ClubLogoName, cc.ClubLogoFile, cc.ClubPhotoFile, Convert.ToDateTime(cc.ClubEstablishedYear), cc.ActiveFlagId, cc.ShowFlagId, cc.PortalID, cc.ModifiedById);
            }
            catch (Exception ex)
            {
                return(i);
            }
            return(i);
        }
예제 #3
0
        public DataTable GetClubPhoto(clsClub cc)
        {
            using (DataTable dt = new DataTable())
            {
                try
                {
                    using (IDataReader reader = dataProvider.ExecuteReader("usp_ClubPhoto", cc.ClubId))
                    {
                        dt.Load(reader);
                        return(dt);
                    }
                }

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