Esempio n. 1
0
    void OnEquipmentChanged(Equipment newItem, Equipment oldItem)
    {
        if (newItem != null)
        {
            HP.AddModifier(newItem.HP);
            SP.AddModifier(newItem.SP);

            MIN_ATT.AddModifier(newItem.MIN_ATT);
            MAX_ATT.AddModifier(newItem.MAX_ATT);

            CRI_RATE.AddModifier(newItem.CRI_RATE);
            DEF.AddModifier(newItem.DEF);
            ATT_SPD.AddModifier(newItem.ATT_SPD);
            MOV_SPD.AddModifier(newItem.MOV_SPD);

            STR.AddModifier(newItem.STR);
            ACC.AddModifier(newItem.ACC);
            SPR.AddModifier(newItem.SPR);
            CON.AddModifier(newItem.CON);
            AGI.AddModifier(newItem.CON);

            CalculateMaxHP();
            CalculateMaxSP();
            CalculateCurrentDMG();
            CalculateCurrentCRI_RATE();
            CalculateCurrentDEF();
            CalculateCurrentATT_SPD();
            CalculateCurrentMOV_SPD();
        }

        if (oldItem != null)
        {
            HP.RemoveModifier(oldItem.HP);
            SP.RemoveModifier(oldItem.SP);

            MIN_ATT.RemoveModifier(oldItem.MIN_ATT);
            MAX_ATT.RemoveModifier(oldItem.MAX_ATT);

            CRI_RATE.RemoveModifier(oldItem.CRI_RATE);
            DEF.RemoveModifier(oldItem.DEF);
            ATT_SPD.RemoveModifier(oldItem.ATT_SPD);
            MOV_SPD.RemoveModifier(oldItem.MOV_SPD);

            STR.RemoveModifier(oldItem.STR);
            ACC.RemoveModifier(oldItem.ACC);
            SPR.RemoveModifier(oldItem.SPR);
            CON.RemoveModifier(oldItem.CON);
            AGI.RemoveModifier(oldItem.CON);

            CalculateMaxHP();
            CalculateMaxSP();
            CalculateCurrentDMG();
            CalculateCurrentCRI_RATE();
            CalculateCurrentDEF();
            CalculateCurrentATT_SPD();
            CalculateCurrentMOV_SPD();
        }
    }
Esempio n. 2
0
        ///<summary>
        /// Returns  first repetition of CON (Consent Segment) - creates it if necessary
        ///</summary>
        public CON GetCON()
        {
            CON ret = null;

            try {
                ret = (CON)this.GetStructure("CON");
            } 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);
        }
Esempio n. 3
0
        private void txtCON_TextChanged(object sender, EventArgs e)
        {
            int CON;

            if (int.TryParse(txtCON.Text, out CON))
            {
                CON = SetStatMod(CON);
                if (CON <= 0)
                {
                    lblCON.Text = CON.ToString("0");
                }
                else
                {
                    lblCON.Text = "+" + CON.ToString("0");
                }
            }
        }
Esempio n. 4
0
 public void setCON_EMPTY(Boolean OPEN)
 {
     if (OPEN)
     {
         if (CON.State == ConnectionState.Closed)
         {
             CON.Open();
         }
     }
     else
     {
         if (CON.State == ConnectionState.Open)
         {
             CON.Close();
         }
     }
 }
Esempio n. 5
0
        private void btnQuadrado_Click(object sender, EventArgs e)
        {
            try
            {
                if (byte.Parse(mtxtLinhas.Text) < 9)
                {
                    byte linhas = byte.Parse(mtxtLinhas.Text);
                    int  aux    = 0;
                    foreach (Panel A in Paineis)
                    {
                        A.Visible = false;
                    }
                    foreach (Control CON in this.Controls)
                    {
                        if (CON.GetType() == typeof(Panel))
                        {
                            foreach (Label Lab in CON.Controls)
                            {
                                var       path     = new System.Drawing.Drawing2D.GraphicsPath();
                                Rectangle pathRect = new Rectangle(0, 0, Lab.Width, Lab.Height);
                                path.AddRectangle(pathRect);

                                Lab.Region = new Region(path);
                            }
                        }
                    }
                    foreach (Panel A in Paineis)
                    {
                        if (aux == Convert.ToInt32(mtxtLinhas.Text))
                        {
                            break;
                        }
                        A.Visible = true;
                        aux++;
                    }
                }
                else
                {
                    MessageBox.Show("Digite um valor válido!");
                }
            }
            catch
            {
                MessageBox.Show("Digite um valor válido!");
            }
        }
Esempio n. 6
0
        private void SetCON()
        {
            int CON;

            if (int.TryParse(txtCON.Text, out CON))
            {
                NewMonster.CON = CON;
                CON            = SetStatMod(CON);
                if (CON <= 0)
                {
                    lblCON.Text = CON.ToString("0");
                }
                else
                {
                    lblCON.Text = "+" + CON.ToString("0");
                }
            }
            else if (txtCON.Text != "")
            {
                MessageBox.Show("only numbers for CON please");
            }
        }
Esempio n. 7
0
        private void rollAllButton_Click(object sender, EventArgs e)
        {
            HP           = rng.Next(1, 21) + 10;
            hpValue.Text = HP.ToString();

            STR           = rng.Next(1, 21);
            strValue.Text = STR.ToString();

            DEX           = rng.Next(1, 21);
            dexValue.Text = DEX.ToString();

            CON           = rng.Next(1, 21);
            conValue.Text = CON.ToString();

            INT           = rng.Next(1, 21);
            intValue.Text = INT.ToString();

            WIS           = rng.Next(1, 21);
            wisValue.Text = WIS.ToString();

            CHA           = rng.Next(1, 21);
            chaValue.Text = CHA.ToString();
        }
Esempio n. 8
0
        /// <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;
            }
        }
Esempio n. 9
0
 ///<summary>
 ///Removes the given CON
 ///</summary>
 public void RemoveCON(CON toRemove)
 {
     this.RemoveStructure("CON", toRemove);
 }
Esempio n. 10
0
 private void conRollButton_Click(object sender, EventArgs e)
 {
     CON           = rng.Next(1, 21);
     conValue.Text = CON.ToString();
 }
Esempio n. 11
0
        public override IEnumerable <ArquivoViewModel> Bind(int?index, int pageSize = 50, params object[] param)
        {
            System.DateTime _data1            = (DateTime)param[0];
            System.DateTime _data2            = (DateTime)param[1];
            int             _EdificacaoID     = (int)param[2];
            int             _UnidadeID        = (int)param[3];
            int             _CondominoID      = (int)param[4];
            int             _GrupoCondominoID = (int?)param[5] ?? 0;
            string          _Nome             = (string)param[6];

            IEnumerable <ArquivoViewModel> archive = new List <ArquivoViewModel>();

            if (_CondominoID > 0)
            {
                string _EdificacaoCondomino = "";

                foreach (Unidade unidade in SessaoLocal.Unidades)
                {
                    _EdificacaoCondomino += unidade.EdificacaoID.ToString() + "|";
                }

                // arquivos do condômino
                archive = (from arq in db.Arquivos
                           join edi in db.Edificacaos on arq.EdificacaoID equals edi.EdificacaoID into EDI
                           from edi in EDI.DefaultIfEmpty()
                           join gru in db.GrupoCondominos on arq.GrupoCondominoID equals gru.GrupoCondominoID into GRU
                           from gru in GRU.DefaultIfEmpty()
                           join con in db.Condominos on arq.CondominoID equals con.CondominoID into CON
                           from con in CON.DefaultIfEmpty()
                           where arq.CondominioID == sessaoCorrente.empresaId &&
                           ((arq.Data >= _data1 && arq.Data <= _data2) || arq.IndSempreVisivel == "S") &&
                           (arq.CondominoID == _CondominoID) &&
                           (_Nome == null || _Nome == "" || arq.Nome.Contains(_Nome))
                           select new ArquivoViewModel()
                {
                    empresaId = SessaoLocal.empresaId,
                    CondominioID = SessaoLocal.empresaId,
                    FileID = arq.FileID,
                    EdificacaoID = arq.EdificacaoID,
                    EdificacaoDescricao = edi.Descricao,
                    UnidadeID = arq.UnidadeID,
                    CondominoID = arq.CondominoID,
                    CondominoNome = con.Nome,
                    GrupoCondominoID = arq.GrupoCondominoID,
                    GrupoCondominoDescricao = gru.Descricao,
                    Nome = arq.Nome,
                    Data = arq.Data,
                    IndSempreVisivel = arq.IndSempreVisivel
                }).Union(from arq in db.Arquivos            // arquivos com visibilidade pública
                         join edi in db.Edificacaos on arq.EdificacaoID equals edi.EdificacaoID into EDI
                         from edi in EDI.DefaultIfEmpty()
                         join gru in db.GrupoCondominos on arq.GrupoCondominoID equals gru.GrupoCondominoID into GRU
                         from gru in GRU.DefaultIfEmpty()
                         join con in db.Condominos on arq.CondominoID equals con.CondominoID into CON
                         from con in CON.DefaultIfEmpty()
                         where arq.CondominioID == sessaoCorrente.empresaId &&
                         ((arq.Data >= _data1 && arq.Data <= _data2) || arq.IndSempreVisivel == "S") &&
                         (!arq.EdificacaoID.HasValue || _EdificacaoCondomino.Contains(arq.EdificacaoID.ToString()) &&
                          !arq.UnidadeID.HasValue) &&
                         !arq.CondominoID.HasValue &&
                         (_GrupoCondominoID == 0 || arq.GrupoCondominoID == _GrupoCondominoID) &&
                         (_Nome == null || _Nome == "" || arq.Nome.Contains(_Nome))
                         select new ArquivoViewModel()
                {
                    empresaId               = SessaoLocal.empresaId,
                    CondominioID            = SessaoLocal.empresaId,
                    FileID                  = arq.FileID,
                    EdificacaoID            = arq.EdificacaoID,
                    EdificacaoDescricao     = edi.Descricao,
                    UnidadeID               = arq.UnidadeID,
                    CondominoID             = arq.CondominoID,
                    CondominoNome           = con.Nome,
                    GrupoCondominoID        = arq.GrupoCondominoID,
                    GrupoCondominoDescricao = gru.Descricao,
                    Nome             = arq.Nome,
                    Data             = arq.Data,
                    IndSempreVisivel = arq.IndSempreVisivel
                });

                archive = (from arch in archive
                           orderby arch.IndSempreVisivel descending, arch.Data descending
                           select new ArquivoViewModel()
                {
                    empresaId = arch.empresaId,
                    CondominioID = arch.empresaId,
                    FileID = arch.FileID,
                    EdificacaoID = arch.EdificacaoID,
                    EdificacaoDescricao = arch.EdificacaoDescricao,
                    UnidadeID = arch.UnidadeID,
                    CondominoID = arch.CondominoID,
                    CondominoNome = arch.Nome,
                    GrupoCondominoID = arch.GrupoCondominoID,
                    GrupoCondominoDescricao = arch.GrupoCondominoDescricao,
                    Nome = arch.Nome,
                    Data = arch.Data,
                    IndSempreVisivel = arch.IndSempreVisivel,
                    PageSize = pageSize,
                    TotalCount = archive.Count()
                }
                           ).Skip((index ?? 0) * pageSize).Take(pageSize).ToList();
            }
            else
            {
                archive = (from arq in db.Arquivos
                           join edi in db.Edificacaos on arq.EdificacaoID equals edi.EdificacaoID into EDI
                           from edi in EDI.DefaultIfEmpty()
                           join gru in db.GrupoCondominos on arq.GrupoCondominoID equals gru.GrupoCondominoID into GRU
                           from gru in GRU.DefaultIfEmpty()
                           join con in db.Condominos on arq.CondominoID equals con.CondominoID into CON
                           from con in CON.DefaultIfEmpty()
                           where arq.CondominioID == sessaoCorrente.empresaId &&
                           ((arq.Data >= _data1 && arq.Data <= _data2) || arq.IndSempreVisivel == "S") &&
                           (_EdificacaoID == 0 || arq.EdificacaoID == _EdificacaoID) &&
                           (_UnidadeID == 0 || arq.UnidadeID == _UnidadeID) &&
                           (_GrupoCondominoID == 0 || arq.GrupoCondominoID == _GrupoCondominoID) &&
                           (_Nome == null || _Nome == "" || arq.Nome.Contains(_Nome))
                           orderby arq.IndSempreVisivel descending, arq.Data descending
                           select new ArquivoViewModel()
                {
                    empresaId = SessaoLocal.empresaId,
                    CondominioID = SessaoLocal.empresaId,
                    FileID = arq.FileID,
                    EdificacaoID = arq.EdificacaoID,
                    EdificacaoDescricao = edi.Descricao,
                    UnidadeID = arq.UnidadeID,
                    CondominoID = arq.CondominoID,
                    CondominoNome = con.Nome,
                    GrupoCondominoID = arq.GrupoCondominoID,
                    GrupoCondominoDescricao = gru.Descricao,
                    Nome = arq.Nome,
                    Data = arq.Data,
                    IndSempreVisivel = arq.IndSempreVisivel,
                    PageSize = pageSize,
                    TotalCount = ((from arq1 in db.Arquivos
                                   join edi1 in db.Edificacaos on arq1.EdificacaoID equals edi1.EdificacaoID into EDI1
                                   from edi1 in EDI1.DefaultIfEmpty()
                                   join gru1 in db.GrupoCondominos on arq1.GrupoCondominoID equals gru1.GrupoCondominoID into GRU1
                                   from gru1 in GRU1.DefaultIfEmpty()
                                   join con1 in db.Condominos on arq1.CondominoID equals con1.CondominoID into CON1
                                   from con1 in CON1.DefaultIfEmpty()
                                   where arq1.CondominioID == sessaoCorrente.empresaId &&
                                   ((arq1.Data >= _data1 && arq1.Data <= _data2) || arq1.IndSempreVisivel == "S") &&
                                   (_EdificacaoID == 0 || arq1.EdificacaoID == _EdificacaoID) &&
                                   (_UnidadeID == 0 || arq1.UnidadeID == _UnidadeID) &&
                                   (_GrupoCondominoID == 0 || arq1.GrupoCondominoID == _GrupoCondominoID) &&
                                   (_Nome == null || _Nome == "" || arq1.Nome.Contains(_Nome))
                                   orderby arq1.IndSempreVisivel descending, arq1.Data descending
                                   select arq1).Count())
                }).Skip((index ?? 0) * pageSize).Take(pageSize).ToList();
            }

            return(archive);
        }
        public override IEnumerable <ChamadoViewModel> Bind(int?index, int pageSize = 50, params object[] param)
        {
            #region parâmetros

            /* 0. Data1
             * 1. Data2
             * 2. ChamadoMotivoID
             * 3. ChamadoStatusID
             * 4. FilaSolicitanteID
             * 5. FilaAtendimentoID
             * 6. EdificacaoID
             * 7. UnidadeID
             */

            DateTime _data1             = (DateTime)param[0];
            DateTime _data2             = (DateTime)param[1];
            int?     _ChamadoMotivoID   = (int?)param[2];
            int?     _ChamadoStatusID   = (int?)param[3];
            int?     _FilaSolicitanteID = (int?)param[4];
            int?     _FilaAtendimentoID = (int?)param[5];
            int?     _EdificacaoID      = (int?)param[6];
            int?     _UnidadeID         = (int?)param[7];
            #endregion

            var x = (from cha in db.Chamados
                     join FilaAtual in db.FilaAtendimentos on cha.FilaAtendimentoID equals FilaAtual.FilaAtendimentoID
                     join con in db.Condominos on cha.CondominoID equals con.CondominoID into CON
                     from con in CON.DefaultIfEmpty()
                     join cre in db.Credenciados on cha.CredenciadoID equals cre.CredenciadoID into CRE
                     from cre in CRE.DefaultIfEmpty()
                     join edi in db.Edificacaos on cha.EdificacaoID equals edi.EdificacaoID into EDI
                     from edi in EDI.DefaultIfEmpty()
                     join uni in db.Unidades on new { CondominioID = cha.CondominioID, EdificacaoID = cha.EdificacaoID.Value, UnidadeID = cha.UnidadeID.Value } equals new { uni.CondominioID, uni.EdificacaoID, uni.UnidadeID } into UNI
                     from uni in UNI.DefaultIfEmpty()
                     join sta in db.ChamadoStatuss on cha.ChamadoStatusID equals sta.ChamadoStatusID
                     join mot in db.ChamadoMotivos on cha.ChamadoMotivoID equals mot.ChamadoMotivoID
                     where cha.CondominioID == SessaoLocal.empresaId &&
                     cha.DataChamado >= _data1 && cha.DataChamado <= _data2 &&
                     sta.CondominioID == SessaoLocal.empresaId &&
                     mot.CondominioID == SessaoLocal.empresaId &&
                     (!_EdificacaoID.HasValue || (cha.EdificacaoID == _EdificacaoID && cha.UnidadeID == _UnidadeID)) &&
                     (!_FilaAtendimentoID.HasValue || cha.FilaAtendimentoID == _FilaAtendimentoID) &&
                     (!_FilaSolicitanteID.HasValue || cha.FilaSolicitanteID == _FilaSolicitanteID) &&
                     (!_ChamadoMotivoID.HasValue || cha.ChamadoMotivoID == _ChamadoMotivoID) &&
                     (!_ChamadoStatusID.HasValue || cha.ChamadoStatusID == _ChamadoStatusID)
                     orderby cha.DataChamado descending
                     select new ChamadoViewModel
            {
                empresaId = SessaoLocal.empresaId,
                ChamadoID = cha.ChamadoID,
                ChamadoMotivoID = cha.ChamadoMotivoID,
                DescricaoChamadoMotivo = mot.Descricao,
                ChamadoStatusID = cha.ChamadoStatusID,
                DescricaoChamadoStatus = sta.Descricao,
                FilaSolicitanteID = cha.FilaSolicitanteID,
                DescricaoFilaSolicitante = (from fil in db.FilaAtendimentos where fil.CondominioID == SessaoLocal.empresaId && fil.FilaAtendimentoID == cha.FilaSolicitanteID select fil.Descricao).FirstOrDefault(),
                FilaAtendimentoID = cha.FilaAtendimentoID,
                DescricaoFilaAtendimento = FilaAtual.Descricao,
                CondominoID = cha.CondominoID,
                CredenciadoID = cha.CredenciadoID,
                NomeCondomino = con != null ? con.Nome : "",
                NomeCredenciado = cre != null ? cre.Nome : "",
                EdificacaoID = cha.EdificacaoID,
                DescricaoEdificacao = edi.Descricao,
                UnidadeID = cha.UnidadeID,
                Codigo = uni.Codigo,
                DataChamado = cha.DataChamado,
                Assunto = cha.Assunto,
                UsuarioID = cha.UsuarioID,
                NomeUsuario = cha.NomeUsuario,
                LoginUsuario = cha.LoginUsuario,
                Prioridade = cha.Prioridade,
                DataUltimaAnotacao = cha.DataUltimaAnotacao,
                DataRedirecionamento = cha.DataRedirecionamento,
                UsuarioFilaID = cha.UsuarioFilaID,
                NomeUsuarioFila = cha.NomeUsuarioFila,
                LoginUsuarioFila = cha.LoginUsuarioFila
            }).ToList();
            return(x);
        }
        public override IEnumerable <ChamadoViewModel> Bind(int?index, int pageSize = 50, params object[] param)
        {
            #region parâmetros

            /* 0. Período:
             *      007 última semana
             *      030 últimos 30 dias
             *      060 últimos 60 dias
             *      090 Últimos 90 dias
             *      180 Últimos 180 dias
             *
             * 1. Edificação
             * 2. Unidade
             * 3. Condômino
             * 4. Fila de atendimento
             * 5. Chamado Motivo =>> Null = Todos
             * 6. Chamado Status =>> Null = Todos             *
             */

            #region Param1: Período
            DateTime _data1 = _data1 = Funcoes.Brasilia().Date.AddDays(-(int)param[0]);
            DateTime _data2 = Funcoes.Brasilia().Date;
            #endregion

            int?_EdificacaoID      = (int?)param[1];
            int?_UnidadeID         = (int?)param[2];
            int?_CondominoID       = (int?)param[3];
            int?_FilaAtendimentoID = (int?)param[4];
            int?_ChamadoMotivoID   = (int?)param[5];
            int?_ChamadoStatusID   = (int?)param[6];
            #endregion

            return((from cha in db.Chamados
                    join FilaAtual in db.FilaAtendimentos on cha.FilaAtendimentoID equals FilaAtual.FilaAtendimentoID
                    join con in db.Condominos on cha.CondominoID equals con.CondominoID into CON
                    from con in CON.DefaultIfEmpty()
                    join cre in db.Credenciados on cha.CredenciadoID equals cre.CredenciadoID into CRE
                    from cre in CRE.DefaultIfEmpty()
                    join edi in db.Edificacaos on cha.EdificacaoID equals edi.EdificacaoID into EDI
                    from edi in EDI.DefaultIfEmpty()
                    join uni in db.Unidades on new { CondominioID = cha.CondominioID, EdificacaoID = cha.EdificacaoID.Value, UnidadeID = cha.UnidadeID.Value } equals new { uni.CondominioID, uni.EdificacaoID, uni.UnidadeID } into UNI
                    from uni in UNI.DefaultIfEmpty()
                    join sta in db.ChamadoStatuss on cha.ChamadoStatusID equals sta.ChamadoStatusID
                    join mot in db.ChamadoMotivos on cha.ChamadoMotivoID equals mot.ChamadoMotivoID
                    where cha.CondominioID == SessaoLocal.empresaId &&
                    cha.DataChamado >= _data1 && cha.DataChamado <= _data2 &&
                    sta.CondominioID == SessaoLocal.empresaId &&
                    mot.CondominioID == SessaoLocal.empresaId &&
                    (!_EdificacaoID.HasValue || (cha.EdificacaoID == _EdificacaoID && cha.UnidadeID == _UnidadeID)) &&
                    (!_CondominoID.HasValue || cha.CondominoID == _CondominoID) &&
                    (!_FilaAtendimentoID.HasValue || cha.FilaAtendimentoID == _FilaAtendimentoID) &&
                    (!_ChamadoMotivoID.HasValue || cha.ChamadoMotivoID == _ChamadoMotivoID) &&
                    (!_ChamadoStatusID.HasValue || cha.ChamadoStatusID == _ChamadoStatusID)
                    orderby cha.DataChamado descending
                    select new ChamadoViewModel
            {
                empresaId = SessaoLocal.empresaId,
                ChamadoID = cha.ChamadoID,
                ChamadoMotivoID = cha.ChamadoMotivoID,
                DescricaoChamadoMotivo = mot.Descricao,
                ChamadoStatusID = cha.ChamadoStatusID,
                DescricaoChamadoStatus = sta.Descricao,
                FilaSolicitanteID = cha.FilaSolicitanteID,
                DescricaoFilaSolicitante = (from fil in db.FilaAtendimentos where fil.CondominioID == SessaoLocal.empresaId && fil.FilaAtendimentoID == cha.FilaSolicitanteID select fil.Descricao).FirstOrDefault(),
                FilaAtendimentoID = cha.FilaAtendimentoID,
                DescricaoFilaAtendimento = FilaAtual.Descricao,
                CondominoID = cha.CondominoID,
                CredenciadoID = cha.CredenciadoID,
                NomeCondomino = con != null ? con.Nome : "",
                NomeCredenciado = cre != null ? cre.Nome : "",
                EdificacaoID = cha.EdificacaoID,
                DescricaoEdificacao = edi.Descricao,
                UnidadeID = cha.UnidadeID,
                Codigo = uni.Codigo,
                DataChamado = cha.DataChamado,
                Assunto = cha.Assunto,
                UsuarioID = cha.UsuarioID,
                NomeUsuario = cha.NomeUsuario,
                LoginUsuario = cha.LoginUsuario,
                Prioridade = cha.Prioridade,
                DataUltimaAnotacao = cha.DataUltimaAnotacao,
                DataRedirecionamento = cha.DataRedirecionamento,
                UsuarioFilaID = cha.UsuarioFilaID,
                NomeUsuarioFila = cha.NomeUsuarioFila,
                LoginUsuarioFila = cha.LoginUsuarioFila
            }).ToList());
        }
        public override IEnumerable <ChamadoViewModel> Bind(int?index, int pageSize = 50, params object[] param)
        {
            int _FilaCondominoID = DWMSessaoLocal.FilaCondominoID(sessaoCorrente, this.db);

            return((from cha in db.Chamados
                    join FilaAtual in db.FilaAtendimentos on cha.FilaAtendimentoID equals FilaAtual.FilaAtendimentoID
                    join con in db.Condominos on cha.CondominoID equals con.CondominoID into CON
                    from con in CON.DefaultIfEmpty()
                    join cre in db.Credenciados on cha.CredenciadoID equals cre.CredenciadoID into CRE
                    from cre in CRE.DefaultIfEmpty()
                    join edi in db.Edificacaos on cha.EdificacaoID equals edi.EdificacaoID into EDI
                    from edi in EDI.DefaultIfEmpty()
                    join uni in db.Unidades on new { CondominioID = cha.CondominioID, EdificacaoID = cha.EdificacaoID.Value, UnidadeID = cha.UnidadeID.Value } equals new { uni.CondominioID, uni.EdificacaoID, uni.UnidadeID } into UNI
                    from uni in UNI.DefaultIfEmpty()
                    join sta in db.ChamadoStatuss on cha.ChamadoStatusID equals sta.ChamadoStatusID
                    join mot in db.ChamadoMotivos on cha.ChamadoMotivoID equals mot.ChamadoMotivoID
                    where  cha.CondominioID == SessaoLocal.empresaId &&
                    sta.CondominioID == SessaoLocal.empresaId &&
                    mot.CondominioID == SessaoLocal.empresaId &&
                    ((cha.ChamadoStatusID == 3 && (SessaoLocal.CondominoID > 0 || SessaoLocal.CredenciadoID > 0)) ||
                     cha.ChamadoStatusID != 3) &&       // 3-Encerrado
                    (cha.UsuarioID == SessaoLocal.usuarioId || cha.UsuarioFilaID == SessaoLocal.usuarioId ||
                     (cha.CondominoID.HasValue && cha.CondominoID == SessaoLocal.CondominoID && SessaoLocal.CondominoID > 0) ||
                     (from usu in db.FilaAtendimentoUsuarios
                      where usu.FilaAtendimentoID == cha.FilaAtendimentoID
                      select usu.UsuarioID).Contains(SessaoLocal.usuarioId))
                    orderby cha.DataChamado descending
                    select new ChamadoViewModel
            {
                empresaId = SessaoLocal.empresaId,
                ChamadoID = cha.ChamadoID,
                ChamadoMotivoID = cha.ChamadoMotivoID,
                DescricaoChamadoMotivo = mot.Descricao,
                ChamadoStatusID = cha.ChamadoStatusID,
                DescricaoChamadoStatus = sta.Descricao,
                FilaSolicitanteID = cha.FilaSolicitanteID,
                DescricaoFilaSolicitante = (from fil in db.FilaAtendimentos where fil.CondominioID == SessaoLocal.empresaId && fil.FilaAtendimentoID == cha.FilaSolicitanteID select fil.Descricao).FirstOrDefault(),
                FilaAtendimentoID = cha.FilaAtendimentoID,
                DescricaoFilaAtendimento = FilaAtual.Descricao,
                FilaCondominoID = _FilaCondominoID,
                CondominoID = cha.CondominoID,
                CredenciadoID = cha.CredenciadoID,
                NomeCondomino = con != null ? con.Nome : "",
                NomeCredenciado = cre != null ? cre.Nome : "",
                EdificacaoID = cha.EdificacaoID,
                DescricaoEdificacao = edi.Descricao,
                UnidadeID = cha.UnidadeID,
                Codigo = uni.Codigo,
                DataChamado = cha.DataChamado,
                Assunto = cha.Assunto,
                UsuarioID = cha.UsuarioID,
                NomeUsuario = cha.NomeUsuario,
                LoginUsuario = cha.LoginUsuario,
                Prioridade = cha.Prioridade,
                DataUltimaAnotacao = cha.DataUltimaAnotacao,
                DataRedirecionamento = cha.DataRedirecionamento,
                UsuarioFilaID = cha.UsuarioFilaID,
                NomeUsuarioFila = cha.NomeUsuarioFila,
                LoginUsuarioFila = cha.LoginUsuarioFila
            }).ToList());
        }