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));
}
