///<summary>
/// Method Invocation of wrapper classes
///<summary>
protected static FR_L6AC_GA_1738 Invoke(DbConnection Connection, DbTransaction Transaction, string ConnectionString, P_L6AC_GA_1738 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
bool cleanupConnection = Connection == null;
bool cleanupTransaction = Transaction == null;
FR_L6AC_GA_1738 functionReturn = new FR_L6AC_GA_1738();
try
{
if (cleanupConnection == true)
{
Connection = CSV2Core_MySQL.Support.DBSQLSupport.CreateConnection(ConnectionString);
Connection.Open();
}
if (cleanupTransaction == true)
{
Transaction = Connection.BeginTransaction();
}
functionReturn = Execute(Connection, Transaction, Parameter, securityTicket);
#region Cleanup Connection/Transaction
//Commit the transaction
if (cleanupTransaction == true)
{
Transaction.Commit();
}
//Close the connection
if (cleanupConnection == true)
{
Connection.Close();
}
#endregion
}
catch (Exception ex)
{
try
{
if (cleanupTransaction == true && Transaction != null)
{
Transaction.Rollback();
}
}
catch { }
try
{
if (cleanupConnection == true && Connection != null)
{
Connection.Close();
}
}
catch { }
throw new Exception("Exception occured in method cls_Get_AftercareData", ex);
}
return(functionReturn);
}
protected static FR_L6AC_GA_1738 Execute(DbConnection Connection, DbTransaction Transaction, P_L6AC_GA_1738 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L6AC_GA_1738();
L6AC_GA_1738 Data = new L6AC_GA_1738();
List <L6AC_GA_1738_Aftercare> Aftercares = new List <L6AC_GA_1738_Aftercare>();
int IsBilled = Parameter.SearchParameters.s_isBilled == true ? 1 : 0;
int IsPerformed = Parameter.SearchParameters.s_isPerformed == true ? 1 : 0;
int IsSheduled = Parameter.SearchParameters.s_isScheduled == true ? 1 : 0;
/*@Get Total_Record_Count,
*------------------------------------------------*/
Data.page_size = Parameter.NumberOfElementsPerPage;
Data.current_page = Parameter.PageClicked;
if (Parameter.SearchParameters.s_patientFirstName == "" && Parameter.SearchParameters.s_patientLastName == "" &&
Parameter.SearchParameters.s_healtInsurance == "" && Parameter.SearchParameters.s_doctorFirstName == "" &&
Parameter.SearchParameters.s_doctorLastName == "")
{
#region
P_L5AF_GAC_1132 count_param = new P_L5AF_GAC_1132();
count_param.S_Practice = SearchMethods.getPracticeParameter(Parameter.SearchParameters.s_practice);
count_param.statusParameters = SearchMethods.getStatusParameter(IsBilled, IsPerformed, IsSheduled, Parameter.SearchParameters.s_aftercareFrom, Parameter.SearchParameters.s_aftercareTo);
count_param.s_doctorParam = "";
count_param.s_scheduled_doctorParam = "";
var recordCount = cls_Get_AftercareCount.Invoke(Connection, Transaction, count_param, securityTicket).Result.total_record_count;
Data.total_record_count = recordCount;
Data.total_page_count = (recordCount + Parameter.NumberOfElementsPerPage - 1) / Parameter.NumberOfElementsPerPage;
var startRowIndex = (Parameter.PageClicked - 1) * Parameter.NumberOfElementsPerPage;
Data.start_row_index = startRowIndex;
Data.end_row_index = startRowIndex + Data.page_size > recordCount ? recordCount : startRowIndex + Data.page_size;
/*@Get Aftercares
*------------------------------------------------*/
P_L5AF_GABD_1107 par = new P_L5AF_GABD_1107();
if (Parameter.IsASC_Order == false)
{
par.OrderBy = "DESC";
}
else
{
par.OrderBy = "ASC";
}
par.OrderValue = Parameter.OrderValue;
par.StartIndex = startRowIndex;
par.NumberOfElements = Parameter.NumberOfElementsPerPage;
par.S_Practice = count_param.S_Practice;
par.statusParameters = count_param.statusParameters;
par.s_doctorParam = count_param.s_doctorParam;
par.s_scheduled_doctorParam = count_param.s_scheduled_doctorParam;
var aftercareBaseData = cls_Get_AftercareBaseData.Invoke(Connection, Transaction, par, securityTicket).Result.ToList();
foreach (var item in aftercareBaseData)
{
P_L5AF_GADFFIDATID_1307 parameter = new P_L5AF_GADFFIDATID_1307();
parameter.FollowupID = item.FollowupID;
parameter.TreatmentID = item.TreatmentID;
L6AC_GA_1738_Aftercare aftercare = new L6AC_GA_1738_Aftercare();
aftercare.id = item.FollowupID.ToString();
aftercare.practice = item.Practice;
if (item.IsTreatmentBilled)
{
aftercare.status = "billed";
aftercare.status_date = item.IfTreatmentBilled_Date;
}
else if (item.IsTreatmentPerformed)
{
aftercare.status = "performed";
aftercare.status_date = item.IfTreatmentPerformed_Date;
}
else
{
aftercare.status = "sheduled";
aftercare.status_date = item.IfSheduled_Date;
aftercare.doctor = item.SheduledDoctorTitle + " " + item.SheduledDoctorFirstName + " " + item.SheduledDoctorLastName;
}
if (item.IsTreatmentPerformed)
{
aftercare.doctor = item.PerformedDoctorTitle + " " + item.PerformedDoctorFirstName + " " + item.PerformedDoctorLastName;
}
aftercare.status_name = aftercare.status;
var otherPartData = cls_Get_AftercareData_for_FollowupID_and_TenantID.Invoke(Connection, Transaction, parameter, securityTicket).Result;
if (otherPartData == null)
{
continue;
}
aftercare.patient_name = otherPartData.PatientFirstName + " " + otherPartData.PatientLastName;
aftercare.health_insurance = otherPartData.HealthInsurance;
aftercare.treatment_date = otherPartData.TreatmentDate;
Aftercares.Add(aftercare);
}
#endregion
}
else if (Parameter.SearchParameters.s_doctorFirstName != "" || Parameter.SearchParameters.s_doctorLastName != "")
{
#region
P_L5AF_GAACFDS_1252 count_param = new P_L5AF_GAACFDS_1252();
count_param.S_Practice = SearchMethods.getPracticeParameter(Parameter.SearchParameters.s_practice);
count_param.statusParameters = SearchMethods.getStatusParameter(IsBilled, IsPerformed, IsSheduled, Parameter.SearchParameters.s_aftercareFrom, Parameter.SearchParameters.s_aftercareTo);
count_param.s_Patient = SearchMethods.getPatientParameter(Parameter.SearchParameters.s_patientFirstName, Parameter.SearchParameters.s_patientLastName);
count_param.s_HealthInsurance = SearchMethods.getPracticeParameter(Parameter.SearchParameters.s_healtInsurance);
count_param.s_doctorParam = SearchMethods.getPerformedDoctorParameter(Parameter.SearchParameters.s_doctorFirstName, Parameter.SearchParameters.s_doctorLastName);
count_param.s_scheduled_doctorParam = SearchMethods.getScheduledDoctorParameter(Parameter.SearchParameters.s_doctorFirstName, Parameter.SearchParameters.s_doctorLastName);
var recordCount = cls_Get_AftercareAllCount_for_doctorSearch.Invoke(Connection, Transaction, count_param, securityTicket).Result.total_record_count;
Data.total_record_count = recordCount;
Data.total_page_count = (recordCount + Parameter.NumberOfElementsPerPage - 1) / Parameter.NumberOfElementsPerPage;
var startRowIndex = (Parameter.PageClicked - 1) * Parameter.NumberOfElementsPerPage;
Data.start_row_index = startRowIndex;
Data.end_row_index = startRowIndex + Data.page_size > recordCount ? recordCount : startRowIndex + Data.page_size;
/*@Get Aftercares
*------------------------------------------------*/
P_L5AF_GAADFDS_1107 par = new P_L5AF_GAADFDS_1107();
if (Parameter.IsASC_Order == false)
{
par.OrderBy = "DESC";
}
else
{
par.OrderBy = "ASC";
}
par.OrderValue = Parameter.OrderValue;
par.StartIndex = startRowIndex;
par.NumberOfElements = Parameter.NumberOfElementsPerPage;
par.S_Practice = count_param.S_Practice;
par.statusParameters = count_param.statusParameters;
par.s_Patient = count_param.s_Patient;
par.s_HealthInsurance = count_param.s_HealthInsurance;
par.s_doctorParam = count_param.s_doctorParam;
par.s_scheduled_doctorParam = count_param.s_scheduled_doctorParam;
var aftercareData = cls_Get_AftercareAllData_for_doctorSearch.Invoke(Connection, Transaction, par, securityTicket).Result.ToList();
foreach (var item in aftercareData)
{
L6AC_GA_1738_Aftercare aftercare = new L6AC_GA_1738_Aftercare();
aftercare.id = item.FollowupID.ToString();
aftercare.practice = item.Practice;
if (item.IsTreatmentBilled)
{
aftercare.status = "billed";
}
else if (item.IsTreatmentPerformed)
{
aftercare.status = "performed";
}
else
{
aftercare.status = "sheduled";
aftercare.doctor = item.SheduledDoctorTitle + " " + item.SheduledDoctorFirstName + " " + item.SheduledDoctorLastName;
}
aftercare.status_date = item.FolllowupDate;
if (item.IsTreatmentPerformed)
{
aftercare.doctor = item.PerformedDoctorTitle + " " + item.PerformedDoctorFirstName + " " + item.PerformedDoctorLastName;
}
aftercare.status_name = aftercare.status;
aftercare.patient_name = item.PatientFirstName + " " + item.PatientLastName;
aftercare.health_insurance = item.HealthInsurance;
aftercare.treatment_date = item.TreatmentDate;
Aftercares.Add(aftercare);
}
#endregion
}
else
{
#region
P_L5AF_GAAC_1732 count_param = new P_L5AF_GAAC_1732();
count_param.S_Practice = SearchMethods.getPracticeParameter(Parameter.SearchParameters.s_practice);
count_param.statusParameters = SearchMethods.getStatusParameter(IsBilled, IsPerformed, IsSheduled, Parameter.SearchParameters.s_aftercareFrom, Parameter.SearchParameters.s_aftercareTo);
count_param.s_Patient = SearchMethods.getPatientParameter(Parameter.SearchParameters.s_patientFirstName, Parameter.SearchParameters.s_patientLastName);
count_param.s_HealthInsurance = SearchMethods.getPracticeParameter(Parameter.SearchParameters.s_healtInsurance);
// count_param.s_doctorParam = SearchMethods.getPerformedDoctorParameter(Parameter.SearchParameters.s_doctorFirstName, Parameter.SearchParameters.s_doctorLastName);
// count_param.s_scheduled_doctorParam = SearchMethods.getScheduledDoctorParameter(Parameter.SearchParameters.s_doctorFirstName, Parameter.SearchParameters.s_doctorLastName);
count_param.s_doctorParam = "";
count_param.s_scheduled_doctorParam = "";
var recordCount = cls_Get_AftercareAllCount.Invoke(Connection, Transaction, count_param, securityTicket).Result.total_record_count;
Data.total_record_count = recordCount;
Data.total_page_count = (recordCount + Parameter.NumberOfElementsPerPage - 1) / Parameter.NumberOfElementsPerPage;
var startRowIndex = (Parameter.PageClicked - 1) * Parameter.NumberOfElementsPerPage;
Data.start_row_index = startRowIndex;
Data.end_row_index = startRowIndex + Data.page_size > recordCount ? recordCount : startRowIndex + Data.page_size;
/*@Get Aftercares
*------------------------------------------------*/
P_L5AF_GAAD_1607 par = new P_L5AF_GAAD_1607();
if (Parameter.IsASC_Order == false)
{
par.OrderBy = "DESC";
}
else
{
par.OrderBy = "ASC";
}
par.OrderValue = Parameter.OrderValue;
par.StartIndex = startRowIndex;
par.NumberOfElements = Parameter.NumberOfElementsPerPage;
par.S_Practice = count_param.S_Practice;
par.statusParameters = count_param.statusParameters;
par.s_Patient = count_param.s_Patient;
par.s_HealthInsurance = count_param.s_HealthInsurance;
par.s_doctorParam = count_param.s_doctorParam;
par.s_scheduled_doctorParam = count_param.s_scheduled_doctorParam;
var aftercareData = cls_Get_AftercareAllData.Invoke(Connection, Transaction, par, securityTicket).Result.ToList();
foreach (var item in aftercareData)
{
L6AC_GA_1738_Aftercare aftercare = new L6AC_GA_1738_Aftercare();
aftercare.id = item.FollowupID.ToString();
aftercare.practice = item.Practice;
if (item.IsTreatmentBilled)
{
aftercare.status = "billed";
}
else if (item.IsTreatmentPerformed)
{
aftercare.status = "performed";
}
else
{
aftercare.status = "sheduled";
aftercare.doctor = item.SheduledDoctorTitle + " " + item.SheduledDoctorFirstName + " " + item.SheduledDoctorLastName;
}
aftercare.status_date = item.FolllowupDate;
if (item.IsTreatmentPerformed)
{
aftercare.doctor = item.PerformedDoctorTitle + " " + item.PerformedDoctorFirstName + " " + item.PerformedDoctorLastName;
}
aftercare.status_name = aftercare.status;
aftercare.patient_name = item.PatientFirstName + " " + item.PatientLastName;
aftercare.health_insurance = item.HealthInsurance;
aftercare.treatment_date = item.TreatmentDate;
Aftercares.Add(aftercare);
}
#endregion
}
Data.aftercares = Aftercares.ToArray();
returnValue.Result = Data;
return(returnValue);
#endregion UserCode
}
