/// <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>
/// Get all details of 1 order.
/// </summary>
/// <param name="where">Condition to get the order's details.</param>
/// <returns>A list object of order's detail type.</returns>
public List <OrderOfServiceDetail> GetAllOrderDetails(String where)
{
List <OrderOfServiceDetail> list = new List <OrderOfServiceDetail>();
List <Object> listObj = DBHelper.Instance.Select("OrderOfServiceDetail", String.Format("{0}", where), null, -1, -1);
foreach (Object item in listObj)
{
OrderOfServiceDetail oosd = (OrderOfServiceDetail)item;
list.Add(oosd);
}
return(list);
}
/// <summary>
/// Update order's detail.
/// </summary>
/// <param name="orderId">Id of the order.</param>
/// <param name="serviceId">Id of the service in order.</param>
/// <param name="fromDate">The date begin use service.</param>
/// <param name="toDate">The date end use service.</param>
/// <param name="number">Number of employee support service.</param>
public void UpdateOrderDetail(Guid orderId, Guid serviceId, String fromDate, String toDate, int number)
{
OrderOfServiceDetail orderDetail = OD.GetOrderDetail(orderId, serviceId);
if (fromDate != null)
{
orderDetail.OrderOfServiceDetail_FromDate = DateTime.Parse(fromDate);
}
if (toDate != null)
{
orderDetail.OrderOfServiceDetail_ToDate = DateTime.Parse(toDate);
}
orderDetail.OrderOfServiceDetail_NumberOfEmployee = number;
int result = OD.UpdateOrderDetail(orderDetail);
if (result == -1)
{
throw new Exception("An error occurred while executing this operation.");
}
}
/// <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())));
}
