public bool DeleteProductMaintenanceRequest(int id)
 {
     try
     {
         Quiz.Core.EntityModel.tblProductMaintenance productRequest = _Context.tblProductMaintenances.Find(id);
         _Context.tblProductMaintenances.Remove(productRequest);;
         _Context.SaveChanges();
         return(true);
     }
     catch (Exception ex)
     {
         return(false);
     }
 }
        public bool SaveProductMaintenanceRequests(ProductMaintenanceViewModel ProductMaintenanceRequest)
        {
            Quiz.Core.EntityModel.tblProductMaintenance tblProductMaintenance = new Quiz.Core.EntityModel.tblProductMaintenance();
            bool result = false;

            try
            {
                if (ProductMaintenanceRequest.Id == 0)
                {
                    Mapper.Map(ProductMaintenanceRequest, tblProductMaintenance);

                    tblProductMaintenance.CreatedOn = DateTime.Now;
                    if (tblProductMaintenance.DateOfService == DateTime.MinValue)
                    {
                        tblProductMaintenance.DateOfService = DateTime.Now;
                    }
                    tblProductMaintenance.CreatedOn = DateTime.Now;
                    tblProductMaintenance.CreatedBy = 101;
                    tblProductMaintenance.IsActive  = true;
                    tblProductMaintenance.IsDeleted = false;
                    _Context.tblProductMaintenances.Add(tblProductMaintenance);
                    _Context.SaveChanges();
                    result = true;
                }
                else
                {
                    var tbl = _Context.tblProductMaintenances.Where(x => x.Id == ProductMaintenanceRequest.Id).FirstOrDefault();
                    tbl.Cost          = ProductMaintenanceRequest.Cost;
                    tbl.DateOfService = ProductMaintenanceRequest.DateOfService;
                    tbl.engineerId    = ProductMaintenanceRequest.engineerId;
                    tbl.SpairPartId   = ProductMaintenanceRequest.SpairPartId;
                    tbl.ProductId     = ProductMaintenanceRequest.ProductId;
                    _Context.SaveChanges();
                    result = true;
                }
            }
            catch (Exception EX)
            {
                result = false;
            }
            return(result);
        }