/// <summary>
        /// Delete customer test by name
        /// </summary>
        /// <param name="name"></param>
        /// <returns></returns>
        public static CustomerRepsonse DeleteCustomerTestByName(string name)
        {
            CustomerRepsonse response = new CustomerRepsonse();

            try
            {
                var ct = db.CustomerTests.Where(x => x.Name == name);

                if (ct != null)
                {
                    response.message = "No customer found";
                    return(response);
                }

                if (ct.Count() > 1)
                {
                    response.message = "More than one customers with same name found";
                    return(response);
                }

                else
                {
                    db.CustomerTests.Remove(ct.FirstOrDefault());
                }
                db.SaveChanges();
                response.message = "Customer deleted successfully";
            }
            catch (Exception ex)
            {
                response.message = String.Format("Unable to add cutomer test. Inner Exception {0}", ex.InnerException);
            }
            return(response);
        }
        /// <summary>
        /// Update customer test by id
        /// </summary>
        /// <param name="id"></param>
        /// <param name="ct"></param>
        /// <returns></returns>
        public static CustomerRepsonse UpdateCustomerById(int id, CustomerTest ct)
        {
            CustomerRepsonse response = new CustomerRepsonse();

            try
            {
                var cust = db.CustomerTests.Where(x => x.ID == id).FirstOrDefault();

                if (cust != null)
                {
                    db.CustomerTests.Remove(cust);
                    //validate id
                    int maxId = db.CustomerTests.Where(x => x.ID != cust.ID).Max(x => x.ID);
                    if (maxId == ct.ID)
                    {
                        response.message = String.Format("There is already a customer with id {0}", id);
                        return(response);
                    }
                    db.CustomerTests.Add(ct);
                }
                else
                {
                    response.message = "No customer found";
                    return(response);
                }
                db.SaveChanges();
                response.message = "Customer Updated successfully";
            }
            catch (Exception ex)
            {
                response.message = String.Format("Unable to add cutomer test. Inner Exception {0}", ex.InnerException);
            }
            return(response);
        }
        /// <summary>
        /// Insert customer test
        /// </summary>
        /// <param name="ct"></param>
        /// <returns></returns>
        public static CustomerRepsonse InsertCustomerTest(CustomerTest ct)
        {
            CustomerRepsonse response = new CustomerRepsonse();

            try
            {
                //validate id
                int id = db.CustomerTests.Max(x => x.ID);
                if (id == ct.ID)
                {
                    response.message = String.Format("There is already a customer with id {0}", id);
                    return(response);
                }
                db.CustomerTests.Add(ct);
                db.SaveChanges();
                response.message = "Customer added successfully";
            }
            catch (Exception ex)
            {
                response.message = String.Format("Unable to add cutomer test. Inner Exception {0}", ex.InnerException);
            }
            return(response);
        }