/// <summary>
/// Inserts user in database. Assigns them ID (max(ID) + 1 form users)
/// </summary>
/// <param name="dbConnection">KaRaFa Database connection</param>
private void InsertUserToDatabase(Database.DatabaseConnection dbConnection)
{
// Creates query to get new id
string maxIdQuery = dbConnection.CreateSelectCommandText(
"Uzivatele",
new string[] { "max(ID) + 1" },
null,
null
);
// Get id
string id = dbConnection.ExecuteSqlScalar(maxIdQuery).ToString();
// Create columns field to save
string[] columns = new string[] {
"ID",
"UzivatelskeJmeno",
"Heslo",
"jeAdmin",
"JeStavbyvedouci",
"JeRozpoctar"
};
// Create values field to save
string[] values = new string[]{
id,
this.userName,
this.password,
this.IsAdmin.ToString(),
this.IsConstructionManager.ToString(),
this.IsCalculationManager.ToString()
};
// Save query
string query = dbConnection.CreateNonQueryCommandText(
Database.NonQueryCommandType.Insert,
"Uzivatele",
columns,
values,
null
);
// Save user to database
dbConnection.ExecuteSqlNonQuery(query);
}
/// <summary>
/// Updates user in specified solumns with specified values
/// </summary>
/// <param name="dbConnection">DatabaseConnection</param>
/// <param name="columns">Columns to update</param>
/// <param name="values">New values to column</param>
private void UpdateUserInDatabase(Database.DatabaseConnection dbConnection, string[] columns, string[] values)
{
if (columns == null || values == null
|| columns.Length == 0 || values.Length == 0
|| columns.Length != values.Length)
return; // Invalid input data
// Create query
string query = dbConnection.CreateNonQueryCommandText(
Database.NonQueryCommandType.Update,
"Uzivatele",
columns,
values,
string.Format("ID = '{0}'", this.ID)
);
// Execute query
dbConnection.ExecuteSqlNonQuery(query);
}
/// <summary>
/// Deletes current user from database
/// </summary>
/// <param name="databaseConnection">KaRaFa database connection</param>
public void DeleteFromDatabase(Database.DatabaseConnection databaseConnection)
{
// delete query
string query = databaseConnection.CreateNonQueryCommandText(
Database.NonQueryCommandType.Delete,
Properties.Resources.TABLE_USERS,
null,
null,
string.Format("ID = {0}", this.ID)
);
// Save user to database
databaseConnection.ExecuteSqlNonQuery(query);
}
