/// <summary> /// Searches the specified search GUID. /// </summary> /// <param name="searchGuid">The search GUID.</param> /// <returns></returns> public int Search(Guid searchGuid) { DataCommand cmd = OrderDataHelper.CreateTranDataCommand(); cmd.CommandText = String.Format("ecf_OrderSearch"); cmd.Parameters = new DataParameters(); cmd.Parameters.Add(new DataParameter("ApplicationId", OrderConfiguration.Instance.ApplicationId, DataParameterType.UniqueIdentifier)); cmd.Parameters.Add(new DataParameter("SearchSetId", searchGuid, DataParameterType.UniqueIdentifier)); cmd.Parameters.Add(new DataParameter("SQLClause", SearchParameters.SqlWhereClause, DataParameterType.NVarChar)); cmd.Parameters.Add(new DataParameter("MetaSQLClause", SearchParameters.SqlMetaWhereClause, DataParameterType.NVarChar)); cmd.Parameters.Add(new DataParameter("FTSPhrase", SearchParameters.FreeTextSearchPhrase, DataParameterType.NVarChar)); cmd.Parameters.Add(new DataParameter("AdvancedFTSPhrase", SearchParameters.AdvancedFreeTextSearchPhrase, DataParameterType.NVarChar)); cmd.Parameters.Add(new DataParameter("OrderBy", SearchParameters.OrderByClause, DataParameterType.NVarChar)); cmd.Parameters.Add(new DataParameter("Namespace", SearchOptions.Namespace, DataParameterType.NVarChar, 1024)); cmd.Parameters.Add(new DataParameter("Classes", CommerceHelper.ConvertToString(SearchOptions.Classes, ","), DataParameterType.NVarChar)); cmd.Parameters.Add(new DataParameter("StartingRec", SearchOptions.StartingRecord, DataParameterType.Int)); cmd.Parameters.Add(new DataParameter("NumRecords", SearchOptions.RecordsToRetrieve, DataParameterType.Int)); DataParameter param = new DataParameter("RecordCount", DataParameterType.Int); param.Direction = ParameterDirection.InputOutput; param.Value = 0; cmd.Parameters.Add(param); DataService.ExecuteNonExec(cmd); return(Int32.Parse(cmd.Parameters["RecordCount"].Value.ToString())); }
/// <summary> /// Returns Jurisdiction by code. /// </summary> /// <param name="code">The jurisdiction code.</param> /// <param name="returnAllGroups">True, to return all jurisdiction groups.</param> /// <returns></returns> public static JurisdictionDto GetJurisdiction(string code, bool returnAllGroups) { // Assign new cache key, specific for site guid and response groups requested string cacheKey = OrderCache.CreateCacheKey("jurisdiction-code", code, returnAllGroups.ToString()); JurisdictionDto dto = null; // check cache first object cachedObject = OrderCache.Get(cacheKey); if (cachedObject != null) { dto = (JurisdictionDto)cachedObject; } // Load the object if (dto == null) { DataCommand cmd = OrderDataHelper.CreateConfigDataCommand(); cmd.CommandText = "[ecf_Jurisdiction_JurisdictionCode]"; cmd.Parameters = new DataParameters(); cmd.Parameters.Add(new DataParameter("ApplicationId", OrderConfiguration.Instance.ApplicationId, DataParameterType.UniqueIdentifier)); cmd.Parameters.Add(new DataParameter("JurisdictionCode", code, DataParameterType.NVarChar, 50)); cmd.Parameters.Add(new DataParameter("ReturnAllGroups", returnAllGroups, DataParameterType.Bit)); cmd.DataSet = new JurisdictionDto(); cmd.TableMapping = DataHelper.MapTables("Jurisdiction", "JurisdictionGroup", "JurisdictionRelation"); DataResult results = DataService.LoadDataSet(cmd); dto = (JurisdictionDto)results.DataSet; } return(dto); }
private void BindReport() { DataCommand tranDataCommand = OrderDataHelper.CreateTranDataCommand(); tranDataCommand.CommandText = "[reporting_OrderReport]"; tranDataCommand.CommandType = CommandType.StoredProcedure; tranDataCommand.Parameters = new DataParameters(); tranDataCommand.Parameters.Add(new DataParameter("ApplicationId", (object)Mediachase.Commerce.Core.AppContext.Current.ApplicationId, DataParameterType.UniqueIdentifier)); tranDataCommand.Parameters.Add(new DataParameter("MarketId", (object)this.MarketFilter.SelectedValue, DataParameterType.NVarChar)); tranDataCommand.Parameters.Add(new DataParameter("CurrencyCode", (object)this.CurrencyFilter.SelectedValue, DataParameterType.NVarChar)); tranDataCommand.Parameters.Add(new DataParameter("CommerceManagerUrl", (object)ConfigurationManager.AppSettings["SiteUrl"], DataParameterType.NVarChar)); tranDataCommand.Parameters.Add(new DataParameter("startdate", (object)this.StartDate.Value.Date.ToUniversalTime(), DataParameterType.DateTime)); tranDataCommand.Parameters.Add(new DataParameter("enddate", (object)this.EndDate.Value.Date.AddDays(1.0).AddSeconds(-1.0).ToUniversalTime(), DataParameterType.DateTime)); tranDataCommand.TableMapping = DataHelper.MapTables(new string[1] { "reporting_OrderReport" }); tranDataCommand.DataSet = (DataSet) new Reports(); DataResult dataResult = DataService.LoadDataSet(tranDataCommand); ReportDataSource reportDataSource = new ReportDataSource(); reportDataSource.Name = "OrdersReport"; reportDataSource.Value = (object)((Reports)dataResult.DataSet).reporting_OrderReport; this.MyReportViewer.LocalReport.DataSources.Clear(); this.MyReportViewer.LocalReport.DataSources.Add(reportDataSource); this.MyReportViewer.LocalReport.ReportPath = this.MapPath("Reports\\OrdersByMarket.rdlc"); this.MyReportViewer.DataBind(); }
/// <summary> /// Binds the report. /// </summary> private void BindReport() { DataCommand cmd = OrderDataHelper.CreateTranDataCommand(); cmd.CommandText = String.Format("select sum(F.SubTotal) GrossSales, sum(F.SubTotal - F.DiscountAmount) NetSales, G.BillingCurrency from OrderForm F inner join OrderFormEx FEX ON FEX.ObjectId = F.OrderFormId inner join OrderGroup G on G.OrderGroupId = F.OrderGroupId where G.Status = (select [Name] from OrderStatus OS where OrderStatusId = (select max(OrderStatusId) from OrderStatus) and OS.ApplicationId = '{0}') and G.ApplicationId = '{0}' and FEX.Created between '{1}' and '{2}' GROUP BY G.BillingCurrency;", OrderConfiguration.Instance.ApplicationId, new DateTime(DateTime.UtcNow.Year, 1, 1).ToString("s"), DateTime.UtcNow.ToString("s")); cmd.CommandType = CommandType.Text; cmd.Parameters = new DataParameters(); cmd.TableMapping = DataHelper.MapTables("SalesTable"); cmd.DataSet = new PerfDataSet(); DataResult results = DataService.LoadDataSet(cmd); cmd.CommandText = String.Format("select sum(F.SubTotal) GrossSales, sum(F.SubTotal - F.DiscountAmount) NetSales, G.BillingCurrency, month(FEX.Created) [Month] from OrderForm F inner join OrderFormEx FEX ON FEX.ObjectId = F.OrderFormId inner join OrderGroup G on G.OrderGroupId = F.OrderGroupId where G.Status = (select [Name] from OrderStatus OS where OrderStatusId = (select max(OrderStatusId) from OrderStatus) and OS.ApplicationId = '{0}') and G.ApplicationId = '{0}' and FEX.Created between '{1}' and '{2}' GROUP BY G.BillingCurrency, month(FEX.Created);", OrderConfiguration.Instance.ApplicationId, new DateTime(DateTime.UtcNow.Year, 1, 1).ToString("s"), DateTime.UtcNow.ToString("s")); cmd.CommandType = CommandType.Text; cmd.Parameters = new DataParameters(); cmd.TableMapping = DataHelper.MapTables("SalesMonthlyTable"); cmd.DataSet = new PerfDataSet(); DataResult results2 = DataService.LoadDataSet(cmd); ReportDataSource source = new ReportDataSource(); source.Name = "SalesTable"; source.Value = ((PerfDataSet)results.DataSet).SalesTable; ReportDataSource source2 = new ReportDataSource(); source2.Name = "SalesMonthlyTable"; source2.Value = ((PerfDataSet)results2.DataSet).SalesMonthlyTable; PerfReportViewer.LocalReport.DataSources.Add(source); PerfReportViewer.LocalReport.DataSources.Add(source2); PerfReportViewer.DataBind(); }
internal static TransactionBookData ToTransactionBookData(XmlNode tranNode) { string tranCode = string.Empty; Guid? orderBatchInstructionId; TransactionBookData tranData = TransactionParser.ParseTransactionBookData(tranNode, out orderBatchInstructionId); tranData.Id = Guid.Parse(tranNode.Attributes["ID"].Value); tranData.Orders = new List <OrderBookData>(); var instrument = InstrumentManager.Default.Get(tranData.InstrumentId); InstrumentCategory instrumentCategory = instrument.Category; foreach (XmlNode orderNode in tranNode.ChildNodes) { if (orderNode.Name == "Order") { OrderBookData orderData = null; if (instrumentCategory == InstrumentCategory.Forex) { orderData = OrderDataHelper.InitializeBookData(orderNode); } else { orderData = OrderDataHelper.InitalizePhysicalBookData(orderNode); } orderData.OrderBatchInstructionID = orderBatchInstructionId; tranData.Orders.Add(orderData); } } tranData.PlaceByRiskMonitor = true; return(tranData); }
/// <summary> /// Gets the taxes. /// </summary> /// <param name="siteId">The site id.</param> /// <param name="taxCategory">The tax category.</param> /// <param name="languageCode">The language code.</param> /// <param name="countryCode">The country code.</param> /// <param name="stateProvinceCode">The state province code.</param> /// <param name="zipPostalCode">The zip postal code.</param> /// <param name="district">The district.</param> /// <param name="county">The county.</param> /// <param name="city">The city.</param> /// <returns></returns> public static DataTable GetTaxes( Guid siteId, string taxCategory, string languageCode, string countryCode, string stateProvinceCode, string zipPostalCode, string district, string county, string city) { DataCommand cmd = OrderDataHelper.CreateConfigDataCommand(); cmd.CommandText = String.Format("ecf_GetTaxes"); cmd.Parameters = new DataParameters(); cmd.Parameters.Add(new DataParameter("ApplicationId", OrderConfiguration.Instance.ApplicationId, DataParameterType.UniqueIdentifier)); cmd.Parameters.Add(new DataParameter("SiteId", siteId, DataParameterType.UniqueIdentifier)); cmd.Parameters.Add(new DataParameter("TaxCategory", taxCategory, DataParameterType.NVarChar, 50)); cmd.Parameters.Add(new DataParameter("LanguageCode", languageCode, DataParameterType.NVarChar, 50)); cmd.Parameters.Add(new DataParameter("CountryCode", countryCode, DataParameterType.NVarChar, 50)); cmd.Parameters.Add(new DataParameter("StateProvinceCode", stateProvinceCode, DataParameterType.NVarChar, 50)); cmd.Parameters.Add(new DataParameter("ZipPostalCode", zipPostalCode, DataParameterType.NVarChar, 50)); cmd.Parameters.Add(new DataParameter("District", district, DataParameterType.NVarChar, 50)); cmd.Parameters.Add(new DataParameter("County", county, DataParameterType.NVarChar, 50)); cmd.Parameters.Add(new DataParameter("City", city, DataParameterType.NVarChar, 50)); return(DataService.LoadTable(cmd)); }
/// <summary> /// Returns shippping method cases by shipping method id. /// </summary> /// <returns></returns> public static DataTable GetShippingMethodCases(Guid shippingMethodId) { DataCommand cmd = OrderDataHelper.CreateConfigDataCommand(); cmd.CommandText = "[ecf_ShippingMethod_GetCases]"; cmd.Parameters = new DataParameters(); cmd.Parameters.Add(new DataParameter("ShippingMethodId", shippingMethodId, DataParameterType.UniqueIdentifier)); return(DataService.LoadTable(cmd)); }
/// <summary> /// Returns shippping package by shipping option id. /// </summary> /// <returns></returns> public static ShippingMethodDto GetShippingPackages() { DataCommand cmd = OrderDataHelper.CreateConfigDataCommand(); cmd.CommandText = "[ecf_ShippingPackage]"; cmd.Parameters = new DataParameters(); cmd.Parameters.Add(new DataParameter("ApplicationId", OrderConfiguration.Instance.ApplicationId, DataParameterType.UniqueIdentifier)); cmd.DataSet = new ShippingMethodDto(); cmd.TableMapping = DataHelper.MapTables("Package"); DataResult results = DataService.LoadDataSet(cmd); return((ShippingMethodDto)results.DataSet); }
/// <summary> /// Saves the payment. /// </summary> /// <param name="dto">The dto.</param> public static void SavePayment(PaymentMethodDto dto) { if (dto == null) { throw new ArgumentNullException("dto", String.Format("PaymentMethodDto can not be null")); } DataCommand cmd = OrderDataHelper.CreateConfigDataCommand(); using (TransactionScope scope = new TransactionScope()) { DataHelper.SaveDataSetSimple(OrderContext.MetaDataContext, cmd, dto, "PaymentMethod", "PaymentMethodParameter", "ShippingPaymentRestriction"); scope.Complete(); } }
/// <summary> /// Saves changes in CountryDto. Not implemented! /// </summary> /// <param name="dto">The dto.</param> public static void SaveCountry(CountryDto dto) { if (dto == null) { throw new ArgumentNullException("dto", String.Format("CountryDto can not be null")); } DataCommand cmd = OrderDataHelper.CreateConfigDataCommand(); using (TransactionScope scope = new TransactionScope()) { DataHelper.SaveDataSetSimple(OrderContext.MetaDataContext, cmd, dto, "Country", "StateProvince"); scope.Complete(); } }
/// <summary> /// Gets the order status. /// </summary> /// <returns></returns> public static OrderStatusDto GetOrderStatus() { //TODO: cache results DataCommand cmd = OrderDataHelper.CreateConfigDataCommand(); cmd.CommandText = String.Format("select * from OrderStatus where ApplicationId = '{0}';", OrderConfiguration.Instance.ApplicationId); cmd.CommandType = CommandType.Text; cmd.Parameters = new DataParameters(); cmd.DataSet = new OrderStatusDto(); cmd.TableMapping = DataHelper.MapTables("OrderStatus"); DataResult results = DataService.LoadDataSet(cmd); return((OrderStatusDto)results.DataSet); }
/// <summary> /// Saves the jurisdiction. /// </summary> /// <param name="dto">The dto.</param> public static void SaveJurisdiction(JurisdictionDto dto) { if (dto == null) { throw new ArgumentNullException("dto", String.Format("JurisdictionDto can not be null")); } DataCommand cmd = OrderDataHelper.CreateConfigDataCommand(); using (TransactionScope scope = new TransactionScope()) { DataHelper.SaveDataSetSimple(OrderContext.MetaDataContext, cmd, dto, "Jurisdiction", "JurisdictionGroup", "JurisdictionRelation"); scope.Complete(); } }
/// <summary> /// Gets the tax by name. /// </summary> /// <returns></returns> public static TaxDto GetTax(string name) { //TODO: cache results DataCommand cmd = OrderDataHelper.CreateConfigDataCommand(); cmd.CommandText = "[ecf_Tax_TaxName]"; cmd.Parameters = new DataParameters(); cmd.Parameters.Add(new DataParameter("ApplicationId", OrderConfiguration.Instance.ApplicationId, DataParameterType.UniqueIdentifier)); cmd.Parameters.Add(new DataParameter("Name", name, DataParameterType.NVarChar, 50)); cmd.DataSet = new TaxDto(); cmd.TableMapping = DataHelper.MapTables("Tax", "TaxLanguage", "TaxValue"); DataResult results = DataService.LoadDataSet(cmd); return((TaxDto)results.DataSet); }
/// <summary> /// Gets the country by code. /// </summary> /// <param name="code">Country code.</param> /// <param name="returnInactive">If true, all regions will be returned, otherwise only visible.</param> /// <returns></returns> public static CountryDto GetCountry(string code, bool returnInactive) { DataCommand cmd = OrderDataHelper.CreateConfigDataCommand(); cmd.CommandText = "[ecf_Country_Code]"; cmd.Parameters = new DataParameters(); cmd.Parameters.Add(new DataParameter("ApplicationId", OrderConfiguration.Instance.ApplicationId, DataParameterType.UniqueIdentifier)); cmd.Parameters.Add(new DataParameter("Code", code, DataParameterType.NVarChar, 3)); cmd.Parameters.Add(new DataParameter("ReturnInactive", returnInactive, DataParameterType.Bit)); cmd.DataSet = new CountryDto(); cmd.TableMapping = DataHelper.MapTables("Country", "StateProvince"); DataResult results = DataService.LoadDataSet(cmd); return((CountryDto)results.DataSet); }
/// <summary> /// Saves the package. /// </summary> /// <param name="dto">The dto.</param> public static void SavePackage(ShippingMethodDto dto) { if (dto == null) { throw new ArgumentNullException("dto", String.Format("ShippingMethodDto can not be null")); } // TODO: Check if user is allowed to perform this operation DataCommand cmd = OrderDataHelper.CreateConfigDataCommand(); using (TransactionScope scope = new TransactionScope()) { DataHelper.SaveDataSetSimple(OrderContext.MetaDataContext, cmd, dto, "Package"); scope.Complete(); } }
/// <summary> /// Returns shippping method by shipping method id. /// </summary> /// <param name="shippingMethodId">The shipping method id.</param> /// <param name="returnInactive">If true, return inactive shipping methods</param> /// <returns></returns> public static ShippingMethodDto GetShippingMethod(Guid shippingMethodId, bool returnInactive) { DataCommand cmd = OrderDataHelper.CreateConfigDataCommand(); cmd.CommandText = "[ecf_ShippingMethod_ShippingMethodId]"; cmd.Parameters = new DataParameters(); cmd.Parameters.Add(new DataParameter("ApplicationId", OrderConfiguration.Instance.ApplicationId, DataParameterType.UniqueIdentifier)); cmd.Parameters.Add(new DataParameter("ShippingMethodId", shippingMethodId, DataParameterType.UniqueIdentifier)); cmd.Parameters.Add(new DataParameter("ReturnInactive", returnInactive, DataParameterType.Bit)); cmd.DataSet = new ShippingMethodDto(); cmd.TableMapping = DataHelper.MapTables("ShippingOption", "ShippingOptionParameter", "ShippingMethod", "ShippingMethodParameter", "ShippingMethodCase", "ShippingCountry", "ShippingRegion", "ShippingPaymentRestriction", "Package", "ShippingPackage"); DataResult results = DataService.LoadDataSet(cmd); return((ShippingMethodDto)results.DataSet); }
/// <summary> /// Returns payment method by id. /// </summary> /// <param name="paymentMethodId">PaymentMethodId</param> /// <param name="returnInactive">if set to <c>true</c> [return inactive].</param> /// <returns></returns> public static PaymentMethodDto GetPaymentMethod(Guid paymentMethodId, bool returnInactive) { //TODO: cache results DataCommand cmd = OrderDataHelper.CreateConfigDataCommand(); cmd.CommandText = "[ecf_PaymentMethod_PaymentMethodId]"; cmd.Parameters = new DataParameters(); cmd.Parameters.Add(new DataParameter("ApplicationId", OrderConfiguration.Instance.ApplicationId, DataParameterType.UniqueIdentifier)); cmd.Parameters.Add(new DataParameter("PaymentMethodId", paymentMethodId, DataParameterType.UniqueIdentifier)); cmd.Parameters.Add(new DataParameter("ReturnInactive", returnInactive, DataParameterType.Bit)); cmd.DataSet = new PaymentMethodDto(); cmd.TableMapping = DataHelper.MapTables("PaymentMethod", "PaymentMethodParameter", "ShippingPaymentRestriction"); DataResult results = DataService.LoadDataSet(cmd); return((PaymentMethodDto)results.DataSet); }
/// <summary> /// Returns shippping method cases by shipping method id. /// </summary> /// <returns></returns> public static DataTable GetShippingMethodCases(Guid shippingMethodId, string countryCode, string stateProvinceCode, string zipPostalCode, string district, string county, string city, decimal?total) { DataCommand cmd = OrderDataHelper.CreateConfigDataCommand(); cmd.CommandText = "[ecf_ShippingMethod_GetCases]"; cmd.Parameters = new DataParameters(); cmd.Parameters.Add(new DataParameter("ShippingMethodId", shippingMethodId, DataParameterType.UniqueIdentifier)); cmd.Parameters.Add(new DataParameter("CountryCode", String.IsNullOrEmpty(countryCode) ? null : countryCode, DataParameterType.NVarChar, 50)); cmd.Parameters.Add(new DataParameter("Total", total, DataParameterType.Money)); cmd.Parameters.Add(new DataParameter("StateProvinceCode", String.IsNullOrEmpty(stateProvinceCode) ? null : stateProvinceCode, DataParameterType.NVarChar, 50)); cmd.Parameters.Add(new DataParameter("ZipPostalCode", String.IsNullOrEmpty(zipPostalCode) ? null : zipPostalCode, DataParameterType.NVarChar, 50)); cmd.Parameters.Add(new DataParameter("District", String.IsNullOrEmpty(district) ? null : district, DataParameterType.NVarChar, 50)); cmd.Parameters.Add(new DataParameter("County", String.IsNullOrEmpty(county) ? null : county, DataParameterType.NVarChar, 50)); cmd.Parameters.Add(new DataParameter("City", String.IsNullOrEmpty(city) ? null : city, DataParameterType.NVarChar, 50)); return(DataService.LoadTable(cmd)); }
/// <summary> /// Returns payment method by system name. /// </summary> /// <param name="name">PaymentMethod SystemKeyword</param> /// <param name="languageid">The languageid.</param> /// <param name="returnInactive">if set to <c>true</c> [return inactive].</param> /// <returns></returns> public static PaymentMethodDto GetPaymentMethodBySystemName(string name, string languageid, bool returnInactive) { //TODO: cache results DataCommand cmd = OrderDataHelper.CreateConfigDataCommand(); cmd.CommandText = "[ecf_PaymentMethod_SystemKeyword]"; cmd.Parameters = new DataParameters(); cmd.Parameters.Add(new DataParameter("ApplicationId", OrderConfiguration.Instance.ApplicationId, DataParameterType.UniqueIdentifier)); cmd.Parameters.Add(new DataParameter("SystemKeyword", name, DataParameterType.NVarChar, 30)); cmd.Parameters.Add(new DataParameter("LanguageId", languageid, DataParameterType.NVarChar, 128)); cmd.Parameters.Add(new DataParameter("ReturnInactive", returnInactive, DataParameterType.Bit)); cmd.DataSet = new PaymentMethodDto(); cmd.TableMapping = DataHelper.MapTables("PaymentMethod", "PaymentMethodParameter", "ShippingPaymentRestriction"); DataResult results = DataService.LoadDataSet(cmd); return((PaymentMethodDto)results.DataSet); }
/// <summary> /// Binds the report. /// </summary> private void BindReport() { DataCommand cmd = OrderDataHelper.CreateTranDataCommand(); cmd.CommandText = String.Format("SELECT E.[Name], I.* from [Inventory] I INNER JOIN [CatalogEntry] E ON E.Code = I.SkuId INNER JOIN Catalog C ON C.CatalogId = E.CatalogId WHERE (I.InstockQuantity - I.ReservedQuantity) < 20 AND I.InventoryStatus <> 0 AND C.ApplicationId = '{0}';", OrderConfiguration.Instance.ApplicationId); cmd.CommandType = CommandType.Text; cmd.Parameters = new DataParameters(); cmd.TableMapping = DataHelper.MapTables("EntryStock"); cmd.DataSet = new ProductDataSet(); DataResult results = DataService.LoadDataSet(cmd); ReportDataSource source = new ReportDataSource(); source.Name = "EntryStock"; source.Value = ((ProductDataSet)results.DataSet).EntryStock; MyReportViewer.LocalReport.DataSources.Add(source); MyReportViewer.DataBind(); }
public void PlaceOrder_ShouldInsertAnOrder_AndReturnTrue(string country, double expectedVat) { // Arrange. var customer = CustomerDataHelper.Add(GetCustomer(country)); var order = GetOrderDto(); var orderService = _container.Resolve <IOrderService>(); // Act. var result = orderService.PlaceOrder(order, customer.CustomerId); var insertedOrder = OrderDataHelper.GetOrder(order.OrderId); // Assert. Assert.IsTrue(result); Assert.IsNotNull(insertedOrder); Assert.AreEqual(customer.CustomerId, insertedOrder.CustomerId); Assert.AreEqual(order.OrderId, insertedOrder.OrderId); Assert.AreEqual(order.Amount, insertedOrder.Amount); Assert.AreEqual(expectedVat, insertedOrder.VAT); }
/// <summary> /// Gets the taxes. /// </summary> /// <returns></returns> public static TaxDto GetTaxDto(TaxType?type, string languageCode) { //TODO: cache results DataCommand cmd = OrderDataHelper.CreateConfigDataCommand(); cmd.CommandText = "[ecf_Tax]"; cmd.Parameters = new DataParameters(); cmd.Parameters.Add(new DataParameter("ApplicationId", OrderConfiguration.Instance.ApplicationId, DataParameterType.UniqueIdentifier)); if (type.HasValue) { cmd.Parameters.Add(new DataParameter("TaxType", type.Value.GetHashCode(), DataParameterType.Int)); } cmd.DataSet = new TaxDto(); cmd.TableMapping = DataHelper.MapTables("Tax", "TaxLanguage", "TaxValue"); DataResult results = DataService.LoadDataSet(cmd); return((TaxDto)results.DataSet); }
internal static TransactionData ToTransactionData(Token token, XmlNode tran) { string tranCode = string.Empty; Protocal.TransactionData tranData = TransactionParser.ParseTransaction(tran); tranData.PlaceByRiskMonitor = token.AppType == AppType.RiskMonitor ? true : false; tranData.Id = Guid.Parse(tran.Attributes["ID"].Value); tranData.Orders = new List <OrderData>(); InstrumentCategory instrumentCategory = InstrumentCategory.Forex; if (tran.Attributes["InstrumentCategory"] != null) { instrumentCategory = (InstrumentCategory)Enum.Parse(typeof(InstrumentCategory), tran.Attributes["InstrumentCategory"].Value); } foreach (XmlNode orderNode in tran.ChildNodes) { if (orderNode.Name == "Order") { OrderData orderData = null; if (tranData.OrderType == OrderType.BinaryOption) { orderData = OrderDataHelper.InitializeBOData(orderNode); } else if (instrumentCategory == InstrumentCategory.Forex) { orderData = OrderDataHelper.Initialize(orderNode); } else { orderData = OrderDataHelper.InitializePhysicalData(orderNode); } tranData.Orders.Add(orderData); } } return(tranData); }
/// <summary> /// Gets the jurisdictions and jurisdiction groups for the specified jurisdiction type. /// </summary> /// <param name="jurisdictionType">JurisdictionType. 1 - tax, 2 - shipping. null - all jurisdictions.</param> /// <returns></returns> public static JurisdictionDto GetJurisdictions(JurisdictionType?jurisdictionType) { // Assign new cache key, specific for site guid and response groups requested string cacheKey = OrderCache.CreateCacheKey("jurisdictions", jurisdictionType.HasValue ? jurisdictionType.Value.ToString() : String.Empty); JurisdictionDto dto = null; // check cache first object cachedObject = OrderCache.Get(cacheKey); if (cachedObject != null) { dto = (JurisdictionDto)cachedObject; } // Load the object if (dto == null) { DataCommand cmd = OrderDataHelper.CreateConfigDataCommand(); cmd.CommandText = "[ecf_Jurisdiction]"; cmd.Parameters = new DataParameters(); cmd.Parameters.Add(new DataParameter("ApplicationId", OrderConfiguration.Instance.ApplicationId, DataParameterType.UniqueIdentifier)); if (jurisdictionType.HasValue) { cmd.Parameters.Add(new DataParameter("JurisdictionType", jurisdictionType.Value.GetHashCode(), DataParameterType.Int)); } cmd.DataSet = new JurisdictionDto(); cmd.TableMapping = DataHelper.MapTables("Jurisdiction", "JurisdictionGroup", "JurisdictionRelation"); DataResult results = DataService.LoadDataSet(cmd); dto = (JurisdictionDto)results.DataSet; // Insert to the cache collection OrderCache.Insert(cacheKey, dto, OrderConfiguration.Instance.Cache.PaymentCollectionTimeout); } return(dto); }
/// <summary> /// Gets the shipping methods. /// </summary> /// <param name="languageid">The languageid.</param> /// <param name="returnInactive">if set to <c>true</c> [return inactive].</param> /// <returns></returns> public static ShippingMethodDto GetShippingMethods(string languageid, bool returnInactive) { // Assign new cache key, specific for site guid and response groups requested string cacheKey = OrderCache.CreateCacheKey("shipping-methods", languageid, returnInactive.ToString()); ShippingMethodDto dto = null; // check cache first object cachedObject = OrderCache.Get(cacheKey); if (cachedObject != null) { dto = (ShippingMethodDto)cachedObject; } // Load the object if (dto == null) { DataCommand cmd = OrderDataHelper.CreateConfigDataCommand(); cmd.CommandText = "[ecf_ShippingMethod_Language]"; cmd.Parameters = new DataParameters(); cmd.Parameters.Add(new DataParameter("ApplicationId", OrderConfiguration.Instance.ApplicationId, DataParameterType.UniqueIdentifier)); cmd.Parameters.Add(new DataParameter("LanguageId", String.IsNullOrEmpty(languageid) ? null : languageid, DataParameterType.NVarChar, 10)); cmd.Parameters.Add(new DataParameter("ReturnInactive", returnInactive, DataParameterType.Bit)); cmd.DataSet = new ShippingMethodDto(); cmd.TableMapping = DataHelper.MapTables("ShippingOption", "ShippingOptionParameter", "ShippingMethod", "ShippingMethodParameter", "ShippingMethodCase", "ShippingCountry", "ShippingRegion", "ShippingPaymentRestriction", "Package", "ShippingPackage"); DataResult results = DataService.LoadDataSet(cmd); dto = (ShippingMethodDto)results.DataSet; // Insert to the cache collection OrderCache.Insert(cacheKey, dto, OrderConfiguration.Instance.Cache.ShippingCollectionTimeout); } return(dto); }
/// <summary> /// Binds the report. /// </summary> private void BindReport() { DataCommand cmd = OrderDataHelper.CreateTranDataCommand(); cmd.CommandText = "[ecf_reporting_CustomerNumOrders]"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters = new DataParameters(); cmd.Parameters.Add(new DataParameter("ApplicationId", CatalogConfiguration.Instance.ApplicationId, DataParameterType.UniqueIdentifier)); cmd.Parameters.Add(new DataParameter("interval", GroupBy.SelectedValue, DataParameterType.VarChar)); cmd.Parameters.Add(new DataParameter("startdate", StartDate.Value.ToUniversalTime(), DataParameterType.DateTime)); cmd.Parameters.Add(new DataParameter("enddate", EndDate.Value.ToUniversalTime(), DataParameterType.DateTime)); cmd.TableMapping = DataHelper.MapTables("CustomerNumOrdersReport"); cmd.DataSet = new CustomersDataSet(); DataResult results = DataService.LoadDataSet(cmd); ReportDataSource source = new ReportDataSource(); source.Name = "CustomerNumOrdersReport"; source.Value = ((CustomersDataSet)results.DataSet).CustomerNumOrdersReport; MyReportViewer.LocalReport.DataSources.Clear(); MyReportViewer.LocalReport.DataSources.Add(source); MyReportViewer.DataBind(); }
public void GetAllCustomersWithOrders_ShouldReturnCustomersAndOrders() { // Arrange. var customerOne = CustomerDataHelper.Add(GetCustomer("UK")); var orderOne = OrderDataHelper.AddOrder(GetOrder(customerOne.CustomerId)); var orderTwo = OrderDataHelper.AddOrder(GetOrder(customerOne.CustomerId)); var customerTwo = CustomerDataHelper.Add(GetCustomer("FR")); var orderThree = OrderDataHelper.AddOrder(GetOrder(customerTwo.CustomerId)); var customerOrderService = _container.Resolve <ICustomerOrderService>(); // Act. var results = customerOrderService.GetAllCustomerWithOrders(); var customerOneResult = results.First(c => c.Customer.CustomerId == customerOne.CustomerId); var customerTwoResult = results.First(c => c.Customer.CustomerId == customerTwo.CustomerId); // Assert. Assert.AreEqual(2, customerOneResult.Orders.Count()); Assert.AreEqual(1, customerTwoResult.Orders.Count()); Assert.IsTrue(customerOneResult.Orders.Any(o => o.OrderId == orderOne.OrderId)); Assert.IsTrue(customerOneResult.Orders.Any(o => o.OrderId == orderTwo.OrderId)); Assert.IsTrue(customerTwoResult.Orders.Any(o => o.OrderId == orderThree.OrderId)); }
/// <summary> /// Gets the countries. /// </summary> /// <param name="returnInactive">If true, all countries will be returned, otherwise only visible.</param> /// <returns></returns> public static CountryDto GetCountries(bool returnInactive) { // Assign new cache key, specific for site guid and response groups requested string cacheKey = OrderCache.CreateCacheKey("countries", returnInactive.ToString()); CountryDto dto = null; // check cache first object cachedObject = OrderCache.Get(cacheKey); if (cachedObject != null) { dto = (CountryDto)cachedObject; } // Load the object if (dto == null) { DataCommand cmd = OrderDataHelper.CreateConfigDataCommand(); cmd.CommandText = "[ecf_Country]"; cmd.Parameters = new DataParameters(); cmd.Parameters.Add(new DataParameter("ApplicationId", OrderConfiguration.Instance.ApplicationId, DataParameterType.UniqueIdentifier)); cmd.Parameters.Add(new DataParameter("ReturnInactive", returnInactive, DataParameterType.Bit)); cmd.DataSet = new CountryDto(); cmd.TableMapping = DataHelper.MapTables("Country", "StateProvince"); DataResult results = DataService.LoadDataSet(cmd); dto = (CountryDto)results.DataSet; // Insert to the cache collection OrderCache.Insert(cacheKey, dto, OrderConfiguration.Instance.Cache.CountryCollectionTimeout); } return(dto); }