public int ItemStatusUpdate(ItemStatus itemStatus)
{
try
{
string commandText =
@"UPDATE ItemStatus SET Name = @name, Description = @description WHERE Id = " +
itemStatus.Id;
Log.Debug("ItemStatusUpdate: [{0}], ItemStatus={1}", commandText, itemStatus.FormatItemStatus());
using (sqLiteConnection)
{
using (SQLiteCommand sqLiteCommand = new SQLiteCommand(commandText, sqLiteConnection))
{
sqLiteConnection.Open();
sqLiteCommand.Parameters.AddWithValue("@name", itemStatus.Name);
sqLiteCommand.Parameters.AddWithValue("@description", itemStatus.Description);
int rowsUpdated = sqLiteCommand.ExecuteNonQuery();
sqLiteConnection.Close();
return rowsUpdated;
}
}
}
catch (Exception exception)
{
Log.Error(exception.ToString);
return 0;
}
}
private ItemStatus ItemStatusSelect(string commandText)
{
try
{
using (sqLiteConnection)
{
sqLiteConnection.Open();
SQLiteCommand mycommand = new SQLiteCommand(sqLiteConnection) {CommandText = commandText};
SQLiteDataReader reader = mycommand.ExecuteReader(CommandBehavior.SequentialAccess);
while (reader.Read())
{
int id = reader.GetInt32(0);
string name = reader.GetString(1);
string description = reader.GetValue(2).ToString();
ItemStatus itemStatus = new ItemStatus
{
Id = id,
Name = name,
Description = description,
};
Log.Debug("Found ItemStatus: {0}", itemStatus.FormatItemStatus());
return itemStatus;
}
reader.Close();
sqLiteConnection.Close();
}
}
catch (Exception exception)
{
Log.Error(exception.ToString());
}
return null;
}
public int ItemStatusInsert(ItemStatus itemStatus)
{
string insertCommand = String.Format(@"INSERT INTO ItemStatus (Name, Description) VALUES('{0}', '{1}')",
itemStatus.Name, itemStatus.Description);
return ExecuteNonQuery(insertCommand);
}
