private static GiftCertificate GetFromReader(SqlDataReader reader) { return(new GiftCertificate { CertificateId = SQLDataHelper.GetInt(reader, "CertificateID"), CertificateCode = SQLDataHelper.GetString(reader, "CertificateCode"), FromName = SQLDataHelper.GetString(reader, "FromName"), ToName = SQLDataHelper.GetString(reader, "ToName"), OrderNumber = SQLDataHelper.GetString(reader, "OrderNumber"), Sum = SQLDataHelper.GetDecimal(reader, "Sum"), Paid = SQLDataHelper.GetBoolean(reader, "Paid"), Used = SQLDataHelper.GetBoolean(reader, "Used"), Enable = SQLDataHelper.GetBoolean(reader, "Enable"), Type = (CertificatePostType)(SQLDataHelper.GetInt(reader, "Type")), CertificateMessage = SQLDataHelper.GetString(reader, "Message"), Email = SQLDataHelper.GetString(reader, "Email"), Country = SQLDataHelper.GetString(reader, "Country"), Zone = SQLDataHelper.GetString(reader, "Zone"), City = SQLDataHelper.GetString(reader, "City"), Zip = SQLDataHelper.GetString(reader, "Zip"), Address = SQLDataHelper.GetString(reader, "Address"), CreationDate = SQLDataHelper.GetDateTime(reader, "CreationDate"), CurrencyCode = SQLDataHelper.GetString(reader, "CurrencyCode"), CurrencyValue = SQLDataHelper.GetDecimal(reader, "CurrencyValue"), FromEmail = SQLDataHelper.GetString(reader, "FromEmail") }); }
private static SiteMapData GetSiteMapDataFromReader(SqlDataReader reader) { var prefUrl = SettingsMain.SiteUrl; prefUrl = prefUrl.Contains("http://") ? prefUrl : "http://" + prefUrl; var siteMapData = new SiteMapData { Changefreq = DefaultChangeFreq, Priority = DefaultPriority }; if (reader.FieldCount == 1) { siteMapData.Loc = prefUrl + UrlService.GetLink(ParamType.Category, SQLDataHelper.GetString(reader, "UrlPath"), SQLDataHelper.GetInt(reader, "CategoryId")); siteMapData.Lastmod = DateTime.Now; } else if (reader.GetName(0).ToLower() == "productid") { siteMapData.Loc = prefUrl + UrlService.GetLink(ParamType.Product, SQLDataHelper.GetString(reader, "UrlPath"), SQLDataHelper.GetInt(reader, "Productid")); siteMapData.Lastmod = SQLDataHelper.GetDateTime(reader, "DateModified"); } else if (reader.GetName(0).ToLower() == "newsid") { siteMapData.Loc = prefUrl + UrlService.GetLink(ParamType.News, SQLDataHelper.GetString(reader, "UrlPath"), SQLDataHelper.GetInt(reader, "NewsID")); siteMapData.Lastmod = SQLDataHelper.GetDateTime(reader, "AddingDate"); } else if (reader.GetName(0).ToLower() == "staticpageid") { siteMapData.Loc = prefUrl + UrlService.GetLink(ParamType.StaticPage, SQLDataHelper.GetString(reader, "UrlPath"), SQLDataHelper.GetInt(reader, "StaticPageID")); siteMapData.Lastmod = SQLDataHelper.GetDateTime(reader, "ModifyDate"); } return(siteMapData); }
private static OrderConfirmation GetFromReader(SqlDataReader reader) { return(new OrderConfirmation { CustomerId = SQLDataHelper.GetGuid(reader, "CustomerId"), OrderConfirmationData = JsonConvert.DeserializeObject <OrderConfirmationData>(SQLDataHelper.GetString(reader, "OrderConfirmationData")), LastUpdate = SQLDataHelper.GetDateTime(reader, "LastUpdate", DateTime.MinValue) }); }
private void SaveNews() { MsgErr(true); // Clean try { var news = new NewsItem { NewsID = NewsId, AddingDate = SQLDataHelper.GetDateTime(txtDate.Text + " " + txtTime.Text), Title = txtTitle.Text, //Picture = file, TextToPublication = FCKTextToPublication.Text, TextAnnotation = CKEditorControlAnnatation.Text, TextToEmail = string.Empty,//rbNo.Checked ? String.Empty : FCKTextToEmail.Text, NewsCategoryID = dboNewsCategory.SelectedValue.TryParseInt(), ShowOnMainPage = chkOnMainPage.Checked, UrlPath = txtStringID.Text, //MetaId = SQLDataHelper.GetInt(hfMetaId.Text), Meta = new MetaInfo { ObjId = NewsId, Title = txtHeadTitle.Text, H1 = txtH1.Text, MetaKeywords = txtMetaKeys.Text, MetaDescription = txtMetaDescription.Text, Type = MetaType.News } }; news.UrlPath = txtStringID.Text; NewsService.UpdateNews(news); if (FileUpload1.HasFile) { if (!FileHelpers.CheckFileExtension(FileUpload1.FileName, FileHelpers.eAdvantShopFileTypes.Image)) { MsgErr(Resource.Admin_ErrorMessage_WrongImageExtension); return; } PhotoService.DeletePhotos(NewsId, PhotoType.News); var tempName = PhotoService.AddPhoto(new Photo(0, NewsId, PhotoType.News) { OriginName = FileUpload1.FileName }); if (!string.IsNullOrWhiteSpace(tempName)) { using (var image = Image.FromStream(FileUpload1.FileContent)) FileHelpers.SaveResizePhotoFile(FoldersHelper.GetPathAbsolut(FolderType.News, tempName), SettingsPictureSize.NewsImageWidth, SettingsPictureSize.NewsImageHeight, image); } } } catch (Exception ex) { MsgErr(ex.Message + " SaveNews main"); Debug.LogError(ex); } }
/// <summary> /// Get Module From SQLDataReader /// </summary> /// <param name="reader"></param> /// <returns></returns> private static Module GetModuleFromReader(SqlDataReader reader) { return(new Module { StringId = SQLDataHelper.GetString(reader, "ModuleStringID"), IsInstall = SQLDataHelper.GetBoolean(reader, "IsInstall"), DateAdded = SQLDataHelper.GetDateTime(reader, "DateAdded"), DateModified = SQLDataHelper.GetDateTime(reader, "DateModified"), Version = SQLDataHelper.GetString(reader, "Version") }); }
public static OfferList GetOfferList(int offerListId) { return(SQLDataAccess.ExecuteReadOne <OfferList>("SELECT * FROM [Catalog].[OffersList] WHERE [OfferListId] = @OfferListID", CommandType.Text, reader => new OfferList { OfferListID = SQLDataHelper.GetInt(reader, "OfferListID"), StartDate = SQLDataHelper.GetDateTime(reader, "StartDate"), EndDate = SQLDataHelper.GetDateTime(reader, "EndDate"), Name = SQLDataHelper.GetString(reader, "Name") }, new SqlParameter("@OfferListID", offerListId))); }
private static StaticBlock GetPagePartFromReader(SqlDataReader reader) { return(new StaticBlock(SQLDataHelper.GetInt(reader, "StaticBlockID")) { Key = SQLDataHelper.GetString(reader, "key"), InnerName = SQLDataHelper.GetString(reader, "InnerName"), Content = SQLDataHelper.GetString(reader, "Content"), Added = SQLDataHelper.GetDateTime(reader, "Added"), Modified = SQLDataHelper.GetDateTime(reader, "Modified"), Enabled = SQLDataHelper.GetBoolean(reader, "Enabled") }); }
/// <summary> /// /// </summary> /// <param name="reader"></param> /// <returns></returns> public static Subscription GetSubscriptionFromReader(SqlDataReader reader) { return(new Subscription { Id = SQLDataHelper.GetInt(reader, "Id"), Email = SQLDataHelper.GetString(reader, "Email"), Subscribe = SQLDataHelper.GetBoolean(reader, "Subscribe"), SubscribeDate = SQLDataHelper.GetDateTime(reader, "SubscribeDate"), UnsubscribeDate = SQLDataHelper.GetDateTime(reader, "UnsubscribeDate"), UnsubscribeReason = SQLDataHelper.GetString(reader, "UnsubscribeReason") }); }
private void CreateNews() { MsgErr(true); // Clean try { //const string format = "yyyy-MM-dd"; var news = new NewsItem { AddingDate = SQLDataHelper.GetDateTime(txtDate.Text + " " + txtTime.Text), Title = txtTitle.Text, //Picture = file, TextToPublication = FCKTextToPublication.Text, TextAnnotation = CKEditorControlAnnatation.Text, TextToEmail = String.Empty, NewsCategoryID = dboNewsCategory.SelectedValue.TryParseInt(), ShowOnMainPage = chkOnMainPage.Checked, UrlPath = txtStringID.Text, Meta = new MetaInfo { MetaDescription = txtMetaDescription.Text, Title = txtHeadTitle.Text, MetaKeywords = txtMetaKeys.Text, H1 = txtH1.Text, Type = MetaType.News } }; var id = NewsService.InsertNews(news); if (FileUpload1.HasFile) { var tempName = PhotoService.AddPhoto(new Photo(0, id, PhotoType.News) { OriginName = FileUpload1.FileName }); if (!string.IsNullOrWhiteSpace(tempName)) { using (Image image = Image.FromStream(FileUpload1.FileContent)) FileHelpers.SaveResizePhotoFile(FoldersHelper.GetPathAbsolut(FolderType.News, tempName), SettingsPictureSize.NewsImageWidth, SettingsPictureSize.NewsImageHeight, image); } } if (lblError.Visible == false) { txtTitle.Text = string.Empty; FCKTextToPublication.Text = string.Empty; } // close } catch (Exception ex) { MsgErr(ex.Message + " CreateNews main"); Debug.LogError(ex); } }
private static AbandonedCart GetOrderConfirmationFromReader(SqlDataReader reader) { return(new AbandonedCart { CustomerId = SQLDataHelper.GetGuid(reader, "CustomerId"), OrderConfirmationData = JsonConvert.DeserializeObject <OrderConfirmationData>(SQLDataHelper.GetString(reader, "OrderConfirmationData")), LastUpdate = SQLDataHelper.GetDateTime(reader, "LastUpdate", DateTime.MinValue), SendingCount = SQLDataHelper.GetInt(reader, "SendingCount"), SendingDate = SQLDataHelper.GetNullableDateTime(reader, "SendingDate") }); }
private static CallbackCustomer GetCallbackCustomerFromReader(SqlDataReader reader) { return(new CallbackCustomer { ID = SQLDataHelper.GetInt(reader, "ID"), Name = SQLDataHelper.GetString(reader, "Name"), Phone = SQLDataHelper.GetString(reader, "Phone"), DateAdded = SQLDataHelper.GetDateTime(reader, "DateAdded"), Comment = SQLDataHelper.GetString(reader, "Comment"), AdminComment = SQLDataHelper.GetString(reader, "AdminComment"), Processed = SQLDataHelper.GetBoolean(reader, "Processed"), }); }
public static ICollection <ApplicationLogEntry> GetAppRestartLogData() { List <ApplicationLogEntry> result = SQLDataAccess.ExecuteReadList <ApplicationLogEntry>( "SELECT TOP (100) * FROM [Internal].[AppRestartLog] ORDER BY [RestartDate] DESC;", CommandType.Text, reader => new ApplicationLogEntry { EntryId = SQLDataHelper.GetInt(reader, "ID"), EntryDate = SQLDataHelper.GetDateTime(reader, "RestartDate"), ServerName = SQLDataHelper.GetString(reader, "ServerName") }); return(result); }
/// <summary> /// Метод загружает данные о просмотрах для пользователя из полученного SqlReader /// </summary> /// <param name="reader"></param> /// <returns></returns> /// <remarks></remarks> private static RecentlyViewRecord ReadViewRecordForReader(SqlDataReader reader) { return(new RecentlyViewRecord { ProductID = SQLDataHelper.GetInt(reader["ProductID"]), ViewTime = SQLDataHelper.GetDateTime(reader["ViewDate"]), ImgPath = SQLDataHelper.GetString(reader["Photo"]), Name = SQLDataHelper.GetString(reader["Name"]), Price = SQLDataHelper.GetDecimal(reader["Price"]), Discount = SQLDataHelper.GetDecimal(reader["Discount"]), UrlPath = SQLDataHelper.GetString(reader["UrlPath"]) }); }
public static ShippingCache Get(int shippingMethodId, int paramHash) { return(SQLDataAccess.ExecuteReadOne <ShippingCache>("Select * from [Order].ShippingCache where ShippingMethodID=@ShippingMethodID and ParamHash=@ParamHash", CommandType.Text, reader => new ShippingCache { ShippingMethodId = SQLDataHelper.GetInt(reader, "ShippingMethodID"), ParamHash = SQLDataHelper.GetInt(reader, "ParamHash"), ServerResponse = SQLDataHelper.GetString(reader, "Options"), Created = SQLDataHelper.GetDateTime(reader, "Created"), }, new SqlParameter("@ShippingMethodID", shippingMethodId), new SqlParameter("@ParamHash", paramHash))); }
public static List <AbandonedCartLetter> GetLetters(Guid customerId) { return (ModulesRepository.ModuleExecuteReadList( "Select * From [Module].[AbandonedCartLetter] Where CustomerId = @CustomerId", CommandType.Text, reader => new AbandonedCartLetter() { CustomerId = SQLDataHelper.GetGuid(reader, "CustomerId"), TemplateId = SQLDataHelper.GetInt(reader, "TemplateId"), Email = SQLDataHelper.GetString(reader, "Email"), SendingDate = SQLDataHelper.GetDateTime(reader, "SendingDate") }, new SqlParameter("CustomerId", customerId))); }
public static List <AbandonedCartLetter> GetAllLetters() { var list = ModulesRepository.ModuleExecuteReadList( "Select * From [Module].[AbandonedCartLetter]", CommandType.Text, reader => new AbandonedCartLetter() { CustomerId = SQLDataHelper.GetGuid(reader, "CustomerId"), TemplateId = SQLDataHelper.GetInt(reader, "TemplateId"), Email = SQLDataHelper.GetString(reader, "Email"), SendingDate = SQLDataHelper.GetDateTime(reader, "SendingDate") }); return(list ?? new List <AbandonedCartLetter>()); }
private static Answer GetAnswerFromReader(SqlDataReader reader) { return(new Answer { AnswerId = SQLDataHelper.GetInt(reader["AnswerID"]), FkidTheme = SQLDataHelper.GetInt(reader["FKIDTheme"]), Name = SQLDataHelper.GetString(reader["Name"]).Trim(), CountVoice = SQLDataHelper.GetInt(reader["CountVoice"]), Sort = SQLDataHelper.GetInt(reader["Sort"]), IsVisible = SQLDataHelper.GetBoolean(reader["IsVisible"]), DateAdded = SQLDataHelper.GetDateTime(reader["DateAdded"]), DateModify = SQLDataHelper.GetDateTime(reader["DateModify"]) }); }
private static ShoppingCartItem GetFromReader(SqlDataReader reader) { return(new ShoppingCartItem { ShoppingCartItemId = SQLDataHelper.GetInt(reader, "ShoppingCartItemId"), ShoppingCartType = (ShoppingCartType)SQLDataHelper.GetInt(reader, "ShoppingCartType"), OfferId = SQLDataHelper.GetInt(reader, "OfferID"), CustomerId = SQLDataHelper.GetGuid(reader, "CustomerId"), AttributesXml = SQLDataHelper.GetString(reader, "AttributesXml"), Amount = SQLDataHelper.GetFloat(reader, "Amount"), CreatedOn = SQLDataHelper.GetDateTime(reader, "CreatedOn"), UpdatedOn = SQLDataHelper.GetDateTime(reader, "UpdatedOn"), }); }
public static Photo GetPhotoFromReader(SqlDataReader reader) { return(new Photo( SQLDataHelper.GetInt(reader, "PhotoId"), SQLDataHelper.GetInt(reader, "ObjId"), (PhotoType)Enum.Parse(typeof(PhotoType), SQLDataHelper.GetString(reader, "Type"), true)) { Description = SQLDataHelper.GetString(reader, "Description"), ModifiedDate = SQLDataHelper.GetDateTime(reader, "ModifiedDate"), PhotoName = SQLDataHelper.GetString(reader, "PhotoName"), OriginName = SQLDataHelper.GetString(reader, "OriginName"), PhotoSortOrder = SQLDataHelper.GetInt(reader, "PhotoSortOrder"), Main = SQLDataHelper.GetBoolean(reader, "Main"), }); }
private static MailFormat GetMailFormatFromReader(SqlDataReader reader) { return(new MailFormat { MailFormatID = SQLDataHelper.GetInt(reader, "MailFormatID"), FormatName = SQLDataHelper.GetString(reader, "FormatName"), FormatSubject = SQLDataHelper.GetString(reader, "FormatSubject"), FormatText = SQLDataHelper.GetString(reader, "FormatText"), FormatType = (MailType)SQLDataHelper.GetInt(reader, "FormatType"), SortOrder = SQLDataHelper.GetInt(reader, "SortOrder"), Enable = SQLDataHelper.GetBoolean(reader, "Enable"), AddDate = SQLDataHelper.GetDateTime(reader, "AddDate"), ModifyDate = SQLDataHelper.GetDateTime(reader, "ModifyDate") }); }
/// <summary> /// /// </summary> /// <param name="reader"></param> /// <returns></returns> private static VoiceTheme GetVoiceThemeFromReader(SqlDataReader reader) { return(new VoiceTheme { VoiceThemeId = SQLDataHelper.GetInt(reader["VoiceThemeID"]), PsyId = SQLDataHelper.GetInt(reader["PSYID"]), Name = SQLDataHelper.GetString(reader["Name"]).Trim(), IsHaveNullVoice = SQLDataHelper.GetBoolean(reader["IsHaveNullVoice"]), IsDefault = SQLDataHelper.GetBoolean(reader["IsDefault"]), IsClose = SQLDataHelper.GetBoolean(reader["IsClose"]), DateAdded = SQLDataHelper.GetDateTime(reader["DateAdded"]), DateModify = SQLDataHelper.GetDateTime(reader["DateModify"]), CountVoice = SQLDataHelper.GetInt(reader["CountVoice"]) }); }
private static StoreReview GetStoreReviewFromReader(SqlDataReader reader) { return(new StoreReview { Id = SQLDataHelper.GetInt(reader, "ID"), ParentId = SQLDataHelper.GetInt(reader, "ParentID"), Rate = SQLDataHelper.GetInt(reader, "Rate"), Review = SQLDataHelper.GetString(reader, "Review"), ReviewerEmail = SQLDataHelper.GetString(reader, "ReviewerEmail"), ReviewerName = SQLDataHelper.GetString(reader, "ReviewerName"), DateAdded = SQLDataHelper.GetDateTime(reader, "DateAdded"), Moderated = SQLDataHelper.GetBoolean(reader, "Moderated"), HasChild = SQLDataHelper.GetInt(reader, "ChildsCount") > 0 }); }
private static Review GetFromReader(SqlDataReader reader) { return new Review { ReviewId = SQLDataHelper.GetInt(reader, "ReviewId"), ParentId = SQLDataHelper.GetNullableInt(reader, "ParentId") ?? 0, EntityId = SQLDataHelper.GetInt(reader, "EntityId"), CustomerId = SQLDataHelper.GetGuid(reader, "CustomerId"), Name = SQLDataHelper.GetString(reader, "Name"), Email = SQLDataHelper.GetString(reader, "Email"), Text = SQLDataHelper.GetString(reader, "Text"), Checked = SQLDataHelper.GetBoolean(reader, "Checked"), AddDate = SQLDataHelper.GetDateTime(reader, "AddDate"), Ip = SQLDataHelper.GetString(reader, "IP") }; }
private static StaticPage GetStaticPageFromReader(SqlDataReader reader) { return(new StaticPage { StaticPageId = SQLDataHelper.GetInt(reader, "StaticPageID"), PageName = SQLDataHelper.GetString(reader, "PageName"), PageText = SQLDataHelper.GetString(reader, "PageText"), SortOrder = SQLDataHelper.GetInt(reader, "SortOrder"), AddDate = SQLDataHelper.GetDateTime(reader, "AddDate"), ModifyDate = SQLDataHelper.GetDateTime(reader, "ModifyDate"), IndexAtSiteMap = SQLDataHelper.GetBoolean(reader, "IndexAtSiteMap"), Enabled = SQLDataHelper.GetBoolean(reader, "Enabled"), ParentId = SQLDataHelper.GetInt(reader, "ParentID", 0), UrlPath = SQLDataHelper.GetString(reader, "UrlPath") }); }
private static NewsItem GetNewsFromReader(SqlDataReader reader) { return(new NewsItem { NewsID = SQLDataHelper.GetInt(reader, "NewsID"), NewsCategoryID = SQLDataHelper.GetInt(reader, "NewsCategoryID"), Title = SQLDataHelper.GetString(reader, "Title"), //Picture = SQLDataHelper.GetString(reader, "Picture"), TextToPublication = SQLDataHelper.GetString(reader, "TextToPublication"), TextToEmail = SQLDataHelper.GetString(reader, "TextToEmail"), TextAnnotation = SQLDataHelper.GetString(reader, "TextAnnotation"), ShowOnMainPage = SQLDataHelper.GetBoolean(reader, "ShowOnMainPage"), AddingDate = SQLDataHelper.GetDateTime(reader, "AddingDate"), UrlPath = SQLDataHelper.GetString(reader, "UrlPath") }); }
private static Coupon GetFromReader(SqlDataReader reader) { return(new Coupon { CouponID = SQLDataHelper.GetInt(reader, "CouponID"), Code = SQLDataHelper.GetString(reader, "Code"), Type = (CouponType)SQLDataHelper.GetInt(reader, "Type"), Value = SQLDataHelper.GetFloat(reader, "Value"), AddingDate = SQLDataHelper.GetDateTime(reader, "AddingDate"), ExpirationDate = SQLDataHelper.GetNullableDateTime(reader, "ExpirationDate"), PossibleUses = SQLDataHelper.GetInt(reader, "PossibleUses"), ActualUses = SQLDataHelper.GetInt(reader, "ActualUses"), Enabled = SQLDataHelper.GetBoolean(reader, "Enabled"), MinimalOrderPrice = SQLDataHelper.GetFloat(reader, "MinimalOrderPrice") }); }
private static SaasData GetSaasDataFromReader(SqlDataReader reader) { return(new SaasData { Name = SQLDataHelper.GetString(reader, "Name"), ProductsCount = SQLDataHelper.GetInt(reader, "ProductsCount"), PhotosCount = SQLDataHelper.GetInt(reader, "PhotosCount"), HaveExcel = SQLDataHelper.GetBoolean(reader, "HaveExcel"), Have1C = SQLDataHelper.GetBoolean(reader, "Have1C"), HaveExportFeeds = SQLDataHelper.GetBoolean(reader, "HaveExportFeeds"), HavePriceRegulating = SQLDataHelper.GetBoolean(reader, "HavePriceRegulating"), HaveBankIntegration = SQLDataHelper.GetBoolean(reader, "HaveBankIntegration"), IsWork = SQLDataHelper.GetBoolean(reader, "IsWork"), PaidTo = SQLDataHelper.GetDateTime(reader, "PaidTo"), LastUpdate = SQLDataHelper.GetDateTime(reader, "LastUpdate") }); }
/// <summary> /// Метод загружает данные о просмотрах для пользователя из полученного SqlReader /// </summary> /// <param name="reader"></param> /// <returns></returns> /// <remarks></remarks> private static RecentlyViewRecord ReadViewRecordFromReader(SqlDataReader reader) { return(new RecentlyViewRecord { ProductID = SQLDataHelper.GetInt(reader["ProductID"]), ViewTime = SQLDataHelper.GetDateTime(reader["ViewDate"]), ImgPath = SQLDataHelper.GetString(reader["Photo"]), PhotoDesc = SQLDataHelper.GetString(reader["PhotoDesc"]), Name = SQLDataHelper.GetString(reader["Name"]), Price = SQLDataHelper.GetFloat(reader["Price"]), Discount = SQLDataHelper.GetFloat(reader["Discount"]), UrlPath = SQLDataHelper.GetString(reader["UrlPath"]), Ratio = SQLDataHelper.GetFloat(reader["Ratio"]), RatioID = SQLDataHelper.GetInt(reader["RatioID"]), MultiPrice = SQLDataHelper.GetFloat(reader["MultiPrice"]), }); }
public static IList <ClientOnlineInfo> GetAllInfo() { List <ClientOnlineInfo> lInfo = SQLDataAccess.ExecuteReadList <ClientOnlineInfo>("SELECT * FROM [Customers].[ClientInfo]", CommandType.Text, reader => new ClientOnlineInfo { SessionId = SQLDataHelper.GetString(reader, "sessionID"), Address = SQLDataHelper.GetString(reader, "Address"), UserAgentBrowser = SQLDataHelper.GetString(reader, "UserAgentBrowser"), UserAgentOS = SQLDataHelper.GetString(reader, "UserAgentOS"), CountryByGeoIp = SQLDataHelper.GetString(reader, "CountryByGeoIp"), LastAccessedPath = SQLDataHelper.GetString(reader, "LastAccessedPath"), Started = SQLDataHelper.GetDateTime(reader, "Started"), Ended = SQLDataHelper.GetDateTime(reader, "Ended") }); return(lInfo); }
public static Customer GetFromSqlDataReader(SqlDataReader reader) { var customer = new Customer { Id = SQLDataHelper.GetGuid(reader, "CustomerID"), CustomerGroupId = SQLDataHelper.GetInt(reader, "CustomerGroupId", 0), EMail = SQLDataHelper.GetString(reader, "EMail"), FirstName = SQLDataHelper.GetString(reader, "FirstName"), LastName = SQLDataHelper.GetString(reader, "LastName"), RegistrationDateTime = SQLDataHelper.GetDateTime(reader, "RegistrationDateTime"), SubscribedForNews = SQLDataHelper.GetBoolean(reader, "Subscribed4News"), Phone = SQLDataHelper.GetString(reader, "Phone"), Password = SQLDataHelper.GetString(reader, "Password"), CustomerRole = (Role)SQLDataHelper.GetInt(reader, "CustomerRole") }; return(customer); }