/// <summary>
/// Updates the time.
/// </summary>
/// <param name="td">The td.</param>
/// <returns>System.Int32.</returns>
/// <exception cref="MyTimeDatabaseLib.TimeDataItemNotFoundException">Couldn't find the time data with that id.</exception>
public static bool UpdateTime(ref TimeData td)
{
if (td.ItemId < 0)
{
return(AddTime(ref td));
}
int itemId = td.ItemId;
using (var db = new TimeDataContext(TimeDataContext.DBConnectionString)) {
try {
TimeDataItem tdi = db.TimeDataItems.Single(s => s.ItemId == itemId);
tdi.BibleStudies = td.BibleStudies;
tdi.Books = td.Books;
tdi.Brochures = td.Brochures;
tdi.Date = td.Date;
tdi.Magazines = td.Magazines;
tdi.Minutes = td.Minutes;
tdi.Notes = td.Notes;
tdi.ReturnVisits = td.ReturnVisits;
tdi.Tracts = td.Tracts;
db.SubmitChanges();
return(true);
} catch (InvalidOperationException) {
return(AddTime(ref td));
} catch {
throw new TimeDataItemNotFoundException("Couldn't find the time data with that id.");
}
}
}
/// <summary>
/// Adds the time.
/// </summary>
/// <param name="d">The d.</param>
public static bool AddTime(ref TimeData d)
{
using (var db = new TimeDataContext(TimeDataContext.DBConnectionString)) {
var newTd = TimeData.Copy(d);
db.TimeDataItems.InsertOnSubmit(newTd);
db.SubmitChanges();
d.ItemId = newTd.ItemId;
return(newTd.ItemId > 0);
}
}
/// <summary>
/// Deletes the time.
/// </summary>
/// <param name="itemId">The item id.</param>
public static bool DeleteTime(int itemId)
{
using (var db = new TimeDataContext(TimeDataContext.DBConnectionString)) {
try {
TimeDataItem t = db.TimeDataItems.Single(s => s.ItemId == itemId);
db.TimeDataItems.DeleteOnSubmit(t);
db.SubmitChanges();
return(true);
} catch (InvalidOperationException) { return(false); }
}
}