//---------------------------------------------------------------------
#endregion
#region --------------ChangeAddress--------------
//---------------------------------------------------------------------
//ChangeAddress
//---------------------------------------------------------------------
public bool ChangeAddress(OrderRequestAddress ShippingAddress, int userId)
{
bool savestats = false;
try
{
string sp = "[dbo].[OrderRequestAddress_ChangeUserAddress]";
//----------------------------------------------------------------
CustomDbParameterList customParameters = ShippingAddress.GetMemberParameters(
e => e.OrderRequestAddressID,
e => e.FName,
e => e.LName,
e => e.CityID,
e => e.Mobile,
e => e.Address,
e => e.ShippingNote,
e => e.ChangeUserAddressAlso);
//UserID
customParameters.Add("@UserID", userId);
//----------------------------------------------------------------
SqlDataHelper.ExecuteStoredProcedure(sp, customParameters);
//----------------------------------------------------------------
savestats = true;
}
catch (Exception ex)
{
savestats = false;
}
return(savestats);
}
//---------------------------------------------------------------------
//ConvertOrderRequestToFinalOrder
//---------------------------------------------------------------------
public bool ConvertOrderRequestToFinalOrder(OrderConfirmationFormDto request)
{
bool isValid = false;
string sp = "[dbo].[Order_ConvertOrderRequestToFinalOrder]";
//Prepare Parameters-----------------------------------------------
CustomDbParameterList customParameters = request.GetMemberParameters(
r => r.UserID,
r => r.PaymentMethodID,
r => r.ShippingMethodID,
r => r.OrderRequestID,
r => r.LangId,
r => r.UserNote,
r => r.FName,
r => r.LName,
r => r.CityID,
r => r.Mobile,
r => r.Address,
//r => r.ShippingNote,
r => r.ChangeUserAddressAlso);
//customParameters.Add("@ShippingNote", request.UserNote);
//IsValid
SqlParameter IsValidOutputParameter = customParameters.AddOutputParameter_Boolean("@IsValid");
//---------------------------------------------------------------------
SqlDataHelper.ExecuteStoredProcedure(sp, customParameters);
//----------------------------------------------------------------
//IsValid
isValid = (bool)IsValidOutputParameter.Value;
return(isValid);
}
//---------------------------------------------------------------------
//CreateFullRequestDataFromUserShoppingCart
//---------------------------------------------------------------------
public OrderRequestFullData CreateFullRequestDataFromUserShoppingCart(int userID, int langId)
{
string sp = "[dbo].[OrderRequest_ConvertShoppingCartToOrderRequest]";
OrderRequestFullData request = new OrderRequestFullData();
CustomDbParameterList customParameters = new CustomDbParameterList();
//---------------------------------------------------------------------
// Set the parameters
//---------------------------------------------------------------------
customParameters.Add("@UserID", userID);
customParameters.Add("@langId", langId);
SqlParameter isValidParameter = customParameters.AddOutputParameter_Boolean("IsValid");
//---------------------------------------------------------------------
// Execute the command
//---------------------------------------------------------------------
Dictionary <string, object> multiRecodSet =
SqlDataHelper.RetrieveMultiRecordSet(
sp,
customParameters,
typeof(OrderRequest),
typeof(List <OrderRequsetItem>),
typeof(OrderRequestAddress)
);
request.RequsetData = (OrderRequest)multiRecodSet["OrderRequest"];
request.ItemsList = (List <OrderRequsetItem>)multiRecodSet["OrderRequsetItem"];
request.ShippingAddress = (OrderRequestAddress)multiRecodSet["OrderRequestAddress"];
//----------------------------------------------------------------
//IsValid
request.IsValid = (bool)isValidParameter.Value;
return(request);
//----------------------------------------------------------------
}
//---------------------------------------------------------------------
#endregion
#region --------------GetFullOrderDataWithDetails--------------
//---------------------------------------------------------------------
//GetFullOrderDataWithDetails
//---------------------------------------------------------------------
public OrderDataWithDetails GetFullOrderDataWithDetails(int userId, int orderId, int langId)
{
OrderDataWithDetails order = new OrderDataWithDetails();
CustomDbParameterList customParameters = new CustomDbParameterList();
//
string sp = "[dbo].[Order_GetFullOrderDataWithDetails]";
//---------------------------------------------------------------------
// Set the parameters
//---------------------------------------------------------------------
customParameters.Add("@UserID", userId);
customParameters.Add("@OrderId", orderId);
customParameters.Add("@langId", langId);
//---------------------------------------------------------------------
// Execute the command
//---------------------------------------------------------------------
Dictionary <string, object> multiRecodSet =
SqlDataHelper.RetrieveMultiRecordSet(
sp,
customParameters,
typeof(Order),
typeof(List <OrderItem>),
typeof(OrderAddress)
);
order.OrderData = (Order)multiRecodSet["Order"];
order.ItemsList = (List <OrderItem>)multiRecodSet["OrderItem"];
order.ShippingAddress = (OrderAddress)multiRecodSet["OrderAddress"];
//----------------------------------------------------------------
return(order);
}
//---------------------------------------------------------------------
#endregion
#region --------------ChangeOrderStatus--------------
//---------------------------------------------------------------------
//ChangeOrderStatus
//---------------------------------------------------------------------
public bool ChangeOrderStatus(int orderID, EnumOrderStatus orderStatusID, float totalPaied, string adminNote)
{
bool savestats = false;
try
{
//[dbo].[Order_ChangeOrderStatus]
string sp = "[dbo].[Order_ChangeOrderStatus]";
CustomDbParameterList customParameters = new CustomDbParameterList();
//----------------------------------------------------------------
customParameters.Add("@OrderID", orderID);
customParameters.Add("@OrderStatusID", orderStatusID);
customParameters.Add("@TotalPaied", totalPaied);
customParameters.Add("@AdminNote", adminNote);
//----------------------------------------------------------------
SqlDataHelper.ExecuteStoredProcedure(sp, customParameters);
//----------------------------------------------------------------
savestats = true;
}
catch (Exception ex)
{
savestats = false;
}
return(savestats);
}
//---------------------------------------------------------------------
#endregion
#region --------------GetUserByUserName--------------
//---------------------------------------------------------------------
//GetUserByUserName
//---------------------------------------------------------------------
public Model.DomainClasses.User GetUserByUserName(string userName)
{
string sp = "[dbo].[Users_GetUserByUserName]";
CustomDbParameterList customParameters = new CustomDbParameterList();
customParameters.Add("@UserName", userName);
return(SqlDataHelper.RetrieveEntitySingleOrDefault <Model.DomainClasses.User>(sp, customParameters));
}
//---------------------------------------------------------------------
#endregion
#region --------------GetShortShoppingCart--------------
//---------------------------------------------------------------------
//GetShortShoppingCart
//---------------------------------------------------------------------
public List <ShoppingCartItem> GetShortShoppingCart(int langId, int userId)
{
string sp = "[dbo].[ShoppingCart_GetShortShoppingCart]";
CustomDbParameterList customParameters = new CustomDbParameterList();
customParameters.Add("@langId", langId);
customParameters.Add("@UserID", userId);
List <ShoppingCartItem> shoppingCartItems = SqlDataHelper.RetrieveEntityList <ShoppingCartItem>(sp, customParameters);
return(shoppingCartItems);
}
//---------------------------------------------------------------------
#endregion
//[dbo].[Message_AddUserMessage]
#region --------------GetMessagesByOrderIdForUser--------------
//---------------------------------------------------------------------
//GetMessagesByOrderIdForUser
//---------------------------------------------------------------------
public List <MessageDto> GetMessagesByOrderIdForUser(int orderId)
{
string sp = "[dbo].[Message_GetMessagesByOrderIdForUser]";
CustomDbParameterList customParameters = new CustomDbParameterList();
// Set the parameters
//---------------------------------------------------------------------
customParameters.Add("@OrderId", orderId);
List <MessageDto> list =
SqlDataHelper.RetrieveEntityList <MessageDto>(sp, customParameters);
//---------------------------------------------------------------------
return(list);
}
//---------------------------------------------------------------------
//AddItemAndReturnList
//---------------------------------------------------------------------
public List <ShoppingCartItem> AddItemAndReturnList(int langId, int userId, int productID, int quantity)
{
string sp = "[dbo].[ShoppingCart_AddItemAndReturnList]";
CustomDbParameterList customParameters = new CustomDbParameterList();
// Set the parameters
customParameters.Add("@langId", langId);
customParameters.Add("@UserID", userId);
customParameters.Add("@ProductID", productID);
customParameters.Add("@Quantity", quantity);
List <ShoppingCartItem> shoppingCartItems =
SqlDataHelper.RetrieveEntityList <ShoppingCartItem>(sp, customParameters);
return(shoppingCartItems);
}
//---------------------------------------------------------------------
#endregion
#region --------------GetUserOrders--------------
//---------------------------------------------------------------------
//GetUserOrders
//---------------------------------------------------------------------
public List <OrderDataDto> GetUserOrders(int UserId, int LangId, int PageIndex, int PageSize, out int TotalRecords)
{
string sp = "[dbo].[Order_GetUserOrders]";
CustomDbParameterList customParameters = new CustomDbParameterList();
// Set the parameters
//---------------------------------------------------------------------
customParameters.Add("@UserId", UserId);
customParameters.Add("@LangId", LangId);
customParameters.Add("@PageIndex", PageIndex);
customParameters.Add("@PageSize", PageSize);
SqlParameter totalRecordsParameter = customParameters.AddOutputParameter_Integer("TotalRecords");
//---------------------------------------------------------------------
// Execute the command
//---------------------------------------------------------------------
List <OrderDataDto> list =
SqlDataHelper.RetrieveEntityList <OrderDataDto>(sp, customParameters);
//---------------------------------------------------------------------
//Gets result rows count
TotalRecords = (int)totalRecordsParameter.Value;
//----------------------------------------------------------------
return(list);
}
//---------------------------------------------------------------------
#endregion
#region --------------GetSearrchBoxFilters--------------
//---------------------------------------------------------------------
//GetSearrchBoxFilters
//---------------------------------------------------------------------
public List <SearchFilter> GetSearrchBoxFilters(SearchParameters parameters)
{
string sp = "[dbo].[Search_GetFiltersWithProducts]";
//[dbo].[Search_GetFiltersWithProducts]
CustomDbParameterList customParameters = new CustomDbParameterList();
// Set the searchParameters
//---------------------------------------------------------------------
//DepartmentID
customParameters.Add("@DepartmentID", parameters.DepartmentID);
//---------------------------------------------------------------------
//SupplierID
if (parameters.SupplierID.HasValue)
{
customParameters.Add("@SupplierID", parameters.SupplierID);
}
//---------------------------------------------------------------------
//Brands
if (!string.IsNullOrEmpty(parameters.Brands))
{
customParameters.Add("@Brands", parameters.Brands);
}
//---------------------------------------------------------------------
//Cars
if (!string.IsNullOrEmpty(parameters.Cars))
{
customParameters.Add("@Cars", parameters.Cars);
}
//---------------------------------------------------------------------
//Categories
if (!string.IsNullOrEmpty(parameters.Categories))
{
customParameters.Add("@Categories", parameters.Categories);
}
//---------------------------------------------------------------------
//Models
if (!string.IsNullOrEmpty(parameters.Models))
{
customParameters.Add("@Models", parameters.Models);
}
//---------------------------------------------------------------------
//ProductTypes
if (!string.IsNullOrEmpty(parameters.ProductTypes))
{
customParameters.Add("@ProductTypes", parameters.ProductTypes);
}
//---------------------------------------------------------------------
//Status
if (!string.IsNullOrEmpty(parameters.Status))
{
customParameters.Add("@Status", parameters.Status);
}
//---------------------------------------------------------------------
//EngineTypes
if (!string.IsNullOrEmpty(parameters.EngineTypes))
{
customParameters.Add("@EngineTypes", parameters.EngineTypes);
}
//---------------------------------------------------------------------
//ProductIndustries
if (!string.IsNullOrEmpty(parameters.ProductIndustries))
{
customParameters.Add("@ProductIndustries", parameters.ProductIndustries);
}
//---------------------------------------------------------------------
//TireSizes
if (!string.IsNullOrEmpty(parameters.TireSizes))
{
customParameters.Add("@TireSizes", parameters.TireSizes);
}
//---------------------------------------------------------------------
//TireWidths
if (!string.IsNullOrEmpty(parameters.TireWidths))
{
customParameters.Add("@TireWidths", parameters.TireWidths);
}
//---------------------------------------------------------------------
//AspectRatios
if (!string.IsNullOrEmpty(parameters.AspectRatios))
{
customParameters.Add("@AspectRatios", parameters.AspectRatios);
}
//---------------------------------------------------------------------
//PriceFrom
if (parameters.PriceFrom.HasValue)
{
customParameters.Add("@PriceFrom", parameters.PriceFrom);
}
//---------------------------------------------------------------------
//PriceTo
if (parameters.PriceTo.HasValue)
{
customParameters.Add("@PriceTo", parameters.PriceTo);
}
//---------------------------------------------------------------------
//LangId
customParameters.Add("@LangId", parameters.LangId);
//---------------------------------------------------------------------
// Execute the command
//---------------------------------------------------------------------
List <SearchFilter> result = SqlDataHelper.RetrieveEntityList <SearchFilter>(sp, customParameters);
//---------------------------------------------------------------------
//return the result
return(result);
}
//---------------------------------------------------------------------
#endregion
#region --------------GetProductsOnly--------------
//---------------------------------------------------------------------
//GetProductsOnly
//---------------------------------------------------------------------
public SearchResult GetProductsOnly(SearchParameters searchParameters)
{
SearchResult result = new SearchResult();
string sp = "[dbo].[Search_GetProductsOnly]";
//Prepare Parameters-----------------------------------------------
CustomDbParameterList customParameters = new CustomDbParameterList();
//---------------------------------------------------------------------
if (searchParameters.DepartmentID > 0)
{
customParameters.Add("@DepartmentID", searchParameters.DepartmentID);
}
//---------------------------------------------------------------------
//SupplierID
if (searchParameters.SupplierID.HasValue && searchParameters.SupplierID > 0)
{
customParameters.Add("@SupplierID", searchParameters.SupplierID);
}
//---------------------------------------------------------------------
//Brands
if (!string.IsNullOrEmpty(searchParameters.Brands))
{
customParameters.Add("@Brands", searchParameters.Brands);
}
//---------------------------------------------------------------------
//Cars
if (!string.IsNullOrEmpty(searchParameters.Cars))
{
customParameters.Add("@Cars", searchParameters.Cars);
}
//---------------------------------------------------------------------
//Categories
if (!string.IsNullOrEmpty(searchParameters.Categories))
{
customParameters.Add("@Categories", searchParameters.Categories);
}
//---------------------------------------------------------------------
//Models
if (!string.IsNullOrEmpty(searchParameters.Models))
{
customParameters.Add("@Models", searchParameters.Models);
}
//---------------------------------------------------------------------
//ProductTypes
if (!string.IsNullOrEmpty(searchParameters.ProductTypes))
{
customParameters.Add("@ProductTypes", searchParameters.ProductTypes);
}
//---------------------------------------------------------------------
//Status
if (!string.IsNullOrEmpty(searchParameters.Status))
{
customParameters.Add("@Status", searchParameters.Status);
}
//---------------------------------------------------------------------
//EngineTypes
if (!string.IsNullOrEmpty(searchParameters.EngineTypes))
{
customParameters.Add("@EngineTypes", searchParameters.EngineTypes);
}
//---------------------------------------------------------------------
//ProductIndustries
if (!string.IsNullOrEmpty(searchParameters.ProductIndustries))
{
customParameters.Add("@ProductIndustries", searchParameters.ProductIndustries);
}
//---------------------------------------------------------------------
//TireSizes
if (!string.IsNullOrEmpty(searchParameters.TireSizes))
{
customParameters.Add("@TireSizes", searchParameters.TireSizes);
}
//---------------------------------------------------------------------
//TireWidths
if (!string.IsNullOrEmpty(searchParameters.TireWidths))
{
customParameters.Add("@TireWidths", searchParameters.TireWidths);
}
//---------------------------------------------------------------------
//AspectRatios
if (!string.IsNullOrEmpty(searchParameters.AspectRatios))
{
customParameters.Add("@AspectRatios", searchParameters.AspectRatios);
}
//---------------------------------------------------------------------
//PriceFrom
if (searchParameters.PriceFrom.HasValue)
{
customParameters.Add("@PriceFrom", searchParameters.PriceFrom);
}
//---------------------------------------------------------------------
//PriceTo
if (searchParameters.PriceTo.HasValue)
{
customParameters.Add("@PriceTo", searchParameters.PriceTo);
}
//---------------------------------------------------------------------
//PageIndex
customParameters.Add("@PageIndex", searchParameters.PageIndex);
//---------------------------------------------------------------------
//PageSize
customParameters.Add("@PageSize", searchParameters.PageSize);
//---------------------------------------------------------------------
//LangId
if (searchParameters.LangId > 0)
{
customParameters.Add("@LangId", searchParameters.LangId);
}
//---------------------------------------------------------------------
//SearchOrderType
customParameters.Add("@SearchOrderType", searchParameters.OrderType);
//---------------------------------------------------------------------
//TotalRecords
SqlParameter totalRecordsParameter = customParameters.AddOutputParameter_Integer("TotalRecords");
//---------------------------------------------------------------------
// Execute the command
//---------------------------------------------------------------------
result.ProductList = SqlDataHelper.RetrieveEntityList <SearchProduct>(sp, customParameters);
//-----------------------------
//Gets result rows count
result.AvailableProductCount = (int)totalRecordsParameter.Value;
//if we didn't get atrue value from database for any reson
//may be there is no data
if (result.AvailableProductCount < 0)
{
result.AvailableProductCount = result.ProductList.Count;
}
//----------------------------------------------------------------
return(result);
}
