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)); }