public Boolean insertDentalAdvice(OnlineOutPatientManagementSystem.UI.Prescription.clsDataTypes.PrescriptionGridDataInfo oPrescriptionDataInfo) { string queryString = "INSERT INTO [DentalAdvice] ([DenAdviceVisitID],[DenAdviceCode],[DenAdviceTeethNo]) " + "VALUES ('" + oPrescriptionDataInfo.strVisitID + "', '" + oPrescriptionDataInfo.strDenAdviceCode + "','" + oPrescriptionDataInfo.strDenAdviceTeethNo + "')"; return Convert.ToBoolean(executeQuery(queryString)); }
public Boolean insertConfirmDx(OnlineOutPatientManagementSystem.UI.Prescription.clsDataTypes.PrescriptionGridDataInfo oPrescriptionDataInfo) { string queryString = "INSERT INTO [ConfirmDx] ([VisitID],[ConfirmDxCode],[VisitDt]) " + "VALUES ('" + oPrescriptionDataInfo.strVisitID + "', '" + oPrescriptionDataInfo.strConfirmDxCode + "','" + oPrescriptionDataInfo.strVisitDt + "' )"; return Convert.ToBoolean(executeQuery(queryString)); }
public Boolean insertCheifComplainceInfo(OnlineOutPatientManagementSystem.UI.Prescription.clsDataTypes.PrescriptionGridDataInfo oPrescriptionDataInfo) { string queryString = "INSERT INTO [ChiefComplaince] ([VisitID],[CCCode], [DurationYY], [DurationMM],[DurationDD]) " + "VALUES ('" + oPrescriptionDataInfo.strVisitID + "', '" + oPrescriptionDataInfo.strCCCode + "', '" + oPrescriptionDataInfo.strYY + "','" + oPrescriptionDataInfo.strMM + "','" + oPrescriptionDataInfo.strDD + "' )"; return Convert.ToBoolean(executeQuery(queryString)); }
public static void SavePrescriptions(OnlineOutPatientManagementSystem.UI.Prescription.clsDataTypes.PrescriptionGenDataInfo oPrescriptionGenDataInfo) { ORM.OnLinePrescriptionDataContext oOPresDataContext = new ORM.OnLinePrescriptionDataContext(); ORM.ClinicVisitHistory oClinicVisitHistory = new ORM.ClinicVisitHistory(); //Basic Infp************************************ //int intMaxClnVisutId = oOPresDataContext.ClinicVisitHistories.Max(u => u.ClinicVisitID) + 1; oClinicVisitHistory.ClinicVisitID = oOPresDataContext.ClinicVisitHistories.Max(u => u.ClinicVisitID) + 1; oClinicVisitHistory.VisitDate = DateTime.Now; oClinicVisitHistory.PatientID = oPrescriptionGenDataInfo.strPatientID; oClinicVisitHistory.Relations = oPrescriptionGenDataInfo.strRelations; oClinicVisitHistory.PatientAge = oPrescriptionGenDataInfo.strPatientAge; oClinicVisitHistory.DrugHistory = oPrescriptionGenDataInfo.strDrugHistory; oClinicVisitHistory.DrugAllergy = oPrescriptionGenDataInfo.strDrugAllergy; //On examinatin Info****************************** oClinicVisitHistory.ExaAnemia = oPrescriptionGenDataInfo.strExaAnemia; oClinicVisitHistory.ExaJaundice = oPrescriptionGenDataInfo.strExaJaundice; oClinicVisitHistory.ExaClubbing = oPrescriptionGenDataInfo.strExaClubbing; oClinicVisitHistory.ExaOedema = oPrescriptionGenDataInfo.strExaOdema; oClinicVisitHistory.ExaL_N = oPrescriptionGenDataInfo.strExaL_N; oClinicVisitHistory.ExaHeart = oPrescriptionGenDataInfo.strExaHeart; oClinicVisitHistory.ExaLung = oPrescriptionGenDataInfo.strExaLung; oClinicVisitHistory.ExaLiver = oPrescriptionGenDataInfo.strExaLiver; oClinicVisitHistory.ExaSpleen = oPrescriptionGenDataInfo.strExaSpleen; oClinicVisitHistory.ExaOthers = oPrescriptionGenDataInfo.strExaOthers; //Blood Pressure oClinicVisitHistory.ExaSystolic = oPrescriptionGenDataInfo.strExaSystolic; oClinicVisitHistory.ExaDiastolic = oPrescriptionGenDataInfo.strExaDiastolic; oClinicVisitHistory.ExaSystolic = oPrescriptionGenDataInfo.strExaSystolic; oClinicVisitHistory.ExaDiastolic = oPrescriptionGenDataInfo.strExaDiastolic; oClinicVisitHistory.ExaPulse = oPrescriptionGenDataInfo.strExaPulse; oClinicVisitHistory.ExaTemp = oPrescriptionGenDataInfo.strExaTemp; oClinicVisitHistory.ExaWt = oPrescriptionGenDataInfo.strExaWt; oClinicVisitHistory.ExaVulva = oPrescriptionGenDataInfo.strExaVulva; oClinicVisitHistory.ExaVagina = oPrescriptionGenDataInfo.strExaVagina; oClinicVisitHistory.ExaOS = oPrescriptionGenDataInfo.strExaOS; oClinicVisitHistory.ExaCervix = oPrescriptionGenDataInfo.strExaCervix; //Other data oClinicVisitHistory.ReferredCode = oPrescriptionGenDataInfo.strReferredCode; //oClinicVisitHistory.Referred = oPrescriptionGenDataInfo.strReferred; oClinicVisitHistory.DoctorCode1 = oPrescriptionGenDataInfo.strDoctorCode1; //oPrescriptionGenDataInfo.strDoctorCode2; oClinicVisitHistory.DoctorCode2 = null; oClinicVisitHistory.NextVisitDt = null; oClinicVisitHistory.EntryDate = DateTime.Now; //Adds an entity in a pending insert state to this System.Data.Linq.Table<TEntity>and parameter is the entity which to be added oOPresDataContext.ClinicVisitHistories.InsertOnSubmit(oClinicVisitHistory); // executes the appropriate commands to implement the changes to the database oOPresDataContext.SubmitChanges(); }
public Boolean insertTreatmentx(OnlineOutPatientManagementSystem.UI.Prescription.clsDataTypes.PrescriptionGridDataInfo oPrescriptionDataInfo) { string queryString = @"INSERT INTO [MedicineDetails] ([VisitID],[MedicineCode],[MedVisitDt], [MedQty],[FrequencyCode],[TreatmentCode], [MedicinePrices],[MedDispuse],[MedReqQty],[MedDispuseDt]) " + "VALUES ('" + oPrescriptionDataInfo.strVisitID + "', '" + oPrescriptionDataInfo.strMedicineCode + "', "+ "'" + oPrescriptionDataInfo.strVisitDt + "', '" + oPrescriptionDataInfo.strMedQty + "'," + "'" + oPrescriptionDataInfo.strFrequencyCode + "', '" + oPrescriptionDataInfo.strTreatmentCode + "'," + "'" + oPrescriptionDataInfo.strMedicinePrices + "', '" + oPrescriptionDataInfo.strMedDispuse + "'," + "'" + oPrescriptionDataInfo.strMedReqQty + "','" + oPrescriptionDataInfo.strMedDispuseDt + "' )"; return Convert.ToBoolean(executeQuery(queryString)); }
public Boolean insertProvisionalDx(OnlineOutPatientManagementSystem.UI.Prescription.clsDataTypes.PrescriptionGridDataInfo oPrescriptionDataInfo) { string queryString = "INSERT INTO [ProvisionalDx] ([ProClinicVisitID],[ProvisionalCode]) " + "VALUES ('" + oPrescriptionDataInfo.strVisitID + "', '" + oPrescriptionDataInfo.strProvisionalCode + "' )"; return Convert.ToBoolean(executeQuery(queryString)); }
public Boolean insertNegativeFindings(OnlineOutPatientManagementSystem.UI.Prescription.clsDataTypes.PrescriptionGridDataInfo oPrescriptionDataInfo) { string queryString = "INSERT INTO [NegativeFindings] ([ClinicVisitID],[NegativeCode]) " + "VALUES ('" + oPrescriptionDataInfo.strVisitID + "', '" + oPrescriptionDataInfo.strNegativeCode + "')"; return Convert.ToBoolean(executeQuery(queryString)); }