public virtual bool Equals(ProductCategory other)
{
if (ReferenceEquals(null, other)) return false;
if (ReferenceEquals(this, other)) return true;
return other.Id == Id && Equals(other.Name, Name);
}
public Product(int id, string name, ProductCategory productCategory)
{
ID = id;
Name = name;
ProductCategory = productCategory;
}
public void CreateProductsinDb()
{
var sessionFactory = SessionHelper.CreateSessionFactory();
using (var session = sessionFactory.OpenSession())
{
using (var transaction = session.BeginTransaction())
{
#region list Data Entered in Database
var listManufacturers = new List<string>
{
"apple", "ericsson", "blackberry",
"garmin", "casio", "dell"
};
var listCarriers = new List<string>
{
"ATT", "Verizon", "T-Mobile",
"Sprint", "US Cellular", "Cricket",
"MetroPCS", "BoostMobile"
};
var listProductCategories = new List<string>
{
"Data Cables", "Battery Charger", "Bluetooth Headset",
"Cell Armour", "Licenced Product", "Protector Case",
"Batteries", "Memory Card", "Screen Protector"
};
var listProductSubCategories = new List<string>
{
"Batteries", "OEM"
};
var listBrandNames = new List<string>
{
"apple", "ericsson", "blackberry",
"garmin", "casio", "dell"
};
var listDevices = new List<string>
{
"MINI",
"SHUFFLE",
"NANO",
"NANO2",
"NANO3",
"NANO4",
"NANO5",
"IPODTOUCH",
"IPODTOUCH2",
"IPODTOUCH3",
"IPODTOUCH4",
"VIDEO30G",
"VIDEO60G",
"IPHONE",
"IPHONE3G",
"IPHONE3GS",
"IPHONE4",
"HTCEVO",
"Sansung Galaxy"
};
#endregion
foreach (var manufacturer in listManufacturers)
{
var newManufactuer = new Manufacturer() { Name = manufacturer };
session.SaveOrUpdate(newManufactuer);
}
foreach (var brandName in listBrandNames)
{
var newBrandName = new BrandName() { Name = brandName };
session.SaveOrUpdate(newBrandName);
}
foreach (var category in listProductCategories)
{
var productCategory = new ProductCategory() { Name = category };
session.SaveOrUpdate(productCategory);
}
var productCategories = (List<ProductCategory>) session.CreateCriteria(typeof (ProductCategory))
.Add(Restrictions.Eq("Name", "Batteries"))
.List<ProductCategory>();
foreach (var productSubCategory in listProductSubCategories)
{
var subCategory = new ProductSubCategory
{
Name = productSubCategory,
ProductCategory = productCategories[0]
};
session.SaveOrUpdate(subCategory);
}
foreach (var carrierItem in listCarriers)
{
var carrier = new Carrier() { Name = carrierItem };
session.SaveOrUpdate(carrier);
}
var manufacturers = (List<Manufacturer>)session.CreateCriteria(typeof(Manufacturer)).List<Manufacturer>();
var manufacturerRet = new Manufacturer();
foreach (var manufacturer in manufacturers.Where(manufacturer => manufacturer.Name.Equals("apple")))
{
manufacturerRet = manufacturer;
break;
}
var brandNames = (List<BrandName>)session.CreateCriteria(typeof(BrandName)).List<BrandName>();
var brandNameRet = new BrandName();
foreach (var brandName in brandNames.Where(br => br.Name.Equals("apple")))
{
brandNameRet = brandName;
break;
}
var productSubCategories = (List<ProductSubCategory>)session.CreateCriteria(typeof(ProductSubCategory)).List<ProductSubCategory>();
var productSubCategoryRet = new ProductSubCategory();
foreach (var productCat in productSubCategories.Where(pc => pc.Name.Equals("Batteries")))
{
productSubCategoryRet = productCat;
break;
}
var carriers = (List<Carrier>)session.CreateCriteria(typeof(Carrier)).List<Carrier>();
var carrierATT = new Carrier();
var carrierSprint = new Carrier();
foreach (var carrier in carriers.Where(c => c.Name.Equals("ATT")))
{
carrierATT = carrier;
break;
}
foreach (var carrier in carriers.Where(c => c.Name.Equals("Sprint")))
{
carrierSprint = carrier;
break;
}
var product = new Product()
{
Name =
"APPLE IPHONE 3G / IPHONE4 / IPOD TOUCH CYONGEAR PORTABLE CHARGER WITH SOLAR CHARGING PANEL (2400MAH) ",
Manufacturer = manufacturerRet,
BrandName = brandNameRet,
ProductSubCategory = productSubCategoryRet
};
var attCarrierList = new List<Carrier>() { carrierATT };
var phoneDevices =
listDevices.Select(
device => new PhoneDevice() {Name = device, Carriers = (IList<Carrier>) attCarrierList});
if (phoneDevices == null) throw new NotImplementedException();
//product.AddToPhoneDevices(phoneDevices);
product.PhoneDevices = phoneDevices.ToList();
var sprintCarrierList = new List<Carrier>() { carrierSprint };
var phoneDevices1 = listDevices.Select(device => new PhoneDevice() { Name = device, Carriers = sprintCarrierList});
foreach (var productCat in productSubCategories.Where(pc => pc.Name.Equals("OEM")))
{
productSubCategoryRet = productCat;
break;
}
var product1 = new Product()
{
Name =
"APPLE IPHONE 3G / IPHONE4 / IPOD TOUCH CYONGEAR PORTABLE CHARGER WITH SOLAR CHARGING PANEL (2400MAH) ",
Manufacturer = manufacturerRet,
BrandName = brandNameRet,
ProductSubCategory = productSubCategoryRet
};
//product1.AddToPhoneDevices(phoneDevices1);
product1.PhoneDevices = phoneDevices1.ToList();
session.SaveOrUpdate(product1);
//product.AddToPhoneDevices(phoneDevices1);
product.PhoneDevices = phoneDevices1.ToList();
session.SaveOrUpdate(product);
transaction.Commit();
}
}
}