public List <ConsultationDrugView> AllConsultationDrugs(int Id)
 {
     using (var consultrepo = new ConsultationDrugsRepository())
     {
         var consultation = consultrepo.Getall().FindAll(x => x.PrescriptionId == Id).ToList();
         return
             ((consultation
               .Select(
                   x =>
                   new ConsultationDrugView()
         {
             DrugId = x.DrugId,
             DrugName = x.DrugName,
             DrugToConsultId = x.DrugToConsultId,
             Price = x.Price,
             Quantity = x.Quantity,
         })).ToList());
     }
 }
 public void ViewDrugToConsult(ConsultationDrugView cdv, int id)
 {
     using (var consultrepo = new ConsultationDrugsRepository())
     {
         var drugid = da.Drugs.ToList().Find(x => x.DrugId == cdv.DrugId);
         if (cdv.DrugToConsultId == 0)
         {
             var prescriptionid    = da.CollectionDrugs.ToList().Find(x => x.collectionID == id);
             ConsultationDrug drug = new ConsultationDrug()
             {
                 DrugId         = cdv.DrugId,
                 PrescriptionId = prescriptionid.collectionID,
                 DrugName       = drugid.DrugName,
                 //Price = drugid.Price * cdv.Quantity,
                 DrugToConsultId = cdv.DrugToConsultId,
                 Quantity        = cdv.Quantity,
             };
             consultrepo.Create(drug);
         }
     }
 }
        public Consultation AddDrugToConsult(string id /*,int PrescriptionID*/)
        {
            using (var consultrepo = new ConsultationDrugsRepository())
            {
                var collection  = da.Consultations.ToList().Find(x => x.ConsultId == id);
                var PatientName = da.Patients.ToList().Find(x => x.PatientId == collection.PatientId);
                collection.patientfullname = PatientName.FullName + " " + PatientName.Surname;
                //var PrescriptionId = da.CollectionDrugs.ToList().Find(x => x.collectionID == id);
                //var c = da.ConsultationDrugs.ToList().Find(x => x.PrescriptionId == PrescriptionId.collectionID);
                //var drugid = da.Drugs.ToList().Find(x => x.DrugId == cdv.DrugId);
                //if (cdv.DrugToConsultId == 0)
                //{
                //    Drug m = drugrep.GetById(cdv.DrugId);
                //    ConsultationDrug con = consultrepo.FindbyId(cdv.DrugToConsultId);
                //        ConsultationDrug consultdrug = new ConsultationDrug()
                //        {
                //            DrugId = cdv.DrugId,
                //            PrescriptionId = id,
                //            DrugName = drugid.DrugName,
                //            Price = drugid.Price*cdv.Quantity,
                //            DrugToConsultId = cdv.DrugToConsultId,
                //            Quantity = cdv.Quantity,
                //        };


                //        int quantity = m.Quantity - cdv.Quantity;
                //        m.Quantity = quantity;

                //        drugrep.Update(m);

                //        consultrepo.Create(consultdrug);

                //}
                return(collection);
            }
        }