示例#1
0
 /// <summary>
 /// Initializes a new instance of the <see cref="Reply"/> class.
 /// </summary>
 /// <param name="_replyId">The _reply id.</param>
 /// <param name="_email">The _email.</param>
 /// <param name="_subject">The _subject.</param>
 /// <param name="_rating">The _rating.</param>
 /// <param name="_userId">The _user id.</param>
 /// <param name="_comment">The _comment.</param>
 /// <param name="_addedOn">The _added on.</param>
 /// <param name="_parentId">The _parent id.</param>
 /// <param name="_reference">The _reference.</param>
 /// <param name="_disabled">if set to <c>true</c> [_disabled].</param>
 /// <param name="_approves">The _approves.</param>
 /// <param name="_disapproves">The _disapproves.</param>
 /// <param name="_flaggedInappropriate">The _flagged inappropriate.</param>
 /// <param name="_flaggedOk">if set to <c>true</c> [_flagged ok].</param>
 /// <param name="site">The site.</param>
 public Reply(Guid _replyId, string _email, string _subject, int _rating, int _userId, string _comment, DateTime _addedOn,
 Guid _parentId, string _reference, bool _disabled, int _approves, int _disapproves, int _flaggedInappropriate, bool _flaggedOk, Site site)
 {
     Id = _replyId;
     Email = _email;
     Subject = _subject;
     Rating = _rating;
     UserId = _userId;
     Comment = _comment;
     AddedOn = _addedOn;
     ParentId = _parentId;
     Reference = _reference;
     Disabled = _disabled;
     Approves = _approves;
     Disapproves = _disapproves;
     FlaggedInappropriate = _flaggedInappropriate;
     FlaggedOk = _flaggedOk;
     Replies = new List<Reply>();
     User = site.Users.List.Find(delegate(Commerce.User u) {
         return u.UserId == _userId;
     });
     if(User == null) {
         User = site.NullUser;
     }
 }
示例#2
0
 /// <summary>
 /// Initializes a new instance of the <see cref="ItemImages"/> class.
 /// </summary>
 /// <param name="site">The site.</param>
 public ItemImages(Site site)
 {
     using(SqlConnection cn = Site.CreateConnection(true, true)) {
         cn.Open();
         using(SqlCommand cmd = new SqlCommand(@"select
     imagingId,rtrim(itemNumber) as itemNumber,fileName,height,width
     from imaging with (nolock)", cn)) {
             using(SqlDataReader d = cmd.ExecuteReader()) {
                 if(d.HasRows) {
                     while(d.Read()) {
                         List.Add(new Image(
                             d.GetGuid(0),
                             d.GetString(1),
                             d.GetString(2),
                             d.GetInt32(3),
                             d.GetInt32(4),
                             "o",
                             site
                         ));
                     }
                 }
             }
         }
     }
     return;
 }
示例#3
0
 /// <summary>
 /// Initializes a new instance of the <see cref="Image"/> class.
 /// </summary>
 /// <param name="id">The id.</param>
 /// <param name="itemNumber">The item number.</param>
 /// <param name="fileName">Name of the file.</param>
 /// <param name="height">The height.</param>
 /// <param name="width">The width.</param>
 /// <param name="locationType">Type of the location.</param>
 /// <param name="_site">The _site.</param>
 public Image(Guid id, string itemNumber, string fileName, int height, int width, string locationType, Site _site)
 {
     this.ItemNumber = itemNumber;
     this.FileName = fileName;
     this.Url = "/img/items/" + _site.siteAddress + "/" + itemNumber + "/" + fileName;
     this.Height = height;
     this.Width = width;
     this.LocationType = locationType;
     this.ImageType = imageTypeStringToImageType(LocationType);
     this.Id = id;
     if(height > 0 && width > 0) {
         this.HorizontalAspectRatio = (height / width);
         this.VerticalAspectRatio = (width / height);
     }
 }
示例#4
0
 /// <summary>
 /// Initializes a new instance of the <see cref="Review"/> class.
 /// </summary>
 /// <param name="f_id">The f_id.</param>
 /// <param name="f_userId">The f_user id.</param>
 /// <param name="f_rating">The f_rating.</param>
 /// <param name="f_value">The f_value.</param>
 /// <param name="f_archive">if set to <c>true</c> [f_archive].</param>
 /// <param name="f_date">The f_date.</param>
 /// <param name="f_refId">The f_ref id.</param>
 /// <param name="f_refType">Type of the f_ref.</param>
 /// <param name="site">The site.</param>
 public Review(Guid f_id, int f_userId, double f_rating, string f_value, bool f_archive,
 DateTime f_date, string f_refId, string f_refType, Site site)
 {
     Id = f_id;
     UserId = f_userId;
     Rating = f_rating;
     Value = f_value;
     Archive = f_archive;
     Date = f_date;
     RefId = f_refId;
     RefType = f_refType;
     User = site.Users.List.Find(delegate(User u) {
         return u.UserId == f_userId;
     });
 }
示例#5
0
 /// <summary>
 /// Initializes a new instance of the <see cref="Session"/> class.
 /// </summary>
 /// <param name="_site">The _site.</param>
 /// <param name="sessionId">The session id.</param>
 /// <param name="cn">The cn.</param>
 /// <param name="trns">The TRNS.</param>
 public Session( Site _site, Guid sessionId, SqlConnection cn, SqlTransaction trns )
 {
     getServerStateInfo();
     if( sessionId == Guid.Empty ) {
         /* Ask the DB for a new sessionid*/
         CreateNewSession( false, cn, trns );
     } else {
         Id = sessionId;
         Refresh( false, cn, trns );
         Cart = new Commerce.Cart( this, Site );
     }
 }
示例#6
0
 /// <summary>
 /// Initializes a new instance of the <see cref="Blogs"/> class.
 /// </summary>
 /// <param name="site">The site.</param>
 public Blogs(Site site)
 {
     using(SqlConnection cn = Site.CreateConnection(true, true)) {
         cn.Open();
         using(SqlCommand cmd = new SqlCommand("dbo.getBlogCategories", cn)) {
             using(SqlDataReader blog_list = cmd.ExecuteReader()) {
                 while(blog_list.Read()) {
                     Counter++;
                     if(!(CurrentId == blog_list.GetGuid(19))) {
                         CurrentId = blog_list.GetGuid(19);
                         B = new Blog(
                             blog_list.GetGuid(19),
                             blog_list.GetString(20),
                             blog_list.GetBoolean(21),
                             blog_list.GetInt32(22),
                             blog_list.GetBoolean(23),
                             blog_list.GetString(24),
                             site
                         );
                         List.Add(B);
                     }
                     BlogEntry e = new BlogEntry(
                         blog_list.GetGuid(0),
                         blog_list.GetString(1),
                         blog_list.GetString(2),
                         blog_list.GetString(3),
                         blog_list.GetString(4),
                         blog_list.GetInt32(5),
                         blog_list.GetInt32(6),
                         blog_list.GetDateTime(7),
                         blog_list.GetDateTime(8),
                         blog_list.GetInt32(9),
                         blog_list.GetString(10),
                         blog_list.GetBoolean(11),
                         blog_list.GetBoolean(12),
                         blog_list.GetBoolean(13),
                         blog_list.GetBoolean(14),
                         blog_list.GetString(15),
                         blog_list.GetBoolean(16),
                         blog_list.GetInt32(17),
                         blog_list.GetBoolean(18),
                         blog_list.GetGuid(25),
                         B,
                         site
                     );
                     B.Add(e);
                     AllEntries.Add(e);
                 }
             }
         }
     }
 }
示例#7
0
 /// <summary>
 /// Initializes a new instance of the <see cref="Redirectors"/> class.
 /// </summary>
 /// <param name="site">The site.</param>
 public Redirectors(Site site)
 {
     using(SqlConnection cn = Site.CreateConnection(true, true)) {
         cn.Open();
         SqlCommand cmd = new SqlCommand(@"select redirectorId, urlMatchPattern, urlToRedirectToMatch, errorMatch,
     case when [contentType] is null then '' else [contentType] end,
     case when [type] is null then '' else [type] end,
     case when [listOrder] is null then 0 else [listOrder] end,
     case when [enabled] is null then cast(0 as bit) else [enabled] end
     from redirector with (nolock)", cn);
         using(SqlDataReader r = cmd.ExecuteReader()) {
             while(r.Read()) {
                 Redirector d = new Redirector(r.GetGuid(0), r.GetString(1),
                 r.GetString(2), r.GetString(3), r.GetString(4), r.GetString(5),
                 r.GetInt32(6), r.GetBoolean(7));
                 List.Add(d);
             }
         }
         /* order the list */
         List.Sort(delegate(Redirector rdr1, Redirector rdr2) {
             return rdr2.Order.CompareTo(rdr1.Order);
         });
     }
 }
 /// <summary>
 /// Initializes a new instance of the <see cref="SeoListMetaUtilities"/> class.
 /// </summary>
 /// <param name="site">The site.</param>
 public SeoListMetaUtilities(Site site)
 {
     using(SqlConnection cn = Site.CreateConnection(true, true)) {
         cn.Open();
         SqlCommand cmd = new SqlCommand("dbo.getPageTitles", cn);
         using(SqlDataReader r = cmd.ExecuteReader()) {
             while(r.Read()) {
                 SeoListMetaUtility d = new SeoListMetaUtility(r.GetGuid(0), r.GetInt32(1)
                 , r.GetString(2), r.GetString(3), r.GetString(4), r.GetString(5));
                 List.Add(d);
             }
         }
     }
 }
示例#9
0
 /// <summary>
 /// Initializes a new instance of the <see cref="Cart"/> class.
 /// </summary>
 /// <param name="f_session">The f_session.</param>
 /// <param name="f_site">The f_site.</param>
 public Cart( Session f_session, Site f_site )
 {
     EstShippingCost = 0;
     EstShipTotal = 0;
     SubTotal = 0;
     GrandTotal = 0;
     TaxTotal = 0;
     DiscountTotal = 0;
     Items = new List<CartItem>();
     Addresses = new List<Address>();
     Session = f_session;
     Site = f_site;
 }
示例#10
0
 /// <summary>
 /// Initializes a new instance of the <see cref="Zones"/> class.
 /// </summary>
 /// <param name="site">The site.</param>
 public Zones(Site site)
 {
     using(SqlConnection cn = Site.CreateConnection(true, true)) {
         cn.Open();
         using(SqlCommand cmd = new SqlCommand("dbo.getZones", cn)) {
             using(SqlDataReader carrierList = cmd.ExecuteReader()) {
                 while(carrierList.Read()) {
                     List.Add(new Zone(
                             carrierList.GetGuid(0),
                             carrierList.GetInt32(1),
                             carrierList.GetDouble(2),
                             carrierList.GetInt32(3),
                             carrierList.GetDecimal(4)
                         )
                     );
                 }
             }
         }
     }
 }
示例#11
0
 /// <summary>
 /// Initializes a new instance of the <see cref="Session"/> class.
 /// </summary>
 /// <param name="_site">The _site.</param>
 /// <param name="sessionId">The session id.</param>
 public Session( Site _site, Guid sessionId )
 {
     getServerStateInfo();
     if( sessionId == Guid.Empty ) {
         /* Ask the DB for a new sessionid*/
         CreateNewSession( false );
     } else {
         Id = sessionId;
         Refresh( false );
         Cart = new Commerce.Cart( this, this.Site );
     }
 }
示例#12
0
 /// <summary>
 /// Initializes a new instance of the <see cref="SiteSections"/> class.
 /// </summary>
 /// <param name="site">The site.</param>
 public SiteSections( Site site )
 {
     using(SqlConnection cn = Site.CreateConnection(true, true)) {
         cn.Open();
         using(SqlCommand cmd = new SqlCommand(@"select s.siteSectionId, siteSectionDetailId,
     name, s.description, URL, data, addDate, active, unique_siteId, s.name, sd.description
     from siteSections s with (nolock)
     inner join siteSectionsDetail sd with (nolock) on s.siteSectionId = sd.siteSectionId
     where unique_siteId = @siteId order by s.siteSectionId, addDate", cn)) {
             ;
             cmd.Parameters.Add("@siteId", SqlDbType.UniqueIdentifier).Value = new Guid(Site.Id.ToString());
             using(SqlDataReader d = cmd.ExecuteReader()) {
                 if(d.HasRows) {
                     Guid currentId = Guid.Empty;
                     SiteSection section = null;
                     while(d.Read()) {
                         if(currentId != d.GetGuid(0)) {
                             currentId = d.GetGuid(0);
                             section = new SiteSection(
                                 d.GetGuid(0),
                                 d.GetString(2),
                                 d.GetString(3),
                                 d.GetString(4)
                             );
                             List.Add(section);
                             /* if this isn't a category add it to the list of URLs to rewrite */
                             section.isCategory = Main.Site.Categories.List.Exists(delegate(Commerce.Category cat) {
                                 return cat.Id == section.Id;
                             });
                         }
                         SiteSectionEntry e = new SiteSectionEntry(
                             d.GetGuid(1),
                             d.GetGuid(0),
                             d.GetString(5),
                             d.GetDateTime(6),
                             d.GetBoolean(7),
                             d.GetString(9),
                             d.GetString(10)
                         );
                         if(section != null) {
                             section.Entries.Add(e);
                         }
                         Entries.Add(e);
                     }
                 }
             }
         }
     }
     return;
 }
示例#13
0
 /// <summary>
 /// Initializes a new instance of the <see cref="SiteDefaults"/> class.
 /// </summary>
 /// <param name="site">The site.</param>
 public SiteDefaults( Site site )
 {
     ( "FUNCTION siteDefaults" ).Debug( 10 );
     MetaKeywords = site.default_meta_keywords;
     MetaDescription = site.default_meta_description;
     PageTitle = site.default_page_title;
     AccessDeniedPage = site.default_access_denied_page;
     EmptyCartPage = site.default_empty_cart_page;
     FormDirectory = site.default_form_detail_directory;
     IntrestPage = site.default_intresting_page;
     ListMode = site.default_listmode;
     OrderBy = site.default_orderby;
     RateId = site.default_rateId;
     RecordsPerPage = site.default_records_per_page;
     AllowPreorders = site.default_new_user_allow_preorder;
     SearchText = site.default_search_text;
     SiteUrl = site.siteAddress;
     Address1 = site.company_address1;
     Address2 = site.company_address2;
     City = site.company_city;
     CareOf = site.company_co;
     Country = site.company_country;
     Email = site.company_email;
     Fax = site.company_fax;
     Name = site.company_name;
     Phone = site.company_phone;
     State = site.company_state;
     Zip = site.company_zip;
     MetaExpires = site.days_meta_expires;
     SiteName = site.friendlySiteName;
     LocalCountry = site.local_country;
     ScannedImagePath = site.scanned_image_path;
     Error404page = site.site_server_404_page;
     Error500page = site.site_server_500_page;
     TestMode = site.test_mode;
     SiteId = Site.Id;
     UseSsl = site.use_ssl;
     PlaceOrderRedirect = site.place_order_redirect;
 }
示例#14
0
 /// <summary>
 /// Initializes a new instance of the <see cref="Reviews"/> class.
 /// </summary>
 /// <param name="site">The site.</param>
 public Reviews(Site site)
 {
     using(SqlConnection cn = Site.CreateConnection(true, true)) {
         cn.Open();
         using(SqlCommand cmd = new SqlCommand("dbo.getReviews", cn)) {
             using(SqlDataReader review_list = cmd.ExecuteReader()) {
                 while(review_list.Read()) {
                     List.Add(new Review(
                         review_list.GetGuid(0),
                         review_list.GetInt32(1),
                         review_list.GetDouble(2),
                         review_list.GetString(3),
                         review_list.GetBoolean(4),
                         review_list.GetDateTime(5),
                         review_list.GetString(6),
                         review_list.GetString(7),
                         site
                     ));
                 }
             }
         }
     }
     return;
 }
示例#15
0
 /// <summary>
 /// Initializes a new instance of the <see cref="Countries"/> class.
 /// </summary>
 /// <param name="site">The site.</param>
 public Countries(Site site)
 {
     using(SqlConnection cn = Site.CreateConnection(true, true)) {
         cn.Open();
         using(SqlCommand cmd = new SqlCommand("dbo.getCountries", cn)) {
             using(SqlDataReader countryList = cmd.ExecuteReader()) {
                 while(countryList.Read()) {
                     List.Add(new Country(countryList.GetString(0)));
                 }
             }
         }
     }
 }
示例#16
0
 /// <summary>
 /// Initializes a new instance of the <see cref="Menus"/> class.
 /// </summary>
 /// <param name="site">The site.</param>
 public Menus( Site site )
 {
     using(SqlConnection cn = Site.CreateConnection(true, true)) {
         cn.Open();
         using(SqlCommand cmd = new SqlCommand("dbo.getMenus", cn)) {
             using(SqlDataReader menu_list = cmd.ExecuteReader()) {
                 string[] column_names = new string[menu_list.FieldCount];
                 for(int x = 0; menu_list.FieldCount > x; x++) {
                     column_names[x] = menu_list.GetName(x);
                 }
                 while(menu_list.Read()) {
                     Object[] raw = new Object[menu_list.FieldCount];
                     menu_list.GetValues(raw);
                     Menu m = new Menu(
                         menu_list.GetGuid(0),
                         menu_list.GetGuid(1),
                         menu_list.GetValue(2).ToString(),
                         menu_list.GetValue(3).ToString(),
                         menu_list.GetBoolean(4),
                         menu_list.GetInt32(5),
                         menu_list.GetInt32(6),
                         menu_list.GetInt32(7),
                         menu_list.GetInt32(8),
                         menu_list.GetValue(9).ToString(),
                         menu_list.GetInt32(10),
                         menu_list.GetValue(11).ToString()
                     );
                     this.Add(m);
                 }
                 BuildHierarchies();
             }
         }
     }
     return;
 }
示例#17
0
 /// <summary>
 /// Initializes a new instance of the <see cref="Blog"/> class.
 /// </summary>
 /// <param name="f_id">The f_id.</param>
 /// <param name="f_categoryName">Name of the f_category.</param>
 /// <param name="f_publicCategory">if set to <c>true</c> [f_public category].</param>
 /// <param name="f_author">The f_author.</param>
 /// <param name="f_showInTicker">if set to <c>true</c> [f_show in ticker].</param>
 /// <param name="f_blogPage">The f_blog page.</param>
 /// <param name="site">The site.</param>
 public Blog(Guid f_id, string f_categoryName, bool f_publicCategory, int f_author, bool f_showInTicker, string f_blogPage, Site site)
 {
     LoadBlog(f_id, f_categoryName, f_publicCategory, f_author, f_showInTicker, f_blogPage, site);
 }
示例#18
0
 /// <summary>
 /// Initializes a new instance of the <see cref="Session"/> class.
 /// </summary>
 /// <param name="_site">The _site.</param>
 public Session( Site _site )
 {
     getServerStateInfo();
     Site = _site;
     string sessionid = null;
     bool newsession = false;
     string cookieName = "";
     cookieName = Site.cookie_name;
     HttpCookie http_cookie_sessionid = null;
     if(HttpContext.Current!=null){
         try {
             http_cookie_sessionid = HttpContext.Current.Request.Cookies[ cookieName ];
         } catch( Exception e ) {
             Exception ex = new Exception( "Cannot aquire cookie from client:" + e.Message );
             http_cookie_sessionid = null;
             throw ex;
         }
     }
     if( http_cookie_sessionid == null ) {
         newsession = true;
     }
     Dictionary<string, object> j = new Dictionary<string, object>();
     if( newsession ) {
         CreateNewSession( true );
         j.Add( "newSession", true );
     } else {
         if( Utilities.GuidPattern.IsMatch( http_cookie_sessionid.Value.ToString() ) ) {
             sessionid = http_cookie_sessionid.Value.ToString();
             Id = new Guid( http_cookie_sessionid.Value.ToString() );
             j.Add( "newSession", false );
         }
     }
     j.Add( "ip", Ip );
     j.Add( "sessionId", Id.ToString() );
     j.Add( "URL", Url + Path );
     j.Add( "userAgent", UserAgent );
     j.Add( "referer", Referer );
     j.Add( "host", Host );
     ( "connection>" + j.ToJson() ).Debug( 10 );
     Refresh();
     return;
 }
示例#19
0
 /// <summary>
 /// Initializes a new instance of the <see cref="Session"/> class.
 /// </summary>
 /// <param name="_site">The _site.</param>
 /// <param name="cn">The cn.</param>
 /// <param name="trns">The TRNS.</param>
 public Session( Site _site, SqlConnection cn, SqlTransaction trns )
 {
     CreateNewSession( false, cn, trns );
 }
示例#20
0
 /// <summary>
 /// Initializes a new instance of the <see cref="Properties"/> class.
 /// </summary>
 /// <param name="site">The site.</param>
 public Properties(Site site)
 {
     using(SqlConnection cn = Site.CreateConnection(true, true)) {
         cn.Open();
         using(SqlCommand cmd = new SqlCommand("dbo.getProperties", cn)) {
             using(SqlDataReader prop_list = cmd.ExecuteReader()) {
                 while(prop_list.Read()) {
                     List.Add(new Property(
                         prop_list.GetGuid(0),
                         prop_list.GetString(1),
                         prop_list.GetString(2),
                         prop_list.GetString(3),
                         prop_list.GetString(4),
                         prop_list.GetInt32(5),
                         (bool)prop_list.GetSqlBoolean(6),
                         prop_list.GetDecimal(7),
                         (bool)prop_list.GetSqlBoolean(8),
                         (bool)prop_list.GetSqlBoolean(9),
                         (bool)prop_list.GetSqlBoolean(10)
                     ));
                 }
             }
         }
     }
     return;
 }
示例#21
0
 /// <summary>
 /// Initializes a new instance of the <see cref="Categories"/> class.
 /// </summary>
 /// <param name="site">The site.</param>
 public Categories( Site site )
 {
     using(SqlConnection cn = Site.CreateConnection(true, true)) {
         cn.Open();
         using(SqlCommand cmd = new SqlCommand("dbo.fullCategoryList", cn)) {
             using(SqlDataReader categories = cmd.ExecuteReader()) {
                 while(categories.Read()) {
                     if(CurrentId != categories.GetGuid(categories.GetOrdinal("categoryId"))) {
                         Cat = new Category(
                             categories.GetString(categories.GetOrdinal("categoryName")),
                             categories.GetGuid(categories.GetOrdinal("categoryId")),
                             categories.GetBoolean(categories.GetOrdinal("enabled"))
                         );
                         CurrentId = Cat.Id;
                         List.Add(Cat);
                     }
                     I = site.Item(categories.GetString(categories.GetOrdinal("itemNumber")));
                     if(I != null) {
                         if(!categories.IsDBNull(categories.GetOrdinal("listOrder"))) {
                             if(I.CategoryOrder == null) {
                                 I.CategoryOrder = new Dictionary<Guid, int>();
                             }
                             if(!I.CategoryOrder.ContainsKey(Cat.Id)) {
                                 I.CategoryOrder.Add(Cat.Id, categories.GetInt32(categories.GetOrdinal("listOrder")));
                             }
                         };
                         if(!Cat.Items.Contains(I)) {
                             Cat.Items.Add(I);
                         }
                     }
                 }
             }
         }
     }
 }
示例#22
0
 /// <summary>
 /// Initializes a new instance of the <see cref="Replies"/> class.
 /// </summary>
 /// <param name="site">The site.</param>
 public Replies(Site site)
 {
     this.Refresh(site);
 }
示例#23
0
 /// <summary>
 /// Initializes a new instance of the <see cref="ZipToZones"/> class.
 /// </summary>
 /// <param name="site">The site.</param>
 public ZipToZones(Site site)
 {
     List = new List<ZipToZone>();
     using(SqlConnection cn = Site.CreateConnection(true, true)) {
         cn.Open();
         using(SqlCommand cmd = new SqlCommand("dbo.getZipToZones", cn)) {
             using(SqlDataReader zoneList = cmd.ExecuteReader()) {
                 while(zoneList.Read()) {
                     List.Add(new ZipToZone(
                         zoneList.GetGuid(0),
                         zoneList.GetInt32(1),
                         zoneList.GetInt32(2),
                         zoneList.GetInt32(3),
                         zoneList.GetInt32(4),
                         zoneList.GetInt32(5),
                         zoneList.GetInt32(6)
                     ));
                 }
             }
         }
     }
 }
示例#24
0
 /// <summary>
 /// Refreshes the list of replies on the site.
 /// </summary>
 /// <param name="site">The site.</param>
 public void Refresh(Site site)
 {
     using(SqlConnection cn = Site.CreateConnection(true, true)) {
         cn.Open();
         SqlCommand cmd = new SqlCommand(@"select replyId, email, subject, rating, userId, comment, addedOn, parentId, reference, disabled, approves, disapproves,
     flaggedInappropriate, flaggedOk from replies with (nolock) order by addedOn asc", cn);
         int counter = 0;
         using(SqlDataReader d = cmd.ExecuteReader()) {
             while(d.Read()) {
                 List.Add(
                     new Reply(
                         d.GetGuid(0),
                         d.GetString(1),
                         d.GetString(2),
                         d.GetInt32(3),
                         d.GetInt32(4),
                         d.GetString(5),
                         d.GetDateTime(6),
                         d.GetGuid(7),
                         d.GetString(8),
                         d.GetBoolean(9),
                         d.GetInt32(10),
                         d.GetInt32(11),
                         d.GetInt32(12),
                         d.GetBoolean(13),
                         site
                     )
                 );
                 counter++;
             }
             BuildReplyHierarchy();
         }
     }
 }
示例#25
0
 /// <summary>
 /// Initializes a new instance of the <see cref="Galleries"/> class.
 /// </summary>
 /// <param name="site">The site.</param>
 public Galleries(Site site)
 {
     using(SqlConnection cn = Site.CreateConnection(true, true)) {
         cn.Open();
         using(SqlCommand cmd = new SqlCommand("dbo.getGalleries", cn)) {
             Guid currentId = Guid.NewGuid();
             using(SqlDataReader gallery_list = cmd.ExecuteReader()) {
                 while(gallery_list.Read()) {
                     if(currentId != gallery_list.GetGuid(28)) {
                         currentId = gallery_list.GetGuid(28);
                         G = new Gallery(
                             gallery_list.GetGuid(28),
                             gallery_list.GetString(29),
                             gallery_list.GetInt32(30),
                             gallery_list.GetInt32(31),
                             gallery_list.GetInt32(32),
                             gallery_list.GetGuid(33),
                             gallery_list.GetGuid(34),
                             gallery_list.GetGuid(35),
                             gallery_list.GetGuid(36),
                             gallery_list.GetGuid(37),
                             gallery_list.GetBoolean(38),
                             gallery_list.GetString(39),
                             gallery_list.GetInt32(40),
                             gallery_list.GetString(41)
                         );
                         List.Add(G);
                     }
                     G.Add(new GalleryImage(
                         gallery_list.GetGuid(0),
                         gallery_list.GetString(1),
                         gallery_list.GetString(2),
                         gallery_list.GetString(3),
                         gallery_list.GetInt32(4),
                         gallery_list.GetInt32(5),
                         gallery_list.GetInt32(6),
                         gallery_list.GetInt32(7),
                         gallery_list.GetInt32(8),
                         gallery_list.GetInt32(9),
                         gallery_list.GetString(10),
                         gallery_list.GetString(11),
                         gallery_list.GetBoolean(12),
                         gallery_list.GetInt32(13),
                         gallery_list.GetInt32(14),
                         gallery_list.GetInt32(15),
                         gallery_list.GetInt32(16),
                         gallery_list.GetInt32(17),
                         gallery_list.GetInt32(18),
                         gallery_list.GetInt32(19),
                         gallery_list.GetDateTime(20),
                         gallery_list.GetInt32(21),
                         gallery_list.GetInt32(22),
                         gallery_list.GetInt32(23),
                         gallery_list.GetInt32(24),
                         gallery_list.GetString(25),
                         gallery_list.GetString(26),
                         gallery_list.GetString(27),
                         gallery_list.GetInt32(42),
                         gallery_list.GetInt32(43),
                         gallery_list.GetString(29),
                         gallery_list.GetGuid(28)
                     ));
                 }
             }
         }
     }
 }
示例#26
0
 /// <summary>
 /// Loads the Blog.
 /// </summary>
 /// <param name="f_id">The f_id.</param>
 /// <param name="f_categoryName">Name of the f_category.</param>
 /// <param name="f_publicCategory">if set to <c>true</c> [f_public category].</param>
 /// <param name="f_author">The f_author.</param>
 /// <param name="f_showInTicker">if set to <c>true</c> [f_show in ticker].</param>
 /// <param name="f_blogPage">The f_blog page.</param>
 /// <param name="site">The site.</param>
 private void LoadBlog(Guid f_id, string f_categoryName, bool f_publicCategory, int f_author, bool f_showInTicker, string f_blogPage, Site site)
 {
     Id = f_id;
     CategoryName = f_categoryName;
     PublicCategory = f_publicCategory;
     AuthorId = f_author;
     Author = Commerce.User.All.Find(delegate(Commerce.User u) {
         return u.UserId == f_author;
     });
     if(Author == null) {
         Author = site.NullUser;
     }
     ShowInTicker = f_showInTicker;
     BlogPage = f_blogPage;
 }
示例#27
0
 /// <summary>
 /// Initializes a new instance of the <see cref="SiteImagePlaceholders"/> class.
 /// </summary>
 /// <param name="site">The site.</param>
 public SiteImagePlaceholders( Site site )
 {
     using(SqlConnection cn = Site.CreateConnection(true, true)) {
         cn.Open();
         using(SqlCommand cmd = new SqlCommand(@"select unique_siteId, m_imagingTemplate,c_imagingTemplate,f_imagingTemplate,t_imagingTemplate,
     a_imagingTemplate,x_imagingTemplate,y_imagingTemplate,z_imagingTemplate,b_imagingTemplate,d_imagingTemplate, siteaddress
     from site_configuration", cn)) {
             using(SqlDataReader r = cmd.ExecuteReader()) {
                 List = new List<SiteImagePlaceholder>();
                 while(r.Read()) {
                     List.Add(new SiteImagePlaceholder(
                         r.GetGuid(0),
                         r.GetGuid(1),
                         r.GetGuid(2),
                         r.GetGuid(3),
                         r.GetGuid(4),
                         r.GetGuid(5),
                         r.GetGuid(6),
                         r.GetGuid(7),
                         r.GetGuid(8),
                         r.GetGuid(9),
                         r.GetGuid(10),
                         r.GetString(11)
                     ));
                 }
             }
         }
     }
 }
示例#28
0
 /// <summary>
 /// Initializes a new instance of the <see cref="FlagTypes"/> class.
 /// </summary>
 /// <param name="site">The site to read from.</param>
 public FlagTypes( Site site )
 {
     using(SqlConnection cn = Site.CreateConnection(true, true)) {
         cn.Open();
         using(SqlCommand cmd = new SqlCommand("dbo.getFlagTypes", cn)) {
             using(SqlDataReader r = cmd.ExecuteReader()) {
                 while(r.Read()) {
                     Flag f = new Flag(
                         r.GetInt32(0) /*flagTypeId*/,
                         r.GetString(1) /*flagTypeName*/,
                         r.GetString(2) /*flagTypeDesc*/,
                         r.GetInt32(3) /*userLevel*/,
                         r.GetBoolean(4) /*shipmentFlag*/,
                         r.GetBoolean(5) /*userFlag*/,
                         r.GetBoolean(6) /*orderFlag*/,
                         r.GetBoolean(7) /*lineFlag*/,
                         r.GetBoolean(8) /*lineDetailFlag*/,
                         r.GetString(9) /*customerReadable*/,
                         r.GetInt32(10) /*agingDaysStatus1*/,
                         r.GetInt32(11) /*agingDaysStatus2*/,
                         r.GetInt32(12) /*agingDaysStatus3*/,
                         r.GetInt32(13) /*agingDaysStatus4*/,
                         r.GetInt32(14) /*agingDaysStatus5*/,
                         r.GetBoolean(15) /*showInProductionAgingReport*/,
                         r.GetInt32(16) /*productionAgingReportOrder*/,
                         r.GetInt32(17) /*cannotOccurBeforeFlagId*/,
                         r.GetInt32(18) /*cannotOccurAfterFlagId*/,
                         r.GetBoolean(19) /*purchaseOrderFlag*/,
                         r.GetBoolean(20) /*purchaseShipmentFlag*/,
                         r.GetBoolean(21) /*purchaseLineFlag*/,
                         r.GetBoolean(22) /*createsNewPurchaseOrder*/,
                         r.GetBoolean(23) /*finishedPurchaseOrderFlag*/,
                         r.GetString(24) /*color*/
                     );
                     List.Add(f);
                 }
             }
         }
     }
 }
示例#29
0
 /// <summary>
 /// Initializes a new instance of the <see cref="Users"/> class.
 /// </summary>
 /// <param name="site">The site.</param>
 public Users( Site site )
 {
     using(SqlConnection cn = Site.CreateConnection(true, true)) {
         cn.Open();
         using(SqlCommand cmd = new SqlCommand("dbo.getUsers @userId", cn)) {
             cmd.Parameters.Add("@userId", SqlDbType.Int).Value = -1;
             using(SqlDataReader user_list = cmd.ExecuteReader()) {
                 while(user_list.Read()) {
                     try {
                         List.Add(GetUserFromDataReader(user_list));
                     } catch(Exception e) {
                         (e.Message).Debug(4);
                         int userId;
                         try {
                             userId = user_list.GetInt32(2);
                         } catch(Exception ex) {
                             (ex.Message).Debug(4);
                             userId = -1;
                         }
                         String.Format("Class users thew an exception on instantiation ==>{0}", userId).Debug(1);
                     }
                 }
             }
         }
     }
     return;
 }
示例#30
0
 /// <summary>
 /// Initializes a new instance of the <see cref="BlogEntry"/> class.
 /// </summary>
 /// <param name="f_id">The f_id.</param>
 /// <param name="f_subject">The f_subject.</param>
 /// <param name="f_message">The f_message.</param>
 /// <param name="f_comments">The f_comments.</param>
 /// <param name="f_tags">The f_tags.</param>
 /// <param name="f_editor">The f_editor.</param>
 /// <param name="f_author">The f_author.</param>
 /// <param name="f_addDate">The f_add date.</param>
 /// <param name="f_dateChanged">The f_date changed.</param>
 /// <param name="f_lastEditor">The f_last editor.</param>
 /// <param name="f_annotations">The f_annotations.</param>
 /// <param name="f_enabled">if set to <c>true</c> [f_enabled].</param>
 /// <param name="f_auditComments">if set to <c>true</c> [f_audit comments].</param>
 /// <param name="f_allowComments">if set to <c>true</c> [f_allow comments].</param>
 /// <param name="f_emailUpdates">if set to <c>true</c> [f_email updates].</param>
 /// <param name="f_blogImage">The f_blog image.</param>
 /// <param name="f_publicBlog">if set to <c>true</c> [f_public Blog].</param>
 /// <param name="f_listOrder">The f_list order.</param>
 /// <param name="f_archive">if set to <c>true</c> [f_archive].</param>
 /// <param name="f_galleryId">The f_gallery id.</param>
 /// <param name="_blog">The _blog.</param>
 /// <param name="site">The site.</param>
 public BlogEntry(Guid f_id, string f_subject, string f_message, string f_comments, string f_tags, int f_editor, int f_author, DateTime f_addDate,
     DateTime f_dateChanged, int f_lastEditor, string f_annotations, bool f_enabled, bool f_auditComments, bool f_allowComments,
     bool f_emailUpdates, string f_blogImage, bool f_publicBlog, int f_listOrder, bool f_archive, Guid f_galleryId, Blog _blog, Site site)
 {
     Id = f_id;
     Subject = f_subject.Trim();
     Message = f_message;
     Comments = f_comments;
     Tags = f_tags.Trim();
     EditorId = f_editor;
     AuthorId = f_author;
     AddDate = f_addDate;
     DateChanged = f_dateChanged;
     LastEditor = f_lastEditor;
     Annotations = f_annotations;
     Enabled = f_enabled;
     AuditComments = f_auditComments;
     AllowComments = f_allowComments;
     EmailUpdates = f_emailUpdates;
     BlogImage = f_blogImage;
     PublicBlog = f_publicBlog;
     ListOrder = f_listOrder;
     Archive = f_archive;
     Blog = _blog;
     GalleryId = f_galleryId;
     Gallery = BlogPlugin.Galleries.List.Find(delegate(Gallery gal) {
         return gal.Id == GalleryId;
     });
     Replies = Commerce.Reply.All.FindAll(delegate(Rendition.Commerce.Reply reply) {
         return (reply.ParentId == f_id)
         && ((reply.FlaggedInappropriate < site.inappropriateHideThreshold) || reply.FlaggedOk);
     });
     Author = Commerce.User.All.Find(delegate(Commerce.User u) {
         return u.UserId == f_author;
     });
     Editor = Commerce.User.All.Find(delegate(Commerce.User u) {
         return u.UserId == f_editor;
     });
     Introduction = Message;
     if(Message.Contains("<h6")) {
         HasIntroduction = true;
         string i = Message.Substring(0, Message.IndexOf("<h6") - 4);
         i = Regex.Replace(i, "(<h6>)|(</h6>)", "", RegexOptions.IgnoreCase);
         Introduction = i;
         Message = Regex.Replace(Message, "(<h6>)|(</h6>)", "", RegexOptions.IgnoreCase);
     }
 }