/// <summary>
        /// Add Service Order Async
        /// </summary>
        /// <param name="serviceOrder"></param>
        /// <returns></returns>
        public async Task AddServiceOrderAsync(TblServiceOrder serviceOrder)
        {
            serviceOrder.Active = true;
            await _databaseDbContext.TblServiceOrder.AddAsync(serviceOrder);

            await _databaseDbContext.SaveChangesAsync();
        }
        /// <summary>
        /// Update Service Order Async
        /// </summary>
        /// <param name="UpdatedServiceOrder"></param>
        /// <returns></returns>
        public async Task UpdateServiceOrderAsync(TblServiceOrder UpdatedServiceOrder)
        {
            var serviceOrder = _databaseDbContext.TblServiceOrder.FirstOrDefaultAsync(_ => _.ServiceOrderId == UpdatedServiceOrder.ServiceOrderId).Result;

            if (null != serviceOrder)
            {
                serviceOrder.ServiceDescription = UpdatedServiceOrder.ServiceDescription;
                serviceOrder.Title        = UpdatedServiceOrder.Title;
                serviceOrder.DueDate      = UpdatedServiceOrder.DueDate;
                serviceOrder.DateAssigned = UpdatedServiceOrder.DateAssigned;
                serviceOrder.EmployeeId   = UpdatedServiceOrder.EmployeeId;
            }
            await _databaseDbContext.SaveChangesAsync();
        }