public static void Delete(MType type)
{
string sql = @"DELETE FROM type WHERE id=@id";
DB db = DB.getDB(databaseFile);
Dictionary <string, object> parms = new Dictionary <string, object>();
parms.Add("@id", type.id);
db.NonQuery(sql, parms);
}
public static void Update(MType type)
{
string sql = @"UPDATE type
SET name=@name
WHERE id=@id";
DB db = DB.getDB(databaseFile);
Dictionary <string, object> parms = new Dictionary <string, object>();
parms.Add("@name", type.name);
parms.Add("@id", type.id);
db.NonQuery(sql, parms);
}
public static void Create(MType type)
{
string sql = @"INSERT INTO type (name)
VALUES (@name)";
DB db = DB.getDB(databaseFile);
Dictionary <string, object> parms = new Dictionary <string, object>();
parms.Add("@name", type.name);
if (db.NonQuery(sql, parms))
{
type.id = db.LastId();
}
}
public static ObservableCollection <MType> RetrieveAll()
{
ObservableCollection <MType> res = new ObservableCollection <MType>();
string sql = "SELECT * FROM type";
DB db = DB.getDB(databaseFile);
ISQLiteStatement statement = db.Query(sql);
while (statement.Step() == SQLiteResult.ROW)
{
MType e = new MType();
Mapping(statement, e);
res.Add(e);
}
return(res);
}
public static ObservableCollection <MType> RetrieveByName(string name)
{
ObservableCollection <MType> res = new ObservableCollection <MType>();
string sql = "SELECT * FROM type WHERE name=@name";
DB db = DB.getDB(databaseFile);
Dictionary <string, object> parms = new Dictionary <string, object>();
parms.Add("@name", name);
ISQLiteStatement statement = db.Query(sql, parms);
while (statement.Step() == SQLiteResult.ROW)
{
MType e = new MType();
Mapping(statement, e);
res.Add(e);
}
return(res);
}
private static void Mapping(ISQLiteStatement statement, MType e)
{
e.id = (long)statement["id"];
e.name = (string)statement["name"];
}
