/// <summary> /// Delete a single TaskType /// </summary> /// <param name="dc">DataContext</param> /// <param name="taskType"></param> public void Delete(DataContext dc, Domain.TaskType taskType) { dc = dc ?? Conn.GetContext(); var dbTaskType = dc.TaskTypes.Where(t => t.TaskTypeId == taskType.ID).SingleOrDefault(); if (dbTaskType == null) { return; } dc.TaskTypes.Attach(dbTaskType, true); dc.TaskTypes.DeleteOnSubmit(dbTaskType); dc.SubmitChanges(); }
/// <summary> /// Find TaskType by it's Enum type /// </summary> /// <param name="dc"></param> /// <param name="type"></param> /// <returns></returns> public Domain.TaskType Find(DataContext dc, TaskTypes type) { var result = All(dc).Where(t => t.Name == type.ToString()).SingleOrDefault(); if (result == null) { result = new Domain.TaskType { Name = type.ToString(), Type = type }; result.Save(); } return(result); }
/// <summary> /// Save a TaskType /// </summary> /// <param name="dc">DataContext</param> /// <param name="taskType"></param> /// <returns>returns the id of the saved taskType</returns> public int Save(DataContext dc, Domain.TaskType taskType) { dc = dc ?? Conn.GetContext(); var dcTaskType = dc.TaskTypes.Where(t => t.TaskTypeId == taskType.ID).SingleOrDefault(); var isNew = false; if (dcTaskType == null) { dcTaskType = new DataAccess.SqlRepository.TaskType(); isNew = true; } dcTaskType.Name = taskType.Name; if (isNew) { dc.TaskTypes.InsertOnSubmit(dcTaskType); } dc.SubmitChanges(); return(dcTaskType.TaskTypeId); }
/// <summary> /// Find TaskType by it's Enum type /// </summary> /// <param name="dc"></param> /// <param name="type"></param> /// <returns></returns> public Domain.TaskType Find(DataContext dc, TaskTypes type) { var result = All(dc).Where(t => t.Name == type.ToString()).SingleOrDefault(); if (result == null) { result = new Domain.TaskType { Name = type.ToString(), Type = type }; result.Save(); } return result; }