public SiteArea GetSiteArea(String siteAreaId)
{
using (SqlConnection connection = this.getProductConnection())
{
SiteArea area = null;
//
DynamicParameters dp = new DynamicParameters();
dp.Add("@siteAreaId", siteAreaId);
connection.Query <SiteArea, PirchImage, int>(
@"select Inventory.SiteArea.*, Inventory.SiteAreaImage.SiteAreaImageId as ImageId, Inventory.SiteAreaImage.ImageUrl, Inventory.SiteAreaImage.Sequence
from Inventory.SiteArea left join Inventory.SiteAreaImage on Inventory.SiteArea.DefaultSiteAreaImageId = Inventory.SiteAreaImage.SiteAreaImageId
where Inventory.SiteArea.SiteAreaId = @siteAreaId",
param: dp,
map: (sitearea, image) =>
{
//
sitearea.ImageIndexOrAdd(image.ImageUrl);
area = sitearea;
//
return(1);
},
splitOn: "ImageId"
);
//
return(area);
}
}
public ActionResult GetProductForSiteArea(String siteArea)
{
ProductService serv = WebServiceUtils.GetEndpointService <ProductService>(ProductServiceInfo.ENDPOINT_NAME);
SiteArea area = serv.ProductsForSiteArea(siteArea);
ViewBag.siteArea = area;
return(View());
}
// TODO - Add pricing
public SiteArea ProductsForSiteArea(SiteArea siteArea)
{
using (SqlConnection connection = this.getProductConnection()) {
// populate the site area's products list
DynamicParameters dp = new DynamicParameters();
dp.Add("@siteareaid", siteArea.SiteAreaId);
connection.Query <PirchProduct, PirchImage, PirchSeries, PirchBrand, int>(
// This still needs to account for sequence
@"select
ProductCatalog.Product.*, ProductCatalog.ProductImage.ProductImageId as ImageId, ProductCatalog.ProductImage.ImageUrl, ProductCatalog.ProductImage.Sequence,
ProductCatalog.BrandSeries.BrandSeriesId, ProductCatalog.BrandSeries.BrandId, ProductCatalog.BrandSeries.Name, ProductCatalog.BrandSeries.Description,
ProductCatalog.Brand.BrandId as BrandSplit, ProductCatalog.Brand.ManufacturerId, ProductCatalog.Brand.Name, ProductCatalog.Brand.Description
from
Inventory.ProductBin join ProductCatalog.Product on Inventory.ProductBin.ProductId = ProductCatalog.Product.ProductId
full outer join ProductCatalog.ProductImage on ProductCatalog.Product.ProductId = ProductCatalog.ProductImage.ProductId
left join ProductCatalog.BrandSeries on ProductCatalog.Product.BrandSeriesId = ProductCatalog.BrandSeries.BrandSeriesId
left join ProductCatalog.Brand on ProductCatalog.BrandSeries.BrandId = ProductCatalog.Brand.BrandId
left join ProductCatalog.Manufacturer on ProductCatalog.Brand.ManufacturerId = ProductCatalog.Manufacturer.ManufacturerId
where
Inventory.ProductBin.SiteAreaId = @siteareaid",
param: dp,
map: (product, image, series, brand) => {
if (product != null)
{
if (product.ProductId != null)
{
product.ImagesIndexOrAdd(image);
product.series = series;
product.brand = brand;
int i = siteArea.ProductTypeIndexOrAddByGuid(this.ProductTypeForPirchProduct(product));
if (i != -1)
{
this.AddPirchProductImagesToProductType(siteArea.ProductTypes[i], product);
}
}
}
return(1);
},
splitOn: "ImageId, BrandSeriesId, BrandSplit"
);
//
return(siteArea);
}
}
public static void SeedDataContext(this ParkingSiteDbContext context)
{
string[] valueLines = System.IO.File.ReadAllLines(@"e:\Value1.CSV");
var parkingSites = new List <ParkingSite>();
foreach (var line in valueLines)
{
var column = line.Split(',');
int i = -1;
Int32.TryParse(column[5], out i);
ParkingSite p = new ParkingSite
{
Parm1 = column[1],
Parm2 = column[2],
Parm3 = column[3],
API = column[4],
NumberOfSpaces = i
};
parkingSites.Add(p);
}
context.AddRange(parkingSites);
context.SaveChanges();
var siteLines = System.IO.File.ReadAllLines(@"e:\Key1.CSV");
var siteAreaKeys = new List <SiteArea>();
foreach (var line in siteLines)
{
int areaId;
var column = line.Split(',');
var parkingArea = new ParkingArea
{
AreaName = column[1]
};
context.Add(parkingArea);
context.SaveChanges();
var area = context.ParkingAreas.Where(pa => pa.AreaName == parkingArea.AreaName).FirstOrDefault();
if (area != null)
{
areaId = area.Id;
}
else
{
areaId = 0;
};
var sites = column[3].Split(' ');
foreach (var site in sites)
{
int i = Int32.Parse(site);
string[] siteLine = valueLines[i - 1].Split(',');
string sitesId = siteLine[1];
var aSite = context.ParkingSite.Where(s => s.Parm1 == sitesId).FirstOrDefault();
if (aSite != null && areaId != 0)
{
var siteArea = new SiteArea();
siteArea.AreaId = areaId;
siteArea.SiteId = aSite.Id;
context.Add(siteArea);
context.SaveChanges();
}
int z = 0;
}
}
// context.AddRange(parkingAreas);
// context.SaveChanges();
int y = 0;
}
public SiteArea ProductsForSiteArea(String siteAreaId)
{
SiteArea area = this.GetSiteArea(siteAreaId);
return(this.ProductsForSiteArea(area));
}
internal SiteArea ProductsForSiteArea(SiteArea siteArea)
{
ProductService productService = WebServiceUtils.GetEndpointService <ProductService>(ProductServiceInfo.ENDPOINT_NAME);
return(productService.ProductsForSiteArea(siteArea));
}
