public int SaveCourseTee(CourseTee courseTee)
{
int r;
lock (locker)
{
if (courseTee.ID != 0)
{
connection = new SqliteConnection("Data Source=" + path);
connection.Open();
using (var command = connection.CreateCommand())
{
command.CommandText = "UPDATE [CourseTees] SET [CourseID] = ?, [TeeID] = ?, [CourseReportedYardage] = ? WHERE [_id] = ?;";
command.Parameters.Add(new SqliteParameter(DbType.Int32)
{
Value = courseTee.CourseID
});
command.Parameters.Add(new SqliteParameter(DbType.Int32)
{
Value = courseTee.CourseReportedYardage
});
command.Parameters.Add(new SqliteParameter(DbType.Int32)
{
Value = courseTee.TeeID
});
command.Parameters.Add(new SqliteParameter(DbType.Int32)
{
Value = courseTee.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 [CourseTees] ([CourseID],[TeeID],[CourseReportedYardage]) VALUES (?,?,?)";
command.Parameters.Add(new SqliteParameter(DbType.Int32)
{
Value = courseTee.CourseID
});
command.Parameters.Add(new SqliteParameter(DbType.Int32)
{
Value = courseTee.TeeID
});
command.Parameters.Add(new SqliteParameter(DbType.Int32)
{
Value = courseTee.CourseReportedYardage
});
r = command.ExecuteNonQuery();
}
connection.Close();
return(r);
}
}
}
public CourseTee GetCourseTee(int id)
{
var t = new CourseTee();
lock (locker)
{
connection = new SqliteConnection("Data Source=" + path);
connection.Open();
using (var command = connection.CreateCommand())
{
command.CommandText = "SELECT [_id], [CourseID], [TeeID], [CourseReportedYardage] FROM [CourseTees] WHERE [_id] = ?";
command.Parameters.Add(new SqliteParameter(DbType.Int32)
{
Value = id
});
var r = command.ExecuteReader();
while (r.Read())
{
t = FromReaderCourseTee(r);
break;
}
}
connection.Close();
}
return(t);
}
/// <summary>Convert from DataReader to CourseTee object</summary>
CourseTee FromReaderCourseTee(SqliteDataReader r)
{
var t = new CourseTee();
if (r["_id"] == System.DBNull.Value)
{
var j = 7;
}
else
{
t.ID = Convert.ToInt32(r["_id"]);
}
t.TeeID = Convert.ToInt32(r["TeeID"]);
t.CourseID = Convert.ToInt32(r["CourseID"]);
t.TeeName = r["TeeName"].ToString();
if (r["CourseReportedYardage"] == System.DBNull.Value)
{
t.CourseReportedYardage = 0;
}
else
{
t.CourseReportedYardage = Convert.ToInt32(r["CourseReportedYardage"]);
}
return(t);
}
public static int SaveCourseTee(CourseTee item)
{
return(me.db.SaveCourseTee(item));
}
public static int SaveCourseTee(CourseTee item)
{
return(CompleteGolfAppRepositoryADO.SaveCourseTee(item));
}
