/// <summary> /// Create detail of order. /// </summary> /// <param name="orderDetail">The object of detail that you want to create.</param> public void CreateOrderDetail(Guid OrderOfService_Id, Guid Service_Id, DateTime OrderOfServiceDetail_FromDate, DateTime OrderOfServiceDetail_ToDate, int OrderOfServiceDetail_NumberOfEmployee) { try { OrderOfServiceDetail oosd = OD.GetOrderDetail(OrderOfService_Id, Service_Id); if (oosd != null) throw new Exception("Information of this order has been created."); OrderOfServiceDetail newOrderDetail = new OrderOfServiceDetail(); newOrderDetail.OrderOfService_Id = OrderOfService_Id; newOrderDetail.OrderOfServiceDetail_FromDate = OrderOfServiceDetail_FromDate; newOrderDetail.OrderOfServiceDetail_NumberOfEmployee = OrderOfServiceDetail_NumberOfEmployee; newOrderDetail.OrderOfServiceDetail_ToDate = OrderOfServiceDetail_ToDate; newOrderDetail.Service_Id = Service_Id; int result = OD.CreateOrderDetail(newOrderDetail); if (result == -1) { throw new Exception("An error occurred while executing this operation."); } } catch (Exception ex) { throw new Exception(ex.Message); } }
/// <summary> /// Create detail of order. /// </summary> /// <param name="orderDetail">The object of detail that you want to create.</param> /// <returns>Return the number of rows affected or return -1 if occur exception.</returns> public int CreateOrderDetail(OrderOfServiceDetail orderDetail) { return DBHelper.Instance.Insert(orderDetail); }
/// <summary> /// Update order detail's information. /// </summary> /// <param name="orderDetail">The order's detail be updated.</param> /// <returns>Return the number of rows affected or return -1 if occur exception.</returns> public int UpdateOrderDetail(OrderOfServiceDetail orderDetail) { return DBHelper.Instance.Update(orderDetail, String.Format("OrderOfService_Id = '{0}' AND Service_Id = '{1}'", orderDetail.OrderOfService_Id.ToString(), orderDetail.Service_Id.ToString())); }