public static List <YaMarketShipping> GetShippings()
{
return(ModulesRepository.ModuleExecuteReadList("Select * From Module.YaMarketShippings", CommandType.Text,
reader => new YaMarketShipping()
{
Id = SQLDataHelper.GetInt(reader, "Id"),
ShippingMethodId = SQLDataHelper.GetInt(reader, "ShippingMethodId"),
Type = SQLDataHelper.GetString(reader, "Type"),
MinDate = SQLDataHelper.GetInt(reader, "MinDate"),
MaxDate = SQLDataHelper.GetInt(reader, "MaxDate")
}));
}
public static List <ProductDiscount> GetProductDiscountsList(DateTime dateTime)
{
return(ModulesRepository.ModuleExecuteReadList(
"Select * From [Module].[" + ModuleName + "] Where ((@dateTime between DateStart and DateExpired) Or (IsRepeat = 1))",
CommandType.Text,
reader => new ProductDiscount()
{
ProductId = ModulesRepository.ConvertTo <int>(reader, "ProductId"),
Discount = ModulesRepository.ConvertTo <float>(reader, "DiscountInTime"),
DateExpired = ModulesRepository.ConvertTo <DateTime>(reader, "DateExpired")
},
new SqlParameter("@dateTime", dateTime)));
}
public static List <AbandonedCart> GetAbondonedCartsUnReg()
{
return
(ModulesRepository.ModuleExecuteReadList(
"Select OrderConfirmation.CustomerId, OrderConfirmationData, LastUpdate, " +
"(Select Count(*) From [Module].[AbandonedCartLetter] Where AbandonedCartLetter.CustomerId = OrderConfirmation.CustomerId) as SendingCount, " +
"(Select Top(1)SendingDate From [Module].[AbandonedCartLetter] Where AbandonedCartLetter.CustomerId = OrderConfirmation.CustomerId Order By SendingDate Desc) as SendingDate " +
"From [Order].[OrderConfirmation] " +
"Left Join [Customers].[Customer] On [OrderConfirmation].[CustomerId] = [Customer].[CustomerId] " +
"Where [Customer].[CustomerId] is null " +
"Order By LastUpdate Desc",
CommandType.Text,
GetOrderConfirmationFromReader));
}
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>());
}
public static List <AbandonedCart> GetAbondonedCartsReg()
{
return
(ModulesRepository.ModuleExecuteReadList(
"Select Distinct sc.[CustomerId], null as OrderConfirmationData, " +
"(Select top(1) UpdatedOn From [Catalog].[ShoppingCart] Where [ShoppingCart].[CustomerID] = sc.CustomerId and ShoppingCartType = @CartType Order By UpdatedOn Desc) as LastUpdate, " +
"(Select Count(*) From [Module].[AbandonedCartLetter] Where AbandonedCartLetter.CustomerId = sc.CustomerId) as SendingCount, " +
"(Select Top(1)SendingDate From [Module].[AbandonedCartLetter] Where AbandonedCartLetter.CustomerId = sc.CustomerId Order By SendingDate Desc) as SendingDate " +
"From [Catalog].[ShoppingCart] as sc " +
"Inner Join [Customers].[Customer] On sc.[CustomerId] = [Customer].[CustomerID] " +
"Where ShoppingCartType = @CartType " +
"Order By LastUpdate Desc",
CommandType.Text,
GetOrderConfirmationFromReader,
new SqlParameter("@CartType", ((int)ShoppingCartType.ShoppingCart).ToString())));
}
public static List <StoreReview> GetStoreReviewsByParentId(int parentId, bool isModerated)
{
return(ModulesRepository.ModuleExecuteReadList <StoreReview>(
"SELECT *, (SELECT Count(ID) FROM [Module].[StoreReview] WHERE [ParentID] = ParentReview.ID) as ChildsCount FROM [Module].[StoreReview] as ParentReview WHERE "
+ (parentId == 0 ? "[ParentID] is NULL" : "[ParentID] = " + parentId)
+ (isModerated ? " AND [Moderated] = 1" : string.Empty) + " ORDER BY [DateAdded]"
+ (parentId == 0 ? "DESC" : "ASC"),
CommandType.Text,
(reader) =>
{
var review = GetStoreReviewFromReader(reader);
review.ChildrenReviews = ModulesRepository.ConvertTo <int>(reader, "ChildsCount") > 0
? GetStoreReviewsByParentId(
ModulesRepository.ConvertTo <int>(reader, "ID"), isModerated)
: new List <StoreReview>();
return review;
}
));
}
public static List <AbandonedCartTemplate> GetTemplates()
{
return
(ModulesRepository.ModuleExecuteReadList("Select * From [Module].[AbandonedCartTemplate]", CommandType.Text,
GetTemplateFromReader));
}
