private static bool AddTime(ref RBCTimeData td)
{
//throw new NotImplementedException();
using (var db = new RBCTimeDataContext()) {
var newTd = Copy(td);
db.RBCTimeDataItems.InsertOnSubmit(newTd);
db.SubmitChanges();
td.ItemID = newTd.ItemId;
return td.ItemID >= 0;
}
}
/// <summary>
/// Adds or Updates the RBC Time.
/// </summary>
/// <param name="td">The Time Data to Add/Update. If the ItemId is -1 it will automatically add it.</param>
/// <returns>[true] if successful, otherwise [false].</returns>
public static bool AddOrUpdateTime(ref RBCTimeData td)
{
if (td.ItemID < 0) return AddTime(ref td);
using (var db = new RBCTimeDataContext()) {
try {
int i = td.ItemID;
var tdUpdate = db.RBCTimeDataItems.Single(s => s.ItemId == i);
if (tdUpdate == null) return AddTime(ref td);
tdUpdate.Minutes = td.Minutes;
tdUpdate.Notes = td.Notes;
tdUpdate.Date = td.Date;
db.SubmitChanges();
return true;
} catch (InvalidOperationException) {
return AddTime(ref td);
} catch {
return false;
}
}
}
public static bool DeleteTime(int ItemID)
{
if (ItemID < 0) return false;
using (var db = new RBCTimeDataContext()) {
try {
var rtd = db.RBCTimeDataItems.Single(s => s.ItemId == ItemID);
if (rtd == null) return false;
db.RBCTimeDataItems.DeleteOnSubmit(rtd);
db.SubmitChanges();
return true;
} catch { return false; }
}
}
