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