Esempio n. 1
0
 public int AddPatient(LocalPatient localPatient)
 {
     using (DSAEntities dsaModel = new DSAEntities())
     {
         var patient = localPatient.ToEntityPatient();
         dsaModel.Patients.AddObject(patient);
         dsaModel.SaveChanges();
         return(patient.id);
     }
 }
Esempio n. 2
0
 public void SavePatients(List <LocalPatient> patients)
 {
     using (DSAEntities dsaModel = new DSAEntities())
     {
         for (int i = 1; i < 13; i++)
         {
             dsaModel.Months.AddObject(new Month()
             {
                 MOnthNumber = i
             });
         }
         dsaModel.SaveChanges();
         foreach (var localPatient in patients)
         {
             var entityPactient = new Patient();
             entityPactient.name = localPatient.Name;
             foreach (var localIntervention in localPatient.Interventions)
             {
                 var year =
                     dsaModel.Years.FirstOrDefault(
                         item => item.YearNb == localIntervention.DateHourDetail.Date.Year);
                 if (year == null)
                 {
                     year = new Year()
                     {
                         YearNb = localIntervention.DateHourDetail.Date.Year
                     };
                     dsaModel.Years.AddObject(year);
                     dsaModel.SaveChanges();
                 }
                 entityPactient.Interventions.Add(new Intervention()
                 {
                     Area           = dsaModel.Areas.FirstOrDefault(item => item.Name == localIntervention.Area.Name),
                     Location       = dsaModel.Locations.FirstOrDefault(item => item.Name == localIntervention.Location.Name),
                     Work           = dsaModel.Works.FirstOrDefault(item => item.Name == localIntervention.Lucrare.Name),
                     Revenue        = dsaModel.Revenues.FirstOrDefault(item => item.Amount == localIntervention.Revenue.Amount),
                     DateHourDetail = new DateHourDetails()
                     {
                         Date       = localIntervention.DateHourDetail.Date,
                         StartHour  = localIntervention.DateHourDetail.StartHour,
                         EndingHour = localIntervention.DateHourDetail.EndingHour,
                         Duration   = localIntervention.DateHourDetail.EndingHour - localIntervention.DateHourDetail.StartHour
                     },
                     Year        = year,
                     Month       = dsaModel.Months.FirstOrDefault(item => item.MOnthNumber == localIntervention.DateHourDetail.Date.Month),
                     Material    = dsaModel.Materials.FirstOrDefault(item => item.Name == localIntervention.Material.Name),
                     Observation = localIntervention.Observation
                 });
             }
             dsaModel.Patients.AddObject(entityPactient);
         }
         dsaModel.SaveChanges();
     }
 }
Esempio n. 3
0
//        public List<LocalTooth> GetTeeth()
//        {
//            List<LocalTooth> teeth=new List<LocalTooth>();
//            using (DSAEntities dsaModel = new DSAEntities())
//            {
//                foreach (var tooth in dsaModel.Teeth)
//                {
//                    teeth.Add(tooth.ToLocalTooth());
//                }
//            }
//            return teeth;
//        }

        public void SaveWorks(List <string> workValues)
        {
            using (DSAEntities dsaModel = new DSAEntities())
            { foreach (var workValue in workValues)
              {
                  dsaModel.Works.AddObject(new Work()
                    {
                        Name = workValue
                    });
              }
              dsaModel.SaveChanges(); }
        }
Esempio n. 4
0
        public List <LocalPatient> GetPatients()
        {
            List <LocalPatient> localPatients = new List <LocalPatient>();

            using (DSAEntities dsaModel = new DSAEntities())
            {
                foreach (var patient in dsaModel.Patients)
                {
                    localPatients.Add(patient.ToLocalPatient());
                }
            }
            return(localPatients);
        }
Esempio n. 5
0
        public List <LocalMaterial> GetMaterials()
        {
            List <LocalMaterial> materials = new List <LocalMaterial>();

            using (DSAEntities dsaModel = new DSAEntities())
            {
                foreach (var loc in dsaModel.Materials)
                {
                    materials.Add(loc.ToLocalMaterial());
                }
            }
            return(materials);
        }
Esempio n. 6
0
        public List <LocalLocation> GetlLocations()
        {
            List <LocalLocation> locations = new List <LocalLocation>();

            using (DSAEntities dsaModel = new DSAEntities())
            {
                foreach (var loc in dsaModel.Locations)
                {
                    locations.Add(loc.ToLocalLocation());
                }
            }
            return(locations);
        }
Esempio n. 7
0
        public List <LocalWork> GetWorks()
        {
            List <LocalWork> works = new List <LocalWork>();

            using (DSAEntities dsaModel = new DSAEntities())
            {
                foreach (var work in dsaModel.Works)
                {
                    works.Add(work.TolLocalWork());
                }
            }
            return(works);
        }
Esempio n. 8
0
        public List <LocalArea> GetAreas()
        {
            List <LocalArea> areas = new List <LocalArea>();

            using (DSAEntities dsaModel = new DSAEntities())
            {
                foreach (var area in dsaModel.Areas)
                {
                    areas.Add(area.ToLocalArea());
                }
            }
            return(areas);
        }
Esempio n. 9
0
 public void SaveAreas(List <string> areasList)
 {
     using (DSAEntities dsaModel = new DSAEntities())
     {
         foreach (var area in areasList)
         {
             dsaModel.Areas.AddObject(new Area()
             {
                 Name = area
             });
         }
         dsaModel.SaveChanges();
     }
 }
Esempio n. 10
0
 public void SaveMaterials(List <string> materialsList)
 {
     using (DSAEntities dsaModel = new DSAEntities())
     {
         foreach (var material in materialsList)
         {
             dsaModel.Materials.AddObject(new Material()
             {
                 Name = material
             });
         }
         dsaModel.SaveChanges();
     }
 }