// INSERT INTO
public int Insert(File file)
{
string query = "INSERT INTO Files (filename, username, state) VALUES (@FILENAME, @USERNAME, @STATE)";
SqlCommand command = new SqlCommand(query);
command.Parameters.AddWithValue("FILENAME", file.Filename);
command.Parameters.AddWithValue("USERNAME", file.Username);
command.Parameters.AddWithValue("STATE", file.State);
try
{
return(_bdd.ActionsOnRows(command));
}
catch (InvalidOperationException)
{
return(0);
}
}
// INSERT INTO
public int Insert(User user)
{
string query = "INSERT INTO Users (username, email, password) VALUES (@USERNAME, @EMAIL, @PASSWORD)";
SqlCommand command = new SqlCommand(query);
command.Parameters.AddWithValue("USERNAME", user.Username);
command.Parameters.AddWithValue("EMAIL", user.Email);
command.Parameters.AddWithValue("PASSWORD", user.Password);
try
{
return(_bdd.ActionsOnRows(command));
}
catch (InvalidOperationException)
{
return(0);
}
}
