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)); }