private bool InsertPhysicalFile(DocumentoAtributo Indice)
{
try
{
File.AppendAllText(string.Format("{0}\\Validation_{1}.txt", pathLog, DateTime.Now.ToString("yyyyMMdd")), string.Format("**** Método: InsertPhysicalFile. Arquivo sendo enviado para o SE: {0}. Inicio: {1} ****", Indice.Registration, DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss")) + Environment.NewLine);
#region .: Save File :.
if (!Directory.Exists(physicalPath))
{
Directory.CreateDirectory(physicalPath);
}
File.AppendAllText(string.Format("{0}\\Validation_{1}.txt", pathLog, DateTime.Now.ToString("yyyyMMdd")), string.Format("**** Método: InsertPhysicalFile. Arquivo sendo enviado para o SE: {0}. Passo 1. Inicio: {1} ****", Indice.Registration, DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss")) + Environment.NewLine);
if (File.Exists(Path.Combine(physicalPath, Indice.FileName)))
{
File.AppendAllText(string.Format("{0}\\Validation_{1}.txt", pathLog, DateTime.Now.ToString("yyyyMMdd")), string.Format("**** Método: InsertPhysicalFile. Arquivo sendo enviado para o SE: {0}. Passo 1.1 Path: {1} ****", Indice.Registration, Path.Combine(physicalPath, Indice.FileName)) + Environment.NewLine);
File.Delete(Path.Combine(physicalPath, Indice.FileName));
}
File.AppendAllText(string.Format("{0}\\Validation_{1}.txt", pathLog, DateTime.Now.ToString("yyyyMMdd")), string.Format("**** Método: InsertPhysicalFile. Arquivo sendo enviado para o SE: {0}. Passo 2. Inicio: {1} ****", Indice.Registration, DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss")) + Environment.NewLine);
File.WriteAllBytes(Path.Combine(physicalPath, Indice.FileName), Indice.FileBinary);
File.AppendAllText(string.Format("{0}\\Validation_{1}.txt", pathLog, DateTime.Now.ToString("yyyyMMdd")), string.Format("**** Método: InsertPhysicalFile. Arquivo sendo enviado para o SE: {0}. Passo 3. Inicio: {1} ****", Indice.Registration, DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss")) + Environment.NewLine);
#endregion
#region .: Query :.
string queryStringInsert = @"INSERT INTO ADINTERFACE (CDINTERFACE, FGIMPORT, CDISOSYSTEM, FGOPTION, NMFIELD01, NMFIELD02, NMFIELD03, NMFIELD04, NMFIELD05, NMFIELD07) VALUES((SELECT COALESCE(MAX(CDINTERFACE),0)+1 FROM ADINTERFACE), 1, 73, 97, '{0}','0','{1}','{2}','{3}','{4}')";
string connectionString = WebConfigurationManager.ConnectionStrings["DefaultSesuite"].ConnectionString;
#endregion
#region .: Insert Sesuite :.
using (SqlConnection connectionInsert = new SqlConnection(connectionString))
{
File.AppendAllText(string.Format("{0}\\Validation_{1}.txt", pathLog, DateTime.Now.ToString("yyyyMMdd")), string.Format("**** Método: InsertPhysicalFile. Arquivo sendo enviado para o SE: {0}. Passo 4. Inicio: {1} ****", Indice.Registration, DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss")) + Environment.NewLine);
string queryInsert = string.Format(queryStringInsert,
Indice.DocumentIdPrimary /*Identificador do Documento*/,
Indice.FileName /*Nome do Arquivo*/,
Indice.User /*Matrícula do Usuário*/,
physicalPathSE + Indice.FileName,
Indice.CategoryPrimary.Trim() /*Identificador da categoria*/);
using (SqlCommand commandInsert = new SqlCommand(queryInsert, connectionInsert))
{
connectionInsert.Open();
commandInsert.ExecuteNonQuery();
}
File.AppendAllText(string.Format("{0}\\Validation_{1}.txt", pathLog, DateTime.Now.ToString("yyyyMMdd")), string.Format("**** Método: InsertPhysicalFile. Arquivo sendo enviado para o SE: {0}. Passo 5. Inicio: {1} ****", Indice.Registration, DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss")) + Environment.NewLine);
}
#endregion
}
catch (Exception ex)
{
File.AppendAllText(string.Format("{0}\\Error_{1}.txt", pathLog, DateTime.Now.ToString("yyyyMMdd")), string.Format("**** Método: InsertPhysicalFile. Arquivo sendo enviado para o SE (Erro {0}): {1}. Fim: {2} ****", ex.Message, Indice.Registration, DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss")) + Environment.NewLine);
throw new Exception("InsertPhysicalFile");
}
File.AppendAllText(string.Format("{0}\\Validation_{1}.txt", pathLog, DateTime.Now.ToString("yyyyMMdd")), string.Format("**** Método: InsertPhysicalFile. Arquivo sendo enviado para o SE: {0}. Fim: {1} ****", Indice.Registration, DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss")) + Environment.NewLine);
return(true);
}
