public static bool AddActivation(User user) { try { var line = new SqlLine { Request = @"INSERT INTO UserActivation VALUES(@ActivationCode)" }; var parCode = new SqlParameter { SqlDbType = System.Data.SqlDbType.VarChar, ParameterName = "@ActivationCode", Value = user.Code }; line.ParList.Add(parCode); var delivery = new DataAccess(); return(delivery.RunStatement(line)); } catch (Exception ex) { throw ex; } }
public void SelectTest() { SqlLine sqlLine = SqlLine.Build().Select(PERSONS_TABLE); List <Person> persons = sqlLine.ExecuteQuery(ReadPerson); Assert.AreEqual(TestsPersons.Length, persons.Count); Assert.AreNotEqual(null, persons.Find(p => p.Name == TestsPersons[0].Name)); }
private static void SetupPersonTable() { TestsPersons = new[] { new Person(1, "Bob", 32), new Person(2, "Alice", 27), new Person(3, "foo", Byte.MaxValue) }; Assert.That.RanToCompletion(() => { try { CreateTable(); } catch (SqlException) { DeleteTable(PERSONS_TABLE); CreateTable(); } }); void CreateTable() { SqlLine initLine = SqlLine.Build($"CREATE TABLE [dbo].[{PERSONS_TABLE}] (" + "[person_id] INT NOT NULL, " + "[person_age] TINYINT NULL, " + "[person_name] NVARCHAR (50) NULL, " + "PRIMARY KEY CLUSTERED ([person_id] ASC))"); initLine.ExecuteNonQuery(); } Assert.That.RanToCompletion(() => { SqlLine deleteLine = SqlLine.Build($"Delete from {PERSONS_TABLE}"); deleteLine.ExecuteNonQuery(); }); Assert.That.RanToCompletion(() => { SqlLine insertLine = SqlLine.Build($"Insert into {PERSONS_TABLE}").Values().Param <Person>(InsertPerson); insertLine.ExecuteNonQuery(TestsPersons[0]); insertLine.ExecuteNonQuery(TestsPersons[1]); insertLine.ExecuteNonQuery(TestsPersons[2]); }); }
public static int AddUser(User user) { try { SqlLine line = new SqlLine(); line.Request = @"EXEC Insert_User VALUES (@FirstName, @LastName, @LastName2, @Email, @Age, @Country, @Username, @Password, @PasswordAge, @PasswordLastSet, 0, @Code)"; SqlParameter parFirstName = new SqlParameter(); parFirstName.SqlDbType = System.Data.SqlDbType.VarChar; parFirstName.ParameterName = "@FirstName"; parFirstName.Value = user.FirstName; SqlParameter parLastName = new SqlParameter(); parLastName.SqlDbType = System.Data.SqlDbType.VarChar; parLastName.ParameterName = "@LastName"; parLastName.Value = user.LastName; SqlParameter parLastName2 = new SqlParameter(); parLastName2.SqlDbType = System.Data.SqlDbType.VarChar; parLastName2.ParameterName = "@LastName2"; parLastName2.Value = user.LastName2; SqlParameter parEmail = new SqlParameter(); parEmail.SqlDbType = System.Data.SqlDbType.VarChar; parEmail.ParameterName = "@Email"; parEmail.Value = user.Email; SqlParameter parCountry = new SqlParameter(); parCountry.SqlDbType = System.Data.SqlDbType.VarChar; parCountry.ParameterName = "@Country"; parCountry.Value = user.Country; SqlParameter parUsername = new SqlParameter(); parUsername.SqlDbType = System.Data.SqlDbType.VarChar; parUsername.ParameterName = "@Username"; parUsername.Value = user.Username; SqlParameter parPassword = new SqlParameter(); parPassword.SqlDbType = System.Data.SqlDbType.VarChar; parPassword.ParameterName = "@Password"; parPassword.Value = user.Password; SqlParameter parAge = new SqlParameter(); parAge.SqlDbType = System.Data.SqlDbType.Int; parAge.ParameterName = "@Age"; parAge.Value = user.Age; SqlParameter parPasswordAge = new SqlParameter(); parPasswordAge.SqlDbType = System.Data.SqlDbType.Int; parPasswordAge.ParameterName = "@PasswordAge"; parPasswordAge.Value = user.PasswordAge; SqlParameter parPasswordLastSet = new SqlParameter(); parPasswordLastSet.SqlDbType = System.Data.SqlDbType.DateTime; parPasswordLastSet.ParameterName = "@PasswordLastSet"; parPasswordLastSet.Value = user.PasswordLastSet; SqlParameter parCode = new SqlParameter(); parCode.SqlDbType = System.Data.SqlDbType.VarChar; parCode.ParameterName = "@Code"; parCode.Value = user.Code; line.ParList.Add(parFirstName); line.ParList.Add(parLastName); line.ParList.Add(parLastName2); line.ParList.Add(parEmail); line.ParList.Add(parCountry); line.ParList.Add(parUsername); line.ParList.Add(parPassword); line.ParList.Add(parAge); line.ParList.Add(parPasswordAge); line.ParList.Add(parPasswordLastSet); line.ParList.Add(parCode); DataAccess objacceso = new DataAccess(); return(objacceso.RunStatementScalar(line)); } catch (Exception ex) { throw ex; } }
public static int AddUser(User user) { try { var line = new SqlLine { Request = @"EXEC Insert_User VALUES (@FirstName, @LastName, @LastName2, @Email, @Age, @Country, @Username, @Password, @PasswordAge, @PasswordLastSet, 0, @Code)" }; var parFirstName = new SqlParameter { SqlDbType = System.Data.SqlDbType.VarChar, ParameterName = "@FirstName", Value = user.FirstName }; line.ParList.Add(parFirstName); var parLastName = new SqlParameter { SqlDbType = System.Data.SqlDbType.VarChar, ParameterName = "@LastName", Value = user.LastName }; line.ParList.Add(parLastName); var parLastName2 = new SqlParameter { SqlDbType = System.Data.SqlDbType.VarChar, ParameterName = "@LastName2", Value = user.LastName2 }; line.ParList.Add(parLastName2); var parEmail = new SqlParameter { SqlDbType = System.Data.SqlDbType.VarChar, ParameterName = "@Email", Value = user.Email }; line.ParList.Add(parEmail); var parCountry = new SqlParameter { SqlDbType = System.Data.SqlDbType.VarChar, ParameterName = "@Country", Value = user.Country }; line.ParList.Add(parCountry); var parUsername = new SqlParameter { SqlDbType = System.Data.SqlDbType.VarChar, ParameterName = "@Username", Value = user.Username }; line.ParList.Add(parUsername); var parPassword = new SqlParameter { SqlDbType = System.Data.SqlDbType.VarChar, ParameterName = "@Password", Value = user.Password }; line.ParList.Add(parPassword); var parAge = new SqlParameter { SqlDbType = System.Data.SqlDbType.Int, ParameterName = "@Age", Value = user.Age }; line.ParList.Add(parAge); var parPasswordAge = new SqlParameter { SqlDbType = System.Data.SqlDbType.Int, ParameterName = "@PasswordAge", Value = user.PasswordAge }; line.ParList.Add(parPasswordAge); var parPasswordLastSet = new SqlParameter { SqlDbType = System.Data.SqlDbType.DateTime, ParameterName = "@PasswordLastSet", Value = user.PasswordLastSet }; line.ParList.Add(parPasswordLastSet); var parCode = new SqlParameter { SqlDbType = System.Data.SqlDbType.VarChar, ParameterName = "@Code", Value = user.Code }; line.ParList.Add(parCode); var delivery = new DataAccess(); return(delivery.RunStatementScalar(line)); } catch (Exception ex) { throw ex; } }
private static void DeleteTable(string tableName) { SqlLine deleteLine = SqlLine.Build($"Drop Table [dbo].[{tableName}]"); deleteLine.ExecuteNonQuery(); }