public void AddCustomerRequest(string cname, string cmobileno, string cemail, string caddinfo, string cdatetimepref, int ccity, string carea)
        {
            CustomerRequest ctemp = new CustomerRequest();

            ctemp.CustomerName             = cname;
            ctemp.CustomerMobile           = cmobileno;
            ctemp.CustomerRequestFor       = "Pest Control";
            ctemp.CustomerEmail            = cemail;
            ctemp.CustomerAdditionalInfo   = caddinfo;
            ctemp.CustomerDateTimePrefText = cdatetimepref;
            ctemp.City = ccity;
            ctemp.Area = carea;



            using (HandyBackOfficeEntities entities = new HandyBackOfficeEntities())
            {
                entities.Database.Connection.Open();
                entities.CustomerRequests.Add(ctemp);
                entities.SaveChanges();
            }
        }