/// <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); } } }
private static RBCTimeDataItem Copy(RBCTimeData td) { return(new RBCTimeDataItem { /*ItemId = td.ItemID,*/ Date = td.Date, Minutes = td.Minutes, Notes = td.Notes }); }
public static bool DeleteTime(RBCTimeData td) { // if (td.ItemID < 0) { return(false); } return(DeleteTime(td.ItemID)); }
public bool DeleteTime() { bool v = _rbcTimeData.ItemID >= 0 && RBCTimeDataInterface.DeleteTime(RBCTimeData); if (v) { _rbcTimeData = null; OnPropertyChanged("RBCTimeData"); } return v; }
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); } }
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; } }
public static RBCTimeData[] GetRBCTimeEntries(DateTime fromDate, DateTime toDate, SortOrder sortOrder) { //throw new NotImplementedException(); using (var db = new RBCTimeDataContext()) { try { var rtd = from x in db.RBCTimeDataItems where x.Date >= fromDate && x.Date <= toDate orderby x.Date select x; return(!rtd.Any() ? null : rtd.Select(i => RBCTimeData.Copy(i)).ToArray()); } catch { return(null); } } }
/// <summary> /// Gets the RBC Time Data for a given itemID. /// </summary> /// <param name="itemID">The item ID to look up.</param> /// <returns>The time data for the given item id.</returns> public static RBCTimeData GetRBCTimeData(int itemID) { // if (itemID < 0) { return(null); } using (var db = new RBCTimeDataContext()) { try { var rtd = db.RBCTimeDataItems.Single(s => s.ItemId == itemID); if (rtd == null) { return(null); } return(RBCTimeData.Copy(rtd)); } catch { return(null); } } }
/// <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 bool ConvertToRBCTime() { var rtd = new RBCTimeData { Minutes = TimeData.Minutes, Date = TimeData.Date, Notes = TimeData.Notes }; return DeleteTime() && RBCTimeDataInterface.AddOrUpdateTime(ref rtd); }
public static bool DeleteTime(RBCTimeData td) { // if (td.ItemID < 0) return false; return DeleteTime(td.ItemID); }
private static RBCTimeDataItem Copy(RBCTimeData td) { return new RBCTimeDataItem { /*ItemId = td.ItemID,*/ Date = td.Date, Minutes = td.Minutes, Notes = td.Notes }; }