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); }