protected void UnloadData(Fundus fundus) { fundus.OpticNerve = txtOpticalNerve.Text; fundus.Vessels = txtVessels.Text; fundus.Macula = txtMacula.Text; fundus.Vitreous = txtVitreous.Text; fundus.Periphery = txtPeriphery.Text; }
protected void LoadData(Fundus fundus) { txtOpticalNerve.Text = fundus.OpticNerve; txtVessels.Text = fundus.Vessels; txtMacula.Text = fundus.Macula; txtVitreous.Text = fundus.Vitreous; txtPeriphery.Text = fundus.Periphery; }
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["FundusId"] != null) { id = Int32.Parse(Request.QueryString["FundusId"]); fundus = CntAriCli.GetFundus(id, ctx); oVisit = fundus.OphthalmologicVisit; LoadData(fundus); } if (Request.QueryString["OphVisitId"] != null) { id = int.Parse(Request.QueryString["OphVisitId"]); oVisit = (OphthalmologicVisit)CntAriCli.GetVisit(id, ctx); if (oVisit.Fundus.Count > 0) { fundus = oVisit.Fundus[0]; LoadData(fundus); } } }
protected bool CreateChange() { if (!DataOk()) { return(false); } if (fundus == null) { fundus = new Fundus(); fundus.OphthalmologicVisit = oVisit; UnloadData(fundus); ctx.Add(fundus); } else { fundus = CntAriCli.GetFundus(fundus.Id, ctx); UnloadData(fundus); } ctx.SaveChanges(); RadAjaxManager1.ResponseScripts.Add(String.Format("showDialog('{0}','{1}','success',null,0,0)", Resources.GeneralResource.Success, Resources.GeneralResource.CorrectlyStored)); Response.Redirect(String.Format("FundusForm.aspx?FundusId={0}", fundus.Id)); return(true); }
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["FundusId"] != null) { id = Int32.Parse(Request.QueryString["FundusId"]); fundus = CntAriCli.GetFundus(id, ctx); oVisit = fundus.OphthalmologicVisit; LoadData(fundus); } if (Request.QueryString["OphVisitId"] != null) { id = int.Parse(Request.QueryString["OphVisitId"]); oVisit = (OphthalmologicVisit)CntAriCli.GetVisit(id, ctx); if (oVisit.Fundus.Count > 0) { fundus = oVisit.Fundus[0]; LoadData(fundus); } } }
protected void UnloadData(Fundus fundus) { fundus.OpticNerve = txtOpticalNerve.Text ; fundus.Vessels = txtVessels.Text ; fundus.Macula = txtMacula.Text ; fundus.Vitreous = txtVitreous.Text ; fundus.Periphery = txtPeriphery.Text ; }
protected bool CreateChange() { if (!DataOk()) return false; if (fundus == null) { fundus = new Fundus(); fundus.OphthalmologicVisit = oVisit; UnloadData(fundus); ctx.Add(fundus); } else { fundus = CntAriCli.GetFundus(fundus.Id, ctx); UnloadData(fundus); } ctx.SaveChanges(); RadAjaxManager1.ResponseScripts.Add(String.Format("showDialog('{0}','{1}','success',null,0,0)", Resources.GeneralResource.Success, Resources.GeneralResource.CorrectlyStored)); Response.Redirect(String.Format("FundusForm.aspx?FundusId={0}", fundus.Id)); return true; }
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(); } } }