public async Task <bool> AddPrescriptionDetails(FullPrescriptionDetailsDTO prescDetails) { var validPatient = _context.Patient.FromSqlInterpolated($"select * from Patient where patientid = {prescDetails.Patientid}").FirstOrDefault(); var consultationPresc = _context.ConsultationPrescription .FromSqlInterpolated($"select * from Consultation_Prescription where patientid = {prescDetails.Patientid} and prescriptionid = {prescDetails.Prescriptionid}") .FirstOrDefault(); if (validPatient != null && consultationPresc != null) { var prescDetailObj = new ConsultationPrescriptionDetails { EncounterId = consultationPresc.Encounterid, Frequencyid = prescDetails.Frequencyid, Doseformid = prescDetails.Doseformid, Routeid = prescDetails.Routeid, Unitid = prescDetails.Unitid, Icdcode = prescDetails.Icdcode, EmrPrescription = prescDetails.EmrPrescription, Encodeddate = DateTime.Now, Encodedby = prescDetails.Encodedby, ItemId = prescDetails.Itemid, Isapprovedrequired = prescDetails.Isapprovedrequired, Locationid = prescDetails.Locationid, ProviderId = prescDetails.Providerid, Patientid = prescDetails.Patientid, Genericid = prescDetails.Genericid, Strength = prescDetails.Strength, Startdate = prescDetails.Startdate, Refill = prescDetails.Refill, Statusid = _context.StatusMaster.Where(s => s.Statustype == "PrescriptionPosting" && s.Status == "Pending").Select(s => s.Statusid).FirstOrDefault(), PrescriptionDetail = prescDetails.Prescdetail, Prescriptionid = prescDetails.Prescriptionid, Qty = prescDetails.Qty, Strengthvalue = prescDetails.Strengthvalue, Dose = prescDetails.Dose, Durationtype = prescDetails.Durationtype, Medicationinstructions = prescDetails.Medicationinstructions, Formularyid = prescDetails.Formularyid, Doctorid = prescDetails.Doctorid, Dosetime = prescDetails.Dosetime, Issubstitutenotallowed = prescDetails.Issubstitutenotallowed, Isactive = true, }; _context.ConsultationPrescriptionDetails.Add(prescDetailObj); await _context.SaveChangesAsync(); return(true); } else { return(false); } }
public async Task <IActionResult> AddPrescriptionDetails([FromBody] FullPrescriptionDetailsDTO prescDetailsObj) { var prescDetailsCreated = await _pharmacyManagementRepository.AddPrescriptionDetails(prescDetailsObj); if (prescDetailsCreated) { return(NoContent()); } else { return(BadRequest()); } }