/// <summary>
/// Get an existing gender, not mocked up in CreateMockData
/// </summary>
/// <returns></returns>
public GenderType ExistingFemale()
{
using (PersonEntities Entity = new PersonEntities())
{
return(Entity.GenderTypes.FirstOrDefault(item => item.Gender == "Female"));
}
}
public void TestMethod1()
{
using (var context = new PersonEntities())
{
var person = context.People.Add(
new Person()
{
FirstName = "Mary", LastName = "Moore"
});
person.Phones = new List <Phone>()
{
new Phone()
{
PhoneType = "Cell 1", PhoneNumber = "888-888-8888"
},
new Phone()
{
PhoneType = "Cell 2", PhoneNumber = "666-666-6666"
},
new Phone()
{
PhoneType = "Cell 3", PhoneNumber = "444-444-444"
}
};
context.SaveChanges();
}
}
/// <summary>
/// Removes test data from database, called from all tests that create data
/// </summary>
/// <remarks>
/// If you have issues with data not disposing then set break-points
/// in the emppty try/catch statements to figure out the issue. More likely
/// than not the interface, in this case IBaseEntity was not implemented on
/// one of the classes.
///
/// The try-catches allow us to continue and throw an exception message in
/// the tear down event TeardownTestBase for any test.
///
/// Empty try/catches are okay here as you should be using this only for
/// unit testing and hopefully on a non production database.
///
/// </remarks>
public bool AnnihilateData(List <object> mAnnihilateList)
{
bool mAnnihilateDataSuccessful = false;
using (var destroyContext = new PersonEntities())
{
for (int i = mAnnihilateList.Count - 1; i >= 0; i--)
{
try
{
var currentObject = mAnnihilateList[i];
var existingItem = destroyContext
.Set(currentObject.GetType())
.Find(((IBaseEntity)currentObject).Identifier);
if (existingItem != null)
{
try
{
var attachedEntry = destroyContext.Entry(existingItem);
attachedEntry.CurrentValues.SetValues(currentObject);
destroyContext.Set(existingItem.GetType()).Attach(existingItem);
destroyContext.Set(existingItem.GetType()).Remove(existingItem);
}
catch (Exception)
{
// ignore nothing do to as the object was not added in properly.
}
}
else
{
var item = currentObject.GetType();
}
}
catch (Exception)
{
//catch and continue save what we can
}
}
try
{
var resultCount = destroyContext.SaveChanges();
var annihlationCount = mAnnihilateList.Count;
mAnnihilateDataSuccessful = (resultCount == annihlationCount);
}
catch (Exception)
{
// keep on going
}
finally
{
destroyContext.Dispose();
}
}
return(mAnnihilateDataSuccessful);
}
public void Delete(decimal id)
{
using (var context = new PersonEntities())
{
var record = (from d in context.Person select d).Where(d => d.Id.Equals(id)).FirstOrDefault();
context.Person.Remove(record);
context.SaveChanges();
}
}
public void Update(PersonModel p)
{
using (var context = new PersonEntities())
{
var query = (from d in context.Person select d).Where(d => d.Id.Equals(p.Id)).FirstOrDefault();
query.Name = p.Name;
query.Gender = p.Gender;
query.Phone = p.Phone;
context.SaveChanges();
}
}
/// <summary>
/// Loads all tables into the context.
/// </summary>
public void LoadTablesIntoContext()
{
ProjectEntities.Load();
PersonEntities.Load();
ExpertEntities.Load();
EventTreeEntities.Load();
TreeEventEntities.Load();
ExpertClassEstimationEntities.Load();
FragilityCurveElementEntities.Load();
TreeEventFragilityCurveElementEntities.Load();
HydraulicConditionElementEntities.Load();
}
protected virtual void Dispose(bool disposing)
{
if (disposing)
{
// free managed resources
if (_dbContext != null)
{
_dbContext.Dispose();
_dbContext = null;
}
}
}
public PersonModel ConsultOne(decimal id)
{
using (var context = new PersonEntities())
{
PersonModel person = new PersonModel();
var record = (from d in context.Person select d).Where(d => d.Id.Equals(id)).FirstOrDefault();
person.Id = record.Id;
person.Name = record.Name;
person.Gender = record.Gender;
person.Phone = record.Phone;
return(person);
}
}
public Form1()
{
InitializeComponent();
PersonEntities ente = new PersonEntities();
master_file master_file = (new master_file()
{
firstname = "My", lastname = "Lastname", function = EFunction.Interessent, aktiv = true, deleted_inaktiv = false, newsletter_flag = true
});
ente.master_file.Add(master_file);
ente.SaveChanges();
}
public void Create(PersonModel p)
{
using (var context = new PersonEntities())
{
Person pe = new Person();
pe.Name = p.Name;
pe.Gender = p.Gender;
pe.Phone = p.Phone;
context.Person.Add(pe);
context.SaveChanges();
}
}
public void ReadNames()
{
var buffer = new StringBuilder();
using (var entities = new PersonEntities())
{
foreach (var person in entities.People)
{
buffer.Append(person.Name + ' ');
}
}
Assert.AreEqual(LoremIpsum, buffer.ToString().Trim(' '));
}
public List <PersonModel> Consult()
{
List <PersonModel> peoplelist = new List <PersonModel>();
using (var context = new PersonEntities())
{
var query = (from d in context.Person select d).ToList();
foreach (var item in query)
{
PersonModel p = new PersonModel();
p.Id = item.Id;
p.Name = item.Name;
p.Gender = item.Gender;
p.Phone = item.Phone;
peoplelist.Add(p);
}
}
return(peoplelist);
}
public void TestInitialize()
{
using (var entities = new PersonEntities())
{
entities.People.RemoveRange(entities.People);
entities.SaveChanges();
var tokens = LoremIpsum.Split(' ');
foreach (var token in tokens)
{
entities.People.Add(new Person
{
Name = token,
PersonId = Guid.NewGuid()
});
}
entities.SaveChanges();
}
}
public Form1()
{
InitializeComponent();
var entities = new PersonEntities();
CommunicationRepository repository = new CommunicationRepository(entities);
var c = repository.GetCommunications <Person>(1);
var d = repository.GetCommunications <Course>(1);
try
{
var svNr = 07866987;
var num = svNr.ToString().Select(x => Convert.ToInt32(x)).ToList();
var s = ConverChar(num[3]);
num.Remove(num[3]);
var x = 0;
//3
var calc = new int[] { 3, 7, 9, 5, 8, 4, 2, 1, 6 }; //11
for (int i = 0; i < calc.Length; i++)
{
var carNum = ConverChar(num[i]);
x += carNum * calc[i];
}
var result = x % 11;
bool resultBool = s == result;
if (resultBool)
{
Console.WriteLine();
}
Console.WriteLine();
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
}
public AddressPersonRepository(PersonEntities entities) : base(entities)
{
this.entities = entities;
}
public UserRepository(PersonEntities Entities) : base(Entities)
{
}
public ContactRepository(PersonEntities entities) : base(entities)
{
}
public AddressRepository(PersonEntities entities) : base(entities)
{
}
public CommunicationRepository(PersonEntities personEntities)
{
entities = personEntities;
docRepo = new DocumentRepository(personEntities);
}
public PersonRepository(PersonEntities entities) : base(entities)
{
}
public DocumentRepository(PersonEntities entities)
{
this.entities = entities;
}
public BaseRepository(PersonEntities Entities)
{
this.entities = Entities;
}
public CourseRepository(PersonEntities entities)
{
this.entities = entities;
}
public void SetupTestBase()
{
AnnihilationList = new List <object>();
DbContext = new PersonEntities();
}