public void GivenLaunchTwoFAApplicationAndVerifyHomescreen() { CleanUp.KillingChromeDriver(); string UI_URL = ConfigurationManager.AppSettings["AppURL"]; AUT.BrowserLaunch_sel(UI_URL); }
public ActionResult Remover(int id) { var result = new JsonResult() { JsonRequestBehavior = JsonRequestBehavior.AllowGet }; try { AUT aut = db.AUT.SingleOrDefault(a => a.Id == id); db.AUT.Remove(aut); db.SaveChanges(); result.Data = new { Result = "Sistema removido com sucesso.", Status = (int)WebExceptionStatus.Success }; } catch (Exception ex) { if (ex.InnerException != null && ex.InnerException.InnerException != null && ex.InnerException.InnerException.Message.ToString().Contains("FK_DataPool_Aut")) { // this.FlashError("Esse registro contém dependência com outra entidade."); result.Data = new { Result = "Esse registro contém dependência com outra entidade.", Status = (int)WebExceptionStatus.SendFailure } } ; else { result.Data = new { Result = ex.Message, Status = (int)WebExceptionStatus.UnknownError } }; //this.FlashError(ex.Message); //result.Data = new { Result = "Esse registro contém dependência com outra entidade.", Status = (int)WebExceptionStatus.UnknownError }; } return(result); }
public override void CreateFile(int IdTestData, EnumTipoOutputFile output) { TestData td = db.TestData.FirstOrDefault(x => x.Id == IdTestData); string NomeTabela = td.Script_CondicaoScript.NomeTecnicoScript; AUT aut = db.AUT.FirstOrDefault(x => x.Id == td.DataPool.IdAut); SQLiteConnection.CreateFile(Diretorio + NomeTabela); List <ParametroValor> pvs = db.ParametroValor.Where(x => x.IdTestData == td.Id).ToList(); //List<Parametro> parametros = db.Parametro.Where(x=> x.) //this.CreateTable(NomeTabala, LinkedList); //SQLiteConnection m_dbConnection = new SQLiteConnection(@"Data Source=C:\Users\brucilin.de.gouveia\Desktop\MyDatabase.sqlite;Version=3;"); //m_dbConnection.Open(); //string sql = "create table highscores (name varchar(20), score int)"; //SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection); //command.ExecuteNonQuery(); //sql = "insert into highscores (name, score) values ('Me', 9001)"; //command = new SQLiteCommand(sql, m_dbConnection); //command.ExecuteNonQuery(); //m_dbConnection.Close(); }
///<summary> /// Returns first repetition of AUT (Authorization Information) - creates it if necessary ///</summary> public AUT GetAUT() { AUT ret = null; try { ret = (AUT)this.GetStructure("AUT"); } catch (HL7Exception e) { HapiLogFactory.GetHapiLog(GetType()).Error("Unexpected error accessing data - this is probably a bug in the source code generator.", e); throw new System.Exception("An unexpected error ocurred", e); } return(ret); }
public ActionResult SalvarEdicao(AUT objeto) { try { Salvar(objeto, true); this.FlashSuccess("Sistema editado com sucesso."); } catch (Exception ex) { this.FlashError(ex.Message); } return(RedirectToAction("Index")); }
public ActionResult Salvar(AUT objeto, bool editar = false) { try { if (!ModelState.IsValid) { var msg = string.Empty; ModelState.Values.SelectMany(v => v.Errors).ForEach(m => msg = string.Concat(m.ErrorMessage.ToString(), @"\n")); if (!msg.IsNullOrWhiteSpace()) { this.FlashWarning(msg); } return(View("Adicionar", objeto)); } AUT aut; if (editar) { db.Entry(objeto).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } else { aut = new AUT() { Descricao = Request.Form.Get("descricao"), }; db.AUT.Add(aut); db.SaveChanges(); this.FlashSuccess("Sistema adicionado com sucesso!."); } } catch (Exception ex) { if (ex.InnerException != null && ex.InnerException.InnerException != null && ex.InnerException.InnerException.Message.ToString().Contains("AK_AUT_Descricao")) { this.FlashError("Já existe um Sistema com essa descrição."); } else { this.FlashError(ex.Message); } } return(RedirectToAction("Index")); }
/// <summary> /// Constructs an HL7 segment for the specified Segments enum object /// </summary> /// <param name="seg">The Segments enum object to construct for</param> public Segment(Segments seg) { switch (seg) { case Segments.ABS: ABS abs = new ABS(); Name = abs.Name; Description = abs.Description; Fields = abs.Fields; break; case Segments.ACC: ACC acc = new ACC(); Name = acc.Name; Description = acc.Description; Fields = acc.Fields; break; case Segments.ADD: ADD add = new ADD(); Name = add.Name; Description = add.Description; Fields = add.Fields; break; case Segments.AFF: AFF aff = new AFF(); Name = aff.Name; Description = aff.Description; Fields = aff.Fields; break; case Segments.AIG: AIG aig = new AIG(); Name = aig.Name; Description = aig.Description; Fields = aig.Fields; break; case Segments.AIL: AIL ail = new AIL(); Name = ail.Name; Description = ail.Description; Fields = ail.Fields; break; case Segments.AIP: AIP aip = new AIP(); Name = aip.Name; Description = aip.Description; Fields = aip.Fields; break; case Segments.AIS: AIS ais = new AIS(); Name = ais.Name; Description = ais.Description; Fields = ais.Fields; break; case Segments.AL1: AL1 al1 = new AL1(); Name = al1.Name; Description = al1.Description; Fields = al1.Fields; break; case Segments.APR: APR apr = new APR(); Name = apr.Name; Description = apr.Description; Fields = apr.Fields; break; case Segments.ARQ: ARQ arq = new ARQ(); Name = arq.Name; Description = arq.Description; Fields = arq.Fields; break; case Segments.AUT: AUT aut = new AUT(); Name = aut.Name; Description = aut.Description; Fields = aut.Fields; break; case Segments.BHS: BHS bhs = new BHS(); Name = bhs.Name; Description = bhs.Description; Fields = bhs.Fields; break; case Segments.BLC: BLC blc = new BLC(); Name = blc.Name; Description = blc.Description; Fields = blc.Fields; break; case Segments.BLG: BLG blg = new BLG(); Name = blg.Name; Description = blg.Description; Fields = blg.Fields; break; case Segments.BPO: BPO bpo = new BPO(); Name = bpo.Name; Description = bpo.Description; Fields = bpo.Fields; break; case Segments.BPX: BPX bpx = new BPX(); Name = bpx.Name; Description = bpx.Description; Fields = bpx.Fields; break; case Segments.BTS: BTS bts = new BTS(); Name = bts.Name; Description = bts.Description; Fields = bts.Fields; break; case Segments.BTX: BTX btx = new BTX(); Name = btx.Name; Description = btx.Description; Fields = btx.Fields; break; case Segments.CDM: CDM cdm = new CDM(); Name = cdm.Name; Description = cdm.Description; Fields = cdm.Fields; break; case Segments.CER: CER cer = new CER(); Name = cer.Name; Description = cer.Description; Fields = cer.Fields; break; case Segments.CM0: CM0 cm0 = new CM0(); Name = cm0.Name; Description = cm0.Description; Fields = cm0.Fields; break; case Segments.CM1: CM1 cm1 = new CM1(); Name = cm1.Name; Description = cm1.Description; Fields = cm1.Fields; break; case Segments.CM2: CM2 cm2 = new CM2(); Name = cm2.Name; Description = cm2.Description; Fields = cm2.Fields; break; case Segments.CNS: CNS cns = new CNS(); Name = cns.Name; Description = cns.Description; Fields = cns.Fields; break; case Segments.CON: CON con = new CON(); Name = con.Name; Description = con.Description; Fields = con.Fields; break; case Segments.CSP: CSP csp = new CSP(); Name = csp.Name; Description = csp.Description; Fields = csp.Fields; break; case Segments.CSR: CSR csr = new CSR(); Name = csr.Name; Description = csr.Description; Fields = csr.Fields; break; case Segments.CSS: CSS css = new CSS(); Name = css.Name; Description = css.Description; Fields = css.Fields; break; case Segments.CTD: CTD ctd = new CTD(); Name = ctd.Name; Description = ctd.Description; Fields = ctd.Fields; break; case Segments.CTI: CTI cti = new CTI(); Name = cti.Name; Description = cti.Description; Fields = cti.Fields; break; case Segments.DB1: DB1 db1 = new DB1(); Name = db1.Name; Description = db1.Description; Fields = db1.Fields; break; case Segments.DG1: DG1 dg1 = new DG1(); Name = dg1.Name; Description = dg1.Description; Fields = dg1.Fields; break; case Segments.DRG: DRG drg = new DRG(); Name = drg.Name; Description = drg.Description; Fields = drg.Fields; break; case Segments.DSC: DSC dsc = new DSC(); Name = dsc.Name; Description = dsc.Description; Fields = dsc.Fields; break; case Segments.DSP: DSP dsp = new DSP(); Name = dsp.Name; Description = dsp.Description; Fields = dsp.Fields; break; case Segments.ECD: ECD ecd = new ECD(); Name = ecd.Name; Description = ecd.Description; Fields = ecd.Fields; break; case Segments.ECR: ECR ecr = new ECR(); Name = ecr.Name; Description = ecr.Description; Fields = ecr.Fields; break; case Segments.EDU: EDU edu = new EDU(); Name = edu.Name; Description = edu.Description; Fields = edu.Fields; break; case Segments.EQL: EQL eql = new EQL(); Name = eql.Name; Description = eql.Description; Fields = eql.Fields; break; case Segments.EQP: EQP eqp = new EQP(); Name = eqp.Name; Description = eqp.Description; Fields = eqp.Fields; break; case Segments.EQU: EQU equ = new EQU(); Name = equ.Name; Description = equ.Description; Fields = equ.Fields; break; case Segments.ERQ: ERQ erq = new ERQ(); Name = erq.Name; Description = erq.Description; Fields = erq.Fields; break; case Segments.ERR: ERR err = new ERR(); Name = err.Name; Description = err.Description; Fields = err.Fields; break; case Segments.EVN: EVN evn = new EVN(); Name = evn.Name; Description = evn.Description; Fields = evn.Fields; break; case Segments.FAC: FAC fac = new FAC(); Name = fac.Name; Description = fac.Description; Fields = fac.Fields; break; case Segments.FHS: FHS fhs = new FHS(); Name = fhs.Name; Description = fhs.Description; Fields = fhs.Fields; break; case Segments.FT1: FT1 ft1 = new FT1(); Name = ft1.Name; Description = ft1.Description; Fields = ft1.Fields; break; case Segments.FTS: FTS fts = new FTS(); Name = fts.Name; Description = fts.Description; Fields = fts.Fields; break; case Segments.GOL: GOL gol = new GOL(); Name = gol.Name; Description = gol.Description; Fields = gol.Fields; break; case Segments.GP1: GP1 gp1 = new GP1(); Name = gp1.Name; Description = gp1.Description; Fields = gp1.Fields; break; case Segments.GP2: GP2 gp2 = new GP2(); Name = gp2.Name; Description = gp2.Description; Fields = gp2.Fields; break; case Segments.GT1: GT1 gt1 = new GT1(); Name = gt1.Name; Description = gt1.Description; Fields = gt1.Fields; break; case Segments.IAM: IAM iam = new IAM(); Name = iam.Name; Description = iam.Description; Fields = iam.Fields; break; case Segments.IIM: IIM iim = new IIM(); Name = iim.Name; Description = iim.Description; Fields = iim.Fields; break; case Segments.IN1: IN1 in1 = new IN1(); Name = in1.Name; Description = in1.Description; Fields = in1.Fields; break; case Segments.IN2: IN2 in2 = new IN2(); Name = in2.Name; Description = in2.Description; Fields = in2.Fields; break; case Segments.IN3: IN3 in3 = new IN3(); Name = in3.Name; Description = in3.Description; Fields = in3.Fields; break; case Segments.INV: INV inv = new INV(); Name = inv.Name; Description = inv.Description; Fields = inv.Fields; break; case Segments.IPC: IPC ipc = new IPC(); Name = ipc.Name; Description = ipc.Description; Fields = ipc.Fields; break; case Segments.ISD: ISD isd = new ISD(); Name = isd.Name; Description = isd.Description; Fields = isd.Fields; break; case Segments.LAN: LAN lan = new LAN(); Name = lan.Name; Description = lan.Description; Fields = lan.Fields; break; case Segments.LCC: LCC lcc = new LCC(); Name = lcc.Name; Description = lcc.Description; Fields = lcc.Fields; break; case Segments.LCH: LCH lch = new LCH(); Name = lch.Name; Description = lch.Description; Fields = lch.Fields; break; case Segments.LDP: LDP ldp = new LDP(); Name = ldp.Name; Description = ldp.Description; Fields = ldp.Fields; break; case Segments.LOC: LOC loc = new LOC(); Name = loc.Name; Description = loc.Description; Fields = loc.Fields; break; case Segments.LRL: LRL lrl = new LRL(); Name = lrl.Name; Description = lrl.Description; Fields = lrl.Fields; break; case Segments.MFA: MFA mfa = new MFA(); Name = mfa.Name; Description = mfa.Description; Fields = mfa.Fields; break; case Segments.MFE: MFE mfe = new MFE(); Name = mfe.Name; Description = mfe.Description; Fields = mfe.Fields; break; case Segments.MFI: MFI mfi = new MFI(); Name = mfi.Name; Description = mfi.Description; Fields = mfi.Fields; break; case Segments.MRG: MRG mrg = new MRG(); Name = mrg.Name; Description = mrg.Description; Fields = mrg.Fields; break; case Segments.MSA: MSA msa = new MSA(); Name = msa.Name; Description = msa.Description; Fields = msa.Fields; break; case Segments.MSH: MSH msh = new MSH(); Name = msh.Name; Description = msh.Description; Fields = msh.Fields; break; case Segments.NCK: NCK nck = new NCK(); Name = nck.Name; Description = nck.Description; Fields = nck.Fields; break; case Segments.NDS: NDS nds = new NDS(); Name = nds.Name; Description = nds.Description; Fields = nds.Fields; break; case Segments.NK1: NK1 nk1 = new NK1(); Name = nk1.Name; Description = nk1.Description; Fields = nk1.Fields; break; case Segments.NPU: NPU npu = new NPU(); Name = npu.Name; Description = npu.Description; Fields = npu.Fields; break; case Segments.NSC: NSC nsc = new NSC(); Name = nsc.Name; Description = nsc.Description; Fields = nsc.Fields; break; case Segments.NST: NST nst = new NST(); Name = nst.Name; Description = nst.Description; Fields = nst.Fields; break; case Segments.NTE: NTE nte = new NTE(); Name = nte.Name; Description = nte.Description; Fields = nte.Fields; break; case Segments.OBR: OBR obr = new OBR(); Name = obr.Name; Description = obr.Description; Fields = obr.Fields; break; case Segments.OBX: OBX obx = new OBX(); Name = obx.Name; Description = obx.Description; Fields = obx.Fields; break; case Segments.ODS: ODS ods = new ODS(); Name = ods.Name; Description = ods.Description; Fields = ods.Fields; break; case Segments.ODT: ODT odt = new ODT(); Name = odt.Name; Description = odt.Description; Fields = odt.Fields; break; case Segments.OM1: OM1 om1 = new OM1(); Name = om1.Name; Description = om1.Description; Fields = om1.Fields; break; case Segments.OM2: OM2 om2 = new OM2(); Name = om2.Name; Description = om2.Description; Fields = om2.Fields; break; case Segments.OM3: OM3 om3 = new OM3(); Name = om3.Name; Description = om3.Description; Fields = om3.Fields; break; case Segments.OM4: OM4 om4 = new OM4(); Name = om4.Name; Description = om4.Description; Fields = om4.Fields; break; case Segments.OM5: OM5 om5 = new OM5(); Name = om5.Name; Description = om5.Description; Fields = om5.Fields; break; case Segments.OM6: OM6 om6 = new OM6(); Name = om6.Name; Description = om6.Description; Fields = om6.Fields; break; case Segments.OM7: OM7 om7 = new OM7(); Name = om7.Name; Description = om7.Description; Fields = om7.Fields; break; case Segments.ORC: ORC orc = new ORC(); Name = orc.Name; Description = orc.Description; Fields = orc.Fields; break; case Segments.ORG: ORG org = new ORG(); Name = org.Name; Description = org.Description; Fields = org.Fields; break; case Segments.OVR: OVR ovr = new OVR(); Name = ovr.Name; Description = ovr.Description; Fields = ovr.Fields; break; case Segments.PCR: PCR pcr = new PCR(); Name = pcr.Name; Description = pcr.Description; Fields = pcr.Fields; break; case Segments.PD1: PD1 pd1 = new PD1(); Name = pd1.Name; Description = pd1.Description; Fields = pd1.Fields; break; case Segments.PDA: PDA pda = new PDA(); Name = pda.Name; Description = pda.Description; Fields = pda.Fields; break; case Segments.PDC: PDC pdc = new PDC(); Name = pdc.Name; Description = pdc.Description; Fields = pdc.Fields; break; case Segments.PEO: PEO peo = new PEO(); Name = peo.Name; Description = peo.Description; Fields = peo.Fields; break; case Segments.PES: PES pes = new PES(); Name = pes.Name; Description = pes.Description; Fields = pes.Fields; break; case Segments.PID: PID pid = new PID(); Name = pid.Name; Description = pid.Description; Fields = pid.Fields; break; case Segments.PR1: PR1 pr1 = new PR1(); Name = pr1.Name; Description = pr1.Description; Fields = pr1.Fields; break; case Segments.PRA: PRA pra = new PRA(); Name = pra.Name; Description = pra.Description; Fields = pra.Fields; break; case Segments.PRB: PRB prb = new PRB(); Name = prb.Name; Description = prb.Description; Fields = prb.Fields; break; case Segments.PRC: PRC prc = new PRC(); Name = prc.Name; Description = prc.Description; Fields = prc.Fields; break; case Segments.PRD: PRD prd = new PRD(); Name = prd.Name; Description = prd.Description; Fields = prd.Fields; break; case Segments.PSH: PSH psh = new PSH(); Name = psh.Name; Description = psh.Description; Fields = psh.Fields; break; case Segments.PTH: PTH pth = new PTH(); Name = pth.Name; Description = pth.Description; Fields = pth.Fields; break; case Segments.PV1: PV1 pv1 = new PV1(); Name = pv1.Name; Description = pv1.Description; Fields = pv1.Fields; break; case Segments.PV2: PV2 pv2 = new PV2(); Name = pv2.Name; Description = pv2.Description; Fields = pv2.Fields; break; case Segments.QAK: QAK qak = new QAK(); Name = qak.Name; Description = qak.Description; Fields = qak.Fields; break; case Segments.QID: QID qid = new QID(); Name = qid.Name; Description = qid.Description; Fields = qid.Fields; break; case Segments.QPD: QPD qpd = new QPD(); Name = qpd.Name; Description = qpd.Description; Fields = qpd.Fields; break; case Segments.QRD: QRD qrd = new QRD(); Name = qrd.Name; Description = qrd.Description; Fields = qrd.Fields; break; case Segments.QRF: QRF qrf = new QRF(); Name = qrf.Name; Description = qrf.Description; Fields = qrf.Fields; break; case Segments.QRI: QRI qri = new QRI(); Name = qri.Name; Description = qri.Description; Fields = qri.Fields; break; case Segments.RCP: RCP rcp = new RCP(); Name = rcp.Name; Description = rcp.Description; Fields = rcp.Fields; break; case Segments.RDF: RDF rdf = new RDF(); Name = rdf.Name; Description = rdf.Description; Fields = rdf.Fields; break; case Segments.RF1: RF1 rf1 = new RF1(); Name = rf1.Name; Description = rf1.Description; Fields = rf1.Fields; break; case Segments.RGS: RGS rgs = new RGS(); Name = rgs.Name; Description = rgs.Description; Fields = rgs.Fields; break; case Segments.RMI: RMI rmi = new RMI(); Name = rmi.Name; Description = rmi.Description; Fields = rmi.Fields; break; case Segments.ROL: ROL rol = new ROL(); Name = rol.Name; Description = rol.Description; Fields = rol.Fields; break; case Segments.RQ1: RQ1 rq1 = new RQ1(); Name = rq1.Name; Description = rq1.Description; Fields = rq1.Fields; break; case Segments.RQD: RQD rqd = new RQD(); Name = rqd.Name; Description = rqd.Description; Fields = rqd.Fields; break; case Segments.RXA: RXA rxa = new RXA(); Name = rxa.Name; Description = rxa.Description; Fields = rxa.Fields; break; case Segments.RXC: RXC rxc = new RXC(); Name = rxc.Name; Description = rxc.Description; Fields = rxc.Fields; break; case Segments.RXD: RXD rxd = new RXD(); Name = rxd.Name; Description = rxd.Description; Fields = rxd.Fields; break; case Segments.RXE: RXE rxe = new RXE(); Name = rxe.Name; Description = rxe.Description; Fields = rxe.Fields; break; case Segments.RXG: RXG rxg = new RXG(); Name = rxg.Name; Description = rxg.Description; Fields = rxg.Fields; break; case Segments.RXO: RXO rxo = new RXO(); Name = rxo.Name; Description = rxo.Description; Fields = rxo.Fields; break; case Segments.RXR: RXR rxr = new RXR(); Name = rxr.Name; Description = rxr.Description; Fields = rxr.Fields; break; case Segments.SAC: SAC sac = new SAC(); Name = sac.Name; Description = sac.Description; Fields = sac.Fields; break; case Segments.SCH: SCH sch = new SCH(); Name = sch.Name; Description = sch.Description; Fields = sch.Fields; break; case Segments.SFT: SFT sft = new SFT(); Name = sft.Name; Description = sft.Description; Fields = sft.Fields; break; case Segments.SID: SID sid = new SID(); Name = sid.Name; Description = sid.Description; Fields = sid.Fields; break; case Segments.SPM: SPM spm = new SPM(); Name = spm.Name; Description = spm.Description; Fields = spm.Fields; break; case Segments.SPR: SPR spr = new SPR(); Name = spr.Name; Description = spr.Description; Fields = spr.Fields; break; case Segments.STF: STF stf = new STF(); Name = stf.Name; Description = stf.Description; Fields = stf.Fields; break; case Segments.TCC: TCC tcc = new TCC(); Name = tcc.Name; Description = tcc.Description; Fields = tcc.Fields; break; case Segments.TCD: TCD tcd = new TCD(); Name = tcd.Name; Description = tcd.Description; Fields = tcd.Fields; break; case Segments.TQ1: TQ1 tq1 = new TQ1(); Name = tq1.Name; Description = tq1.Description; Fields = tq1.Fields; break; case Segments.TQ2: TQ2 tq2 = new TQ2(); Name = tq2.Name; Description = tq2.Description; Fields = tq2.Fields; break; case Segments.TXA: TXA txa = new TXA(); Name = txa.Name; Description = txa.Description; Fields = txa.Fields; break; case Segments.UB1: UB1 ub1 = new UB1(); Name = ub1.Name; Description = ub1.Description; Fields = ub1.Fields; break; case Segments.UB2: UB2 ub2 = new UB2(); Name = ub2.Name; Description = ub2.Description; Fields = ub2.Fields; break; case Segments.URD: URD urd = new URD(); Name = urd.Name; Description = urd.Description; Fields = urd.Fields; break; case Segments.URS: URS urs = new URS(); Name = urs.Name; Description = urs.Description; Fields = urs.Fields; break; case Segments.VAR: VAR var = new VAR(); Name = var.Name; Description = var.Description; Fields = var.Fields; break; case Segments.VTQ: VTQ vtq = new VTQ(); Name = vtq.Name; Description = vtq.Description; Fields = vtq.Fields; break; } }
public void CloseApplication() { AUT.Close(); }
///<summary> ///Removes the given AUT ///</summary> public void RemoveAUT(AUT toRemove) { this.RemoveStructure("AUT", toRemove); }
public ActionResult AcompanharExecucoes() { List <Encadeamento> encs = (from enc in db.Encadeamento //join enc_td in db.Encadeamento_TestData on enc.Id equals enc_td.IdEncadeamento //join td in db.TestData on enc_td.IdTestData equals td.Id //join exec in db.Execucao on td.IdExecucao equals exec.Id select enc ).Distinct().ToList(); List <Encadeamento_TestDataVO> encad_testDatas = new List <Encadeamento_TestDataVO>(); foreach (Encadeamento enc in encs) { List <Encadeamento_TestData> encTDs = (from td in db.Encadeamento_TestData where td.IdEncadeamento == enc.Id select td ).ToList(); int qtdErr = 0; int qtdTds = 0; int qtdSuc = 0; int qtdEmGer = 0; qtdTds = encTDs.Count(); DataPool dp = new DataPool(); List <TestDataVO> tds = new List <TestDataVO>(); AUT aut = new AUT(); TestData tdn = new TestData(); Execucao exec = new Execucao(); foreach (Encadeamento_TestData encTd in encTDs) { tdn = db.TestData.Where(x => x.Id == encTd.IdTestData).FirstOrDefault(); dp = db.DataPool.Where(x => x.Id == tdn.IdDataPool).FirstOrDefault(); aut = db.AUT.Where(x => x.Id == dp.IdAut).FirstOrDefault(); exec = db.Execucao.Where(x => x.IdTestData == tdn.Id).FirstOrDefault(); //string temp = tdn.TempoEstimadoExecucao.ToString(); DateTime?tempInicial = null; DateTime?tempFim = null; int? IdStatusExec = null; if (!(exec == null)) { tempInicial = exec.InicioExecucao; tempFim = exec.TerminoExecucao; IdStatusExec = exec.IdStatusExecucao; } string caminho_evidencia = ""; if (!(tdn.CaminhoEvidencia == null)) { caminho_evidencia = tdn.CaminhoEvidencia; } string temp = ""; if (!(tempInicial == null || tempInicial.Equals("")) && !(tempFim == null || tempFim.Equals(""))) { temp = tempInicial + " - " + tempFim; } if (tdn.IdStatus == 4) { qtdErr += 1; } else if (tdn.IdStatus == 3 || tdn.IdStatus == 5 || tdn.IdStatus == 6) { qtdSuc += 1; } else if (tdn.IdStatus == 2) { qtdEmGer += 1; } tds.Add(new TestDataVO { Descricao = tdn.Descricao, IdStatus = tdn.IdStatus, DescricaoAut = aut.Descricao, tempoExecString = temp, CaminhoEvidencia = caminho_evidencia, IdTestData = tdn.Id, idStatusExec = IdStatusExec }); } encad_testDatas.Add(new Encadeamento_TestDataVO { Descricao = enc.Descricao, Id = enc.Id, testDatas = tds, qtdErros = qtdErr, qtdTDs = qtdTds, qtdSuccess = qtdSuc, qtdEmGeracao = qtdEmGer }); } return(View(encad_testDatas)); }
public ActionResult Editar(int idEncadeamento) { Encadeamento enc = db.Encadeamento.Where(x => x.Id == idEncadeamento).FirstOrDefault(); EncadeamentoVO encVo = new EncadeamentoVO(); if (enc != null) { encVo.IdEncadeamento = enc.Id; encVo.Descricao = enc.Descricao; List <Encadeamento_TestData> enctds = db.Encadeamento_TestData.Where(x => x.IdEncadeamento == enc.Id).OrderByDescending(x => x.Ordem).ToList(); encVo.qtdTds = enctds.Count(); List <EncadeamentoVO.TestDataEncadeamento> testDatas = new List <EncadeamentoVO.TestDataEncadeamento>(); foreach (Encadeamento_TestData enctd in enctds) { TestData td = db.TestData.Where(x => x.Id == enctd.IdTestData).FirstOrDefault(); DataPool dp = db.DataPool.Where(x => x.Id == td.IdDataPool).FirstOrDefault(); AUT aut = db.AUT.Where(x => x.Id == dp.IdAut).FirstOrDefault(); List <ParametroScript> ListParametroScript = db.ParametroScript.Where(x => x.IdScript_CondicaoScript == td.IdScript_CondicaoScript).ToList(); List <EncadeamentoVO.TestDataEncadeamento.ParametroEncadeamento> parametros = new List <EncadeamentoVO.TestDataEncadeamento.ParametroEncadeamento>(); foreach (ParametroScript ps in ListParametroScript) { Parametro par = db.Parametro.Where(x => x.Id == ps.IdParametro).FirstOrDefault(); TipoParametro tp = db.TipoParametro.Where(x => x.Id == ps.IdTipoParametro).FirstOrDefault(); ParametroValor pv = db.ParametroValor.Where(x => x.IdParametroScript == ps.Id).Where(x => x.IdTestData == td.Id).FirstOrDefault(); EncadeamentoVO.TestDataEncadeamento.ParametroEncadeamento p = new EncadeamentoVO.TestDataEncadeamento.ParametroEncadeamento { Descricao = enc.Descricao, DescricaoParametro = par.Descricao, DescricaoTestData = td.Descricao, DescricaoTipoParametro = tp.Descricao, IdParametroScript = ps.Id, IdParametroValor = pv.Id, IdParametroValor_Origem = pv.IdParametroValor_Origem, IdTestData = td.Id, IdTipoParametro = tp.Id, Obrigatorio = ps.Obrigatorio, IdParametro = par.Id, Tipo = tp.Descricao, Valor = pv.Valor }; parametros.Add(p); } EncadeamentoVO.TestDataEncadeamento testData = new EncadeamentoVO.TestDataEncadeamento { Descricao = td.Descricao, Id = enctd.Id, IdTestData = td.Id, Ordem = enctd.Ordem, DescricaoAut = aut.Descricao, parametros = parametros, IdAmbienteExecucao = enctd.IdAmbienteExecucao, }; testDatas.Add(testData); } encVo.testDatas = testDatas; } Usuario user = GetLoggedUser(); ViewBag.listaTDMs = (from t in db.TDM join tdm in db.TDM_Usuario on t.Id equals tdm.IdTDM where tdm.IdUsuario == user.Id select new TDMVO { IdTestData = t.Id, Descricao = t.Descricao } ).ToList(); return(View(encVo)); }
public JsonResult listarTestDatas(string datapool) { #region Debug log.Info("Entrada no método listarTestDatas do Encadeamento."); log.Info("Id do DataPool: " + datapool); #endregion int idDatapool = Int32.Parse(datapool); SqlParameter[] param = { new SqlParameter("@IdDatapool", idDatapool), }; #region log.Info("Preparando a execução da PROC PR_LISTAR_TEST_DATA, passando o parâmtetro: " + idDatapool); #endregion //Executa a PROC que retorna os TestData List <TestDataVO> TestDataVOs = db.Database.SqlQuery <TestDataVO>("EXEC PR_LISTAR_TESTDATA @IdDatapool ", param).ToList(); #region log.Info("PROC 'PR_LISTAR_TEST_DATA' executada com sucesso e foram retornados " + TestDataVOs.Count() + " registros."); #endregion int qtdErr = 0; int qtdTds = 0; int qtdSuc = 0; int qtdEmGer = 0; int qtdCadas = 0; qtdTds = TestDataVOs.Count(); DataPool dp = new DataPool(); List <TestDataVO> tds = new List <TestDataVO>(); AUT aut = new AUT(); TestData tdn = new TestData(); Execucao exec = new Execucao(); for (int i = 0; i < TestDataVOs.Count(); i++) { int? idTemp = TestDataVOs[i].IdTestData; string descTD = TestDataVOs[i].Descricao; tdn = db.TestData.Where(x => x.Id == idTemp).FirstOrDefault(); dp = db.DataPool.Where(x => x.Id == tdn.IdDataPool).FirstOrDefault(); List <AmbienteExecucaoVO> amb_exec = (from scsa in db.Script_CondicaoScript_Ambiente join av in db.AmbienteExecucao on scsa.IdAmbienteExecucao equals av.Id join scs in db.Script_CondicaoScript on scsa.IdScript_CondicaoScript equals scs.Id where scs.Id == dp.IdScript_CondicaoScript select new AmbienteExecucaoVO { Id = scsa.IdAmbienteExecucao, Descricao = av.Descricao }).DistinctBy(x => x.Descricao).ToList(); TestDataVOs[i].AmbientesExecs = amb_exec; List <ParametroValorVO> parametros = (from pv in db.ParametroValor join ps in db.ParametroScript on pv.IdParametroScript equals ps.Id join tp in db.TipoParametro on ps.IdTipoParametro equals tp.Id join p in db.Parametro on ps.IdParametro equals p.Id where pv.IdTestData == idTemp select new ParametroValorVO { IdParametroValor = pv.Id, IdParametroScript = pv.IdParametroScript, Valor = pv.Valor, IdTestData = pv.IdTestData, DescricaoTestData = descTD, DescricaoParametro = p.Descricao, DescricaoTipoParametro = tp.Descricao, IdParametroValor_Origem = pv.IdParametroValor_Origem, IdTipoParametro = ps.IdTipoParametro, Tipo = p.Tipo }).ToList(); List <ChaveVO> listaChaveVO = (from item in parametros select new ChaveVO { value = string.Concat(item.DescricaoTestData, " - ", item.DescricaoParametro, " (", item.DescricaoTipoParametro, ") "), key = item.IdParametroValor }).ToList(); foreach (ParametroValorVO vo in parametros) { string key = string.Concat(vo.DescricaoTestData, " - ", vo.DescricaoParametro, " (", vo.DescricaoTipoParametro, ") "); Dictionary <string, int?> dicChaves = new Dictionary <string, int?>(); dicChaves.Add("ATMP", 0); foreach (ChaveVO item in listaChaveVO) { dicChaves.Add(item.value, item.key); } if (!dicChaves.ContainsKey(key)) { vo.DescricaoOrigem = dicChaves; } else { dicChaves.Remove(key); vo.DescricaoOrigem = dicChaves; } } #region log.Info("Preenchimento dos parametros do testData executado com sucesso e foram retornados " + parametros.Count() + " registros."); #endregion TestDataVOs[i].valores = parametros; aut = db.AUT.Where(x => x.Id == dp.IdAut).FirstOrDefault(); exec = db.Execucao.Where(x => x.IdTestData == tdn.Id).FirstOrDefault(); //string temp = tdn.TempoEstimadoExecucao.ToString(); DateTime?tempInicial = null; DateTime?tempFim = null; int? IdStatusExec = null; if (!(exec == null)) { tempInicial = exec.InicioExecucao; tempFim = exec.TerminoExecucao; IdStatusExec = exec.IdStatusExecucao; } string caminho_evidencia = ""; if (!(tdn.CaminhoEvidencia == null)) { caminho_evidencia = tdn.CaminhoEvidencia; } string temp = ""; if (!(tempInicial == null || tempInicial.Equals("")) && !(tempFim == null || tempFim.Equals(""))) { temp = tempInicial + " - " + tempFim; } if (tdn.IdStatus == 4) { qtdErr += 1; } else if (tdn.IdStatus == 3 || tdn.IdStatus == 5 || tdn.IdStatus == 6) { qtdSuc += 1; } else if (tdn.IdStatus == 2) { qtdEmGer += 1; } else if (tdn.IdStatus == 1) { qtdCadas += 1; } TestDataVOs[i].tempoExecString = temp; TestDataVOs[i].CaminhoEvidencia = caminho_evidencia; TestDataVOs[i].idStatusExec = IdStatusExec; TestDataVOs[i].tempoExecString = temp; TestDataVOs[i].DescricaoAut = aut.Descricao; //tds.Add(new TestDataVO { Descricao = tdn.Descricao, IdStatus = tdn.IdStatus, DescricaoAut = aut.Descricao, tempoExecString = temp, CaminhoEvidencia = caminho_evidencia, IdTestData = tdn.Id, idStatusExec = IdStatusExec }); } string json = JsonConvert.SerializeObject(TestDataVOs, Formatting.Indented); return(Json(json, JsonRequestBehavior.AllowGet)); }