protected void Page_Init(object sender, EventArgs e) { ctx = new AriClinicContext("AriClinicContext"); // security control, it must be a user logged if (Session["User"] == null) Response.Redirect("Default.aspx"); else { user = (User)Session["User"]; user = CntAriCli.GetUser(user.UserId, ctx); Process proc = (from p in ctx.Processes where p.Code == "examinationassigned" select p).FirstOrDefault<Process>(); per = CntAriCli.GetPermission(user.UserGroup, proc, ctx); btnAccept.Visible = per.Modify; } // if (Request.QueryString["AntSegmentId"] != null) { id = Int32.Parse(Request.QueryString["AntSegmentId"]); atsg = CntAriCli.GetAntSegment(id, ctx); oVisit = atsg.OphthalmologicVisit; LoadData(atsg); } if (Request.QueryString["OphVisitId"] != null) { id = int.Parse(Request.QueryString["OphVisitId"]); oVisit = (OphthalmologicVisit)CntAriCli.GetVisit(id, ctx); if (oVisit.AntSegments.Count > 0) { atsg = oVisit.AntSegments[0]; LoadData(atsg); } } }
public static void ImportVisits(OleDbConnection con, AriClinicContext ctx) { int id = 0; // (0) Borra tipos previos ctx.Delete(ctx.MotAppends); ctx.Delete(ctx.AntSegments); ctx.Delete(ctx.Fundus); ctx.Delete(ctx.OphthalmologicVisits); ctx.Delete(ctx.BaseVisits); ctx.SaveChanges(); // (1) Dar de alta las visitas importadas string sql = "SELECT * FROM HistVisitas"; cmd = new OleDbCommand(sql, con); da = new OleDbDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds, "ConVisitas"); int nreg = ds.Tables["ConVisitas"].Rows.Count; int reg = 0; foreach (DataRow dr in ds.Tables["ConVisitas"].Rows) { reg++; Boolean newVisit = false; Console.WriteLine("Visitas {0:#####0} de {1:#####0} {2}", reg, nreg, "VISITAS"); BaseVisit visit = (from v in ctx.BaseVisits where v.OftRefVisita == (int)dr["RefVisita"] select v).FirstOrDefault<BaseVisit>(); if (visit == null) { visit = new BaseVisit(); newVisit = true; } visit.OftRefVisita = (int)dr["RefVisita"]; visit.VisitDate = (DateTime)dr["Fecha"]; id = (int)dr["IdTipCit"]; visit.AppointmentType = (from apt in ctx.AppointmentTypes where apt.OftId == id select apt).FirstOrDefault<AppointmentType>(); id = (int)dr["IdMot"]; visit.VisitReason = (from vr in ctx.VisitReasons where vr.OftId == id select vr).FirstOrDefault<VisitReason>(); id = (int)dr["IdMed"]; visit.Professional = (from p in ctx.Professionals where p.OftId == id select p).FirstOrDefault<Professional>(); id = (int)dr["NumHis"]; visit.Patient = (from p in ctx.Patients where p.OftId == id select p).FirstOrDefault<Patient>(); if (dr["Observaciones"] != DBNull.Value) visit.Comments = (string)dr["Observaciones"]; if ((decimal)(float)dr["TOOD"] != 0 || (decimal)(float)dr["TOOI"] != 0) { OphthalmologicVisit ophVisit; if (newVisit) { ophVisit = new OphthalmologicVisit(); } else { ophVisit = (OphthalmologicVisit)visit; } ophVisit.OftRefVisita = visit.OftRefVisita; ophVisit.AppointmentType = visit.AppointmentType; ophVisit.VisitReason = visit.VisitReason; ophVisit.VisitDate = visit.VisitDate; ophVisit.Patient = visit.Patient; ophVisit.Professional = visit.Professional; ophVisit.Comments = visit.Comments; ophVisit.VType = "ophvisit"; if (newVisit) ctx.Add(ophVisit); ctx.SaveChanges(); // Motilidad y anejos MotAppend mot; if (newVisit) { mot = new MotAppend(); } else { mot = ophVisit.MotAppends[0]; } if (dr["MotOcular"] != DBNull.Value) mot.EyeMotility = (string)dr["MotOcular"]; if (dr["cejas"] != DBNull.Value) mot.Eyebrows = (string)dr["Cejas"]; if (dr["AreaPeriocular"] != DBNull.Value) mot.PeriocularArea = (string)dr["AreaPeriocular"]; mot.C1RE = (decimal)(float)dr["C1OD"]; mot.C1LE = (decimal)(float)dr["C1OI"]; mot.C2RE = (decimal)(float)dr["C2OD"]; mot.C2LE = (decimal)(float)dr["C2OI"]; mot.C3RE = (decimal)(float)dr["C3OD"]; mot.C3LE = (decimal)(float)dr["C3OI"]; mot.C4RE = (decimal)(float)dr["C4OD"]; mot.C4LE = (decimal)(float)dr["C4OI"]; mot.C5RE = (decimal)(float)dr["C5OD"]; mot.C5LE = (decimal)(float)dr["C5OI"]; mot.C6RE = (decimal)(float)dr["C6OD"]; mot.C6LE = (decimal)(float)dr["C6OI"]; mot.C7RE = (decimal)(float)dr["C7OD"]; mot.C7LE = (decimal)(float)dr["C7OI"]; mot.C8RE = (decimal)(float)dr["C8OD"]; mot.C8LE = (decimal)(float)dr["C8OI"]; mot.C9RE = (decimal)(float)dr["C9OD"]; mot.C9LE = (decimal)(float)dr["C9OI"]; mot.C10RE = (decimal)(float)dr["C10OD"]; mot.C10LE = (decimal)(float)dr["C10OI"]; mot.C11RE = (decimal)(float)dr["C11OD"]; mot.C11LE = (decimal)(float)dr["C11OI"]; mot.C12RE = (decimal)(float)dr["C12OD"]; mot.C12LE = (decimal)(float)dr["C12OI"]; mot.OphthalmologicVisit = ophVisit; if (newVisit) ctx.Add(mot); ctx.SaveChanges(); // Segmento anterior AntSegment ant; if (newVisit) { ant = new AntSegment(); } else { ant = ophVisit.AntSegments[0]; } if (dr["ObsParpados"] != DBNull.Value) ant.EyebrowsComments = (string)dr["ObsParpados"]; if (dr["Conjuntiva"].GetType() == typeof(DBNull)) { } if (dr["Conjuntiva"] != DBNull.Value) ant.Conjunctiva = (string)dr["Conjuntiva"]; if (dr["Cornea"] != DBNull.Value) ant.Cornea = (string)dr["Cornea"]; if (dr["Camara"] != DBNull.Value) ant.Chamber = (string)dr["Camara"]; if (dr["Tyndall"] != DBNull.Value) ant.Tyndall = (string)dr["Tyndall"]; if (dr["Pupila"] != DBNull.Value) ant.Pupil = (string)dr["Pupila"]; if (dr["Cristalino"] != DBNull.Value) ant.Crystalline = (string)dr["Cristalino"]; ant.EyestrainLE = (decimal)(float)dr["TOOI"]; ant.EyestrainRE = (decimal)(float)dr["TOOD"]; ant.OphthalmologicVisit = ophVisit; if (newVisit) ctx.Add(ant); ctx.SaveChanges(); // Fondo de ojo Fundus fundus; if (newVisit) { fundus = new Fundus(); } else { fundus = ophVisit.Fundus[0]; } if (dr["NervioOptico"] != DBNull.Value) fundus.OpticNerve = (string)dr["NervioOptico"]; if (dr["Vasos"] != DBNull.Value) fundus.Vessels = (string)dr["Vasos"]; if (dr["Macula"] != DBNull.Value) fundus.Macula = (string)dr["Macula"]; if (dr["Vitreo"] != DBNull.Value) fundus.Vitreous = (string)dr["Vitreo"]; if (dr["Periferia"] != DBNull.Value) fundus.Periphery = (string)dr["Periferia"]; fundus.OphthalmologicVisit = ophVisit; if (newVisit) ctx.Add(fundus); ctx.SaveChanges(); } else { visit.VType = "general"; if (newVisit) ctx.Add(visit); ctx.SaveChanges(); } } }
protected void LoadData(AntSegment atsg) { txtConjunctiva.Text = atsg.Conjunctiva; txtCornea.Text = atsg.Cornea; txtChamber.Text = atsg.Chamber; txtTyndall.Text = atsg.Tyndall; txtIris.Text = atsg.Iris; txtPupil.Text = atsg.Pupil; txtCrystalline.Text = atsg.Crystalline; if (atsg.EyestrainRE != null) txtEyestrainRE.Value = (double)atsg.EyestrainRE; if (atsg.EyestrainLE != null) txtEyestrainLE.Value = (double)atsg.EyestrainLE; }
protected void UnloadData(AntSegment atsg) { atsg.Conjunctiva = txtConjunctiva.Text; atsg.Cornea = txtCornea.Text; atsg.Chamber =txtChamber.Text; atsg.Tyndall = txtTyndall.Text ; atsg.Iris = txtIris.Text ; atsg.Pupil = txtPupil.Text ; atsg.Crystalline = txtCrystalline.Text ; if (txtEyestrainRE.Value != null) atsg.EyestrainRE = (decimal)txtEyestrainRE.Value; if (txtEyestrainLE.Value != null) atsg.EyestrainLE = (decimal)txtEyestrainLE.Value; }
protected bool CreateChange() { if (!DataOk()) return false; if (atsg == null) { atsg = new AntSegment(); atsg.OphthalmologicVisit = oVisit; UnloadData(atsg); ctx.Add(atsg); } else { atsg = CntAriCli.GetAntSegment(atsg.Id, ctx); UnloadData(atsg); } ctx.SaveChanges(); RadAjaxManager1.ResponseScripts.Add(String.Format("showDialog('{0}','{1}','success',null,0,0)" ,Resources.GeneralResource.Success ,Resources.GeneralResource.CorrectlyStored)); Response.Redirect(String.Format("AntSegmentForm.aspx?AntSegmentId={0}",atsg.Id)); return true; }