public void ServiceManager_Delete()
{
Sets.NorthwindDataSet set = null;
Adapters.TableAdapterManager tableAdapterManager = null;
Services.ServiceManager serviceManager = null;
try
{
// init defaults
set = new Sets.NorthwindDataSet();
tableAdapterManager = new Adapters.TableAdapterManager();
serviceManager = new Services.ServiceManager(tableAdapterManager);
// data modifier
Random rand = new Random();
// if -1 then something bad will happen!
int affected = -1;
// get all and select the last
serviceManager.CategoryRepository.Fill(set.Category);
var category = set.Category.AsEntities().First(x => x.CategoryID == set.Category.AsEntities().Max(y => y.CategoryID));
// call update method (magic happens here, because it will call an insert method then update entity id and return affected rows number)
affected = serviceManager.CategoryRepository.Delete(category);
// accept changes
set.Category.RemoveCategoryRow(category.AsDataRow());
set.Category.AcceptChanges();
// assert
Assert.IsTrue(affected == 1);
}
catch (Exception err)
{
Console.WriteLine(err);
Assert.IsNull(err);
}
if (tableAdapterManager != null) tableAdapterManager.Dispose();
if (set != null) set.Dispose();
serviceManager = null;
tableAdapterManager = null;
set = null;
}
static void Main(string[] args)
{
Sets.NorthwindDataSet set = null;
Adapters.TableAdapterManager tableAdapterManager = null;
Services.IServiceManager serviceManager = null;
try
{
set = new Sets.NorthwindDataSet();
tableAdapterManager = new Adapters.TableAdapterManager();
serviceManager = new Services.ServiceManager(tableAdapterManager);
serviceManager.CategoryRepository.Fill(set.Category);
serviceManager.ProductRepository.Fill(set.Product);
foreach (var product in set.Product.AsEntities())
Console.WriteLine("ID: {0}, Name: {1}, Category: {2}", product.ProductID, product.ProductName, product.Category.CategoryName);
}
catch(SqlException err)
{
Console.WriteLine(err);
}
catch(Exception err)
{
Console.WriteLine(err.Message);
}
if(tableAdapterManager != null)
tableAdapterManager.Dispose();
if(set != null)
set.Dispose();
serviceManager = null;
tableAdapterManager = null;
set = null;
Console.WriteLine("Press any key to exit...");
Console.ReadKey();
}
public void ServiceManager_Update()
{
Sets.NorthwindDataSet set = null;
Sets.NorthwindDataSet.ProductDataTable table = null;
Adapters.TableAdapterManager tableAdapterManager = null;
Services.ServiceManager serviceManager = null;
try
{
set = new Sets.NorthwindDataSet();
tableAdapterManager = new Adapters.TableAdapterManager();
serviceManager = new Services.ServiceManager(tableAdapterManager);
Random rand = new Random();
serviceManager.ProductRepository.Fill(set.Product);
var product = set.Product.FindByProductID(1).AsEntity();
product.UnitsInStock = (short)rand.Next(1, 100);
var x = serviceManager.ProductRepository.Update(product);
var all = set.Product.AsEntities();
all.ToList().ForEach(model => model.UnitsInStock = (short)rand.Next(0, 100));
var y = serviceManager.ProductRepository.Update(all.ToArray());
Console.WriteLine("{0}, {1}", x, y);
Assert.IsTrue(x == 1);
Assert.IsTrue(y == 77);
}
catch (Exception err)
{
Console.WriteLine(err);
Assert.IsNull(err);
}
if (tableAdapterManager != null) tableAdapterManager.Dispose();
if (table != null) table.Dispose();
if (set != null) set.Dispose();
serviceManager = null;
tableAdapterManager = null;
table = null;
set = null;
}
public void ServiceManager_Insert()
{
Sets.NorthwindDataSet set = null;
Adapters.TableAdapterManager tableAdapterManager = null;
Services.ServiceManager serviceManager = null;
try
{
// init defaults
set = new Sets.NorthwindDataSet();
tableAdapterManager = new Adapters.TableAdapterManager();
serviceManager = new Services.ServiceManager(tableAdapterManager);
// data modifier
Random rand = new Random();
// if -1 then something bad will happen!
int affected = -1;
// create new entity
var category =
new Entities.Category(set.Category.NewCategoryRow())
{
CategoryName = "TEST-" + rand.Next(0, 100),
Description = "DESC-" + rand.Next(100, 200),
Picture = null
};
// add to table as datarow (magic happens here!)
set.Category.AddCategoryRow(category.AsDataRow());
// call update method (magic happens here, because it will call an insert method then update entity id and return affected rows number)
affected = serviceManager.CategoryRepository.Update(category);
// assert
Assert.IsTrue(affected == 1);
Assert.IsTrue(category.CategoryID > 0);
}
catch (Exception err)
{
Console.WriteLine(err);
Assert.IsNull(err);
}
if (tableAdapterManager != null) tableAdapterManager.Dispose();
if (set != null) set.Dispose();
serviceManager = null;
tableAdapterManager = null;
set = null;
}
public void ServiceManager_Entities()
{
Sets.NorthwindDataSet set = null;
Sets.NorthwindDataSet.ProductDataTable table = null;
Adapters.TableAdapterManager tableAdapterManager = null;
Services.ServiceManager serviceManager = null;
try
{
set = new Sets.NorthwindDataSet();
tableAdapterManager = new Adapters.TableAdapterManager();
serviceManager = new Services.ServiceManager(tableAdapterManager);
serviceManager.ProductRepository.Fill(set.Product);
var entity = set.Product[0].AsEntity();
var entities = set.Product.AsEntities();
table = entities.AsDataTable();
Assert.IsTrue(set.Product.Count() > 0);
Assert.IsNotNull(entity);
Assert.IsTrue(entity.ProductID == 1);
Assert.IsNotNull(entities);
Assert.IsTrue(entities.Count() > 0);
Assert.IsTrue(entities.Count() == 77);
Assert.IsTrue(table.Count() == 77);
}
catch (Exception err)
{
Console.WriteLine(err);
Assert.IsNull(err);
}
if(tableAdapterManager != null)
tableAdapterManager.Dispose();
if (table != null)
table.Dispose();
if(set != null)
set.Dispose();
serviceManager = null;
tableAdapterManager = null;
table = null;
set = null;
}