public void Update(string CustomerID,string CustomerTypeID)
{
Customercustomerdemo item = new Customercustomerdemo();
item.MarkOld();
item.IsLoaded = true;
item.CustomerID = CustomerID;
item.CustomerTypeID = CustomerTypeID;
item.Save(UserName);
}
public static void Initialize(NHibernateHelper nHibernateHelper)
{
var categories = SeedCategories()
.Generate(1)
.ToList();
var suppliers = SeedSuppliers()
.Generate(1)
.ToList();
var products = new List <Products>();
foreach (var category in categories)
{
foreach (var supplier in suppliers)
{
var products1 = SeedProducts()
.Generate(5)
.ToList();
foreach (var product in products1)
{
category.AddProduct(product);
supplier.AddProduct(product);
products.Add(product);
}
}
}
var customers = SeedCustomers()
.Generate(5)
.ToList();
var customerDemographics = SeedCustomerDemographics()
.Generate(1)
.ToList();
var employees = SeedEmployees()
.Generate(4)
.ToList();
var shippers = SeedShippers()
.Generate(1)
.ToList();
var orders = new List <Orders>();
foreach (var customer in customers)
{
foreach (var employee in employees)
{
foreach (var shipper in shippers)
{
var order = SeedOrders()
.Generate(1)
.First();
customer.AddOrder(order);
employee.AddOrder(order);
shipper.AddOrder(order);
orders.Add(order);
}
}
}
var customerCustomerDemos = new List <Customercustomerdemo>();
foreach (var customer in customers)
{
foreach (var customerDemo in customerDemographics)
{
var customerCustomerDemo = new Customercustomerdemo();
customer.AddCustomerDemo(customerCustomerDemo);
customerDemo.AddCustomerDemo(customerCustomerDemo);
customerCustomerDemos.Add(customerCustomerDemo);
}
}
List <Orderdetails> orderDetails = new List <Orderdetails>();
foreach (var order in orders)
{
foreach (var product in products)
{
var orderDetail = SeedOrderDetails()
.Generate(1)
.First();
order.AddOrderDetail(orderDetail);
product.AddOrderDetail(orderDetail);
orderDetails.Add(orderDetail);
}
}
var regions = SeedRegions()
.Generate(1)
.ToList();
var territories = new List <Territories>();
foreach (var region in regions)
{
var territories1 = SeedTerritories()
.Generate(2)
.ToList();
foreach (var territory in territories1)
{
region.AddTerritory(territory);
territories.Add(territory);
}
}
var employeeTerritories = new List <Employeeterritories>();
foreach (var employee in employees)
{
foreach (var territory in territories)
{
var employeeTerritory = new Employeeterritories();
employee.AddEmployeeTerritory(employeeTerritory);
territory.AddEmployeeTerritory(employeeTerritory);
employeeTerritories.Add(employeeTerritory);
}
}
foreach (var region in regions)
{
using (var session = nHibernateHelper.GetSessionFactory().OpenSession())
{
using (var tx = session.BeginTransaction())
{
session.Save(region);
tx.Commit();
}
}
}
foreach (var territory in territories)
{
using (var session = nHibernateHelper.GetSessionFactory().OpenSession())
{
using (var tx = session.BeginTransaction())
{
session.Save(territory);
tx.Commit();
}
}
}
foreach (var customer in customers)
{
using (var session = nHibernateHelper.GetSessionFactory().OpenSession())
{
using (var tx = session.BeginTransaction())
{
session.Save(customer);
tx.Commit();
}
}
}
foreach (var customerDemo in customerDemographics)
{
using (var session = nHibernateHelper.GetSessionFactory().OpenSession())
{
using (var tx = session.BeginTransaction())
{
session.Save(customerDemo);
tx.Commit();
}
}
}
foreach (var customerCustomerDemo in customerCustomerDemos)
{
using (var session = nHibernateHelper.GetSessionFactory().OpenSession())
{
using (var tx = session.BeginTransaction())
{
session.Save(customerCustomerDemo);
tx.Commit();
}
}
}
foreach (var category in categories)
{
using (var session = nHibernateHelper.GetSessionFactory().OpenSession())
{
using (var tx = session.BeginTransaction())
{
session.Save(category);
tx.Commit();
}
}
}
foreach (var supplier in suppliers)
{
using (var session = nHibernateHelper.GetSessionFactory().OpenSession())
{
using (var tx = session.BeginTransaction())
{
session.Save(supplier);
tx.Commit();
}
}
}
foreach (var product in products)
{
using (var session = nHibernateHelper.GetSessionFactory().OpenSession())
{
using (var tx = session.BeginTransaction())
{
session.Save(product);
tx.Commit();
}
}
}
foreach (var employee in employees)
{
using (var session = nHibernateHelper.GetSessionFactory().OpenSession())
{
using (var tx = session.BeginTransaction())
{
session.Save(employee);
tx.Commit();
}
}
}
foreach (var employeeTerritory in employeeTerritories)
{
using (var session = nHibernateHelper.GetSessionFactory().OpenSession())
{
using (var tx = session.BeginTransaction())
{
session.Save(employeeTerritory);
tx.Commit();
}
}
}
foreach (var shipper in shippers)
{
using (var session = nHibernateHelper.GetSessionFactory().OpenSession())
{
using (var tx = session.BeginTransaction())
{
session.Save(shipper);
tx.Commit();
}
}
}
foreach (var order in orders)
{
using (var session = nHibernateHelper.GetSessionFactory().OpenSession())
{
using (var tx = session.BeginTransaction())
{
session.Save(order);
tx.Commit();
}
}
}
foreach (var orderDetail in orderDetails)
{
using (var session = nHibernateHelper.GetSessionFactory().OpenSession())
{
using (var tx = session.BeginTransaction())
{
session.Save(orderDetail);
tx.Commit();
}
}
}
}
public void Insert(string CustomerID,string CustomerTypeID)
{
Customercustomerdemo item = new Customercustomerdemo();
item.CustomerID = CustomerID;
item.CustomerTypeID = CustomerTypeID;
item.Save(UserName);
}
