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; } } } }