public SKUIndexViewItem(Model.SKU sku, Model.Vendor vendor, Model.PrivateKey privateKey, IEnumerable <Model.SkuFeature> skuFeatures)
: base(sku)
{
VendorName = vendor.Name;
PrivateKeyName = privateKey.DisplayName;
FeatureSummary = skuFeatures.ToSummary(x => x.Feature.FeatureName, 3, ", ");
}
/// <summary>
/// Construct the viewmodel
/// </summary>
/// <param name="privateKeyList">List of privateKey entities</param>
/// <param name="parentVendor">Vendor entity that ownes these private keys</param>
public PrivateKeyIndexViewModel(List <Model.PrivateKey> privateKeyList, Model.Vendor parentVendor) : this()
{
PrivateKeys = new List <PrivateKeyViewModel>();
foreach (Model.PrivateKey entity in privateKeyList)
{
PrivateKeys.Add(new PrivateKeyViewModel(entity));
}
ParentVendorGUID = parentVendor.ObjectId;
}
/// <summary>
/// Construct viewmodel
/// </summary>
/// <param name="vendor">Vendor that this viewmodel represents</param>
public VendorViewModel(Model.Vendor vendor) : this()
{
this.ObjectId = vendor.ObjectId;
this.Name = vendor.Name;
this.Street = vendor.Street;
this.PostalCode = vendor.PostalCode;
this.City = vendor.City;
this.Region = vendor.Region;
this.CountryCode = vendor.CountryCode;
}
public View.Vendor Build(Model.Vendor vendor)
{
return(new View.Vendor
{
VendorGuid = vendor.VendorGuid,
Name = vendor.Name,
CreatedOn = vendor.CreatedOn.ToString(),
UpdatedOn = vendor.UpdatedOn.ToString()
});
}
/// <summary>
/// Convert back to Vendor instance
/// </summary>
/// <param name="original">Original Vendor. If Null a new instance is created.</param>
/// <returns>Vendor containing viewmodel data </returns>
public Model.Vendor ToEntity(Model.Vendor original)
{
Model.Vendor current = original ?? new Model.Vendor();
current.Name = this.Name;
current.Street = this.Street;
current.PostalCode = this.PostalCode;
current.City = this.City;
current.Region = this.Region;
current.CountryCode = this.CountryCode;
return(current);
}
public VendorIndexViewItem(Model.Vendor vendor, Model.Country country)
: base(vendor)
{
ObjectId = vendor.ObjectId;
CountryName = country.CountryName;
}
/// <summary>
/// Convert back to Vendor instance
/// </summary>
/// <param name="original">Original Vendor. If Null a new instance is created.</param>
/// <returns>Vendor containing viewmodel data </returns>
public Model.Vendor ToEntity(Model.Vendor original)
{
return(Vendor.ToEntity(original));
}
/// <summary>
/// Construct the viewmodel
/// </summary>
/// <param name="vendor">Vendor entity</param>
/// <param name="countries">Country query for selectionlist</param>
public VendorEditViewModel(Model.Vendor vendor, List <Model.Country> countries)
{
Vendor = new VendorViewModel(vendor);
CountryList = countries.ToSelectList(c => c.CountryCode, c => c.CountryName);
}
/// <summary>
/// Construct the viewmodel
/// </summary>
/// <param name="vendor">Vendor of this PrivateKey</param>
public PrivateKeyCreateViewModel(Model.Vendor vendor)
{
VendorId = vendor.ObjectId;
}
public VendorDetailsViewItem(Model.Vendor vendor, Model.Country country)
: base(vendor)
{
CountryName = country.CountryName;
}
/// <summary>
/// Construct the viewmodel
/// </summary>
/// <param name="vendor">Vendor entity</param>
public VendorDetailsViewModel(Model.Vendor vendor)
: this()
{
Vendor = new VendorDetailsViewItem(vendor, vendor.Country);
}
public FeatureIndexViewItem(Model.Feature feature, Model.Vendor vendor)
: base(feature)
{
VendorName = vendor.Name;
}
private static void LoadMySQLEntries()
{
using (ProductsDBContext sqlContext = new ProductsDBContext())
{
ProductsDBModel mySQLContext = new ProductsDBModel(@"Server=localhost;Database=products_db;Uid=Rami;Pwd=killer91;");
foreach (var measure in mySQLContext.Measures)
{
ProductsDB.Model.Measure newMeasure = new Model.Measure()
{
MeasureId = measure.Measure_ID,
MeasureName = measure.Measure_Name
};
sqlContext.Measures.Add(newMeasure);
}
sqlContext.SaveChanges();
foreach (var vendor in mySQLContext.Vendors)
{
ProductsDB.Model.Vendor newVendor = new Model.Vendor()
{
VendorId = vendor.Vendor_ID,
VendorName = vendor.Vendor_Name
};
sqlContext.Vendors.Add(newVendor);
}
sqlContext.SaveChanges();
foreach (var prod in mySQLContext.Products)
{
ProductsDB.Model.Vendor vendor = sqlContext.Vendors.Where
(v => v.VendorId == prod.Vendors_Vendor_ID).First();
ProductsDB.Model.Measure measure = sqlContext.Measures.Where
(m => m.MeasureId == prod.Measures_Measure_ID).First();
ProductsDB.Model.Product newProd = new Model.Product()
{
ProductId = prod.Products_ID,
ProductName = prod.Product_Name,
VendorId = prod.Vendors_Vendor_ID,
Vendor = vendor,
MeasureId = prod.Measures_Measure_ID,
Measure = measure,
BasePrice = prod.BasePrice,
};
sqlContext.Products.Add(newProd);
}
sqlContext.SaveChanges();
}
}
