using System;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using System.Data;
using System.Globalization;
using System.Linq;
using System.Runtime.InteropServices;
using System.Text.RegularExpressions;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Forms;
using ClosedXML.Excel;
using Gestor.Application.Actions;
using Gestor.Application.Componentes;
using Gestor.Application.Helpers;
using Gestor.Application.Servicos.Seguros.Itens;
using Gestor.Application.ViewModels.Generic;
using Gestor.Common.Validation;
using Gestor.Model.Common;
using Gestor.Model.Domain.Common;
using Gestor.Model.Domain.Configuracoes;
using Gestor.Model.Domain.Generic;
using Gestor.Model.Domain.Seguros;
using Gestor.Model.Helper;
using Microsoft.Office.Interop.Excel;

namespace Gestor.Application.ViewModels.Seguros.Itens;

public class AutoViewModel : ItemViewModel, IDisposable
{
	private new readonly ItemServico _itemServico;

	private readonly AutoServico _servico;

	private bool _allowAlterarExcluir = true;

	private Visibility _isVisiblePorcentagemReferencia = (Visibility)2;

	private Visibility _isVisibleValorDeterminado = (Visibility)2;

	private object _cobertura;

	private List<Combustivel> _combustivel = ((Combustivel[])Enum.GetValues(typeof(Combustivel))).OrderBy((Combustivel x) => ValidationHelper.GetCategory((Enum)(object)x)).ToList();

	private Item _selectedItem = new Item();

	private List<Fabricante> _fabricantes;

	private Fabricante _selectedFabricante;

	private string _codigoItem;

	private Categoria? _categocia;

	private UsoVeiculo? _usoVeiculo;

	private Item ItemSelecionado { get; set; }

	private Ramo Ramo { get; }

	public bool Invoke { get; set; }

	public bool AllowAlterarExcluir
	{
		get
		{
			return _allowAlterarExcluir;
		}
		set
		{
			_allowAlterarExcluir = value;
			OnPropertyChanged("AllowAlterarExcluir");
		}
	}

	public Visibility IsVisiblePorcentagemReferencia
	{
		get
		{
			//IL_0001: Unknown result type (might be due to invalid IL or missing references)
			return _isVisiblePorcentagemReferencia;
		}
		set
		{
			//IL_0001: Unknown result type (might be due to invalid IL or missing references)
			//IL_0002: Unknown result type (might be due to invalid IL or missing references)
			_isVisiblePorcentagemReferencia = value;
			OnPropertyChanged("IsVisiblePorcentagemReferencia");
		}
	}

	public Visibility IsVisibleValorDeterminado
	{
		get
		{
			//IL_0001: Unknown result type (might be due to invalid IL or missing references)
			return _isVisibleValorDeterminado;
		}
		set
		{
			//IL_0001: Unknown result type (might be due to invalid IL or missing references)
			//IL_0002: Unknown result type (might be due to invalid IL or missing references)
			_isVisibleValorDeterminado = value;
			OnPropertyChanged("IsVisibleValorDeterminado");
		}
	}

	public object Cobertura
	{
		get
		{
			return _cobertura;
		}
		set
		{
			_cobertura = value;
			OnPropertyChanged("Cobertura");
		}
	}

	public List<Combustivel> Combustivel
	{
		get
		{
			return _combustivel;
		}
		set
		{
			_combustivel = value;
			OnPropertyChanged("Combustivel");
		}
	}

	public Item SelectedItem
	{
		get
		{
			return _selectedItem;
		}
		set
		{
			_selectedItem = value;
			VerificarEnables((value != null) ? new long?(((DomainBase)value).Id) : null);
			OnPropertyChanged("SelectedItem");
		}
	}

	public List<Fabricante> Fabricantes
	{
		get
		{
			return _fabricantes;
		}
		set
		{
			_fabricantes = value;
			OnPropertyChanged("Fabricantes");
		}
	}

	public Fabricante SelectedFabricante
	{
		get
		{
			return _selectedFabricante;
		}
		set
		{
			_selectedFabricante = value;
			OnPropertyChanged("SelectedFabricante");
		}
	}

	public string CodigoItem
	{
		get
		{
			return _codigoItem;
		}
		set
		{
			_codigoItem = value;
			OnPropertyChanged("CodigoItem");
		}
	}

	public Categoria? Categoria
	{
		get
		{
			return _categocia;
		}
		set
		{
			_categocia = value;
			Item selectedItem = SelectedItem;
			if (((selectedItem != null) ? selectedItem.Auto : null) != null)
			{
				SelectedItem.Auto.Categoria = value;
			}
			OnPropertyChanged("Categoria");
		}
	}

	public UsoVeiculo? UsoVeiculo
	{
		get
		{
			return _usoVeiculo;
		}
		set
		{
			//IL_0002: Unknown result type (might be due to invalid IL or missing references)
			//IL_0008: Invalid comparison between Unknown and I4
			//IL_000c: Unknown result type (might be due to invalid IL or missing references)
			//IL_0012: Invalid comparison between Unknown and I4
			if ((int)value.GetValueOrDefault() == 2 || (int)value.GetValueOrDefault() == 3)
			{
				SelectedItem.Auto.Categoria = (Categoria)3;
				Categoria = (Categoria)3;
			}
			Item selectedItem = SelectedItem;
			if (((selectedItem != null) ? selectedItem.Auto : null) != null && value.HasValue)
			{
				SelectedItem.Auto.UsoVeiculo = value;
			}
			_usoVeiculo = value;
			OnPropertyChanged("UsoVeiculo");
		}
	}

	public AutoViewModel(bool substituir = false, ManutencaoItem manutencao = null, Item itemSelecionado = null, Ramo ramo = null, bool endossoRenovacao = false)
	{
		//IL_0009: Unknown result type (might be due to invalid IL or missing references)
		//IL_0010: Unknown result type (might be due to invalid IL or missing references)
		//IL_0059: Unknown result type (might be due to invalid IL or missing references)
		//IL_0063: Expected O, but got Unknown
		//IL_00b1: Unknown result type (might be due to invalid IL or missing references)
		Invoke = itemSelecionado == null;
		ItemSelecionado = itemSelecionado ?? ConsultaViewModel.ItemSelecionado;
		Ramo = ramo ?? ConsultaViewModel.DocumentoSelecionado.Controle.Ramo;
		if (Invoke)
		{
			ItemSelecionado = (Item)(((object)ItemSelecionado) ?? ((object)new Item()));
			ItemSelecionado.Documento = ConsultaViewModel.DocumentoSelecionado;
		}
		_itemServico = new ItemServico();
		_servico = new AutoServico();
		Seleciona(ItemSelecionado);
		if (substituir)
		{
			Substituir(ItemSelecionado);
		}
		if (manutencao != null)
		{
			Manter(ItemSelecionado, manutencao);
		}
		AllowAlterarExcluir = !endossoRenovacao;
		CarregaCobertura();
	}

	public void CarregaCobertura()
	{
		CoberturaViewModel.Item = ItemSelecionado;
		CoberturaViewModel.Ramo = Ramo;
		Cobertura = new CoberturaView(CoberturaViewModel);
	}

	public void Descarregar()
	{
		Cobertura = null;
	}

	private void WorkOnSelectedAuto(Auto value)
	{
		if (value != null && ((DomainBase)value).Id != 0L)
		{
			SelectedFabricante = ((IEnumerable<Fabricante>)Fabricantes).FirstOrDefault((Func<Fabricante, bool>)delegate(Fabricante x)
			{
				int id = x.Id;
				Fabricante fabricante = value.Fabricante;
				return id == ((fabricante != null) ? new int?(fabricante.Id) : null);
			});
		}
	}

	public async void Seleciona(Item item)
	{
		Loading(isLoading: true);
		await PermissaoTela((TipoTela)3);
		await SelecionaItem(item);
		Loading(isLoading: false);
	}

	public async void Substituir(Item item)
	{
		base.ItemSubstituido = item;
		await Incluir(substituir: true);
	}

	public void Manter(Item item, ManutencaoItem manutencao)
	{
		//IL_0001: Unknown result type (might be due to invalid IL or missing references)
		//IL_0007: Invalid comparison between Unknown and I4
		if ((int)manutencao.Tipo == 1)
		{
			base.ItemSubstituido = item;
		}
		Manter(manutencao);
		base.Mantido = true;
	}

	public async Task SelecionaItem(Item item, bool registrar = true)
	{
		if (item != null && LastAccessId == ((DomainBase)item).Id && (int)LastAccessTela == 9)
		{
			return;
		}
		base.Mantido = false;
		Fabricantes = Recursos.Fabricantes;
		if (!new List<long> { 5L, 37L }.Contains(((DomainBase)Ramo).Id))
		{
			return;
		}
		CoberturaViewModel.Ramo = Ramo;
		if (CoberturaViewModel.CoberturasPadrao == null)
		{
			await CoberturaViewModel.SelectionaCoberturas();
		}
		if (item == null || ((DomainBase)item).Id == 0L)
		{
			SelectedItem = null;
			CoberturaViewModel.Coberturas = null;
			base.IsVisible = (Visibility)0;
			return;
		}
		Loading(isLoading: true);
		item = await _itemServico.BuscarItemPorIdAsync(((DomainBase)item).Id);
		Item val = item;
		val.Auto = await _itemServico.BuscaAuto(((DomainBase)item).Id);
		SelectedItem = item;
		((DomainBase)SelectedItem).Initialize();
		Initialized = true;
		WorkOnSelectedAuto(SelectedItem.Auto);
		CoberturaViewModel.Item = item;
		await CoberturaViewModel.CancelarAlteracao();
		if (registrar)
		{
			RegistrarAcao("ACESSOU ITEM DE DESCRIÇÃO \"" + SelectedItem.Descricao + "\"", ((DomainBase)SelectedItem).Id, (TipoTela)3, $"ID ITEM: {((DomainBase)SelectedItem).Id}\nID DOCUMENTO: {((DomainBase)SelectedItem.Documento).Id}\nRAMO: {SelectedItem.Documento.Controle.Ramo.Nome}\nCLIENTE: {SelectedItem.Documento.Controle.Cliente.Nome}\nID CLIENTE: {((DomainBase)SelectedItem.Documento.Controle.Cliente).Id}");
		}
		LastAccessId = ((DomainBase)SelectedItem).Id;
		LastAccessTela = (TipoTela)3;
		CodigoItem = ((DomainBase)SelectedItem).Id.ToString();
		UsoVeiculo = SelectedItem.Auto.UsoVeiculo;
		Categoria = SelectedItem.Auto.Categoria;
		Loading(isLoading: false);
	}

	public async Task<List<KeyValuePair<string, string>>> Validate()
	{
		List<KeyValuePair<string, string>> errors = new List<KeyValuePair<string, string>>();
		if (string.IsNullOrEmpty(SelectedItem.Auto.Chassi))
		{
			return errors;
		}
		if (Recursos.Configuracoes.Any((ConfiguracaoSistema x) => (int)x.Configuracao == 26))
		{
			return errors;
		}
		Documento val = await new AutoServico().BuscarAuto(SelectedItem.Auto.Chassi, ((DomainBase)SelectedItem.Auto).Id, SelectedItem.Documento.Vigencia1, SelectedItem.Documento.Vigencia2, ((DomainBase)SelectedItem.Documento.Controle.Seguradora).Id);
		if (val == null)
		{
			return errors;
		}
		if (!AllowAlterarExcluir && ((DomainBase)SelectedItem.Documento.Controle).Id == ((DomainBase)val.Controle).Id)
		{
			return errors;
		}
		errors.Add(new KeyValuePair<string, string>("Chassi", "CHASSI JÁ CADASTRADO NA APÓLICE " + val.Apolice + " DO CLIENTE " + val.Controle.Cliente.Nome + "."));
		return errors;
	}

	public async Task<List<KeyValuePair<string, string>>> Validate(Item item)
	{
		List<KeyValuePair<string, string>> errors = new List<KeyValuePair<string, string>>();
		if (string.IsNullOrEmpty(item.Auto.Chassi))
		{
			return errors;
		}
		if (Recursos.Configuracoes.Any((ConfiguracaoSistema x) => (int)x.Configuracao == 26))
		{
			return errors;
		}
		Documento val = await new AutoServico().BuscarAuto(item.Auto.Chassi, ((DomainBase)item.Auto).Id, item.Documento.Vigencia1, item.Documento.Vigencia2, ((DomainBase)item.Documento.Controle.Seguradora).Id);
		if (val == null)
		{
			return errors;
		}
		if (!AllowAlterarExcluir && ((DomainBase)item.Documento.Controle).Id == ((DomainBase)val.Controle).Id)
		{
			return errors;
		}
		errors.Add(new KeyValuePair<string, string>("Chassi", "CHASSI JÁ CADASTRADO NA APÓLICE " + val.Apolice + " DO CLIENTE " + val.Controle.Cliente.Nome + "."));
		return errors;
	}

	public async Task<List<KeyValuePair<string, string>>> Salvar()
	{
		SelectedItem.Auto.Placa = ((!string.IsNullOrEmpty(SelectedItem.Auto.Placa)) ? ValidationHelper.FormataPlaca(SelectedItem.Auto.Placa) : string.Empty);
		Item selectedItem = SelectedItem;
		string[] array = new string[7];
		Fabricante fabricante = SelectedItem.Auto.Fabricante;
		array[0] = ((fabricante != null) ? fabricante.Descricao : null);
		array[1] = " ";
		array[2] = SelectedItem.Auto.Modelo;
		array[3] = " / ";
		array[4] = SelectedItem.Auto.Chassi;
		array[5] = " / ";
		array[6] = SelectedItem.Auto.Placa;
		selectedItem.Descricao = string.Concat(array);
		List<KeyValuePair<string, string>> errorMessages = SelectedItem.Validate(Recursos.Configuracoes.Any((ConfiguracaoSistema x) => (int)x.Configuracao == 18), Recursos.Configuracoes.Any((ConfiguracaoSistema x) => (int)x.Configuracao == 27));
		List<KeyValuePair<string, string>> list = errorMessages;
		list.AddRange(await Validate());
		if (errorMessages.Count > 0)
		{
			return errorMessages;
		}
		Item selectedItem2 = SelectedItem;
		selectedItem2.Coberturas = await CoberturaViewModel.LimpaCoberturas();
		string acao = ((((DomainBase)SelectedItem).Id == 0L) ? "INCLUIU" : "ALTEROU");
		string status = ((SelectedItem.Documento.Ordem <= 0) ? "" : (base.Mantido ? $"ITEM ALTERADO NO ENDOSSO ORDEM {SelectedItem.Documento.Ordem}" : ((base.ItemSubstituido != null) ? $"SUBSTITUIÇÃO DO ITEM {base.ItemSubstituido.Ordem} NO ENDOSSO ORDEM {SelectedItem.Documento.Ordem}" : $"ITEM INCLUÍDO NO ENDOSSO ORDEM {SelectedItem.Documento.Ordem}")));
		if (((DomainBase)SelectedItem).Id == 0L)
		{
			SelectedItem.Status = status;
		}
		SelectedItem = await _itemServico.Save(SelectedItem);
		if (!_itemServico.Sucesso)
		{
			return null;
		}
		if (base.ItemSubstituido != null)
		{
			string descricao = (base.Mantido ? $"ITEM ALTERADO NO ENDOSSO ORDEM {SelectedItem.Documento.Ordem}" : $"ITEM SUBSTITUIDO NO ENDOSSO ORDEM {SelectedItem.Documento.Ordem}");
			await _itemServico.Substituir(base.ItemSubstituido, ((DomainBase)SelectedItem).Id, descricao);
		}
		base.Mantido = false;
		await SelecionaItem(SelectedItem, registrar: false);
		ItemSelecionado = SelectedItem;
		if (Invoke)
		{
			ConsultaViewModel.ItemSelecionado = SelectedItem;
		}
		ToggleSnackBar(Ramo.Nome + " SALVO COM SUCESSO");
		RegistrarAcao(acao + " ITEM DE DESCRIÇÃO \"" + SelectedItem.Descricao + "\"", ((DomainBase)SelectedItem).Id, (TipoTela)3, $"ID ITEM: {((DomainBase)SelectedItem).Id}\nID DOCUMENTO: {((DomainBase)SelectedItem.Documento).Id}\nRAMO: {SelectedItem.Documento.Controle.Ramo.Nome}\nCLIENTE: {SelectedItem.Documento.Controle.Cliente.Nome}\nID CLIENTE: {((DomainBase)SelectedItem.Documento.Controle.Cliente).Id}");
		Alterar(alterar: false);
		return null;
	}

	public async Task<List<KeyValuePair<string, string>>> SalvarRange(IEnumerable<Item> list)
	{
		Item ultimoItem = new Item();
		List<KeyValuePair<string, string>> erros = new List<KeyValuePair<string, string>>();
		int ordeminicial = await QuantidadeDeItens(((DomainBase)list.First().Documento.Controle).Id);
		foreach (Item item in list)
		{
			if (!item.Auto.Isencao.HasValue)
			{
				item.Auto.Isencao = (Isencao)0;
			}
			if (!item.Auto.ZeroKm.HasValue)
			{
				item.Auto.ZeroKm = false;
			}
			if (!item.Auto.Financiado.HasValue)
			{
				item.Auto.Financiado = false;
			}
			if (!item.Auto.UsoVeiculo.HasValue)
			{
				item.Auto.UsoVeiculo = (UsoVeiculo)0;
			}
			item.Ordem = ordeminicial;
			ordeminicial++;
			item.Auto.Item = item;
			item.Auto.Placa = ((!string.IsNullOrEmpty(item.Auto.Placa)) ? ValidationHelper.FormataPlaca(item.Auto.Placa) : string.Empty);
			Item obj = item;
			string[] array = new string[7];
			Fabricante fabricante = item.Auto.Fabricante;
			array[0] = ((fabricante != null) ? fabricante.Descricao : null);
			array[1] = " ";
			array[2] = item.Auto.Modelo;
			array[3] = " / ";
			array[4] = item.Auto.Chassi;
			array[5] = " / ";
			array[6] = item.Auto.Placa;
			obj.Descricao = string.Concat(array);
			List<KeyValuePair<string, string>> errorMessages = item.Validate(Recursos.Configuracoes.Any((ConfiguracaoSistema x) => (int)x.Configuracao == 18), false);
			List<KeyValuePair<string, string>> list2 = errorMessages;
			list2.AddRange(await Validate(item));
			item.Status = ((item.Documento.Ordem > 0) ? $"ITEM INCLUÍDO NO ENDOSSO ORDEM {item.Documento.Ordem}" : "");
			if (errorMessages.Count > 0)
			{
				erros.Add(new KeyValuePair<string, string>("", item.Descricao));
				erros.AddRange(errorMessages);
			}
		}
		if (erros.Count > 0)
		{
			return erros;
		}
		foreach (Item item in list)
		{
			string acao = ((((DomainBase)item).Id == 0L) ? "INCLUIU" : "ALTEROU");
			ultimoItem = await _itemServico.Save(item);
			RegistrarAcao(acao + " ITEM DE DESCRIÇÃO \"" + item.Descricao + "\"", ((DomainBase)item).Id, (TipoTela)3, $"ID ITEM: {((DomainBase)item).Id}\nID DOCUMENTO: {((DomainBase)item.Documento).Id}\nRAMO: {item.Documento.Controle.Ramo.Nome}\nCLIENTE: {item.Documento.Controle.Cliente.Nome}\nID CLIENTE: {((DomainBase)item.Documento.Controle.Cliente).Id}");
		}
		SelectedItem = ultimoItem;
		await SelecionaItem(SelectedItem, registrar: false);
		ItemSelecionado = SelectedItem;
		if (Invoke)
		{
			ConsultaViewModel.ItemSelecionado = SelectedItem;
		}
		ToggleSnackBar("ITENS SALVOS COM SUCESSO");
		Alterar(alterar: false);
		return null;
	}

	public async Task<bool> Excluir()
	{
		if (SelectedItem == null || ((DomainBase)SelectedItem).Id == 0L)
		{
			return false;
		}
		if (!(await ShowMessage("DESEJA EXCLUIR?", "SIM", "NÃO")))
		{
			return false;
		}
		Loading(isLoading: true);
		bool num = await _servico.Delete(SelectedItem);
		Loading(isLoading: false);
		if (!num)
		{
			await ShowMessage("NÃO POSSÍVEL EXCLUIR O ITEM");
			return false;
		}
		RegistrarAcao("EXCLUIU ITEM DE DESCRIÇÃO \"" + SelectedItem.Descricao + "\"", ((DomainBase)SelectedItem).Id, (TipoTela)3, $"ID ITEM: {((DomainBase)SelectedItem).Id}\nID DOCUMENTO: {((DomainBase)SelectedItem.Documento).Id}\nRAMO: {SelectedItem.Documento.Controle.Ramo.Nome}\nCLIENTE: {SelectedItem.Documento.Controle.Cliente.Nome}\nID CLIENTE: {((DomainBase)SelectedItem.Documento.Controle.Cliente).Id}");
		ToggleSnackBar(Ramo.Nome + " EXCLUÍDO COM SUCESSO");
		return true;
	}

	public async Task<Fipe> BuscaModelo(string fipe)
	{
		return await _itemServico.BuscarModelo(fipe);
	}

	public async Task Incluir(bool substituir = false)
	{
		List<Cobertura> coberturas = ((CoberturaViewModel.Coberturas == null) ? CoberturaViewModel.CarregaCoberturaPadrao().ToList() : CoberturaViewModel.Coberturas.ToList());
		Item val = new Item();
		val.Documento = ItemSelecionado.Documento;
		Item val2 = val;
		int? ordem = (substituir ? base.ItemSubstituido.Ordem : new int?(await QuantidadeDeItens(((DomainBase)ItemSelecionado.Documento.Controle).Id)));
		val2.Ordem = ordem;
		val.Auto = new Auto
		{
			Isencao = (Isencao)0,
			ZeroKm = false,
			Financiado = false,
			UsoVeiculo = (UsoVeiculo)0,
			Categoria = (Categoria)3
		};
		val.Substituicao = (substituir ? new long?(((DomainBase)base.ItemSubstituido).Id) : null);
		Item item = val;
		bool flag = substituir;
		if (flag)
		{
			flag = await ShowMessage("DESEJA COPIAR OS DADOS DO ITEM?", "SIM", "NÃO");
		}
		if (flag)
		{
			((DomainBase)SelectedItem).Id = 0L;
			((DomainBase)SelectedItem.Auto).Id = 0L;
			Item selectedItem = SelectedItem;
			Item itemSubstituido = base.ItemSubstituido;
			selectedItem.Substituicao = ((itemSubstituido != null) ? new long?(((DomainBase)itemSubstituido).Id) : null);
			SelectedItem.Documento = ItemSelecionado.Documento;
		}
		else
		{
			SelectedItem = item;
			SelectedItem.Auto.Item = item;
			UsoVeiculo = SelectedItem.Auto.UsoVeiculo;
			Categoria = SelectedItem.Auto.Categoria;
		}
		if (item.Ordem.GetValueOrDefault() == 2 && !substituir && !(await ShowMessage("ESTA APÓLICE SERÁ UMA FROTA, DESEJA CONTINUAR?", "SIM", "NÃO")))
		{
			return;
		}
		flag = item.Ordem > 1;
		if (flag)
		{
			flag = await ShowMessage("DESEJA REPLICAR AS COBERTURAS DO ITEM SELECIONADO?", "SIM", "NÃO");
		}
		if (flag)
		{
			CoberturaViewModel.Coberturas = new ObservableCollection<Cobertura>();
			coberturas.ForEach(delegate(Cobertura x)
			{
				x.Item = SelectedItem;
				CoberturaViewModel.Coberturas.Add(x);
			});
		}
		else
		{
			CoberturaViewModel.CarregaPadrao();
		}
		if (substituir)
		{
			CoberturaViewModel.Coberturas = new ObservableCollection<Cobertura>();
			coberturas.ForEach(delegate(Cobertura x)
			{
				x.Item = SelectedItem;
				CoberturaViewModel.Coberturas.Add(x);
			});
		}
		Alterar(alterar: true);
	}

	public void Manter(ManutencaoItem manutencao)
	{
		//IL_0077: Unknown result type (might be due to invalid IL or missing references)
		List<Cobertura> obj = CoberturaViewModel.Coberturas?.ToList();
		((DomainBase)SelectedItem).Id = 0L;
		((DomainBase)SelectedItem.Auto).Id = 0L;
		Item selectedItem = SelectedItem;
		Item itemSubstituido = base.ItemSubstituido;
		selectedItem.Substituicao = ((itemSubstituido != null) ? new long?(((DomainBase)itemSubstituido).Id) : null);
		SelectedItem.Documento = ItemSelecionado.Documento;
		if ((int)manutencao.Tipo == 0)
		{
			SelectedItem.Sinistrado = false;
			SelectedItem.Status = "";
			SelectedItem.Sinistro = null;
			SelectedItem.Sinistros = null;
		}
		CoberturaViewModel.CarregaPadrao();
		CoberturaViewModel.Coberturas = new ObservableCollection<Cobertura>();
		obj?.ForEach(delegate(Cobertura x)
		{
			x.Item = SelectedItem;
			CoberturaViewModel.Coberturas.Add(x);
		});
		Alterar(alterar: true);
	}

	public async void CancelarAlteracao()
	{
		Loading(isLoading: true);
		await SelecionaItem(ItemSelecionado, registrar: false);
		await CoberturaViewModel.CancelarAlteracao();
		Alterar(alterar: false);
		Loading(isLoading: false);
	}

	public void Dispose()
	{
		Gestor.Application.Actions.Actions.UpdateItem = (Action<Item>)Delegate.Remove(Gestor.Application.Actions.Actions.UpdateItem, new Action<Item>(Seleciona));
		Gestor.Application.Actions.Actions.SubstituirItem = (Action<Item>)Delegate.Remove(Gestor.Application.Actions.Actions.SubstituirItem, new Action<Item>(Substituir));
		Gestor.Application.Actions.Actions.ManterItem = (Action<Item, ManutencaoItem>)Delegate.Remove(Gestor.Application.Actions.Actions.ManterItem, new Action<Item, ManutencaoItem>(Manter));
	}

	public void Atualiza(string valorSelecionado)
	{
		if (valorSelecionado == "MERCADO")
		{
			IsVisiblePorcentagemReferencia = (Visibility)0;
			IsVisibleValorDeterminado = (Visibility)2;
		}
		else
		{
			IsVisiblePorcentagemReferencia = (Visibility)2;
			IsVisibleValorDeterminado = (Visibility)0;
		}
	}

	public async void BaixarXls()
	{
		FolderBrowserDialog fbd = new FolderBrowserDialog();
		try
		{
			fbd.SelectedPath = Environment.SpecialFolder.Desktop.ToString();
			if ((int)((CommonDialog)fbd).ShowDialog() == 1 && !string.IsNullOrWhiteSpace(fbd.SelectedPath))
			{
				XLWorkbook val = new XLWorkbook();
				DataTable dataTable = new DataTable();
				List<string> list = new List<string>
				{
					"placa", "fabricante", "modelo", "fipe", "chassi", "anofabricacao", "anomodelo", "cor", "categoria", "combustivel",
					"zerokm", "renavam", "capacidade", "portas", "bonus", "ceppernoite", "ci", "financiado", "correcao", "isencao",
					"pcd", "cepcirculacao", "tipocobertura", "porcentagemreferencia", "tabelareferencia", "valordeterminado", "observacao", "pr casco", "fr casco", "lmi casco",
					"obs casco", "pr dm", "fr dm", "lmi dm", "obs dm", "pr dc", "fr dc", "lmi dc", "obs dc", "pr morte",
					"fr morte", "lmi morte", "obs morte", "pr invalidez", "fr invalidez", "lmi invalidez", "obs invalidez", "pr carro reserva", "fr carro reserva", "lmi carro reserva",
					"obs carro reserva", "pr vidros", "fr vidros", "lmi vidros", "obs vidros", "pr carroceria", "fr carroceria", "lmi carroceria", "obs carroceria", "pr Ass 24Horas",
					"fr Ass 24Horas", "lmi Ass 24Horas", "obs Ass 24Horas", "pr Danos Morais", "fr Danos Morais", "lmi Danos Morais", "obs Danos Morais", "pr app", "fr app", "lmi app",
					"obs app", "pr equipamentos", "fr equipamentos", "lmi equipamentos", "obs equipamentos"
				};
				List<List<string>> list2 = new List<List<string>>
				{
					new List<string>
					{
						"XXX0X00", "FORD", "MODELO", "000000-0", "75F 8C33MP Y2 W12900", "2000", "2001", "PRETO", "PASSEIO", "FLEX",
						"SIM", "00000000000", "5", "5", "100", "00.000-000", "000000", "NÃO", "MERCADO", "SEM",
						"NÃO", "00.000-000", "COMPREENSIVA", "100", "FIPE", "", "OBSERVAÇÕES", "1000", "2000", "3000",
						"teste obs", "", "", "", "", "2000", "3000", "4000", "teste obs", "100000",
						"200000", "300000", "teste obs", "2000", "3000", "4000", "teste obs", "", "", "",
						"", "1000", "2000", "3000", "teste obs", "2000", "3000", "4000", "teste obs", "",
						"", "", "", "1000", "2000", "3000", "teste obs", "", "", "",
						"", "2000", "3000", "4000", "teste obs", "1000", "2000", "3000", "teste obs"
					},
					new List<string>
					{
						"XXX0X01", "CHEVROLET", "MODELO", "000000-1", "4EL ZBE75H B5 A65693", "2000", "2001", "VERDE", "PICKUP", "GASOLINA/ÁLCOOL/GNV",
						"NÃO", "00000000000", "5", "2", "100", "00.000-000", "000000", "SIM", "DETERMINADO", "IPI E ICMS",
						"NÃO", "00.000-000", "INCÊNDIO E ROUBO/FURTO", "100", "MOLICAR", "19767,34", "OBSERVAÇÕES", "1000", "2000", "3000",
						"teste obs", "", "", "", "", "2000", "3000", "4000", "teste obs", "100000",
						"200000", "300000", "teste obs", "2000", "3000", "4000", "teste obs", "", "", "",
						"", "1000", "2000", "3000", "teste obs", "2000", "3000", "4000", "teste obs", "",
						"", "", "", "1000", "2000", "3000", "teste obs", "", "", "",
						"", "2000", "3000", "4000", "teste obs", "1000", "2000", "3000", "teste obs"
					}
				};
				List<string> list3 = new List<string>
				{
					"BRANCO", "CINZA", "PRATA", "VERMELHO", "AMARELO", "OURO", "LARANJA", "ROSA", "VERDE", "AZUL",
					"VINHO", "MARROM", "BEGE", "DOURADO", "OUTROS"
				};
				List<string> list4 = new List<string>
				{
					"PICKUP", "OUTROS", "PASSEIO", "CAMINHÃO", "CAMINHONETE", "ÔNIBUS", "UTILITÁRIO", "CARGA", "MOTOCICLETA", "TAXI",
					"UBER", "REBOCADOR", "REBOQUE/SEMI REBOQUE"
				};
				List<string> list5 = new List<string>
				{
					"ÁLCOOL", "GASOLINA", "DIESEL", "FLEX", "GNV", "OUTROS", "GASOLINA/GNV", "GASOLINA/ÁLCOOL/GNV", "GASOLINA/ELÉTRICO", "HÍBRIDO",
					"ELÉTRICO", "GASOLINA/ÁLCOOL/ELÉTRICO"
				};
				List<string> list6 = new List<string> { "MERCADO", "DETERMINADO" };
				List<string> list7 = new List<string> { "SEM ISENÇÃO", "ICMS", "IPI", "IPI E ICMS" };
				List<string> list8 = new List<string> { "COMPREENSIVA", "INCÊNDIO E ROUBO/FURTO", "DANOS A TERCEIROS", "PASSAGEIROS", "ROUBO/FURTO" };
				List<string> list9 = new List<string> { "MOLICAR", "FIPE" };
				List<string> list10 = new List<string> { "SIM", "NÃO" };
				foreach (string item in list)
				{
					DataColumn column = new DataColumn
					{
						DataType = Type.GetType("System.String"),
						ColumnName = item
					};
					dataTable.Columns.Add(column);
				}
				foreach (List<string> item2 in list2)
				{
					DataRow dataRow = dataTable.NewRow();
					foreach (string item3 in list)
					{
						dataRow[item3] = item2[list.IndexOf(item3)];
					}
					dataTable.Rows.Add(dataRow);
				}
				val.Worksheets.Add(dataTable, "EXEMPLO AUTO EXCEL");
				val.SaveAs(fbd.SelectedPath + "\\EXEMPLO AUTO EXCEL.xlsx");
				val = new XLWorkbook();
				dataTable = new DataTable();
				foreach (string item4 in list)
				{
					DataColumn column2 = new DataColumn
					{
						DataType = Type.GetType("System.String"),
						ColumnName = item4
					};
					dataTable.Columns.Add(column2);
				}
				foreach (string item5 in list3)
				{
					DataRow dataRow2 = dataTable.NewRow();
					foreach (string item6 in list)
					{
						int num = list3.IndexOf(item5);
						switch (item6)
						{
						case "cor":
							dataRow2[item6] = ((list3.Count >= num + 1) ? list3[num] : "");
							break;
						case "categoria":
							dataRow2[item6] = ((list4.Count >= num + 1) ? list4[num] : "");
							break;
						case "combustivel":
							dataRow2[item6] = ((list5.Count >= num + 1) ? list5[num] : "");
							break;
						case "correcao":
							dataRow2[item6] = ((list6.Count >= num + 1) ? list6[num] : "");
							break;
						case "isencao":
							dataRow2[item6] = ((list7.Count >= num + 1) ? list7[num] : "");
							break;
						case "tipocobertura":
							dataRow2[item6] = ((list8.Count >= num + 1) ? list8[num] : "");
							break;
						case "tabelareferencia":
							dataRow2[item6] = ((list9.Count >= num + 1) ? list9[num] : "");
							break;
						case "pcd":
						case "zerokm":
						case "financiado":
							dataRow2[item6] = ((list10.Count >= num + 1) ? list10[num] : "");
							break;
						case "placa":
							dataRow2[item6] = ((num == 0) ? "XXX0X00" : "");
							break;
						case "fabricante":
							dataRow2[item6] = ((num == 0) ? "FABRICANTE" : "");
							break;
						case "modelo":
							dataRow2[item6] = ((num == 0) ? "MODELO" : "");
							break;
						case "fipe":
							dataRow2[item6] = ((num == 0) ? "000000-0" : "");
							break;
						case "chassi":
							dataRow2[item6] = ((num == 0) ? "XXX XXXXXX XX XXXXXX" : "");
							break;
						case "anofabricacao":
							dataRow2[item6] = ((num == 0) ? "0000" : "");
							break;
						case "anomodelo":
							dataRow2[item6] = ((num == 0) ? "0000" : "");
							break;
						case "renavam":
							dataRow2[item6] = ((num == 0) ? "00000000000" : "");
							break;
						case "capacidade":
							dataRow2[item6] = ((num == 0) ? "000" : "");
							break;
						case "portas":
							dataRow2[item6] = ((num == 0) ? "00" : "");
							break;
						case "bonus":
							dataRow2[item6] = ((num == 0) ? "0" : "");
							break;
						case "ceppernoite":
							dataRow2[item6] = ((num == 0) ? "00.000-000" : "");
							break;
						case "ci":
							dataRow2[item6] = ((num == 0) ? "000000" : "");
							break;
						case "cepcirculacao":
							dataRow2[item6] = ((num == 0) ? "00.000-000" : "");
							break;
						case "porcentagemreferencia":
							dataRow2[item6] = ((num == 0) ? "000" : "");
							break;
						case "valordeterminado":
							dataRow2[item6] = ((num == 0) ? "000000" : "");
							break;
						case "observacao":
							dataRow2[item6] = ((num == 0) ? "OBSERVAÇÕES" : "");
							break;
						case "pr casco":
							dataRow2[item6] = ((num == 0) ? "0" : "");
							break;
						case "fr casco":
							dataRow2[item6] = ((num == 0) ? "0" : "");
							break;
						case "lmi casco":
							dataRow2[item6] = ((num == 0) ? "0" : "");
							break;
						case "obs casco":
							dataRow2[item6] = ((num == 0) ? "OBSERVAÇÃO" : "");
							break;
						case "pr dm":
							dataRow2[item6] = ((num == 0) ? "0" : "");
							break;
						case "fr dm":
							dataRow2[item6] = ((num == 0) ? "0" : "");
							break;
						case "lmi dm":
							dataRow2[item6] = ((num == 0) ? "0" : "");
							break;
						case "obs dm":
							dataRow2[item6] = ((num == 0) ? "OBSERVAÇÃO" : "");
							break;
						case "pr dc":
							dataRow2[item6] = ((num == 0) ? "0" : "");
							break;
						case "fr dc":
							dataRow2[item6] = ((num == 0) ? "0" : "");
							break;
						case "lmi dc":
							dataRow2[item6] = ((num == 0) ? "0" : "");
							break;
						case "obs dc":
							dataRow2[item6] = ((num == 0) ? "OBSERVAÇÃO" : "");
							break;
						case "pr morte":
							dataRow2[item6] = ((num == 0) ? "0" : "");
							break;
						case "fr morte":
							dataRow2[item6] = ((num == 0) ? "0" : "");
							break;
						case "lmi morte":
							dataRow2[item6] = ((num == 0) ? "0" : "");
							break;
						case "obs morte":
							dataRow2[item6] = ((num == 0) ? "OBSERVAÇÃO" : "");
							break;
						case "pr invalidez":
							dataRow2[item6] = ((num == 0) ? "0" : "");
							break;
						case "fr invalidez":
							dataRow2[item6] = ((num == 0) ? "0" : "");
							break;
						case "lmi invalidez":
							dataRow2[item6] = ((num == 0) ? "0" : "");
							break;
						case "obs invalidez":
							dataRow2[item6] = ((num == 0) ? "OBSERVAÇÃO" : "");
							break;
						case "pr carro reserva":
							dataRow2[item6] = ((num == 0) ? "0" : "");
							break;
						case "fr carro reserva":
							dataRow2[item6] = ((num == 0) ? "0" : "");
							break;
						case "lmi carro reserva":
							dataRow2[item6] = ((num == 0) ? "0" : "");
							break;
						case "obs carro reserva":
							dataRow2[item6] = ((num == 0) ? "OBSERVAÇÃO" : "");
							break;
						case "pr vidros":
							dataRow2[item6] = ((num == 0) ? "0" : "");
							break;
						case "fr vidros":
							dataRow2[item6] = ((num == 0) ? "0" : "");
							break;
						case "lmi vidros":
							dataRow2[item6] = ((num == 0) ? "0" : "");
							break;
						case "obs vidros":
							dataRow2[item6] = ((num == 0) ? "OBSERVAÇÃO" : "");
							break;
						case "pr carroceria":
							dataRow2[item6] = ((num == 0) ? "0" : "");
							break;
						case "fr carroceria":
							dataRow2[item6] = ((num == 0) ? "0" : "");
							break;
						case "lmi carroceria":
							dataRow2[item6] = ((num == 0) ? "0" : "");
							break;
						case "obs carroceria":
							dataRow2[item6] = ((num == 0) ? "OBSERVAÇÃO" : "");
							break;
						case "pr Ass 24Horas":
							dataRow2[item6] = ((num == 0) ? "0" : "");
							break;
						case "fr Ass 24Horas":
							dataRow2[item6] = ((num == 0) ? "0" : "");
							break;
						case "lmi Ass 24Horas":
							dataRow2[item6] = ((num == 0) ? "0" : "");
							break;
						case "obs Ass 24Horas":
							dataRow2[item6] = ((num == 0) ? "OBSERVAÇÃO" : "");
							break;
						case "pr Danos Morais":
							dataRow2[item6] = ((num == 0) ? "0" : "");
							break;
						case "fr Danos Morais":
							dataRow2[item6] = ((num == 0) ? "0" : "");
							break;
						case "lmi Danos Morais":
							dataRow2[item6] = ((num == 0) ? "0" : "");
							break;
						case "obs Danos Morais":
							dataRow2[item6] = ((num == 0) ? "OBSERVAÇÃO" : "");
							break;
						case "pr app":
							dataRow2[item6] = ((num == 0) ? "0" : "");
							break;
						case "fr app":
							dataRow2[item6] = ((num == 0) ? "0" : "");
							break;
						case "lmi app":
							dataRow2[item6] = ((num == 0) ? "0" : "");
							break;
						case "obs app":
							dataRow2[item6] = ((num == 0) ? "OBSERVAÇÃO" : "");
							break;
						case "pr equipamentos":
							dataRow2[item6] = ((num == 0) ? "0" : "");
							break;
						case "fr equipamentos":
							dataRow2[item6] = ((num == 0) ? "0" : "");
							break;
						case "lmi equipamentos":
							dataRow2[item6] = ((num == 0) ? "0" : "");
							break;
						case "obs equipamentos":
							dataRow2[item6] = ((num == 0) ? "OBSERVAÇÃO" : "");
							break;
						}
					}
					dataTable.Rows.Add(dataRow2);
				}
				val.Worksheets.Add(dataTable, "VALORES PERMITIDOS AUTO EXCEL");
				val.SaveAs(fbd.SelectedPath + "\\VALORES PERMITIDOS AUTO EXCEL.xlsx");
			}
			await ShowMessage("\"EXEMPLO AUTO EXCEL.xlsx\" E \"VALORES PERMITIDOS AUTO EXCEL.xlsx\"\nFORAM SALVOS EM \"" + fbd.SelectedPath + "\"");
		}
		finally
		{
			((IDisposable)fbd)?.Dispose();
		}
	}

	public async Task<List<KeyValuePair<string, string>>> ImportarXls()
	{
		List<KeyValuePair<string, string>> erros = new List<KeyValuePair<string, string>>();
		OpenFileDialog val = new OpenFileDialog();
		string path;
		try
		{
			((FileDialog)val).Filter = "Excel|*.xls;*.xlsx";
			((FileDialog)val).InitialDirectory = Environment.SpecialFolder.Desktop.ToString();
			if (1 != (int)((CommonDialog)val).ShowDialog())
			{
				erros.Add(new KeyValuePair<string, string>("EXCEL", "ERRO AO SELECIONAR DOCUMENTO"));
				return erros;
			}
			path = ((FileDialog)val).FileName;
		}
		finally
		{
			((IDisposable)val)?.Dispose();
		}
		try
		{
			List<Task<Item>> list = await Task.Run(delegate
			{
				Microsoft.Office.Interop.Excel.Application application = (Microsoft.Office.Interop.Excel.Application)Activator.CreateInstance(Marshal.GetTypeFromCLSID(new Guid("00024500-0000-0000-C000-000000000046")));
				Workbook workbook = application.Workbooks.Open(path, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
				new List<string>
				{
					"placa", "fabricante", "modelo", "fipe", "chassi", "anofabricacao", "anomodelo", "cor", "categoria", "combustivel",
					"zerokm", "renavam", "capacidade", "portas", "bonus", "ceppernoite", "ci", "financiado", "correcao", "isencao",
					"pcd", "cepcirculacao", "tipocobertura", "porcentagemreferencia", "tabelareferencia", "valordeterminado", "observacao", "usoveiculos"
				};
				List<DataTable> list2 = new List<DataTable>();
				foreach (object worksheet in workbook.Worksheets)
				{
					DataTable dataTable = new DataTable();
					Microsoft.Office.Interop.Excel.Range usedRange = ((Worksheet)worksheet).UsedRange;
					object[,] array = (dynamic)usedRange.Value2;
					int num = 0;
					for (int i = 0; i <= usedRange.Columns.Count - 1; i++)
					{
						if (array[1, i + 1] == null)
						{
							num--;
						}
						else
						{
							DataColumn column = new DataColumn
							{
								DataType = Type.GetType("System.String"),
								ColumnName = Funcoes.RemoverAcentos(array[1, i + 1].ToString().ToLower())
							};
							dataTable.Columns.Add(column);
							for (int j = 0; j <= usedRange.Rows.Count - 2; j++)
							{
								object obj = array[j + 2, i + 1];
								string value = ((obj is string text) ? Funcoes.RemoverAcentos(text).ToUpper() : ((!(obj is double num2)) ? ((!(obj is bool)) ? "" : (((bool)obj) ? "1" : "0")) : ((!num2.ToString(CultureInfo.InvariantCulture).Contains("+")) ? num2.ToString(CultureInfo.InvariantCulture) : ".")));
								if (i + num == 0)
								{
									dataTable.Rows.Add(dataTable.NewRow());
									dataTable.Rows[j][i + num] = value;
								}
								else
								{
									dataTable.Rows[j][i + num] = value;
								}
							}
						}
					}
					list2.Add(dataTable);
				}
				application.Quit();
				List<Task<Item>> list3 = new List<Task<Item>>();
				foreach (DataTable dt in list2)
				{
					for (int num3 = dt.Rows.Count - 1; num3 >= 0; num3--)
					{
						if (dt.Rows[num3].ItemArray.All((object item) => string.IsNullOrEmpty(item?.ToString())))
						{
							dt.Rows.RemoveAt(num3);
						}
					}
					list3.AddRange(((IEnumerable<DataRow>)dt.AsEnumerable().ToList()).Select((Func<DataRow, Task<Item>>)async delegate(DataRow x)
					{
						Item val2 = new Item();
						Item val3 = val2;
						Auto val4 = new Auto();
						val4.Placa = ((!dt.Columns.Contains("placa") || string.IsNullOrWhiteSpace(x.Field<object>("placa").ToString())) ? null : x.Field<object>("placa").ToString().ToUpper());
						val4.AnoFabricacao = ((!dt.Columns.Contains("anofabricacao") || string.IsNullOrWhiteSpace(x.Field<object>("anofabricacao").ToString())) ? null : new Regex("[^0-9]").Replace(x.Field<object>("anofabricacao").ToString(), ""));
						val4.AnoModelo = ((!dt.Columns.Contains("anomodelo") || string.IsNullOrWhiteSpace(x.Field<object>("anomodelo").ToString())) ? null : new Regex("[^0-9]").Replace(x.Field<object>("anomodelo").ToString(), ""));
						val4.Bonus = ((!dt.Columns.Contains("bonus") || string.IsNullOrWhiteSpace(x.Field<object>("bonus").ToString())) ? null : new int?(int.Parse(new Regex("[^0-9]").Replace(x.Field<object>("bonus").ToString(), ""))));
						val4.Capacidade = ((!dt.Columns.Contains("capacidade") || string.IsNullOrWhiteSpace(x.Field<object>("capacidade").ToString())) ? null : new Regex("[^0-9]").Replace(x.Field<object>("capacidade").ToString(), ""));
						val4.CepPernoite = ((!dt.Columns.Contains("ceppernoite") || string.IsNullOrWhiteSpace(x.Field<object>("ceppernoite").ToString())) ? ValidationHelper.FormatPostCode(new Regex("[^0-9]").Replace(x.Field<object>("cepcirculacao").ToString(), "")) : ValidationHelper.FormatPostCode(new Regex("[^0-9]").Replace(x.Field<object>("ceppernoite").ToString(), "")));
						val4.Chassi = ((!dt.Columns.Contains("chassi") || string.IsNullOrWhiteSpace(x.Field<object>("chassi").ToString())) ? null : x.Field<object>("chassi").ToString());
						val4.Ci = ((!dt.Columns.Contains("ci") || string.IsNullOrWhiteSpace(x.Field<object>("ci").ToString())) ? null : new Regex("[^0-9]").Replace(x.Field<object>("ci").ToString(), ""));
						val4.Observacao = ((!dt.Columns.Contains("observacao") || string.IsNullOrWhiteSpace(x.Field<object>("observacao").ToString())) ? null : x.Field<object>("observacao").ToString());
						val4.Cor = ((!dt.Columns.Contains("cor") || string.IsNullOrWhiteSpace(x.Field<object>("cor").ToString())) ? null : Funcoes.GetCor(x.Field<object>("cor").ToString().ToLower()));
						val4.Financiado = ((!dt.Columns.Contains("financiado") || string.IsNullOrWhiteSpace(x.Field<object>("financiado").ToString())) ? null : new bool?(x.Field<object>("financiado").ToString().ToLower() == "sim"));
						val4.ZeroKm = ((!dt.Columns.Contains("zerokm") || string.IsNullOrWhiteSpace(x.Field<object>("zerokm").ToString())) ? null : new bool?(x.Field<object>("zerokm").ToString().ToLower() == "sim"));
						val4.Combustivel = ((!dt.Columns.Contains("combustivel") || string.IsNullOrWhiteSpace(x.Field<object>("combustivel").ToString())) ? null : Funcoes.GetCombustivel(x.Field<object>("combustivel").ToString().ToLower()));
						val4.Correcao = ((!dt.Columns.Contains("correcao") || string.IsNullOrWhiteSpace(x.Field<object>("correcao").ToString())) ? null : Funcoes.GetCorrecao(x.Field<object>("correcao").ToString().ToLower()));
						Auto val5 = val4;
						Fabricante fabricante = ((dt.Columns.Contains("fabricante") && !string.IsNullOrWhiteSpace(x.Field<object>("fabricante").ToString())) ? (await Funcoes.GetFabricante(x.Field<object>("fabricante").ToString().ToLower())) : null);
						val5.Fabricante = fabricante;
						val4.Fipe = ((!dt.Columns.Contains("fipe") || string.IsNullOrWhiteSpace(x.Field<object>("fipe").ToString())) ? null : ValidationHelper.FormataFipe(new Regex("[^0-9]").Replace(x.Field<object>("fipe").ToString(), "")));
						val4.Isencao = ((!dt.Columns.Contains("isencao") || string.IsNullOrWhiteSpace(x.Field<object>("isencao").ToString())) ? null : Funcoes.GetIsencao(x.Field<object>("isencao").ToString().ToLower()));
						val4.Modelo = ((!dt.Columns.Contains("modelo") || string.IsNullOrWhiteSpace(x.Field<object>("modelo").ToString())) ? null : x.Field<object>("modelo").ToString());
						val4.Pcd = ((!dt.Columns.Contains("pcd") || string.IsNullOrWhiteSpace(x.Field<object>("pcd").ToString())) ? null : new bool?(x.Field<object>("pcd").ToString().ToLower() == "sim"));
						val4.PorcentagemReferencia = ((!dt.Columns.Contains("porcentagemreferencia") || string.IsNullOrWhiteSpace(x.Field<object>("porcentagemreferencia").ToString())) ? 0m : (decimal.TryParse(x.Field<object>("porcentagemreferencia").ToString(), out var _) ? decimal.Parse(x.Field<object>("porcentagemreferencia").ToString()) : 0m));
						val4.Portas = ((!dt.Columns.Contains("portas") || string.IsNullOrWhiteSpace(x.Field<object>("portas").ToString())) ? null : new Regex("[^0-9]").Replace(x.Field<object>("portas").ToString(), ""));
						val4.RegiaoCirculacao = ((!dt.Columns.Contains("cepcirculacao") || string.IsNullOrWhiteSpace(x.Field<object>("cepcirculacao").ToString())) ? null : ValidationHelper.FormatPostCode(new Regex("[^0-9]").Replace(x.Field<object>("cepcirculacao").ToString(), "")));
						val4.Renavam = ((!dt.Columns.Contains("renavam") || string.IsNullOrWhiteSpace(x.Field<object>("renavam").ToString())) ? null : new Regex("[^0-9]").Replace(x.Field<object>("renavam").ToString(), ""));
						val4.TabelaReferencia = ((!dt.Columns.Contains("tabelareferencia") || string.IsNullOrWhiteSpace(x.Field<object>("tabelareferencia").ToString())) ? null : Funcoes.GetTabelaReferencia(x.Field<object>("tabelareferencia").ToString().ToLower()));
						val4.TipoCobertura = ((!dt.Columns.Contains("tipocobertura") || string.IsNullOrWhiteSpace(x.Field<object>("tipocobertura").ToString())) ? null : Funcoes.GetTipoCobertura(x.Field<object>("tipocobertura").ToString().ToLower()));
						val4.ValorDeterminado = ((!dt.Columns.Contains("valordeterminado") || string.IsNullOrWhiteSpace(x.Field<object>("valordeterminado").ToString()) || !ValidationHelper.ValidateValor(x.Field<object>("valordeterminado").ToString())) ? 0m : decimal.Parse(x.Field<object>("valordeterminado").ToString()));
						val4.Categoria = ((!dt.Columns.Contains("categoria") || string.IsNullOrWhiteSpace(x.Field<object>("categoria").ToString())) ? null : Funcoes.GetCategoria(x.Field<object>("categoria").ToString().ToLower()));
						val4.UsoVeiculo = ((!dt.Columns.Contains("usoveiculo") || string.IsNullOrWhiteSpace(x.Field<object>("usoveiculo").ToString())) ? null : Funcoes.GetUsoveiculo(x.Field<object>("usoveiculo").ToString().ToUpper()));
						val4.KitGas = ((!dt.Columns.Contains("KitGas") || string.IsNullOrWhiteSpace(x.Field<object>("KitGas").ToString())) ? null : new bool?(x.Field<object>("KitGas").ToString().ToLower() == "sim"));
						val3.Auto = val4;
						val2.Coberturas = Coberturas(x);
						val2.Documento = ItemSelecionado.Documento;
						val2.Substituicao = null;
						return val2;
					}).ToList());
				}
				return list3;
			});
			if (list.Count == 0)
			{
				erros.Add(new KeyValuePair<string, string>("EXCEL", "NENHUMA COLUNA FOI ENCONTRADA"));
				return erros;
			}
			erros = await SalvarRange(await Task.WhenAll(list));
		}
		catch (Exception)
		{
			erros.Add(new KeyValuePair<string, string>("EXCEL", "FALHA AO IMPORTAR O EXCEL,\nVERIFIQUE SE O ARQUIVO POSSUI ALGUM ERRO"));
		}
		return erros;
	}

	public List<Cobertura> Coberturas(DataRow row)
	{
		//IL_0478: Unknown result type (might be due to invalid IL or missing references)
		//IL_047d: Unknown result type (might be due to invalid IL or missing references)
		//IL_047e: Unknown result type (might be due to invalid IL or missing references)
		//IL_0483: Unknown result type (might be due to invalid IL or missing references)
		//IL_0491: Expected O, but got Unknown
		//IL_0491: Unknown result type (might be due to invalid IL or missing references)
		//IL_04a5: Unknown result type (might be due to invalid IL or missing references)
		//IL_04ad: Unknown result type (might be due to invalid IL or missing references)
		//IL_04b5: Unknown result type (might be due to invalid IL or missing references)
		//IL_04c2: Expected O, but got Unknown
		List<Cobertura> list = new List<Cobertura>();
		foreach (DataColumn column in row.Table.Columns)
		{
			if (!Regex.IsMatch(column.ColumnName, "pr .+"))
			{
				continue;
			}
			string value = Regex.Match(column.ColumnName, "pr (.+)").Groups[1].Value;
			if (!(value != "casco") || !(value != "dm") || !(value != "dc") || !(value != "morte") || !(value != "invalidez") || !(value != "carro reserva") || !(value != "vidros") || !(value != "carroceria") || !(value != "ass 24horas") || !(value != "danos morais") || !(value != "app") || !(value != "equipamentos"))
			{
				int num = 0;
				string text = "";
				switch (value)
				{
				case "casco":
					num = 1;
					text = "Veiculo (Casco)";
					break;
				case "dm":
					num = 2;
					text = "Danos Materiais";
					break;
				case "dc":
					num = 3;
					text = "Danos Corporais";
					break;
				case "morte":
					num = 4;
					text = "Morte";
					break;
				case "invalidez":
					num = 5;
					text = "Invalidez";
					break;
				case "carro reserva":
					num = 7;
					text = "Carro Reserva";
					break;
				case "vidros":
					num = 6;
					text = "Vidros";
					break;
				case "carroceria":
					num = 25;
					text = "Carroceria";
					break;
				case "ass 24horas":
					num = 19;
					text = "Assistência (Guincho)";
					break;
				case "danos morais":
					num = 17;
					text = "Danos Morais";
					break;
				case "app":
					num = 53;
					text = "Acidentes Pessoais";
					break;
				case "equipamentos":
					num = 54;
					text = "Equipamentos";
					break;
				}
				decimal num2 = (string.IsNullOrWhiteSpace(row.Field<object>("pr " + value).ToString()) ? 0m : ValidationHelper.ToDecimal(row.Field<object>("pr " + value).ToString(), "pt-BR"));
				decimal num3 = (string.IsNullOrWhiteSpace(row.Field<object>("lmi " + value).ToString()) ? 0m : ValidationHelper.ToDecimal(row.Field<object>("lmi " + value).ToString(), "pt-BR"));
				decimal num4 = (string.IsNullOrWhiteSpace(row.Field<object>("fr " + value).ToString()) ? 0m : ValidationHelper.ToDecimal(row.Field<object>("fr " + value).ToString(), "pt-BR"));
				string text2 = (string.IsNullOrWhiteSpace(row.Field<object>("obs " + value).ToString()) ? "" : row.Field<object>("obs " + value).ToString());
				if (num3 > 0m || num4 > 0m || num2 > 0m)
				{
					list.Add(new Cobertura
					{
						CoberturaPadrao = new CoberturaPadrao
						{
							Id = num
						},
						Observacao = text + " - " + text2,
						Premio = num2,
						Lmi = num3,
						Franquia = num4
					});
				}
			}
		}
		return list;
	}
}