public bool Create(User _user)
{
var query =
"INSERT INTO Users (Username, Password, Role, PvK, PuK) VALUES (@Username, @Password, @Role, @PvK, @PuK)";
var sqlParameters = new SqlParameter[5];
sqlParameters[0] = new SqlParameter("@Username", SqlDbType.VarChar);
sqlParameters[0].Value = _user.Username;
sqlParameters[1] = new SqlParameter("@Password", SqlDbType.VarChar);
sqlParameters[1].Value = _user.Password;
sqlParameters[2] = new SqlParameter("@Role", SqlDbType.VarChar);
sqlParameters[2].Value = _user.Role;
sqlParameters[3] = new SqlParameter("@PvK", SqlDbType.VarBinary);
sqlParameters[3].Value = _user.PvK;
sqlParameters[4] = new SqlParameter("@PuK", SqlDbType.VarBinary);
sqlParameters[4].Value = _user.PuK;
return(conn.executeInsertQuery(query, sqlParameters));
}
public bool Create(Message _msg)
{
var query =
"INSERT INTO Messages (FromUser, ToUser, CreateDate, File1, File2, File3, IV) VALUES (@FromUser, @ToUser, @CreateDate, @File1, @File2, @File3, @IV)";
var sqlParameters = new SqlParameter[7];
sqlParameters[0] = new SqlParameter("@FromUser", SqlDbType.Int);
sqlParameters[0].Value = _msg.From.Id;
sqlParameters[1] = new SqlParameter("@ToUser", SqlDbType.Int);
sqlParameters[1].Value = _msg.To.Id;
sqlParameters[2] = new SqlParameter("@CreateDate", SqlDbType.DateTime);
sqlParameters[2].Value = _msg.When;
sqlParameters[3] = new SqlParameter("@File1", SqlDbType.VarBinary);
sqlParameters[3].Value = _msg.File1;
sqlParameters[4] = new SqlParameter("@File2", SqlDbType.VarBinary);
sqlParameters[4].Value = _msg.File2;
sqlParameters[5] = new SqlParameter("@File3", SqlDbType.VarBinary);
sqlParameters[5].Value = _msg.File3;
sqlParameters[6] = new SqlParameter("@IV", SqlDbType.VarBinary);
sqlParameters[6].Value = _msg.IV;
return(conn.executeInsertQuery(query, sqlParameters));
}
