protected override void OnModelCreating(ModelBuilder modelBuilder) { base.OnModelCreating(modelBuilder); BuyerConfiguration.Config(modelBuilder); OrderConfiguration.Config(modelBuilder); }
public ResponseModel UpdateOrderConfiguration([FromBody] OrderConfiguration orderConfiguration) { int UpdateCount = 0; HSOrderCaller hSOrderCaller = new HSOrderCaller(); ResponseModel objResponseModel = new ResponseModel(); int statusCode = 0; string statusMessage = ""; try { string token = Convert.ToString(Request.Headers["X-Authorized-Token"]); Authenticate authenticate = new Authenticate(); authenticate = SecurityService.GetAuthenticateDataFromToken(_radisCacheServerAddress, SecurityService.DecryptStringAES(token)); UpdateCount = hSOrderCaller.UpdateOrderConfiguration(new HSOrderService(_connectionString), orderConfiguration, authenticate.UserMasterID); statusCode = UpdateCount.Equals(0) ? (int)EnumMaster.StatusCode.RecordNotFound : (int)EnumMaster.StatusCode.Success; statusMessage = CommonFunction.GetEnumDescription((EnumMaster.StatusCode)statusCode); objResponseModel.Status = true; objResponseModel.StatusCode = statusCode; objResponseModel.Message = statusMessage; objResponseModel.ResponseData = UpdateCount; } catch (Exception) { throw; } return(objResponseModel); }
private void AddOrderConfiguration(ApplicationDbContext context) { var item = new OrderConfiguration() { MinBikeQuantity = 24, MaxDiscount = 95 }; context.OrderConfigurations.AddOrUpdate(item); }
public int UpdateOrderConfiguration(OrderConfiguration orderConfiguration, int modifiedBy) { int UpdateCount = 0; try { conn.Open(); MySqlCommand cmd = new MySqlCommand("SP_PHYUpdateOrderConfiguration", conn) { Connection = conn }; cmd.Parameters.AddWithValue("@_ID", orderConfiguration.ID); cmd.Parameters.AddWithValue("@_IntegratedSystem", Convert.ToInt16(orderConfiguration.IntegratedSystem)); cmd.Parameters.AddWithValue("@_Payment", Convert.ToInt16(orderConfiguration.Payment)); cmd.Parameters.AddWithValue("@_Shipment", Convert.ToInt16(orderConfiguration.Shipment)); cmd.Parameters.AddWithValue("@_ShoppingBag", Convert.ToInt16(orderConfiguration.ShoppingBag)); cmd.Parameters.AddWithValue("@_StoreDelivery", Convert.ToInt16(orderConfiguration.StoreDelivery)); cmd.Parameters.AddWithValue("@_AlertCommunicationviaWhtsup", Convert.ToInt16(orderConfiguration.AlertCommunicationviaWhtsup)); cmd.Parameters.AddWithValue("@_AlertCommunicationviaSMS", Convert.ToInt16(orderConfiguration.AlertCommunicationviaSMS)); cmd.Parameters.AddWithValue("@_AlertCommunicationviaSMSText", orderConfiguration.AlertCommunicationSMSText); cmd.Parameters.AddWithValue("@_EnableClickAfterValue", Convert.ToInt16(orderConfiguration.EnableClickAfterValue)); cmd.Parameters.AddWithValue("@_EnableClickAfterDuration", orderConfiguration.EnableClickAfterDuration); cmd.Parameters.AddWithValue("@_ShoppingBagConvertToOrder", Convert.ToInt16(orderConfiguration.ShoppingBagConvertToOrder)); cmd.Parameters.AddWithValue("@_ShoppingBagConvertToOrderText", orderConfiguration.ShoppingBagConvertToOrderText); cmd.Parameters.AddWithValue("@_AWBAssigned", Convert.ToInt16(orderConfiguration.AWBAssigned)); cmd.Parameters.AddWithValue("@_AWBAssignedText", orderConfiguration.AWBAssignedText); cmd.Parameters.AddWithValue("@_PickupScheduled", Convert.ToInt16(orderConfiguration.PickupScheduled)); cmd.Parameters.AddWithValue("@_PickupScheduledText", orderConfiguration.PickupScheduledText); cmd.Parameters.AddWithValue("@_Shipped", Convert.ToInt16(orderConfiguration.Shipped)); cmd.Parameters.AddWithValue("@_ShippedText", orderConfiguration.ShippedText); cmd.Parameters.AddWithValue("@_Delivered", Convert.ToInt16(orderConfiguration.Delivered)); cmd.Parameters.AddWithValue("@_DeliveredText", orderConfiguration.DeliveredText); cmd.Parameters.AddWithValue("@_ModifiedBy", modifiedBy); cmd.CommandType = CommandType.StoredProcedure; UpdateCount = Convert.ToInt32(cmd.ExecuteNonQuery()); } catch (Exception) { throw; } finally { if (conn != null) { conn.Close(); } } return(UpdateCount); }
public void UpdateOrderConfiguration(Order order, IEnumerable <short> optionIds) { var optionsToDelete = DataContext.OrderConfigurations.Where(x => x.OrderID == order.ID); foreach (var opt in optionsToDelete) { DataContext.OrderConfigurations.Remove(opt); } DataContext.SaveChanges(); foreach (var id in optionIds) { var opt = new OrderConfiguration { OrderID = order.ID, OptionID = id }; DataContext.OrderConfigurations.Add(opt); } DataContext.SaveChanges(); var orderType = DataContext.OrderTypes.SingleOrDefault(x => x.ID == order.TypeID); var name = string.Format("ELCUT {0}", orderType.Name); var configurations = DataContext.OrderConfigurations .Where(x => x.OrderID == order.ID && x.Option.ParentID == null) .Include(x => x.Option) .Include(x => x.Option.Options); foreach (var opt in configurations) { name += ", " + opt.Option.Name; foreach (var child in opt.Option.Options) { name += " +" + child.Name; } name.Trim(",".ToCharArray()); } order.ConfigurationName = name; DataContext.SaveChanges(); order.Price = order.CalculatePrice(); DataContext.SaveChanges(); }
public void CanLoadOrders() { var order1 = new OrderConfiguration() { Base = "BTC", Symbol = "XRP", LossStop = 11m, ProfitStop = 8m, BuyAmount = 1m }; var order2 = new OrderConfiguration() { Base = "LTC", Symbol = "BTC", LossStop = 15m, ProfitStop = 12m, BuyAmount = 2.5m }; var loader = Container.Resolve <IOrdersLoader>(); Assert.True(loader.Orders.Count == 2); var firstOrder = loader.Orders[0]; var secondOrder = loader.Orders[1]; var firstOrdersEqual = order1.Base.Equals(firstOrder.Base) && order1.Symbol.Equals(firstOrder.Symbol) && order1.ProfitStop.Equals(firstOrder.ProfitStop) && order1.LossStop.Equals(firstOrder.LossStop) && order1.BuyAmount.Equals(firstOrder.BuyAmount); Assert.True(firstOrdersEqual); var secondOrdersEqual = order2.Base.Equals(secondOrder.Base) && order2.Symbol.Equals(secondOrder.Symbol) && order2.ProfitStop.Equals(secondOrder.ProfitStop) && order2.LossStop.Equals(secondOrder.LossStop) && order2.BuyAmount.Equals(secondOrder.BuyAmount); Assert.True(secondOrdersEqual); }
protected override void OnModelCreating(ModelBuilder modelBuilder) { modelBuilder.HasDefaultSchema("efcore"); CategoryConfiguration.Configure(modelBuilder.Entity <Category>()); ShipperConfiguration.Configure(modelBuilder.Entity <Shipper>()); RegionConfiguration.Configure(modelBuilder.Entity <Region>()); SupplierConfiguration.Configure(modelBuilder.Entity <Supplier>()); EmployeeConfiguration.Configure(modelBuilder.Entity <Employee>()); CustomerDemographicsConfiguration.Configure(modelBuilder.Entity <CustomerDemoGraphic>()); CustomerConfiguration.Configure(modelBuilder.Entity <Customer>()); OrderConfiguration.Configure(modelBuilder.Entity <Order>()); ProductConfiguration.Configure(modelBuilder.Entity <Product>()); TerritoryConfiguration.Configure(modelBuilder.Entity <Territories>()); EmployeeTerritoryConfiguration.Configure(modelBuilder.Entity <EmployeeTerritories>()); CustomerCustomerDemographConfiguration.Configure(modelBuilder.Entity <CustomerCustomerDemograph>()); OrderDetailConfiguration.Configure(modelBuilder.Entity <OrderDetail>()); base.OnModelCreating(modelBuilder); }
public OrderCalulationResult CalculateCost(Order order) { OrderConfiguration orderConfiguration = order.Configuration; double hoursSpent = CalculateHoursSpent(order); double driversJobCost = CalculateCostOfDriversJob(hoursSpent, orderConfiguration.DriverJobCostPerHour); double fuelCost = CalculateFuelCost(order.Distance, orderConfiguration.FuelLiterCost, orderConfiguration.AverageFuelConsumptionPerHundredKilometers); double vehicleAmortization = CalculateVehicleAmortization(fuelCost); double fullCost = driversJobCost + fuelCost + vehicleAmortization; OrderCalulationResult orderCalulationResult = new OrderCalulationResult { EndTime = order.StartTime.AddHours(hoursSpent), DriversJobCost = driversJobCost, FuelCost = fuelCost, VehicleAmortization = vehicleAmortization, FullCost = fullCost }; return(orderCalulationResult); }
protected override void OnModelCreating(ModelBuilder builder) { CustomerConfiguration.Configure(builder); OrderConfiguration.Configure(builder); base.OnModelCreating(builder); var entityTypes = builder.Model .GetEntityTypes() .ToList(); // Set global query filter for not deleted entities only // Disable cascade delete var foreignKeys = entityTypes .SelectMany(e => e.GetForeignKeys() .Where(f => f.DeleteBehavior == DeleteBehavior.Cascade)); foreach (var foreignKey in foreignKeys) { foreignKey.DeleteBehavior = DeleteBehavior.Restrict; } }
public OrderConfiguration GetOrderConfiguration(int tenantId, int userId, string programCode) { DataSet ds = new DataSet(); OrderConfiguration moduleConfiguration = new OrderConfiguration(); try { conn.Open(); MySqlCommand cmd = new MySqlCommand("SP_PHYGetOrderConfiguration", conn) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@_tenantID", tenantId); cmd.Parameters.AddWithValue("@_prgramCode", programCode); MySqlDataAdapter da = new MySqlDataAdapter { SelectCommand = cmd }; da.Fill(ds); if (ds != null && ds.Tables[0] != null) { if (ds.Tables[0].Rows.Count > 0) { moduleConfiguration.ID = Convert.ToInt32(ds.Tables[0].Rows[0]["ID"]); moduleConfiguration.IntegratedSystem = ds.Tables[0].Rows[0]["IntegratedSystem"] == DBNull.Value ? false : Convert.ToBoolean(ds.Tables[0].Rows[0]["IntegratedSystem"]); moduleConfiguration.Payment = ds.Tables[0].Rows[0]["Payment"] == DBNull.Value ? false : Convert.ToBoolean(ds.Tables[0].Rows[0]["Payment"]); moduleConfiguration.Shipment = ds.Tables[0].Rows[0]["Shipment"] == DBNull.Value ? false : Convert.ToBoolean(ds.Tables[0].Rows[0]["Shipment"]); moduleConfiguration.ShoppingBag = ds.Tables[0].Rows[0]["ShoppingBag"] == DBNull.Value ? false : Convert.ToBoolean(ds.Tables[0].Rows[0]["ShoppingBag"]); moduleConfiguration.EnableClickAfterValue = ds.Tables[0].Rows[0]["EnableClickAfterValue"] == DBNull.Value ? 0 : Convert.ToInt16(ds.Tables[0].Rows[0]["EnableClickAfterValue"]); moduleConfiguration.EnableClickAfterDuration = ds.Tables[0].Rows[0]["EnableClickAfterDuration"] == DBNull.Value ? "" : Convert.ToString(ds.Tables[0].Rows[0]["EnableClickAfterDuration"]); moduleConfiguration.StoreDelivery = ds.Tables[0].Rows[0]["StoreDelivery"] == DBNull.Value ? false : Convert.ToBoolean(ds.Tables[0].Rows[0]["StoreDelivery"]); moduleConfiguration.AlertCommunicationviaWhtsup = ds.Tables[0].Rows[0]["AlertCommunicationviaWhtsup"] == DBNull.Value ? false : Convert.ToBoolean(ds.Tables[0].Rows[0]["AlertCommunicationviaWhtsup"]); moduleConfiguration.AlertCommunicationviaSMS = ds.Tables[0].Rows[0]["AlertCommunicationviaSMS"] == DBNull.Value ? false : Convert.ToBoolean(ds.Tables[0].Rows[0]["AlertCommunicationviaSMS"]); moduleConfiguration.AlertCommunicationSMSText = ds.Tables[0].Rows[0]["AlertCommunicationSMSText"] == DBNull.Value ? "" : Convert.ToString(ds.Tables[0].Rows[0]["AlertCommunicationSMSText"]); moduleConfiguration.ShoppingBagConvertToOrder = ds.Tables[0].Rows[0]["ShoppingBagConvertToOrder"] == DBNull.Value ? false : Convert.ToBoolean(ds.Tables[0].Rows[0]["ShoppingBagConvertToOrder"]); moduleConfiguration.ShoppingBagConvertToOrderText = ds.Tables[0].Rows[0]["ShoppingBagConvertToOrderText"] == DBNull.Value ? "" : Convert.ToString(ds.Tables[0].Rows[0]["ShoppingBagConvertToOrderText"]); moduleConfiguration.AWBAssigned = ds.Tables[0].Rows[0]["AWBAssigned"] == DBNull.Value ? false : Convert.ToBoolean(ds.Tables[0].Rows[0]["AWBAssigned"]); moduleConfiguration.AWBAssignedText = ds.Tables[0].Rows[0]["AWBAssignedText"] == DBNull.Value ? "" : Convert.ToString(ds.Tables[0].Rows[0]["AWBAssignedText"]); moduleConfiguration.PickupScheduled = ds.Tables[0].Rows[0]["PickupScheduled"] == DBNull.Value ? false : Convert.ToBoolean(ds.Tables[0].Rows[0]["PickupScheduled"]); moduleConfiguration.PickupScheduledText = ds.Tables[0].Rows[0]["PickupScheduledText"] == DBNull.Value ? "" : Convert.ToString(ds.Tables[0].Rows[0]["PickupScheduledText"]); moduleConfiguration.Shipped = ds.Tables[0].Rows[0]["Shipped"] == DBNull.Value ? false : Convert.ToBoolean(ds.Tables[0].Rows[0]["Shipped"]); moduleConfiguration.ShippedText = ds.Tables[0].Rows[0]["ShippedText"] == DBNull.Value ? "" : Convert.ToString(ds.Tables[0].Rows[0]["ShippedText"]); moduleConfiguration.Delivered = ds.Tables[0].Rows[0]["Delivered"] == DBNull.Value ? false : Convert.ToBoolean(ds.Tables[0].Rows[0]["Delivered"]); moduleConfiguration.DeliveredText = ds.Tables[0].Rows[0]["DeliveredText"] == DBNull.Value ? "" : Convert.ToString(ds.Tables[0].Rows[0]["DeliveredText"]); } } } catch (Exception) { throw; } finally { if (conn != null) { conn.Close(); } if (ds != null) { ds.Dispose(); } } return(moduleConfiguration); }
public int UpdateOrderConfiguration(IHSOrder order, OrderConfiguration orderConfiguration, int modifiedBy) { _OrderRepository = order; return(_OrderRepository.UpdateOrderConfiguration(orderConfiguration, modifiedBy)); }
/// <summary> /// Restores the meta data. /// </summary> private static void RestoreMetaData() { OrderConfiguration.ConfigureMetaData(); }