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 = CntAriCli.GetUser((Session["User"] as User).UserId, ctx); Process proc = (from p in ctx.Processes where p.Code == "rtickets" select p).FirstOrDefault<Process>(); per = CntAriCli.GetPermission(user.UserGroup, proc, ctx); } // cheks if is call from another form if (Request.QueryString["Report"] != null) report = Request.QueryString["Report"]; if (Request.QueryString["FDate"] != null) fDate = CntWeb.ParseUrlDate(Request.QueryString["FDate"]); if (Request.QueryString["TDate"] != null) tDate = CntWeb.ParseUrlDate(Request.QueryString["TDate"]); if (Request.QueryString["Diary"] != null) diary = CntAriCli.GetDiary(int.Parse(Request.QueryString["Diary"]),ctx); if (Request.QueryString["Visit"] != null) visit = CntAriCli.GetVisit(int.Parse(Request.QueryString["Visit"]), ctx); if (Request.QueryString["Treatment"] != null) treatment = CntAriCli.GetTreatment(int.Parse(Request.QueryString["Treatment"]), ctx); if (Request.QueryString["Invoice"] != null) invoice = CntAriCli.GetInvoice(int.Parse(Request.QueryString["Invoice"]), ctx); if (Request.QueryString["PrescriptionGlasses"] != null) prescriptionGlasses = CntAriCli.GetPrescriptionGlasses(int.Parse(Request.QueryString["PrescriptionGlasses"]), ctx); }
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 == "procedureassigned" select p).FirstOrDefault<Process>(); per = CntAriCli.GetPermission(user.UserGroup, proc, ctx); btnAccept.Visible = per.Modify; } // if (Request.QueryString["ProcedureAssignedId"] != null) { procedureAssignedId = Int32.Parse(Request.QueryString["ProcedureAssignedId"]); procedureAssigned = CntAriCli.GetProcedureAssigned(procedureAssignedId, ctx); LoadData(procedureAssigned); } else { rdpProcedureDate.SelectedDate = DateTime.Now; } // if (Request.QueryString["PatientId"] != null) { patientId = int.Parse(Request.QueryString["PatientId"]); patient = CntAriCli.GetPatient(patientId, ctx); // fix rdc with patient rdcPatient.Items.Clear(); rdcPatient.Items.Add(new RadComboBoxItem(patient.FullName,patient.PersonId.ToString())); rdcPatient.SelectedValue = patient.PersonId.ToString(); rdcPatient.Enabled = false; } // if (Request.QueryString["VisitId"] != null) { visitId = int.Parse(Request.QueryString["VisitId"]); visit = CntAriCli.GetVisit(visitId, ctx); patientId = visit.Patient.PersonId; patient = CntAriCli.GetPatient(patientId, ctx); // fix rdc with patient rdcPatient.Items.Clear(); rdcPatient.Items.Add(new RadComboBoxItem(patient.FullName, patient.PersonId.ToString())); rdcPatient.SelectedValue = patient.PersonId.ToString(); rdcPatient.Enabled = false; // rdpProcedureDate.SelectedDate = visit.VisitDate; } }
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 == "visit" select p).FirstOrDefault<Process>(); per = CntAriCli.GetPermission(user.UserGroup, proc, ctx); btnAccept.Visible = per.Modify; } // if (Request.QueryString["VisitId"] != null) { visitId = Int32.Parse(Request.QueryString["VisitId"]); visit = CntAriCli.GetVisit(visitId, ctx); oVisit = (OphthalmologicVisit)visit; LoadData(oVisit); } else { rdpVisitDate.SelectedDate = DateTime.Now; } // if (Request.QueryString["PatientId"] != null) { patientId = int.Parse(Request.QueryString["PatientId"]); patient = CntAriCli.GetPatient(patientId, ctx); // fix rdc with patient rdcPatient.Items.Clear(); rdcPatient.Items.Add(new RadComboBoxItem(patient.FullName,patient.PersonId.ToString())); rdcPatient.SelectedValue = patient.PersonId.ToString(); rdcPatient.Enabled = false; } // if (Request.QueryString["Type"] != null) { type = Request.QueryString["Type"]; if (type == "InTab") { HtmlControl tt = (HtmlControl)this.FindControl("TitleArea"); tt.Attributes["class"] = "ghost"; } } }
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 = CntAriCli.GetUser((Session["User"] as User).UserId, ctx); user = CntAriCli.GetUser(user.UserId, ctx); Process proc = (from p in ctx.Processes where p.Code == "visit" select p).FirstOrDefault<Process>(); per = CntAriCli.GetPermission(user.UserGroup, proc, ctx); } // cheks if is call from another form if (Request.QueryString["Type"] != null) type = Request.QueryString["Type"]; // read patient information if (Request.QueryString["PatientId"] != null) { patientId = int.Parse(Request.QueryString["PatientId"]); patient = CntAriCli.GetPatient(patientId, ctx); } if (Request.QueryString["VisitId"] != null) { visitId = Int32.Parse(Request.QueryString["VisitId"]); visit = CntAriCli.GetVisit(visitId, ctx); oVisit = (OphthalmologicVisit)visit; patient = visit.Patient; patientId = patient.PersonId; string title = String.Format("{0} ({1:dd/MM/yyyy}) {2}", visit.VisitReason.Name, visit.VisitDate, visit.Patient.FullName); lblTitle.Text = title; this.Title = title; } else { lblTitle.Text = "Nueva visita"; } }
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 == "procedureassigned" select p).FirstOrDefault<Process>(); per = CntAriCli.GetPermission(user.UserGroup, proc, ctx); } // cheks if is call from another form if (Request.QueryString["Type"] != null) type = Request.QueryString["Type"]; // check if grid is call from a tab if (type == "InTab") { HtmlControl tt = (HtmlControl)this.FindControl("TitleArea"); tt.Attributes["class"] = "ghost"; // hide patient column RadGrid1.Columns.FindByDataField("Patient.FullName").Visible = false; } if (Request.QueryString["PatientId"] != null) { patientId = int.Parse(Request.QueryString["PatientId"]); patient = CntAriCli.GetPatient(patientId, ctx); } if (Request.QueryString["VisitId"] != null) { visitId = int.Parse(Request.QueryString["VisitId"]); visit = CntAriCli.GetVisit(visitId, ctx); } // translate filters CntWeb.TranslateRadGridFilters(RadGrid1); }
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 == "visit" select p).FirstOrDefault<Process>(); per = CntAriCli.GetPermission(user.UserGroup, proc, ctx); btnAccept.Visible = per.Modify; if (user.Professionals.Count > 0) { professional = user.Professionals[0]; LoadComboProfesional(professional); } } // if (Request.QueryString["VisitId"] != null) { visitId = Int32.Parse(Request.QueryString["VisitId"]); visit = CntAriCli.GetVisit(visitId, ctx); LoadData(visit); } else { rdpVisitDate.SelectedDate = DateTime.Now; // load professional if (Session["Professional"] != null) LoadComboProfesional((Professional)Session["Professional"]); // called from an appointment? if (Request.QueryString["AppointmentId"] != null) { app = CntAriCli.GetAppointment(int.Parse(Request.QueryString["AppointmentId"]), ctx); if (app != null) { Patient pat = app.Patient; rdcPatient.Items.Clear(); rdcPatient.Items.Add(new RadComboBoxItem(pat.FullName, pat.PersonId.ToString())); rdcPatient.SelectedValue = pat.PersonId.ToString(); // rdpVisitDate.SelectedDate = app.BeginDateTime; // LoadComboProfesional(app.Professional); // AppointmentType appt = app.AppointmentType; rdcAppointmentType.Items.Clear(); rdcAppointmentType.Items.Add(new RadComboBoxItem(appt.Name, appt.AppointmentTypeId.ToString())); rdcAppointmentType.SelectedValue = appt.AppointmentTypeId.ToString(); // fromAppointment = true; } } } // if (Request.QueryString["PatientId"] != null) { patientId = int.Parse(Request.QueryString["PatientId"]); patient = CntAriCli.GetPatient(patientId, ctx); // fix rdc with patient rdcPatient.Items.Clear(); rdcPatient.Items.Add(new RadComboBoxItem(patient.FullName,patient.PersonId.ToString())); rdcPatient.SelectedValue = patient.PersonId.ToString(); rdcPatient.Enabled = false; } // if (Request.QueryString["Type"] != null) { type = Request.QueryString["Type"]; if (type == "InTab") { HtmlControl tt = (HtmlControl)this.FindControl("TitleArea"); tt.Attributes["class"] = "ghost"; } } if (Request.QueryString["Caller"] != null) { caller = Request.QueryString["Caller"]; } }
protected void UnloadData(BaseVisit visit) { visit.Patient = CntAriCli.GetPatient(int.Parse(rdcPatient.SelectedValue), ctx); visit.VisitDate = (DateTime)rdpVisitDate.SelectedDate; if (newVisit) visit.Patient.LastUpdate = visit.VisitDate; visit.Professional = CntAriCli.GetProfessional(int.Parse(rdcProfessional.SelectedValue), ctx); if (rdcVisitReason.SelectedValue != "") visit.VisitReason = CntAriCli.GetVisitReason(int.Parse(rdcVisitReason.SelectedValue), ctx); if (rdcAppointmentType.SelectedValue != "") visit.AppointmentType = CntAriCli.GetAppointmentType(int.Parse(rdcAppointmentType.SelectedValue), ctx); visit.Comments = txtComments.Text; visit.VType = "general"; }
protected void LoadData(BaseVisit visit) { // Load patient data rdcPatient.Items.Clear(); rdcPatient.Items.Add(new RadComboBoxItem(visit.Patient.FullName, visit.Patient.PersonId.ToString())); rdcPatient.SelectedValue = visit.Patient.PersonId.ToString(); // Load professional data rdcProfessional.Items.Clear(); rdcProfessional.Items.Add(new RadComboBoxItem(visit.Professional.FullName, visit.Professional.PersonId.ToString())); rdcProfessional.SelectedValue = visit.Professional.PersonId.ToString(); rdpVisitDate.SelectedDate = visit.VisitDate; // Load visit reason if (visit.VisitReason != null) { rdcVisitReason.Items.Clear(); rdcVisitReason.Items.Add(new RadComboBoxItem(visit.VisitReason.Name, visit.VisitReason.VisitReasonId.ToString())); rdcVisitReason.SelectedValue = visit.VisitReason.VisitReasonId.ToString(); } // Load appointment type if (visit.AppointmentType != null) { rdcAppointmentType.Items.Clear(); rdcAppointmentType.Items.Add(new RadComboBoxItem(visit.AppointmentType.Name, visit.AppointmentType.AppointmentTypeId.ToString())); rdcAppointmentType.SelectedValue = visit.AppointmentType.AppointmentTypeId.ToString(); } txtComments.Text = visit.Comments; }
protected bool CreateChange() { if (!DataOk()) return false; if (visit == null) { visit = new BaseVisit(); newVisit = true; if (app != null) { visit.AppointmentInfo = app; } UnloadData(visit); ctx.Add(visit); } else { visit = CntAriCli.GetVisit(visitId, ctx); UnloadData(visit); } ctx.SaveChanges(); 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(); } } }
protected void RadAjaxManager1_AjaxRequest(object sender, AjaxRequestEventArgs e) { RefreshGrid(true); if (e.Argument == "new") { RadGrid1.CurrentPageIndex = RadGrid1.PageCount - 1; RadGrid1.Rebind(); } if (e.Argument == "yes") { if (Session["DeleteId"] != null) { try { visitId = (int)Session["DeleteId"]; visit = (from da in ctx.BaseVisits where da.VisitId == visitId select da).FirstOrDefault<BaseVisit>(); ctx.Delete(visit); ctx.SaveChanges(); RefreshGrid(true); Session["DeleteId"] = null; } catch (Exception ex) { Session["Exception"] = ex; string command = String.Format("showDialog('Error','{0}','error',null, 0, 0)" , Resources.GeneralResource.DeleteRecordFail); RadAjaxManager1.ResponseScripts.Add(command); } } } }