private static void LoadFile(string fileName)
{
using (StreamReader sr = new StreamReader(fileName))
{
var csv = new CsvReader(sr);
while (csv.Read())
{
//Import Customer(Account and Parent)
int accountId = ImportCustomer(csv);
//ClassInfo
ClassInfo classInfo = new ClassInfo();
classInfo.FromCsv(csv);
using (PrivateClassesDBContext dbContext = new PrivateClassesDBContext())
{
ClassInfoRepo repo = new ClassInfoRepo(dbContext);
repo.Add(classInfo);
try
{
//Save to DB
dbContext.SaveChanges();
}
catch (DbEntityValidationException)
{
throw;
}
}
}
}
}
public void ClassInfoIntegationTests_AddClass()
{
using (PrivateClassesDBContext dbContext = new PrivateClassesDBContext())
{
ClassInfoRepo repo = new ClassInfoRepo(dbContext);
repo.Add(new ClassInfo {
ClassCategoryId = 1, ClassName = "TestClass", Location = "Trails", ProductCode = "C12345", DateStart = DateTime.Now, DateEnd = DateTime.Now
});
try
{
dbContext.SaveChanges();
}
catch (DbEntityValidationException exc)
{
Assert.Fail(exc.EntityValidationErrors.ToString());
}
catch (Exception exc)
{
Assert.Fail(exc.ToString());
}
var res = repo.FindOne(c => c.ClassName == "TestClass");
Assert.IsNotNull(res);
}
}
//public IEnumerable<ClassCategory> GetAllCategories()
//{
// using (I2LIPrivateClassesDBContext entities = new I2LIPrivateClassesDBContext())
// {
// //res = entities.ClassInfoes.Include("Orders").Include("ClassCategory").ToList();
// var categories = entities.ClassCategories.ToList();
// return categories;
// //var res = entities.ClassInfoes.ToList();
// //return res;
// }
//}
public ClassInfo GetClassById(int id)
{
using (PrivateClassesDBContext entities = new PrivateClassesDBContext())
{
return(entities.ClassInfoes.FirstOrDefault(x => x.Id == id));
}
}
public IEnumerable <ClassInfo> GetAllClasses()
{
using (PrivateClassesDBContext entities = new PrivateClassesDBContext())
{
//var res = entities.ClassInfoes.Include("ClassCategory").ToList();
var res = entities.ClassInfoes.Include(c => c.ClassCategory).ToList();
return(res);
}
}
public void ClassInfoIntegationTests_FindUnPaidClasses()
{
using (PrivateClassesDBContext dbContext = new PrivateClassesDBContext())
{
ClassInfoRepo repo = new ClassInfoRepo(dbContext);
List <ClassInfo> res = repo.FindMany(c => c.Orders.Where(o => !o.PaymentId.HasValue).Count() > 0).ToList();
Assert.IsTrue(res != null && res.Count > 0);
}
}
public void ParticipantIntegationTests_GetAllAccounts()
{
using (PrivateClassesDBContext dbContext = new PrivateClassesDBContext())
{
ParticipantRepo repo = new ParticipantRepo(dbContext);
var res = repo.GetAllAccounts();
Assert.IsTrue(res != null && res.Count > 0);
}
}
public void ClassInfoIntegationTests_GetClassById()
{
using (PrivateClassesDBContext dbContext = new PrivateClassesDBContext())
{
ClassInfoRepo repo = new ClassInfoRepo(dbContext);
var res = repo.GetClassById(3);
Assert.IsTrue(res != null && res.ClassCategory != null);
}
}
public void ClassInfoIntegationTests_GetAll()
{
using (PrivateClassesDBContext dbContext = new PrivateClassesDBContext())
{
ClassInfoRepo repo = new ClassInfoRepo(dbContext);
List <ClassInfo> res = repo.GetAll().ToList();
Assert.IsTrue(res != null && res.Count > 0);
}
}
public void ClassInfoIntegationTests_GetClassCategoryByKeyword()
{
using (PrivateClassesDBContext dbContext = new PrivateClassesDBContext())
{
ClassInfoRepo repo = new ClassInfoRepo(dbContext);
var res = repo.GetClassCategoryByKeyword("Party");
Assert.IsTrue(res != null);
}
}
public void ClassInfoIntegationTests_FindOne()
{
using (PrivateClassesDBContext dbContext = new PrivateClassesDBContext())
{
GenericRepository <ClassInfo> repo = new GenericRepository <ClassInfo>(dbContext);
//Calling generic method
var res = repo.FindOne(x => x.ClassName.ToLower().Contains("Survival") && x.DateStart > new DateTime(2017, 8, 1));
Assert.IsTrue(res != null);
}
}
public void ClassInfoIntegationTests_FindMany()
{
using (PrivateClassesDBContext dbContext = new PrivateClassesDBContext())
{
GenericRepository <ClassInfo> repo = new GenericRepository <ClassInfo>(dbContext);
//Calling generic method
var res = repo.FindMany(x => x.ClassName.ToLower().Contains("Survival")).ToList();
Assert.IsTrue(res != null && res.Count > 0);
}
}
public void ParticipantIntegationTests_GetAccountByStudent()
{
using (PrivateClassesDBContext dbContext = new PrivateClassesDBContext())
{
ParticipantRepo repo = new ParticipantRepo(dbContext);
StudentInfo student = new StudentInfo()
{
LastName = "Skop", FirstName = "Abby", AccountInfoId = 1, Gender = "f"
};
var res = repo.GetAllAccounts();
Assert.IsTrue(res != null && res.Count > 0);
}
}
private static int ImportCustomer(CsvReader csv)
{
int accointId = 0;
//Import Parent
ParentInfo p = new ParentInfo();
p.FromCsv(csv);
//
using (PrivateClassesDBContext dbContext = new PrivateClassesDBContext())
{
ParticipantRepo repo = new ParticipantRepo(dbContext);
//If participant exist
var existingParent = repo.GetAllParents().FirstOrDefault(x => x.LastName.ToLower() == p.LastName.ToLower() && x.Email == p.Email);
if (existingParent != null)
{
accointId = existingParent.AccountInfoId;
//TODO-1
//Update changes
}
else
{
//repo.AddAccount(new AccountInfo { LastName = p.LastName, Email = p.Email, DateApplied = DateTime.Now});
p.AccountInfo = new AccountInfo {
LastName = p.LastName, Email = p.Email, DateApplied = DateTime.Now
};
repo.AddParent(p);
}
try
{
//Save to DB
dbContext.SaveChanges();
}
catch (DbEntityValidationException exc)
{
string[] validationErrorMessages = exc.EntityValidationErrors.Select(x => x.ValidationErrors.ToList()[0].ErrorMessage).ToArray();
throw new DbEntityValidationException(String.Join("; ", validationErrorMessages));
}
}
return(accointId);
}
public void ParticipantIntegationTests_AddStudent()
{
using (PrivateClassesDBContext dbContext = new PrivateClassesDBContext())
{
List <StudentInfo> validStudents = new List <StudentInfo>()
{
new StudentInfo()
{
LastName = "Skop", FirstName = "Abby", AccountInfoId = 1, Gender = "f", DateOfBirth = new DateTime(2010, 10, 12)
},
new StudentInfo()
{
LastName = "Skop", FirstName = "Max", AccountInfoId = 1, Gender = "m", DateOfBirth = new DateTime(2006, 7, 1)
},
};
ParticipantRepo repo = new ParticipantRepo(dbContext);
try
{
foreach (var s in validStudents)
{
repo.AddStudent(s);
}
dbContext.SaveChanges();
}
catch (DbEntityValidationException exc)
{
string[] validationErrorMessages = exc.EntityValidationErrors.Select(x => x.ValidationErrors.ToList()[0].ErrorMessage).ToArray();
Assert.Fail(String.Join("; ", validationErrorMessages));
}
catch (Exception exc)
{
Assert.Fail(exc.ToString());
}
var res = repo.GetAllStudents().SingleOrDefault(s => s.LastName == "Skop" && s.FirstName == "Abby");
Assert.IsNotNull(res);
}
}
public void ParticipantIntegationTests_AddAccount()
{
using (PrivateClassesDBContext dbContext = new PrivateClassesDBContext())
{
List <AccountInfo> validAccounts = new List <AccountInfo>()
{
new AccountInfo()
{
LastName = "Skop", Email = "*****@*****.**", DateApplied = DateTime.Now
},
new AccountInfo()
{
LastName = "Skop", Email = "*****@*****.**", DateApplied = DateTime.Now
}
};
ParticipantRepo repo = new ParticipantRepo(dbContext);
try
{
foreach (var a in validAccounts)
{
repo.AddAccount(a);
}
dbContext.SaveChanges();
}
catch (DbEntityValidationException exc)
{
string[] validationErrorMessages = exc.EntityValidationErrors.Select(x => x.ValidationErrors.ToList()[0].ErrorMessage).ToArray();
Assert.Fail(String.Join("; ", validationErrorMessages));
}
catch (Exception exc)
{
Assert.Fail(exc.ToString());
}
var res = repo.GetAllAccounts().SingleOrDefault(a => a.Email == validAccounts[0].Email);
Assert.IsNotNull(res);
}
}
public void ParticipantIntegationTests_AddParent()
{
using (PrivateClassesDBContext dbContext = new PrivateClassesDBContext())
{
List <ParentInfo> validParents = new List <ParentInfo>()
{
new ParentInfo()
{
LastName = "Skop", FirstName = "Serge", AccountInfoId = 1
},
new ParentInfo()
{
LastName = "Skop", FirstName = "Lily", AccountInfoId = 1
},
};
ParticipantRepo repo = new ParticipantRepo(dbContext);
try
{
foreach (var p in validParents)
{
repo.AddParent(p);
}
dbContext.SaveChanges();
}
catch (DbEntityValidationException exc)
{
string[] validationErrorMessages = exc.EntityValidationErrors.Select(x => x.ValidationErrors.ToList()[0].ErrorMessage).ToArray();
Assert.Fail(String.Join("; ", validationErrorMessages));
}
catch (Exception exc)
{
Assert.Fail(exc.ToString());
}
var res = repo.GetAllParents().SingleOrDefault(p => p.LastName == "Skop" && p.FirstName == "Serge");
Assert.IsNotNull(res);
}
}
public void ParticipantIntegationTests_AddSecondParentWithExistingAccount()
{
using (PrivateClassesDBContext dbContext = new PrivateClassesDBContext())
{
ParentInfo parent_2 = new ParentInfo()
{
LastName = "Doe", FirstName = "Jane", Email = "*****@*****.**"
};
ParticipantRepo repo = new ParticipantRepo(dbContext);
try
{
//Get Account
var allAccounts = repo.GetAllAccounts();
var a = allAccounts.SingleOrDefault(x => x.LastName == parent_2.LastName && x.Email.Trim() == parent_2.Email);
Assert.IsNotNull(a, "Account not found");
parent_2.AccountInfo = a;
//repo.AddParent(parent_2);
//dbContext.SaveChanges();
}
catch (DbEntityValidationException exc)
{
string[] validationErrorMessages = exc.EntityValidationErrors.Select(x => x.ValidationErrors.ToList()[0].ErrorMessage).ToArray();
Assert.Fail(String.Join("; ", validationErrorMessages));
}
catch (Exception exc)
{
Assert.Fail(exc.ToString());
}
var parentRes_2 = repo.GetAllParents().SingleOrDefault(p => p.LastName.Trim() == parent_2.LastName && p.FirstName.Trim() == parent_2.FirstName);
Assert.IsNotNull(parentRes_2, "Parent 2");
Assert.IsNotNull(parentRes_2.AccountInfo, "AccountInfo is NULL");
Assert.IsTrue(parentRes_2.AccountInfoId > 0, "AccountId");
}
}
public void ParticipantIntegationTests_AddParentWithAccount()
{
using (PrivateClassesDBContext dbContext = new PrivateClassesDBContext())
{
ParentInfo parent_1 = new ParentInfo()
{
LastName = "Doe", FirstName = "John", Email = "*****@*****.**"
};
AccountInfo a = new AccountInfo {
LastName = parent_1.LastName, Email = parent_1.Email
};
parent_1.AccountInfo = a;
ParticipantRepo repo = new ParticipantRepo(dbContext);
try
{
repo.AddParent(parent_1);
dbContext.SaveChanges();
}
catch (DbEntityValidationException exc)
{
string[] validationErrorMessages = exc.EntityValidationErrors.Select(x => x.ValidationErrors.ToList()[0].ErrorMessage).ToArray();
Assert.Fail(String.Join("; ", validationErrorMessages));
}
catch (Exception exc)
{
Assert.Fail(exc.ToString());
}
var parentRes_1 = repo.GetAllParents().SingleOrDefault(p => p.LastName == parent_1.LastName && p.FirstName == parent_1.FirstName);
Assert.IsNotNull(parentRes_1, "Parent 1");
Assert.IsNotNull(parentRes_1.AccountInfo, "AccountInfo is NULL");
Assert.IsTrue(parentRes_1.AccountInfoId > 0, "AccountId");
}
}
public ClassInfoRepo(PrivateClassesDBContext dbContext) :
base(dbContext)
{
}
public ParticipantRepo(PrivateClassesDBContext dbContext) :
base(dbContext)
{
}
