public void TestMethod_AddPassword()
{
bool pasted = false;
using (ImageGalleryEntities2 db = new ImageGalleryEntities2())
{
using (DbContextTransaction tran = db.Database.BeginTransaction())
{
try
{
string login = GetRandomString(20);
string password = GetRandomString(16);
db.insert_new_password(login, password);
List <PASSWORD> res = db.PASSWORD.Select(t => t).ToList();
foreach (PASSWORD i in res)
{
if (i.Login == login && i.Password1 == password)
{
pasted = true;
break;
}
}
tran.Commit();
}
catch (Exception)
{
tran.Rollback();
throw;
}
}
}
Assert.AreEqual(true, pasted);
}
public List <PASSWORD> GetPasswords()
{
using (ImageGalleryEntities2 db = new ImageGalleryEntities2())
{
using (DbContextTransaction transaction = db.Database.BeginTransaction())
{
try
{
var res = db.PASSWORD.Select(t => t).ToList();
transaction.Commit();
return(res);
}
catch (Exception)
{
transaction.Rollback();
throw;
}
}
}
}
public List <USER> getUsers()
{
using (ImageGalleryEntities2 db = new ImageGalleryEntities2())
{
using (DbContextTransaction transaction = db.Database.BeginTransaction())
{
try
{
var res = db.USER.Select(t => t).ToList();
transaction.Commit();
return(res);
}
catch (Exception ex)
{
transaction.Rollback();
throw;
}
}
}
}
public void InsertNewUser(string name, string surname, string login, string password)
{
using (ImageGalleryEntities2 db = new ImageGalleryEntities2())
{
using (DbContextTransaction tran = db.Database.BeginTransaction())
{
try
{
db.insert_new_password(login, password);
int insertedIdx = GetPasswords().Where(t => (t.Login == login && t.Password1 == password)).Select(t => t.Id).FirstOrDefault();
db.insert_new_user(name, surname, insertedIdx);
tran.Commit();
}
catch (Exception)
{
tran.Rollback();
throw;
}
}
}
}
