public ConfiguracaoBE Insert(ConfiguracaoBE obj)
{
switch (obj.Conf_Tipo)
{
case "TPVenc":
obj.Conf_Tipo = "TVC";
break;
case "IBGE":
obj.Conf_Tipo = "IBG";
break;
case "CFOP":
obj.Conf_Tipo = "CFO";
break;
case "PAGE":
obj.Conf_Tipo = "PAG";
break;
case "TIPEND":
obj.Conf_Tipo = "TEN";
break;
case "INSTBOL":
obj.Conf_Tipo = "IBO";
break;
}
obj.Conf_id = new ConfiguracaoDao().Insert(obj);
return(obj);
}
public bool Update(ConfiguracaoBE obj)
{
switch (obj.Conf_Tipo)
{
case "TPVenc":
obj.Conf_Tipo = "TVC";
break;
case "IBGE":
obj.Conf_Tipo = "IBG";
break;
case "CFOP":
obj.Conf_Tipo = "CFO";
break;
case "PAGE":
obj.Conf_Tipo = "PAG";
break;
case "TIPEND":
obj.Conf_Tipo = "TEN";
break;
case "INSTBOL":
obj.Conf_Tipo = "IBO";
break;
}
return(new ConfiguracaoDao().Update(obj).Value);
}
public Envio()
{
InitializeComponent();
pnStatus.Visible = false;
abrirArquivo = new OpenFileDialog();
config = new ConfiguracaoBE();
erro = new List <String>();
_emails = new List <String>();
destinatarios = new List <String>();
dirAtual = Directory.GetCurrentDirectory();
arqConfig = "EmailConfig.txt";
dgvConfig.Columns.Add("Email", "E-Mail");
dgvConfig.Columns["Email"].Width = 300;
dgvConfig.Columns.Add("SMTP", "Servidor SMTP");
dgvConfig.Columns["SMTP"].Width = 250;
dgvConfig.Columns.Add("Porta", "Porta");
dgvConfig.Columns["Porta"].Width = 80;
dgvConfig.Columns.Add("SSL", "SSL");
dgvConfig.Columns["SSL"].Width = 30;
dgvConfig.Columns.Add("Cred", "Cred.");
dgvConfig.Columns["Cred"].Width = 30;
dgvConfig.ReadOnly = true;
dgvAnexos.Columns.Add("FileName", "Arquivo Anexo");
dgvAnexos.Columns["FileName"].Width = 350;
dgvAnexos.Columns.Add("Acao", " ");
dgvAnexos.Columns["Acao"].Width = 30;
dgvAnexos.Columns["Acao"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.BottomCenter;
dgvAnexos.ReadOnly = true;
atach = new List <Anexo>();
Point loc = new Point();
loc.X = 13;
loc.Y = 4;
pnDe.Location = loc;
}
public void Open(ConfiguracaoBE configBE)
{
_connectionString = "Server=<<SERVER>>;Database=<<DATABASENAME>>;User ID=<<USERNAME>>;Password=<<PASSWORD>>;Pooling=true;Port=<<PORT>>;Allow User Variables = True;DefaultCommandTimeout=0;convertzerodatetime=true;";
_connectionString = _connectionString.Replace("<<SERVER>>", configBE.XdServidor);
_connectionString = _connectionString.Replace("<<PORT>>", configBE.XdPorta);
_connectionString = _connectionString.Replace("<<DATABASENAME>>", configBE.XdNomeBase);
_connectionString = _connectionString.Replace("<<USERNAME>>", configBE.XdUsuario);
_connectionString = _connectionString.Replace("<<PASSWORD>>", configBE.XdSenha);
_connection = new MySqlConnection(_connectionString);
try
{
_connection.Open();
}
catch (Exception ex)
{
throw ex;
}
}
private static void LoadConfigurationFromXml()
{
ConfigBE = new ConfiguracaoBE();
ConfigBE = Serialize.DeserializeFromXmlUtf8 <ConfiguracaoBE>(Constants.CONFIG_FILE_NAME);
}
private static void CreateNewXmlConfiguration()
{
ConfigBE = new ConfiguracaoBE();
Serialize.SerializeToXmlUft8 <ConfiguracaoBE>(Constants.CONFIG_FILE_NAME, ConfigBE);
}
public ConfiguracaoBE SelectId(ConfiguracaoBE obj)
{
return(new ConfiguracaoDao().SelectId <ConfiguracaoBE>(obj));
}
public List <ConfiguracaoBE> Select(ConfiguracaoBE obj)
{
return(new ConfiguracaoDao().Select <ConfiguracaoBE>(obj).ToList());
}
public bool Delete(ConfiguracaoBE obj)
{
return(new ConfiguracaoDao().Delete(obj).Value);
}
