Exemple #1
0
        /// <summary>
        /// Get Customer Class
        /// </summary>
        /// <param name="line_of_business"></param>
        /// <param name="policy_type"></param>
        /// <param name="vehicle_type"></param>
        /// <param name="zone"></param>
        /// <param name="country"></param>
        /// <param name="channel"></param>
        /// <param name="supervisor"></param>
        /// <param name="GPProductID"></param>
        /// <returns></returns>
        public string GetCustomerClass(string line_of_business, string policy_type, string vehicle_type, string zone, string country, string channel, string supervisor, string GPProductID)
        {
            var contexto  = new ATLANEntities();
            var custclass = string.Empty;

            try
            {
                custclass = contexto.usp_ST_SYSFLEX_CUSTOMER_GET_CLASS(line_of_business, policy_type, vehicle_type, zone, country, channel, supervisor, GPProductID).FirstOrDefault();

                return(custclass);
            }
            catch (EntityException ex)
            {
                log.LogExeption("Ocurrió un error: ", 2, ex);
                throw;
            }
            catch (Exception ex)
            {
                log.LogExeption("Ocurrió un error: ", 2, ex);
                throw;
            }
            finally
            {
                contexto.Dispose();
            }
        }