public DataTable CreateFrequency(string FrequencyName, int UserId)
{
lock (this)
{
ClsObject FrequencyManager = new ClsObject();
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@FrequencyName", SqlDbType.VarChar, FrequencyName);
ClsUtility.AddParameters("@UserId", SqlDbType.Int, UserId.ToString());
return((DataTable)FrequencyManager.ReturnObject(ClsUtility.theParams, "pr_Admin_SaveDrugFrequency_Constella", ClsDBUtility.ObjectEnum.DataTable));
}
}
public DataSet GetFieldsforAdd(int Patient_ID)
{
lock (this)
{
ClsUtility.Init_Hashtable();
ClsObject HomeVisitManager = new ClsObject();
ClsUtility.AddParameters("@Patientid", SqlDbType.Int, Patient_ID.ToString());
ClsUtility.AddParameters("@password", SqlDbType.VarChar, ApplicationAccess.DBSecurity);
return((DataSet)HomeVisitManager.ReturnObject(ClsUtility.theParams, "pr_Scheduler_SelectHomeVisitfields_Constella", ClsUtility.ObjectEnum.DataSet));
}
}
public DataSet GetFacilityStatsExposedInfants(int LocationId)
{
lock (this)
{
ClsObject FacilityManager = new ClsObject();
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@LocationId", SqlDbType.Int, LocationId.ToString());
ClsUtility.AddParameters("@DBKey", SqlDbType.VarChar, ApplicationAccess.DBSecurity);
return((DataSet)FacilityManager.ReturnObject(ClsUtility.theParams, "pr_Security_facilitydetailsExposedInfants_constella", ClsDBUtility.ObjectEnum.DataSet));
}
}
/// <summary>
/// Gets the pharmacy prescription details.
/// </summary>
/// <param name="pharmacyId">The pharmacy identifier.</param>
/// <param name="patientId">The patient identifier.</param>
/// <param name="IQCareFlag">The iq care flag.</param>
/// <returns></returns>
public DataSet GetPharmacyPrescriptionDetails(int pharmacyId, int patientId, int IQCareFlag)
{
ClsObject PharmacyManager = new ClsObject();
ClsUtility.Init_Hashtable();
ClsUtility.AddExtendedParameters("@Ptn_Pharmacy_Pk", SqlDbType.Int, pharmacyId);
ClsUtility.AddExtendedParameters("@PatientId", SqlDbType.Int, patientId);
ClsUtility.AddParameters("@IQCareFlag", SqlDbType.Int, IQCareFlag.ToString());
// ClsUtility.AddParameters("@password", SqlDbType.VarChar, ApplicationAccess.DBSecurity);
return((DataSet)PharmacyManager.ReturnObject(ClsUtility.theParams, "pr_SCM_GetPharmacyPrescription_Futures", ClsUtility.ObjectEnum.DataSet));
}
public DataSet GetKNHPMTCTHEI(int patientID, int VisitID)
{
lock (this)
{
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@patientID", SqlDbType.Int, patientID.ToString());
ClsUtility.AddParameters("@VisitId", SqlDbType.Int, VisitID.ToString());
ClsObject UserManager = new ClsObject();
return((DataSet)UserManager.ReturnObject(ClsUtility.theParams, "pr_KNH_GetPMTCTHEIPatientData", ClsDBUtility.ObjectEnum.DataSet));
}
}
public DataSet GetFormModuleLinkDetail(Int32 ModuleId)
{
lock (this)
{
ClsObject BusinessRule = new ClsObject();
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@ModuleID", SqlDbType.VarChar, ModuleId.ToString());
return((DataSet)BusinessRule.ReturnObject(ClsUtility.theParams, "pr_FormBuilder_GetFormModuleLinkIdentifier_Futures", ClsUtility.ObjectEnum.DataSet));
}
}
public DataSet GetDesignationByID(int designationid)
{
lock (this)
{
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@designationid", SqlDbType.Int, designationid.ToString());
ClsObject DesignationManager = new ClsObject();
return((DataSet)DesignationManager.ReturnObject(ClsUtility.theParams, "pr_Admin_SelectDesignationByID_Constella", ClsUtility.ObjectEnum.DataSet));
}
}
public DataSet GetLinkedForms_FormLinking(int ModuleID, int FeatureID)
{
lock (this)
{
ClsObject PatientHistory = new ClsObject();
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@ModuleId", SqlDbType.Int, ModuleID.ToString());
ClsUtility.AddParameters("@FeatureId", SqlDbType.Int, FeatureID.ToString());
return((DataSet)PatientHistory.ReturnObject(ClsUtility.theParams, "pr_Clinical_GetLinkedForms_FormLinking", ClsUtility.ObjectEnum.DataSet));
}
}
public void ImportIQCareData(Int32 LocationId, string theFileName)
{
try
{
///Databases cannot be created in Transaction Mode. ///
ClsUtility.Init_Hashtable();
ClsObject theImportManager = new ClsObject();
theImportManager.ReturnObject(ClsUtility.theParams, "Pr_Admin_CreateExportDB_Futures", ClsUtility.ObjectEnum.ExecuteNonQuery);
///Restore DB-Cannot be in Transaction Mode///
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@FileName", SqlDbType.VarChar, theFileName);
theImportManager.ReturnObject(ClsUtility.theParams, "Pr_Admin_RestoreImportIQCareData_Futures", ClsUtility.ObjectEnum.ExecuteNonQuery);
this.Connection = DataMgr.GetConnection();
this.Transaction = DataMgr.BeginTransaction(this.Connection);
theImportManager.Connection = this.Connection;
theImportManager.Transaction = this.Transaction;
///Import IQCare Data///
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@Password", SqlDbType.VarChar, ApplicationAccess.DBSecurity.ToString());
theImportManager.ReturnObject(ClsUtility.theParams, "Pr_Admin_ImportIQCareData_Futures", ClsUtility.ObjectEnum.ExecuteNonQuery);
theImportManager.ReturnObject(ClsUtility.theParams, "Pr_Admin_ImportIQCareCustomFormData_Futures", ClsUtility.ObjectEnum.ExecuteNonQuery);
theImportManager.ReturnObject(ClsUtility.theParams, "Pr_Admin_ImportIQCareTransactionData_Futures", ClsUtility.ObjectEnum.ExecuteNonQuery);
ClsUtility.Init_Hashtable();
theImportManager.ReturnObject(ClsUtility.theParams, "Pr_Admin_ImportIQCareSupportData_Futures", ClsUtility.ObjectEnum.ExecuteNonQuery);
DataMgr.CommitTransaction(this.Transaction);
///Drop DB-Cannot be in Transaction Mode///
ClsUtility.Init_Hashtable();
theImportManager.ReturnObject(ClsUtility.theParams, "Pr_Admin_DropIQExportDB_Futures", ClsUtility.ObjectEnum.ExecuteNonQuery);
DataMgr.ReleaseConnection(this.Connection);
}
catch
{
if (this.Transaction != null)
{
DataMgr.RollBackTransation(this.Transaction);
}
throw;
}
finally
{
if (this.Connection != null)
{
DataMgr.ReleaseConnection(this.Connection);
}
}
}
public DataSet IQTouchGetPatientDetails(int PatientId)
{
lock (this)
{
ClsObject PatientManager = new ClsObject();
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@PatientId", SqlDbType.Int, PatientId.ToString());
ClsUtility.AddParameters("@DBKey", SqlDbType.VarChar, ApplicationAccess.DBSecurity);
return((DataSet)PatientManager.ReturnObject(ClsUtility.theParams, "pr_PASDP_PatientDetails", ClsUtility.ObjectEnum.DataSet));
}
}
public DataSet IQTouchGetPatientHistory(int PatientId)
{
lock (this)
{
ClsObject PatientHistory = new ClsObject();
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@PatientId", SqlDbType.Int, PatientId.ToString());
ClsUtility.AddParameters("@password", SqlDbType.VarChar, ApplicationAccess.DBSecurity);
return((DataSet)PatientHistory.ReturnObject(ClsUtility.theParams, "pr_IQTouchClinical_GetPatientHistory", ClsUtility.ObjectEnum.DataSet));
}
}
//public DataSet GetPatientDetailsCTC(string patientid, int VisitID)
//{
// ClsUtility.Init_Hashtable();
// ClsUtility.AddParameters("@patientid", SqlDbType.Int, patientid.ToString());
// ClsUtility.AddParameters("@visitID", SqlDbType.Int, VisitID.ToString());
// ClsUtility.AddParameters("@password", SqlDbType.VarChar, ApplicationAccess.DBSecurity);
// ClsObject UserManager = new ClsObject();
// return (DataSet)UserManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_PatientDetailsCTC_Constella", ClsUtility.ObjectEnum.DataSet);
//}
public DataTable GetPatientDebitNoteSummary(int PatientID)
{
lock (this)
{
ClsObject PatientVisitMgr = new ClsObject();
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@PatientId", SqlDbType.Int, PatientID.ToString());
return((DataTable)PatientVisitMgr.ReturnObject(ClsUtility.theParams, "Pr_Clinical_GetPatientDebitNoteSummary_Futures", ClsUtility.ObjectEnum.DataTable));
}
}
public DataSet ReActivatePatient(int PatientId, Int32 ModId)
{
lock (this)
{
ClsObject ReActivatePtnMgr = new ClsObject();
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@PatientId", SqlDbType.Int, PatientId.ToString());
ClsUtility.AddParameters("@Mod", SqlDbType.Int, ModId.ToString());
return((DataSet)ReActivatePtnMgr.ReturnObject(ClsUtility.theParams, "pr_Clinical_ReActivatePatient_Constella", ClsUtility.ObjectEnum.DataSet));
}
}
public DataTable CreateSchedule(string ScheduleName, int UserId)
{
lock (this)
{
ClsObject ScheduleManager = new ClsObject();
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@ScheduleName", SqlDbType.VarChar, ScheduleName);
ClsUtility.AddParameters("@UserId", SqlDbType.Int, UserId.ToString());
return((DataTable)ScheduleManager.ReturnObject(ClsUtility.theParams, "pr_Admin_SaveDrugSchedule_Futures", ClsDBUtility.ObjectEnum.DataTable));
}
}
/// <summary>
/// Gets the appointment reasons.
/// </summary>
/// <param name="Id">The identifier.</param>
/// <returns></returns>
public DataSet GetAppointmentReasons(int Id)
{
lock (this)
{
ClsUtility.Init_Hashtable();
ClsObject AppointmentReasons = new ClsObject();
ClsUtility.AddParameters("@Id", SqlDbType.Int, Id.ToString());
return((DataSet)AppointmentReasons.ReturnObject(ClsUtility.theParams, "pr_Scheduler_SelectAppReason_Constella", ClsUtility.ObjectEnum.DataSet));
}
}
public DataSet GetEmployees(int Id)
{
lock (this)
{
ClsUtility.Init_Hashtable();
ClsObject Employees = new ClsObject();
ClsUtility.AddParameters("@Id", SqlDbType.Int, Id.ToString());
return((DataSet)Employees.ReturnObject(ClsUtility.theParams, "pr_Admin_GetEmployeeDetails_Constella", ClsDBUtility.ObjectEnum.DataSet));
}
}
public DataSet GetPatientInfo(string patientid)
{
lock (this)
{
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@patientid", SqlDbType.VarChar, patientid.ToString());
ClsUtility.AddParameters("@password", SqlDbType.VarChar, ApplicationAccess.DBSecurity);
ClsObject UserManager = new ClsObject();
return((DataSet)UserManager.ReturnObject(ClsUtility.theParams, "pr_Laboratory_GetPatientInfo_Constella", ClsUtility.ObjectEnum.DataSet));
}
}
public int SaveNewSection(string SectionName, int UserID)
{
try
{
this.Connection = DataMgr.GetConnection();
this.Transaction = DataMgr.BeginTransaction(this.Connection);
ClsObject SectionManager = new ClsObject();
SectionManager.Connection = this.Connection;
SectionManager.Transaction = this.Transaction;
oUtility.Init_Hashtable();
oUtility.AddParameters("@SectionName", SqlDbType.VarChar, SectionName);
oUtility.AddParameters("@UserId", SqlDbType.Int, UserID.ToString());
DataRow theDR;
theDR = (DataRow)SectionManager.ReturnObject(oUtility.theParams, "Pr_Admin_InsertSection_Constella", ClsUtility.ObjectEnum.DataRow);
if (Convert.ToInt32(theDR[0]) == 0)
{
MsgBuilder theBL = new MsgBuilder();
theBL.DataElements["MessageText"] = "Error in Saving Section record. Try Again..";
AppException.Create("#C1", theBL);
}
DataMgr.CommitTransaction(this.Transaction);
DataMgr.ReleaseConnection(this.Connection);
return(Convert.ToInt32(theDR[0]));
}
catch
{
throw;
}
finally
{
if (this.Connection != null)
{
DataMgr.ReleaseConnection(this.Connection);
}
}
}
public DataSet GetUserCredentials(string UserName, int LocationId, int SystemId)
{
lock (this)
{
ClsObject LoginManager = new ClsObject();
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@LoginName", SqlDbType.VarChar, UserName);
ClsUtility.AddParameters("@LocationId", SqlDbType.Int, LocationId.ToString());
ClsUtility.AddParameters("@SystemId", SqlDbType.Int, SystemId.ToString());
return((DataSet)LoginManager.ReturnObject(ClsUtility.theParams, "Pr_Security_UserLogin_Constella", ClsUtility.ObjectEnum.DataSet));
}
}
public DataSet GetFollowUpARTupdate(int patientID, int VisitID, int LocationID)
{
lock (this)
{
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@patientID", SqlDbType.Int, patientID.ToString());
ClsUtility.AddParameters("@VisitID", SqlDbType.Int, VisitID.ToString());
ClsUtility.AddParameters("@LocationID", SqlDbType.Int, LocationID.ToString());
ClsObject UserManager = new ClsObject();
return((DataSet)UserManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_GetFollowUpARTUpdate_Constella", ClsUtility.ObjectEnum.DataSet));
}
}
public DataSet GetPatient_No_Of_VisitDate(int patientid, DateTime visitdate, int visittype)
{
lock (this)
{
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@patientID", SqlDbType.Int, patientid.ToString());
ClsUtility.AddParameters("@HIVvisitdate", SqlDbType.Int, visitdate.ToString());
ClsUtility.AddParameters("@visittype", SqlDbType.Int, visittype.ToString());
ClsObject IEManager = new ClsObject();
return((DataSet)IEManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_GetPatient_No_of_VisitDateConstella", ClsUtility.ObjectEnum.DataSet));
}
}
public DataTable GetCustomFieldList(Int32 SystemId, Int32 FacilityId)
{
ClsObject CustomManager = new ClsObject();
lock (this)
{
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@SystemId", SqlDbType.Int, SystemId.ToString());
ClsUtility.AddParameters("@FacilityId", SqlDbType.Int, FacilityId.ToString());
return((DataTable)CustomManager.ReturnObject(ClsUtility.theParams, "pr_Admin_GetCustomFieldList_Constella", ClsUtility.ObjectEnum.DataTable));
}
}
public DataSet GetVillage(int Ward, int SystemID)
{
ClsObject CustomManager = new ClsObject();
lock (this)
{
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@Ward", SqlDbType.Int, Ward.ToString());
ClsUtility.AddParameters("@SystemId", SqlDbType.Int, SystemID.ToString());
return((DataSet)CustomManager.ReturnObject(ClsUtility.theParams, "Pr_Admin_GetWardVillage_Constella", ClsUtility.ObjectEnum.DataSet));
}
}
public DataSet GetDistric(int RegionID, int SystemID)
{
ClsObject CustomManager = new ClsObject();
lock (this)
{
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@RegionID", SqlDbType.Int, RegionID.ToString());
ClsUtility.AddParameters("@SystemId", SqlDbType.Int, SystemID.ToString());
return((DataSet)CustomManager.ReturnObject(ClsUtility.theParams, "Pr_Admin_GetRegionDistric_Constella", ClsUtility.ObjectEnum.DataSet));
}
}
public DataTable GetCustomMasterNonSelectedRecord(string TableName)
{
TableName = "lnk_" + TableName;
ClsObject CustomManager = new ClsObject();
lock (this)
{
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@TableName", SqlDbType.VarChar, TableName);
return((DataTable)CustomManager.ReturnObject(ClsUtility.theParams, "pr_Admin_GetCustomMasterLinkSelectedRecord_Constella", ClsUtility.ObjectEnum.DataTable));
}
}
public int DeleteBudgetConfigDetails(int BudgetConfigID, int DeleteFlag, int UserId)
{
ClsObject ItemList = new ClsObject();
int theRowAffected = 0;
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@BudgetConfigID", SqlDbType.Int, BudgetConfigID.ToString());
ClsUtility.AddParameters("@DeleteFlag", SqlDbType.Int, DeleteFlag.ToString());
ClsUtility.AddParameters("@UserId", SqlDbType.Int, UserId.ToString());
theRowAffected = (int)ItemList.ReturnObject(ClsUtility.theParams, "pr_SCM_DeleteBudgetConfigDetail", ClsDBUtility.ObjectEnum.ExecuteNonQuery);
return(theRowAffected);
}
public int DeleteExposedInfantById(int Id)
{
lock (this)
{
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@Id", SqlDbType.Int, Id.ToString());
ClsObject VisitManager = new ClsObject();
int theRowAffected = 0;
theRowAffected = (int)VisitManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_DeleteExposedInfantById", ClsUtility.ObjectEnum.ExecuteNonQuery);
return(theRowAffected);
}
}
public DataTable GetCareEndedNos(int Patient_ID, DateTime LastcontactDate, int flagcontactdate)
{
lock (this)
{
ClsUtility.Init_Hashtable();
ClsObject CareManager = new ClsObject();
ClsUtility.AddParameters("@patientID", SqlDbType.Int, Patient_ID.ToString());
ClsUtility.AddParameters("@contactDate", SqlDbType.DateTime, LastcontactDate.ToString());
ClsUtility.AddParameters("@flag", SqlDbType.Int, flagcontactdate.ToString());
return((DataTable)CareManager.ReturnObject(ClsUtility.theParams, "pr_Scheduler_NoofCareEnded_onDate_Constella", ClsDBUtility.ObjectEnum.DataTable));
}
}
public DataSet GetFormDetail(string strFormStatus, string strTechArea, Int32 CountryId)
{
lock (this)
{
ClsObject FormDetail = new ClsObject();
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@FormStatus", SqlDbType.VarChar, strFormStatus);
ClsUtility.AddParameters("@TechArea", SqlDbType.VarChar, strTechArea);
ClsUtility.AddParameters("@CountryId", SqlDbType.VarChar, CountryId.ToString());
return((DataSet)FormDetail.ReturnObject(ClsUtility.theParams, "Pr_ManageForm_GetFormDetail_Futures", ClsDBUtility.ObjectEnum.DataSet));
}
}
public DataTable searchPatientsRegistered(string fname, string mname, string lname, string patientId)
{
ClsObject PharmacyManager = new ClsObject();
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@fname", SqlDbType.VarChar, fname);
ClsUtility.AddParameters("@mname", SqlDbType.VarChar, mname);
ClsUtility.AddParameters("@lname", SqlDbType.VarChar, lname);
ClsUtility.AddParameters("@patientid", SqlDbType.VarChar, patientId);
return((DataTable)PharmacyManager.ReturnObject(ClsUtility.theParams, "Pharmacy_SearchAllRegisteredPatients", ClsUtility.ObjectEnum.DataTable));
}