protected void Page_Load(object sender, EventArgs e)
 {
     // First control the type of parent page
     if (Request.QueryString["InsuranceID"] != null)
     {
         insuranceId = Int32.Parse(Request.QueryString["InsuranceId"]);
         ins = CntAriCli.GetInsurance(insuranceId, ctx);
         caller = "ins"; // Called by Insurance
     }
 }
Exemple #2
0
        public static void ImportAssurancePolicies(OleDbConnection con, AriClinicContext ctx)
        {
            //(0) Borrar las aseguradoras y pólizas previas.
            ctx.Delete(ctx.Policies);
            ctx.Delete(ctx.Insurances);
            ctx.Delete(ctx.InsuranceServices);
            ctx.SaveChanges();

            //(1) Por defecto creamos una aseguradora que es la clínica de Valencia.

            Insurance insurance = (from i in ctx.Insurances
                                   where i.Name == "MIESTETIC (Valencia)"
                                   select i).FirstOrDefault<Insurance>();
            if (insurance == null)
            {
                insurance = new Insurance();
                insurance.Name = "MIESTETIC (Valencia)";
                insurance.Internal = true;
                ctx.Add(insurance);
            }

            //(2) Ahora leemos, de nuevo, todos los tipos de servicio porque en OFT
            // ellos llevan los importes y en nuestro caso son los Insurance services
            string sql = "SELECT * FROM ServMed";
            cmd = new OleDbCommand(sql, con);
            da = new OleDbDataAdapter(cmd);
            DataSet ds = new DataSet();
            da.Fill(ds, "ConServicios");
            int nreg = ds.Tables["ConServicios"].Rows.Count;
            int reg = 0;
            InsuranceService ins = null;
            foreach (DataRow dr in ds.Tables["ConServicios"].Rows)
            {
                reg++;
                Console.WriteLine("Servicions {0:#####0} de {1:#####0} {2}", reg, nreg, "SERVICIO");
                int id = (int)dr["IdServMed"];
                ins = (from i in ctx.InsuranceServices
                       where i.OftId == id
                       select i).FirstOrDefault<InsuranceService>();
                if (ins == null)
                {
                    ins = new InsuranceService();
                    ctx.Add(ins);
                }
                ins.Insurance = insurance;
                ins.Service = (from s in ctx.Services
                               where s.OftId == id
                               select s).FirstOrDefault<Service>();
                ins.Price = (decimal)dr["Importe"];
            }

            //(3) por último asignamos una póliza a todos los clientes que tenemos dados de alta.
            foreach (Customer cus in ctx.Customers)
            {
                Customer localCus = cus;
                Policy pol = (from p in ctx.Policies
                              where p.Customer.PersonId == localCus.PersonId &&
                                    p.Insurance.InsuranceId == insurance.InsuranceId
                              select p).FirstOrDefault<Policy>();
                if (pol == null)
                {
                    pol = new Policy();
                    pol.Customer = localCus;
                    pol.Insurance = insurance;
                    ctx.Add(pol);
                }
            }
            ctx.SaveChanges();
        }
Exemple #3
0
 public static IList<Patient> GetPatients(Insurance insurance, AriClinicContext ctx)
 {
     var rs = from p in ctx.Policies
              where p.Insurance.InsuranceId == insurance.InsuranceId
              select p;
     IList<Patient> lp = new List<Patient>();
     foreach (Policy p in rs)
     {
         Patient pat = (from pt in ctx.Patients
                        where pt.Customer.PersonId == p.Customer.PersonId
                        select pt).FirstOrDefault<Patient>();
         if (pat != null)
             lp.Add(pat);
     }
     return lp;
 }
Exemple #4
0
 public static InsuranceService GetInsuranceService(int id, Insurance insurance, AriClinicContext ctx)
 {
     return (from i in ctx.InsuranceServices
             where i.InsuranceServiceId == id &&
                   i.Insurance.InsuranceId == insurance.InsuranceId
             select i).FirstOrDefault<InsuranceService>();
 }