public Int32 Insert(DeliveryStop deliveryStop)
{
if (deliveryStop == null)
{
throw new ArgumentNullException(nameof(deliveryStop));
}
return(_cn.Insert(deliveryStop));
}
//-------------------------------------------------------
// add new stop data
public int AddNewStopSata(DeliveryStop deliveryStop)
{
using (var Connection = new SqlConnection(ConfigurationManager.ConnectionStrings["FuelDelivery"].ConnectionString))
{
Connection.Open();
var result = Connection.ExecuteScalar <int>(@"INSERT INTO [dbo].[DeliveryStop]([customerId],[deliveryEventId],[noOfGallons])
VALUES (@customerId, @deliveryEventId, @noOfGallons)"
, deliveryStop);
return(result);
}
}
public HttpResponseMessage AddNewStop(DeliveryStop deliveryStop)
{
try
{
var newStop = new DeliveryStopDataAccess();
var newRow = newStop.AddNewStopSata(deliveryStop);
return(Request.CreateResponse(HttpStatusCode.OK, "New stop added "));
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
}
void SeedDatabase()
{
var dg = new DataGenerator();
_cn.BeginTransaction();
var p = new Product();
p.Description = "Fresh Organic Raw Milk";
p.Price = 5.99d;
p.Icon = "milk.png";
p.UnitOfMeasure = "gal";
_productService.Insert(p);
p = new Product();
p.Description = "Light Buffalo Mozzarella";
p.Price = 6.75;
p.Icon = "mozzarella.png";
p.UnitOfMeasure = "lbs";
_productService.Insert(p);
p = new Product();
p.Description = "Organic Unsalted Butter";
p.Price = 4.99;
p.Icon = "butter.png";
p.UnitOfMeasure = "lbs";
_productService.Insert(p);
p = new Product();
p.Description = "Free-range Eggs";
p.Price = 3.99;
p.Icon = "eggs.png";
p.UnitOfMeasure = "dz";
_productService.Insert(p);
for (var i = 0; i < 20; i++)
{
var c = new Customer();
c.Address = $"{dg.GetInteger(10, 1000)} {dg.GetStreet()}";
c.CityStateZip = "Cranbury, NJ 08520";
if (i % 2 == 0)
{
c.AddressType = Constants.Residence;
c.Name = dg.GetFullName();
}
else
{
c.AddressType = Constants.Business;
c.Name = dg.GetCompanyName();
}
_customerService.Insert(c);
}
var products = _productService.GetAll();
var customers = _customerService.GetAll();
var currentCustomer = 0;
for (var i = -735; i < 0; i++)
{
var hourDelivered = 8;
for (var j = 0; j < 9; j++)
{
var itemsDelivered = 0;
var revenue = 0.0d;
var milesDriven = 0;
var o = new Order();
o.CustomerId = customers[currentCustomer].Id;
o.DateOrdered = DateTime.Today.AddDays(i - 7);
o.DateScheduledDelivery = DateTime.Today.AddDays(i);
o.DateDelivered = new DateTime(o.DateScheduledDelivery.Year, o.DateScheduledDelivery.Month, o.DateScheduledDelivery.Day, j + 8, hourDelivered, dg.GetInteger(0, 59));
hourDelivered += 1;
o.OrderStatus = OrderStatus.Completed;
var items = new List <OrderItem>();
for (var k = 0; k < 4; k++)
{
var oo = new OrderItem();
oo.ProductId = products[k].Id;
if (customers[currentCustomer].AddressType == Constants.Business)
{
oo.Quantity = dg.GetInteger(5, 40);
if (i < -365)
{
oo.Quantity = oo.Quantity - dg.GetInteger(0, 5);
if (oo.Quantity < 1)
{
oo.Quantity = 1;
}
}
}
else
{
oo.Quantity = dg.GetInteger(1, 5);
if (i < -365)
{
oo.Quantity = oo.Quantity - dg.GetInteger(0, 2);
if (oo.Quantity < 1)
{
oo.Quantity = 1;
}
}
}
oo.ExtendedPrice = oo.Quantity * products[0].Price;
oo.OrderItemStatus = OrderItemStatus.Delivered;
items.Add(oo);
itemsDelivered += oo.Quantity;
revenue += oo.ExtendedPrice;
milesDriven += dg.GetInteger(5, 12);
}
var averageSpeed = dg.GetInteger(35, 50);
var fuelEfficiency = dg.GetInteger(25, 30);
_orderService.Insert(o, items);
var dh = new DeliveryHistory();
dh.OrderId = o.Id;
dh.CustomerId = o.CustomerId;
dh.AverageSpeed = averageSpeed;
dh.DateDelivered = o.DateDelivered.Value;
dh.FuelEfficiency = fuelEfficiency;
dh.ItemsDelivered = itemsDelivered;
dh.MileDriven = milesDriven;
dh.Revenue = revenue;
_deliveryHistoryService.Insert(dh);
currentCustomer += 1;
if (currentCustomer > customers.Count - 1)
{
currentCustomer = 0;
}
}
}
var ht = new HashSet <Int32>();
var maxCustomerId = customers.Count - 1;
var routeStopNumber = 1;
for (var i = 0; i < 11; i++)
{
var customerIndex = -1;
while (customerIndex == -1)
{
var test = dg.GetInteger(0, maxCustomerId);
if (!ht.Contains(test))
{
customerIndex = test;
ht.Add(test);
}
}
var o = new Order();
o.CustomerId = customers[customerIndex].Id;
o.DateOrdered = DateTime.Today.AddDays(-7);
o.DateScheduledDelivery = DateTime.Today;
o.OrderStatus = OrderStatus.New;
var items = new List <OrderItem>();
for (var k = 0; k < 4; k++)
{
var oo = new OrderItem();
oo.ProductId = products[k].Id;
if (customers[customerIndex].AddressType == Constants.Business)
{
oo.Quantity = dg.GetInteger(5, 25);
}
else
{
oo.Quantity = dg.GetInteger(1, 5);
}
oo.ExtendedPrice = oo.Quantity * products[0].Price;
oo.OrderItemStatus = OrderItemStatus.NotDelivered;
items.Add(oo);
}
_orderService.Insert(o, items);
var ds = new DeliveryStop();
ds.DateDelivery = o.DateScheduledDelivery;
ds.MileageFromPreviousStop = dg.GetInteger(5, 25);
ds.OrderId = o.Id;
ds.RouteStopNumber = routeStopNumber;
_deliveryStopService.Insert(ds);
routeStopNumber += 1;
}
_cn.Commit();
}
public ActionResult Details(int id)
{
DeliveryStop deliveryStop = db.deliveryStop.Find(id);
return(View(deliveryStop));
}
