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);
}
}
}
}
