public JsonResult carregaCondicaoScript(string id)
{
int idScript = Int32.Parse(id);
List <Script_CondicaoScript> listaScript_CondicaoScript = db.Script_CondicaoScript.Where(x => x.IdScript == idScript).ToList();
List <CondicaoScript> listaCondicaoScript = new List <CondicaoScript>();
for (int i = 0; i < listaScript_CondicaoScript.Count; i++)
{
CondicaoScript condicaoScript = db.CondicaoScript.Find(listaScript_CondicaoScript[i].IdCondicaoScript);
if (condicaoScript != null)
{
listaCondicaoScript.Add(condicaoScript);
}
}
ViewBag.listCondicaoScript = listaCondicaoScript;
Dictionary <string, string> ListaCondicao = new Dictionary <string, string>();
foreach (var item in listaCondicaoScript)
{
ListaCondicao.Add(item.Id + "", item.Descricao);
}
string json = JsonConvert.SerializeObject(ListaCondicao, Formatting.Indented);
return(Json(json, JsonRequestBehavior.AllowGet));
}
public static bool ValidaPlanilhaExcelExecucao(string path, DataPool dp)
{
System.Data.DataTable dt = new System.Data.DataTable();
//Conexão com Excel
string excelConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source='" + path + "';Extended Properties='Excel 12.0 xml;HDR=YES;IMEX=1;'";
using (OleDbConnection conExcel = new OleDbConnection(excelConnectionString))
{
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conExcel;
conExcel.Open();
System.Data.DataTable table = conExcel.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
cmd.CommandText = "select * from [CONFIG$D6:D11]";
OleDbDataAdapter adp = new OleDbDataAdapter(cmd);
adp.Fill(dt);
}
bool retorno = true;
string[] valores = new string[3];
int count = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
if (!dt.Rows[i].ItemArray[0].ToString().Equals(""))
{
valores[count] = dt.Rows[i].ItemArray[0].ToString();
count++;
}
}
string sistema = "";
string script = "";
string condicao = "";
for (int i = 0; i < valores.Length; i++)
{
if (i == 0)
{
sistema = valores[i];
}
if (i == 1)
{
script = valores[i];
}
if (i == 2)
{
condicao = valores[i];
}
}
DbEntities db = new DbEntities();
Script_CondicaoScript scs = db.Script_CondicaoScript.Where(x => x.Id == dp.IdScript_CondicaoScript).FirstOrDefault();
Script s = db.Script.Where(x => x.Id == scs.IdScript).FirstOrDefault();
CondicaoScript cs = db.CondicaoScript.Where(x => x.Id == scs.IdCondicaoScript).FirstOrDefault();
if (!dp.AUT.Descricao.Equals(sistema, StringComparison.InvariantCultureIgnoreCase))
{
retorno = false;
}
else
{
retorno = true;
}
//if (!dp.Find(x => x.AUT.Equals(sistema, StringComparison.InvariantCultureIgnoreCase))
// retorno = false;
if (s != null)
{
if (!s.Descricao.Equals(script, StringComparison.InvariantCultureIgnoreCase))
{
retorno = false;
}
}
if (cs != null)
{
if (cs.Descricao.Equals(condicao, StringComparison.InvariantCultureIgnoreCase))
{
retorno = false;
}
}
else if (!condicao.Equals("") && !condicao.Equals("SELECIONE"))
{
retorno = false;
}
return(retorno);
}
