public Tee GetTee(int id)
{
var t = new Tee();
lock (locker)
{
connection = new SqliteConnection("Data Source=" + path);
connection.Open();
using (var command = connection.CreateCommand())
{
command.CommandText = "SELECT [_id], [TeeName] From Tees WHERE [_id] = ?";
command.Parameters.Add(new SqliteParameter(DbType.Int32)
{
Value = id
});
var r = command.ExecuteReader();
while (r.Read())
{
t = FromReader(r);
break;
}
}
connection.Close();
}
return(t);
}
/// <summary>Convert from DataReader to Tee object</summary>
Tee FromReader(SqliteDataReader r)
{
var t = new Tee();
t.ID = Convert.ToInt32(r["_id"]);
t.TeeName = r["TeeName"].ToString();
return(t);
}
public int SaveTee(Tee item)
{
int r;
lock (locker)
{
if (item.ID != 0)
{
connection = new SqliteConnection("Data Source=" + path);
connection.Open();
using (var command = connection.CreateCommand())
{
command.CommandText = "UPDATE [Tees] SET [TeeName] = ? WHERE [_id] = ?;";
command.Parameters.Add(new SqliteParameter(DbType.String)
{
Value = item.TeeName
});
command.Parameters.Add(new SqliteParameter(DbType.Int32)
{
Value = item.ID
});
r = command.ExecuteNonQuery();
}
connection.Close();
return(r);
}
else
{
connection = new SqliteConnection("Data Source=" + path);
connection.Open();
using (var command = connection.CreateCommand())
{
command.CommandText = "INSERT INTO [Tees] ([TeeName]) VALUES (?)";
command.Parameters.Add(new SqliteParameter(DbType.String)
{
Value = item.TeeName
});
r = command.ExecuteNonQuery();
}
connection.Close();
return(r);
}
}
}
public static int SaveTee(Tee item)
{
return(CompleteGolfAppRepositoryADO.SaveTee(item));
}
public static int SaveTee(Tee item)
{
return(me.db.SaveTee(item));
}