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