private bool isRotinaChecagem()
{
string rotinaChecagem = Path.Combine(Application.StartupPath, "r_ch_vendas_lanctos");
var dataAtual = DateTime.Now.Date;
if (File.Exists(rotinaChecagem) == false)
{
//cria o arquivo
FileManagerIts.CreateFile(rotinaChecagem);
}
try
{
string checagem = FileManagerIts.GetDataStringFile(rotinaChecagem);
Nullable <DateTime> data = DataUtil.ToDate(checagem).Date;
if (data == dataAtual)
{
return(true);
}
else
{
//registra a ocorrencia da rotina no dia
FileManagerIts.OverWriteOnFile(rotinaChecagem, dataAtual.ToShortDateString());
}
}
catch (Exception)
{
FileManagerIts.DeleteFile(rotinaChecagem);
}
return(false);
}
public XFrmHighlighting(string textOrFile, ScintillaNET.Lexer lexer)
{
InitializeComponent();
if (File.Exists(textOrFile))
{
this.scintilla.Text = FileManagerIts.GetDataStringFile(textOrFile);
this.file = textOrFile;
}
else
{
this.scintilla.Text = textOrFile;
}
scintilla.ConfigureLexer(lexer);
}
private void barBtnOpen_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
OpenFileDialog open = new OpenFileDialog();
if (open.ShowDialog() == DialogResult.OK)
{
var data = FileManagerIts.GetDataFile(open.FileName);
var sb = new StringBuilder();
foreach (var item in data)
{
sb.AppendLine(item);
}
scintillaOriginal.Text = FileManagerIts.GetDataStringFile(open.FileName);
}
}
private void barBtnOpenFileSql_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (openFileSql.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
string xmlFile = openFileSql.FileName;
if (!xmlFile.ToLower().EndsWith(".sql"))
{
XMessageIts.Advertencia("Selecione o arquivo de configuração .xml");
}
else if (FileManagerIts.IsEmpty(xmlFile))
{
XMessageIts.Erro("Arquivo de configuração está vazio.");
}
else
{
scintilla.Text = FileManagerIts.GetDataStringFile(openFileSql.FileName);
}
}
}
public XFrmQueryEditor(string file) : this()
{
this.scintilla.Text = FileManagerIts.GetDataStringFile(file);
}
//Uso Particular -> Chamada recursiva
private static void ExecDDL(string resource)
{
using (TransactionScope ts = new TransactionScope(TransactionScopeOption.Required,
new TransactionOptions()
{
IsolationLevel = IsolationLevel.ReadUncommitted
}))
{
using (var cnn = new AdminContext().ConnectionSql)
{
cnn.OpenConnection();
var connection = cnn.Connection;
try
{
Dictionary <string, bool> statusScripts = new Dictionary <string, bool>();
List <SqlCommand> commands = new List <SqlCommand>();
//cria a transacao
cnn.Transaction = connection.BeginTransaction(System.Data.IsolationLevel.ReadUncommitted, "myTransaction");
//de tudo .sql q esta la dentro
var sqlFiles = new FileManagerIts().ToFilesRecursive(resource);
var sqls = sqlFiles.Where(file => file.ToString().EndsWith(".sql"));
foreach (var sql in sqlFiles)
{
var sqlFileName = Path.GetFileName(sql);
Console.WriteLine("Executando script: " + sqlFileName);
var sqlQuery = FileManagerIts.GetDataStringFile(sql);
// split script on GO command
IEnumerable <string> commandStrings = Regex.Split(sqlQuery, @"^\s*GO\s*$",
RegexOptions.Multiline | RegexOptions.IgnoreCase);
//executando cada script separado por GO
foreach (string commandString in commandStrings)
{
try
{
if (commandString.Trim() != string.Empty)
{
var command = new SqlCommand(commandString, null);
command.Transaction = cnn.Transaction;
var result = cnn.ExecuteNonQuery(command);
commands.Add(command);
if (result.IsCompleted) //se executou o arquivo DDL..
{
//taskLogger("Comando " + commandString + " executado com sucesso.");
Console.WriteLine("Comando " + sqlFileName + " executado com sucesso.");
Console.WriteLine("============================================================================");
statusScripts.Add(commandString, true);
}
}
}
catch (SqlException sqlE)
{
Console.WriteLine("Error: " + sqlE.Number + "Comando: \n" + commandString + " \nLine: " + sqlE.LineNumber + " Message:" + sqlE.Message);
statusScripts.Add(commandString, false);
}
}//fim
}
//se a lista de scripts executados tiver mais de um item falso
if (statusScripts.Where(s => s.Value == false).Count() == 0)
{
cnn.Transaction.Commit();
ts.Complete();
}
else
{
cnn.Transaction.Rollback();
}
}
catch (TransactionAbortedException traCanc)
{
Console.WriteLine("Ocorreram erros no processo. Todas as alterações serao desfeitas.");
Console.WriteLine("Erro: " + traCanc.Message);
}
catch (Exception ex)
{
Console.WriteLine("Ocorreram erros no processo. Todas as alterações serao desfeitas.");
Console.WriteLine("Erro: " + ex.Message);
}
}
}
}
public XFrmXmlCompare(string xmlFile1, string xmlFile2) : this()
{
this.scintillaOriginal.Text = FileManagerIts.GetDataStringFile(xmlFile1);
this.scintillaResult.Text = FileManagerIts.GetDataStringFile(xmlFile2);
}
