public void DeleteWorkOrder(WorkOrder workOrder) { using (ISession session = HibernateProvider.Factory.OpenSession()) { session.Delete(workOrder); session.Flush(); } }
public void InsertWorkOrder(WorkOrder workOrder) { using (ISession session = HibernateProvider.Factory.OpenSession()) { session.SaveOrUpdate(workOrder); session.Flush(); } }
/// <summary> /// Deprecated Method for adding a new object to the WorkOrders EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToWorkOrders(WorkOrder workOrder) { base.AddObject("WorkOrders", workOrder); }
public bool TryLoadWorkOrderByJobID(string jobID, out WorkOrder workOrder) { bool bSuccess = false; workOrder = null; //TODO: prone to SQL injection string sqlQuery = string.Format("SELECT * FROM WorkOrders WHERE JobID = '{0}'", jobID); try { OleDbCommand sqlCommand = new OleDbCommand(sqlQuery, _accessConnection); OleDbDataReader reader = sqlCommand.ExecuteReader(); while (reader.Read()) { workOrder = new WorkOrder(); workOrder.Load(reader); bSuccess = true; } } catch (Exception e) { } return bSuccess; }
/// <summary> /// Create a new WorkOrder object. /// </summary> /// <param name="workOrderID">Initial value of the WorkOrderID property.</param> public static WorkOrder CreateWorkOrder(global::System.Int32 workOrderID) { WorkOrder workOrder = new WorkOrder(); workOrder.WorkOrderID = workOrderID; return workOrder; }