public DataSet Dental_SavePatientCaseSheet(IPatientAdultMainScreen patientAdultMain)
{
dataSet = new DataSet();
_storedProcedure = "Dental_SavePatientCaseSheet";
_parameters = new SqlParameter[11];
_parameters[0] = new SqlParameter("@DentalAdultMainId", SqlDbType.BigInt);
_parameters[0].Value = patientAdultMain.DentalAdultMainId;
_parameters[1] = new SqlParameter("@Temperature", SqlDbType.NVarChar);
_parameters[1].Value = patientAdultMain.Temperature;
_parameters[2] = new SqlParameter("@RespiratoryRate", SqlDbType.NVarChar);
_parameters[2].Value = patientAdultMain.RespiratoryRate;
_parameters[3] = new SqlParameter("@PulseRate", SqlDbType.NVarChar);
_parameters[3].Value = patientAdultMain.PulseRate;
_parameters[4] = new SqlParameter("@FamilyHistory", SqlDbType.NVarChar);
_parameters[4].Value = patientAdultMain.FamilyHistory;
_parameters[5] = new SqlParameter("@SocialHistory", SqlDbType.NVarChar);
_parameters[5].Value = patientAdultMain.SocialHistory;
_parameters[6] = new SqlParameter("@MedicalHistory", SqlDbType.NVarChar);
_parameters[6].Value = patientAdultMain.MedicalHistory;
_parameters[7] = new SqlParameter("@DentalHistory", SqlDbType.NVarChar);
_parameters[7].Value = patientAdultMain.DentalHistory;
_parameters[8] = new SqlParameter("@HistoryOfIllness", SqlDbType.NVarChar);
_parameters[8].Value = patientAdultMain.HistoryOfIllness;
_parameters[9] = new SqlParameter("@CaseChiefComplaint", SqlDbType.NVarChar);
_parameters[9].Value = patientAdultMain.CaseChiefComplaint;
_parameters[10] = new SqlParameter("@BloodPressure", SqlDbType.NVarChar);
_parameters[10].Value = patientAdultMain.BloodPressure;
dataSet = RunProcedure(_storedProcedure, _parameters, true);
return(dataSet);
}
public DataSet Dental_ApproveTreatmentPlan(IPatientAdultMainScreen patientAdultMainScreen)
{
dataSet = new DataSet();
_storedProcedure = "Dental_ApproveTreatmentPlan";
_parameters = new SqlParameter[3];
_parameters[0] = new SqlParameter("@DentalAdultMainId", SqlDbType.BigInt);
_parameters[0].Value = Convert.ToInt64(patientAdultMainScreen.DentalAdultMainId);
_parameters[1] = new SqlParameter("@ApprovedStatus", SqlDbType.NVarChar);
_parameters[1].Value = patientAdultMainScreen.TreatmentPlanApprovedStatus;
_parameters[2] = new SqlParameter("@TreatmentPlanComments", SqlDbType.NVarChar);
_parameters[2].Value = patientAdultMainScreen.TreatmentPlanComments;
dataSet = RunProcedure(_storedProcedure, _parameters, true);
return(dataSet);
}
public DataSet Dental_SendforCaseStudy(IPatientAdultMainScreen patientAdultMainScreen)
{
dataSet = new DataSet();
_storedProcedure = "Dental_SendforCaseStudy";
_parameters = new SqlParameter[3];
_parameters[0] = new SqlParameter("@DentalAdultMainId", SqlDbType.BigInt);
_parameters[0].Value = Convert.ToInt64(patientAdultMainScreen.DentalAdultMainId);
_parameters[1] = new SqlParameter("@Status", SqlDbType.Bit);
_parameters[1].Value = Convert.ToBoolean(patientAdultMainScreen.IsSentforCaseStudy);
_parameters[2] = new SqlParameter("@CaseAssignedStudentId", SqlDbType.BigInt);
_parameters[2].Value = Convert.ToInt64(patientAdultMainScreen.CaseAssignedStudentId);
dataSet = RunProcedure(_storedProcedure, _parameters, true);
return(dataSet);
}
//public DataSet GetAdultMainScreeningData(int patientId, int? clinicId, string patientMobile, int? doctorTreatmentId, int? dentalMainId)
//{
// _storedProcedure = "GetAdultMainScreeningData";
// _parameters = new SqlParameter[5];
// _parameters[0] = new SqlParameter("@PatientId", SqlDbType.Int);
// _parameters[0].Value = patientId;
// _parameters[1] = new SqlParameter("@ClinicIdRef", SqlDbType.Int);
// _parameters[1].Value = clinicId;
// _parameters[2] = new SqlParameter("@PatientMobile", SqlDbType.NVarChar);
// _parameters[2].Value = patientMobile;
// _parameters[3] = new SqlParameter("@DoctorTreatmentId", SqlDbType.BigInt);
// _parameters[3].Value = doctorTreatmentId;
// _parameters[4] = new SqlParameter("@DentalMainId", SqlDbType.BigInt);
// _parameters[4].Value = dentalMainId;
// return RunProcedure(_storedProcedure, _parameters, true);
//}
public DataSet Dental_SavePatientHistory(IPatientAdultMainScreen patientAdultMain)
{
dataSet = new DataSet();
_storedProcedure = "Dental_SavePatientHistory";
_parameters = new SqlParameter[5];
_parameters[0] = new SqlParameter("@DentalAdultMainId", SqlDbType.BigInt);
_parameters[0].Value = patientAdultMain.DentalAdultMainId;
_parameters[1] = new SqlParameter("@IsPatientTreatedPreviously", SqlDbType.Bit);
_parameters[1].Value = patientAdultMain.IsPatientTreatedPreviously;
_parameters[2] = new SqlParameter("@DetailsHistoryTreatment", SqlDbType.NVarChar);
_parameters[2].Value = patientAdultMain.DetailsHistoryTreatment;
_parameters[3] = new SqlParameter("@IsPatientHaveMedicalCondition", SqlDbType.Bit);
_parameters[3].Value = patientAdultMain.IsPatientHaveMedicalCondition;
_parameters[4] = new SqlParameter("@MedicalConditionDetails", SqlDbType.NVarChar);
_parameters[4].Value = patientAdultMain.MedicalConditionDetails;
dataSet = RunProcedure(_storedProcedure, _parameters, true);
return(dataSet);
}
public DataSet SaveDentalAdultMain(IPatientAdultMainScreen patient)
{
try
{
dataSet = new DataSet();
_storedProcedure = "SaveDentalAdultMain";
_parameters = new SqlParameter[13];
_parameters[0] = new SqlParameter("@DentalAdultMainId", SqlDbType.BigInt);
_parameters[0].Value = patient.DentalAdultMainId;
_parameters[1] = new SqlParameter("@PatientId", SqlDbType.BigInt);
_parameters[1].Value = patient.PatientId;
_parameters[2] = new SqlParameter("@ClinicRefId", SqlDbType.BigInt);
_parameters[2].Value = patient.ClinicId;
_parameters[3] = new SqlParameter("@VisitRegisterId", SqlDbType.BigInt);
_parameters[3].Value = patient.VisitRegisterId;
_parameters[4] = new SqlParameter("@DoctorTreatmentId", SqlDbType.BigInt);
_parameters[4].Value = patient.DoctorTreatmentId;
_parameters[5] = new SqlParameter("@DoctorAssignedTo", SqlDbType.BigInt);
_parameters[5].Value = patient.DoctorAssignedTo;
_parameters[6] = new SqlParameter("@Comments", SqlDbType.NVarChar);
_parameters[6].Value = patient.Comments;
_parameters[7] = new SqlParameter("@IssueDate", SqlDbType.DateTime);
_parameters[7].Value = patient.IssueDate;
_parameters[8] = new SqlParameter("@UpdatedBy", SqlDbType.BigInt);
_parameters[8].Value = patient.UpdatedBy;
_parameters[9] = new SqlParameter("@DocumentBookIdRef", SqlDbType.BigInt);
_parameters[9].Value = patient.DocumentBookId;
_parameters[10] = new SqlParameter("@DocumentTypeIdRef", SqlDbType.BigInt);
_parameters[10].Value = patient.DocumentTypeId;
_parameters[11] = new SqlParameter("@IsAdult", SqlDbType.Bit);
_parameters[11].Value = patient.IsAdult;
_parameters[12] = new SqlParameter("@TblTeethSectionNotationMappingType", SqlDbType.Structured);
_parameters[12].Value = patient.TeethSectionNotationMappingDT;
dataSet = RunProcedure(_storedProcedure, _parameters, true);
return(dataSet);
}
catch (System.Exception)
{
throw;
}
}
public DataSet Dental_SavePatientLabReport(IPatientAdultMainScreen patientAdultMainScreen)
{
dataSet = new DataSet();
_storedProcedure = "Dental_SavePatientLabReport";
_parameters = new SqlParameter[7];
_parameters[0] = new SqlParameter("@DentalLabReportId", SqlDbType.BigInt);
_parameters[0].Value = patientAdultMainScreen.DentalAdultMainId;
_parameters[1] = new SqlParameter("@DentalAdultMainId", SqlDbType.BigInt);
_parameters[1].Value = patientAdultMainScreen.ApprovedStatus;
_parameters[2] = new SqlParameter("@LabReportRequestId", SqlDbType.VarChar);
_parameters[2].Value = patientAdultMainScreen.ApprovedStatus;
_parameters[3] = new SqlParameter("@ReportTypeId", SqlDbType.Int);
_parameters[3].Value = patientAdultMainScreen.ApprovedStatus;
_parameters[4] = new SqlParameter("@PreferredLabId", SqlDbType.Int);
_parameters[4].Value = patientAdultMainScreen.ApprovedStatus;
_parameters[5] = new SqlParameter("@Comments", SqlDbType.NVarChar);
_parameters[5].Value = patientAdultMainScreen.ApprovedStatus;
_parameters[6] = new SqlParameter("@UpdatedBy", SqlDbType.BigInt);
_parameters[6].Value = patientAdultMainScreen.ApprovedStatus;
dataSet = RunProcedure(_storedProcedure, _parameters, true);
return(dataSet);
}
