public DataSet GetSystemBasedLabels(int SystemId, int FeatureId, int ModuleId)
{
lock (this)
{
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@SystemId", SqlDbType.Int, SystemId.ToString());
ClsUtility.AddParameters("@FeatureId", SqlDbType.Int, FeatureId.ToString());
ClsUtility.AddParameters("@ModuleId", SqlDbType.Int, ModuleId.ToString());
ClsObject FacilityManager = new ClsObject();
return((DataSet)FacilityManager.ReturnObject(ClsUtility.theParams, "pr_SystemAdmin_GetSystemBasedLabels_Constella", ClsUtility.ObjectEnum.DataSet));
FacilityManager = null;
}
}
public DataSet GetCodes()
{
lock (this)
{
oUtility.Init_Hashtable();
ClsObject CodeManager = new ClsObject();
return((DataSet)CodeManager.ReturnObject(oUtility.theParams, "pr_Admin_SelectCode_Constella", ClsUtility.ObjectEnum.DataSet));
}
}
private void cmdEMap_Click(object sender, EventArgs e)
{
//TODO Replace with pr_SaveUpdateExcelMapping_IQTools
Cursor.Current = Cursors.WaitCursor;
DataRow qryDR; DataRow catDR;
ClsUtility.Init_Hashtable(); int i = 0;
qryDR = (DataRow)theObject.ReturnObject(Entity.getconnString(clsGbl.xmlPath), ClsUtility.theParams
, "SELECT qryID FROM aa_Queries WHERE qryName = '" + lstQueries.Items[lstQueries.SelectedIndex].ToString() + "'"
, ClsUtility.ObjectEnum.DataRow, serverType);
catDR = (DataRow)theObject.ReturnObject(Entity.getconnString(clsGbl.xmlPath), ClsUtility.theParams
, "SELECT sbCatID FROM aa_SBCategory " +
"WHERE sbCategory = '" + lstCategories.Items[lstCategories.SelectedIndex].ToString()
+ "' And QryId=" + qryDR["QryID"], ClsUtility.ObjectEnum.DataRow, serverType);
i = 0;
try
{
string sql = "DELETE FROM aa_XLMaps WHERE QryID=" + qryDR["qryID"].ToString() + " AND xlCatID=" + catDR["sbCatID"].ToString();
i = (int)theObject.ReturnObject(Entity.getconnString(clsGbl.xmlPath), ClsUtility.theParams, sql
, ClsUtility.ObjectEnum.ExecuteNonQuery, serverType);
foreach (DataGridViewRow dr in dgXls.Rows)
{
if (dr.Cells["xlsCell"].Value.ToString().Length > 1)
{
//i = (int)theObject.ReturnObject(Entity.getconnString(clsGbl.xmlPath), ClsUtility.theParams
// , "UPDATE aa_XLMaps SET xlsCell, QryID, xlsTitle, xlCatID, CreateDate, DhisElementID, CategoryOptionID) VALUES('" +
// dr.Cells["xlsCell"].Value.ToString() + "', " + qryDR["qryID"].ToString() + ", '"
// + dr.Cells["xlsTitle"].Value.ToString() + "', " + catDR["sbCatID"].ToString() + ", dbo.fn_GetCurrentDate(), '"
// + dr.Cells["DHISElementID"].Value.ToString() + "','" + dr.Cells["categoryOptionID"].Value.ToString() + "' )"
// , ClsUtility.ObjectEnum.ExecuteNonQuery, serverType);
i = (int)theObject.ReturnObject(Entity.getconnString(clsGbl.xmlPath), ClsUtility.theParams
, "INSERT INTO aa_XLMaps (xlsCell, QryID, xlsTitle, xlCatID, CreateDate, DhisElementID, CategoryOptionID) VALUES('" +
dr.Cells["xlsCell"].Value.ToString() + "', " + qryDR["qryID"].ToString() + ", '"
+ dr.Cells["xlsTitle"].Value.ToString() + "', " + catDR["sbCatID"].ToString() + ", dbo.fn_GetCurrentDate(), '"
+ dr.Cells["DHISElementID"].Value.ToString() + "','" + dr.Cells["categoryOptionID"].Value.ToString() + "' )"
, ClsUtility.ObjectEnum.ExecuteNonQuery, serverType);
}
}
MessageBox.Show("Query Mapping Was Saved Successfully", Assets.Messages.InfoHeader);
}
catch (Exception ex)
{
EH.LogError(ex.Message, "Excel Mapping", serverType);
}
Cursor.Current = Cursors.Default;
}
public int SaveKNHMEILabResult(DataTable theDT, int userId, int PatientId, int VisitId)
{
ClsObject KNHMEIManager = new ClsObject();
int retlab = 0;
try
{
this.Connection = DataMgr.GetConnection();
this.Transaction = DataMgr.BeginTransaction(this.Connection);
KNHMEIManager.Connection = this.Connection;
KNHMEIManager.Transaction = this.Transaction;
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@patientid", SqlDbType.Int, PatientId.ToString());
ClsUtility.AddParameters("@Visit_ID", SqlDbType.Int, VisitId.ToString());
retlab = (int)KNHMEIManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_DeleteKNHMEILabResult_Futures", ClsDBUtility.ObjectEnum.ExecuteNonQuery);
foreach (DataRow theDR in theDT.Rows)
{
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@patientid", SqlDbType.Int, PatientId.ToString());
ClsUtility.AddParameters("@LabVisitID", SqlDbType.Int, theDR["LabVisitId"].ToString());
ClsUtility.AddParameters("@Visit_ID", SqlDbType.Int, VisitId.ToString());
ClsUtility.AddParameters("@ParameterId", SqlDbType.Int, theDR["ParameterID"].ToString());
ClsUtility.AddParameters("@PrevResult", SqlDbType.VarChar, theDR["PrevResult"].ToString());
ClsUtility.AddParameters("@PrevResultDate", SqlDbType.VarChar, theDR["PrevResultDate"].ToString());
ClsUtility.AddParameters("@UserId", SqlDbType.Int, userId.ToString());
retlab = (int)KNHMEIManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveKNHMEILabResult_Futures", ClsDBUtility.ObjectEnum.ExecuteNonQuery);
}
DataMgr.CommitTransaction(this.Transaction);
DataMgr.ReleaseConnection(this.Connection);
}
catch
{
DataMgr.RollBackTransation(this.Transaction);
throw;
}
finally
{
KNHMEIManager = null;
if (this.Connection != null)
{
DataMgr.ReleaseConnection(this.Connection);
}
}
return(retlab);
}
private bool loginEMR(string username, string password, string facilityname)
{
DataRow dr;
Entity en = new Entity();
string connstring = Entity.GetConnString().ToString();
ClsUtility.Init_Hashtable();
string sPassword = ClsUtility.Encrypt(password);
string sSQL = "SELECT top 1 a.userID, a.UserName, a.Password, a.UserFirstName, a.UserLastName, c.GroupName, f.FacilityID, f.SatelliteID MFLCode FROM " +
"(Select FacilityID, SatelliteID FROM mst_Facility WHERE FacilityName = '" + facilityname + "') f, " +
"mst_user a " +
"INNER JOIN dbo.lnk_UserGroup b ON a.UserID = b.UserID " +
"INNER JOIN dbo.mst_Groups c ON b.GroupID = c.GroupID " +
"WHERE a.DeleteFlag = 0 AND a.UserName = '******' AND Password = '******'";
try {
dr = (DataRow)en.ReturnObject(connstring, ClsUtility.theParams, sSQL, ClsUtility.ObjectEnum.DataRow, serverType);
}
catch (Exception ex) {
if (ex.Message.Contains("There is no row at position 0"))
{
MessageBox.Show(Assets.Messages.InvalidUser, Assets.Messages.ErrorHeader, MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
else
{
MessageBox.Show(ex.Message, Assets.Messages.ErrorHeader);
return(false);
}
}
if (dr.Table.Rows.Count >= 1)
{
clsGbl.loggedInUser.UserID = Convert.ToInt16(dr["userID"]);
clsGbl.loggedInUser.UserName = dr["UserName"].ToString();
clsGbl.loggedInUser.Password = dr["Password"].ToString();
clsGbl.loggedInUser.FirstName = dr["UserFirstName"].ToString();
clsGbl.loggedInUser.LastName = dr["UserLastName"].ToString();
clsGbl.loggedInUser.Group = dr["GroupName"].ToString();
clsGbl.loggedInUser.FacilityID = Convert.ToInt16(dr["FacilityID"]);
clsGbl.loggedInUser.FacilityName = facilityname;
clsGbl.loggedInUser.MFLCode = dr["MFLCode"].ToString();
return(true);
}
else
{
MessageBox.Show(Assets.Messages.InvalidUser, Assets.Messages.ErrorHeader);
return(false);
}
}
public int SaveCustomFieldValues(string sqlstr)
{
try
{
this.Connection = DataMgr.GetConnection();
this.Transaction = DataMgr.BeginTransaction(this.Connection);
ClsObject CustomFields = new ClsObject();
CustomFields.Connection = this.Connection;
CustomFields.Transaction = this.Transaction;
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@QryString", SqlDbType.VarChar, sqlstr);
int RowsAffected = (Int32)CustomFields.ReturnObject(ClsUtility.theParams, "pr_General_Dynamic_Insert", ClsUtility.ObjectEnum.ExecuteNonQuery);
/*
* if (RowsAffected == 0)
* {
* MsgBuilder theBL = new MsgBuilder();
* theBL.DataElements["MessageText"] = "Error in Saving Custom Fields record. Try Again..";
* AppException.Create("#C1", theBL);
* }
* else
* {
* MsgBuilder theBL = new MsgBuilder();
* theBL.DataElements["MessageText"] = "Saved Custom Fields record...";
* AppException.Create("#C1", theBL);
* }
*/
DataMgr.CommitTransaction(this.Transaction);
DataMgr.ReleaseConnection(this.Connection);
return(RowsAffected);
}
catch
{
DataMgr.RollBackTransation(this.Transaction);
throw;
}
finally
{
if (this.Connection != null)
{
DataMgr.ReleaseConnection(this.Connection);
}
}
}
public DataTable SaveNewLab(string LabName, int DepartmentID, int LabTypeID, int UserID, string DataType, decimal MaxBoundary, decimal MinBoundary, int Sequence, int UnitId)
{
try
{
DataTable theAffectedDT;
this.Connection = DataMgr.GetConnection();
this.Transaction = DataMgr.BeginTransaction(this.Connection);
ClsObject LabManager = new ClsObject();
LabManager.Connection = this.Connection;
LabManager.Transaction = this.Transaction;
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@LabName", SqlDbType.VarChar, LabName);
ClsUtility.AddParameters("@LabDepartmentID", SqlDbType.Int, DepartmentID.ToString());
ClsUtility.AddParameters("@LabTypeID", SqlDbType.Int, LabTypeID.ToString());
ClsUtility.AddParameters("@UserId", SqlDbType.Int, UserID.ToString());
// ClsUtility.AddParameters("@DeleteFlag", SqlDbType.Int, DeleteFlag.ToString());
ClsUtility.AddParameters("@DataType", SqlDbType.NVarChar, DataType.ToString());
ClsUtility.AddParameters("@MaxBoundary", SqlDbType.Decimal, MaxBoundary.ToString());
ClsUtility.AddParameters("@MinBoundary", SqlDbType.Decimal, MinBoundary.ToString());
ClsUtility.AddParameters("@Sequence", SqlDbType.Int, Sequence.ToString());
ClsUtility.AddParameters("@UnitId", SqlDbType.Int, UnitId.ToString());
DataRow theDR;
theAffectedDT = (DataTable)LabManager.ReturnObject(ClsUtility.theParams, "pr_Admin_AddLabTest_Constella", ClsDBUtility.ObjectEnum.DataTable);
if (theAffectedDT.Rows[0][0].ToString() == "-1")
{
MsgBuilder theBL = new MsgBuilder();
theBL.DataElements["MessageText"] = "Error in Saving Lab record. Try Again..";
AppException.Create("#C1", theBL);
}
DataMgr.CommitTransaction(this.Transaction);
DataMgr.ReleaseConnection(this.Connection);
return(theAffectedDT);
}
catch
{
throw;
}
finally
{
if (this.Connection != null)
{
DataMgr.ReleaseConnection(this.Connection);
}
}
}
public int SaveFollowupEducation(int Id, int patientId, int typeId, int topicId, int visitPk, int locationId, DateTime visitDate,
string comments, string otherDetail, int userId, int deleteFlag, int?moduleId = null)
{
ClsObject FollowupEducation = new ClsObject();
int retval = 0;
try
{
//this.Connection = DataMgr.GetConnection();
//this.Transaction = DataMgr.BeginTransaction(this.Connection);
//FollowupEducation.Connection = this.Connection;
//FollowupEducation.Transaction = this.Transaction;
ClsUtility.Init_Hashtable();
ClsUtility.AddExtendedParameters("@Id", SqlDbType.Int, Id);
ClsUtility.AddExtendedParameters("@Ptn_pk", SqlDbType.Int, patientId);
ClsUtility.AddExtendedParameters("@VisitPk ", SqlDbType.Int, visitPk);
ClsUtility.AddExtendedParameters("@LocationID", SqlDbType.Int, locationId);
ClsUtility.AddExtendedParameters("@CouncellingTypeId", SqlDbType.Int, typeId);
ClsUtility.AddExtendedParameters("@CouncellingTopicId", SqlDbType.Int, topicId);
ClsUtility.AddExtendedParameters("@VisitDate", SqlDbType.DateTime, visitDate.ToString());
ClsUtility.AddParameters("@Comments", SqlDbType.VarChar, comments);
ClsUtility.AddParameters("@OtherDetail", SqlDbType.VarChar, otherDetail);
ClsUtility.AddExtendedParameters("@UserId", SqlDbType.Int, userId);
ClsUtility.AddExtendedParameters("@DeleteFlag", SqlDbType.Int, deleteFlag);
if (moduleId.HasValue)
{
ClsUtility.AddExtendedParameters("@ModuleId", SqlDbType.Int, moduleId.Value);
}
retval = (int)FollowupEducation.ReturnObject(ClsUtility.theParams, "Pr_Clinical_SaveFollowupEducation_Constella", ClsUtility.ObjectEnum.ExecuteNonQuery);
// DataMgr.CommitTransaction(this.Transaction);
//DataMgr.ReleaseConnection(this.Connection);
}
catch
{
// DataMgr.RollBackTransation(this.Transaction);
throw;
}
finally
{
FollowupEducation = null;
//if (this.Connection != null)
// DataMgr.ReleaseConnection(this.Connection);
}
return(retval);
}
/// <summary>
/// Updates the patientppointment details.
/// </summary>
/// <param name="AppointmentId">The appointment identifier.</param>
/// <param name="AppDate">The application date.</param>
/// <param name="AppReasonId">The application reason identifier.</param>
/// <param name="UserId">The user identifier.</param>
/// <param name="AppProviderId">The application provider identifier.</param>
/// <param name="Updationdate">The updationdate.</param>
/// <param name="ModuleId">The module identifier.</param>
/// <param name="AppNote">The application note.</param>
/// <returns></returns>
public int UpdatePatientppointmentDetails(int AppointmentId, DateTime AppDate, int AppReasonId, int UserId, int AppProviderId, DateTime Updationdate, int?ModuleId = null, string AppNote = "")
{
lock (this)
{
try
{
int theAffectedRows = 0;
this.Connection = DataMgr.GetConnection();
this.Transaction = DataMgr.BeginTransaction(this.Connection);
ClsObject obj = new ClsObject();
obj.Connection = this.Connection;
obj.Transaction = this.Transaction;
ClsUtility.Init_Hashtable();
ClsUtility.AddExtendedParameters("@AppointmentId", SqlDbType.Int, AppointmentId);
ClsUtility.AddExtendedParameters("@AppDate", SqlDbType.DateTime, AppDate);
ClsUtility.AddExtendedParameters("@AppReasonId", SqlDbType.Int, AppReasonId);
ClsUtility.AddExtendedParameters("@UserId", SqlDbType.Int, UserId);
ClsUtility.AddExtendedParameters("@AppProviderId", SqlDbType.Int, AppProviderId);
ClsUtility.AddExtendedParameters("@Updationdate", SqlDbType.DateTime, Updationdate);
if (ModuleId.HasValue)
{
ClsUtility.AddExtendedParameters("@ModuleId", SqlDbType.Int, ModuleId.Value);
}
if (AppNote != "")
{
ClsUtility.AddParameters("@AppNote", SqlDbType.VarChar, AppNote);
}
theAffectedRows = (int)obj.ReturnObject(ClsUtility.theParams, "pr_Scheduler_UpdatePatientAppointmentDetails_Constella", ClsUtility.ObjectEnum.ExecuteNonQuery);
DataMgr.CommitTransaction(this.Transaction);
DataMgr.ReleaseConnection(this.Connection);
return(theAffectedRows);
}
catch
{
DataMgr.RollBackTransation(this.Transaction);
throw;
}
finally
{
if (this.Connection != null)
{
DataMgr.ReleaseConnection(this.Connection);
}
}
}
}
public void SavePharmacyRefill_Web(DataTable dt, int iserId, int dispensedBy, string DispensedByDate, string deleteScript)
{
DataTable thePharmacyDT = new DataTable();
try
{
this.Connection = DataMgr.GetConnection();
this.Transaction = DataMgr.BeginTransaction(this.Connection);
ClsObject theManager = new ClsObject();
foreach (DataRow theDR in dt.Rows)
{
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@ptn_pharmacy_pk", SqlDbType.Int, theDR["orderId"].ToString());
ClsUtility.AddParameters("@drug_pk", SqlDbType.Int, theDR["DrugId"].ToString());
ClsUtility.AddParameters("@batchid", SqlDbType.Int, theDR["BatchId"].ToString());
//ClsUtility.AddParameters("@DispensedQuantity", SqlDbType.Decimal, theDR["RefillQty"].ToString() == "" ? "0" : theDR["RefillQty"].ToString());
ClsUtility.AddParameters("@DispensedQuantity", SqlDbType.Decimal, theDR["QtyDispensed"].ToString() == "" ? "0" : theDR["QtyDispensed"].ToString());
ClsUtility.AddParameters("@DispensedBy", SqlDbType.Int, dispensedBy.ToString());
if (DispensedByDate.ToString() != "")
{
ClsUtility.AddParameters("@DispensedByDate", SqlDbType.VarChar, DispensedByDate.ToString());
}
ClsUtility.AddParameters("@PrintPrescriptionStatus", SqlDbType.Int, theDR["PrintPrescriptionStatus"].ToString() == "True" ? "1" : "0");
ClsUtility.AddParameters("@comments", SqlDbType.Int, theDR["comments"].ToString());
if (deleteScript != "")
{
ClsUtility.AddParameters("@deleteScript", SqlDbType.VarChar, deleteScript);
}
theManager.ReturnObject(ClsUtility.theParams, "pr_SCM_SavePharmacyPartialDispense_Web", ClsDBUtility.ObjectEnum.DataTable);
}
DataMgr.CommitTransaction(this.Transaction);
DataMgr.ReleaseConnection(this.Connection);
}
catch
{
DataMgr.RollBackTransation(this.Transaction);
throw;
}
finally
{
if (this.Connection != null)
{
DataMgr.ReleaseConnection(this.Connection);
}
}
}
/// <summary>
/// Imports the reports from iq tools.
/// </summary>
/// <param name="overwrite">if set to <c>true</c> [overwrite].</param>
/// <exception cref="System.NotImplementedException"></exception>
public void ImportReportsFromIQTools(bool overwrite = false)
{
lock (this)
{
ClsObject ReportManager = new ClsObject();
ClsUtility.Init_Hashtable();
string queryStatement;
DataMgr dataManager = new DataMgr();
// string sourceDB = dataManager.Reports_DatabaseName;
// string destinationDB = dataManager.EMR_DatabaseName;
//if (overwrite)
//{
// queryStatement = "Truncate table dbo.IQToolsExcelReports";
// ReportManager.ReturnObject(ClsUtility.theParams, queryStatement, ClsUtility.ObjectEnum.ExecuteNonQuery);
// ReportManager.Connection = null;
//}
queryStatement = @"SELECT catID,Category FROM aa_Category WHERE excel=1;";
DataTable dt = (DataTable)ReportManager.ReturnIQToolsObject(ClsUtility.theParams, queryStatement, ClsDBUtility.ObjectEnum.DataTable, ConnectionMode.REPORT);
if (dt != null)
{
ReportManager.Connection = null;
dt.TableName = "reports";
//dt.Namespace = "fromiqtools";
System.IO.StringWriter writer = new System.IO.StringWriter();
dt.WriteXml(writer, true);
queryStatement = "pr_IQTools_ImportReports";
// @"Insert Into dbo.IQToolsExcelReports(IQToolsCaTID,ReportName,ReportStylesheet)
// Select
// a.c.value('catID[1]','int'),
// a.c.Category('Category[1]','varchar(200)')
// From @x.nodes(//reports) a(c);";
ClsUtility.Init_Hashtable();
if (overwrite)
{
ClsUtility.AddParameters("@overwrite", SqlDbType.Bit, (overwrite) ? "1" : "0");
}
ClsUtility.AddParameters("@data", SqlDbType.Xml, writer.ToString());
ReportManager.ReturnObject(ClsUtility.theParams, queryStatement, ClsDBUtility.ObjectEnum.ExecuteNonQuery);
}
// return (DataSet)ReportManager.ReturnObject(ClsUtility.theParams, "pr_Reports_Patient_Constella", ClsUtility.ObjectEnum.DataSet);
}
}
public void UpdateBlueCardBaselineTransferInTreatment(int?ptn_pk, DateTime?transferInDate, DateTime?treatmentStartDate,
int currentTreatment, string facilityFrom, int countyFrom)
{
ClsObject obj = new ClsObject();
ClsUtility.Init_Hashtable();
ClsUtility.AddExtendedParameters("@ptn_pk", SqlDbType.Int, ptn_pk);
ClsUtility.AddExtendedParameters("@TransferInDate", SqlDbType.DateTime, transferInDate);
ClsUtility.AddExtendedParameters("@TreatmentStartDate", SqlDbType.DateTime, treatmentStartDate);
ClsUtility.AddExtendedParameters("@CurrentTreatment", SqlDbType.Int, currentTreatment);
ClsUtility.AddExtendedParameters("@FacilityFrom", SqlDbType.VarChar, facilityFrom);
ClsUtility.AddExtendedParameters("@CountyFrom", SqlDbType.Int, countyFrom);
DataTable dt = (DataTable)obj.ReturnObject(ClsUtility.theParams, "sp_UpdateBlueCardBaselineTransferInTreatment", ClsUtility.ObjectEnum.DataTable);
}
public DataSet GetPatientDetails(int facilityID, int moduleId, string identifier, string identifierNumber)
{
lock (this)
{
ClsObject clsObject = new ClsObject();
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@EnrollmentType", SqlDbType.Int, identifier.ToString());
ClsUtility.AddParameters("@enrollmentid", SqlDbType.Int, identifierNumber.ToString());
ClsUtility.AddParameters("@FacilityId", SqlDbType.Int, facilityID.ToString());
ClsUtility.AddParameters("@password", SqlDbType.Int, DBSecurity);
ClsUtility.AddParameters("@moduleId", SqlDbType.Int, moduleId.ToString());
ClsObject UserManager = new ClsObject();
return((DataSet)clsObject.ReturnObject(ClsUtility.theParams, "Pr_IPT_GetPatientSearchResults", ClsDBUtility.ObjectEnum.DataSet));
}
}
public DataTable SaveCustomReport(Int32 ReportId, Int32 CategoryId, string CategoryName, string ReportName, string ReportQuery, Int32 UserId)
{
lock (this)
{
ClsUtility.Init_Hashtable();
ClsObject theQB = new ClsObject();
ClsUtility.AddParameters("@ReportId", SqlDbType.Int, ReportId.ToString());
ClsUtility.AddParameters("@CategoryId", SqlDbType.Int, CategoryId.ToString());
ClsUtility.AddParameters("@CategoryName", SqlDbType.VarChar, CategoryName);
ClsUtility.AddParameters("@ReportName", SqlDbType.VarChar, ReportName);
ClsUtility.AddParameters("@ReportQuery", SqlDbType.VarChar, ReportQuery);
ClsUtility.AddParameters("@UserId", SqlDbType.VarChar, UserId.ToString());
return((DataTable)theQB.ReturnObject(ClsUtility.theParams, "pr_SaveCustomReports_Futures", ClsUtility.ObjectEnum.DataTable));
}
}
/// <summary>
/// Gets the item list store_ filtered.
/// </summary>
/// <param name="itemTypeId">The item type identifier.</param>
/// <param name="Subtypeid">The subtypeid.</param>
/// <param name="StoreId">The store identifier.</param>
/// <returns></returns>
public DataSet GetItemListStore_Filtered(int itemTypeId, int Subtypeid, int StoreId)
{
lock (this)
{
ClsUtility.Init_Hashtable();
ClsObject ItemList = new ClsObject();
ClsUtility.AddParameters("@ItemTypeId", SqlDbType.Int, itemTypeId.ToString());
ClsUtility.AddParameters("@SubitemId", SqlDbType.Int, Subtypeid.ToString());
ClsUtility.AddParameters("@StoreId", SqlDbType.Int, StoreId.ToString());
return
((DataSet)
ItemList.ReturnObject(ClsUtility.theParams, "pr_SCM_GetItemListStoreFiltered_Futures",
ClsUtility.ObjectEnum.DataSet));
}
}
public int SaveBackupSetup(string theDrive, DateTime theTime)
{
DateTime theBackupDatetime = theTime;
lock (this)
{
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@BackupDrive", SqlDbType.VarChar, theDrive.ToString());
ClsUtility.AddParameters("@BackUpTime", SqlDbType.DateTime, theBackupDatetime.ToString());
ClsObject BackupManager = new ClsObject();
return((Int32)BackupManager.ReturnObjectNewImpl(ClsUtility.theParams, "Pr_Admin_UpdateBackupSetup_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery));
BackupManager = null;
}
}
public DataSet GetFieldsforID(int Patient_ID, int LocationId, int SystemId, int ModuleId, int FeatureId)
{
lock (this)
{
ClsUtility.Init_Hashtable();
ClsObject CareManager = new ClsObject();
ClsUtility.AddParameters("@Patientid", SqlDbType.Int, Patient_ID.ToString());
ClsUtility.AddParameters("@LocationId", SqlDbType.Int, LocationId.ToString());
ClsUtility.AddParameters("@SystemId", SqlDbType.Int, SystemId.ToString());
ClsUtility.AddParameters("@ModuleId", SqlDbType.Int, ModuleId.ToString());
ClsUtility.AddParameters("@FeatureId", SqlDbType.Int, FeatureId.ToString());
ClsUtility.AddParameters("@password", SqlDbType.VarChar, ApplicationAccess.DBSecurity.ToString());
return((DataSet)CareManager.ReturnObject(ClsUtility.theParams, "pr_Scheduler_SelectContactCarefields_Constella", ClsDBUtility.ObjectEnum.DataSet));
}
}
public DataSet GetCD4TLC(Hashtable htCD4TLC)
{
lock (this)
{
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@Mode", SqlDbType.VarChar, htCD4TLC["Mode"].ToString());
ClsUtility.AddParameters("@LocationID", SqlDbType.VarChar, htCD4TLC["LocationID"].ToString());
ClsUtility.AddParameters("@UserID", SqlDbType.VarChar, htCD4TLC["UserID"].ToString());
ClsUtility.AddParameters("@Ptn_Pk", SqlDbType.VarChar, htCD4TLC["Ptn_Pk"].ToString());
ClsUtility.AddParameters("@VisitId", SqlDbType.VarChar, htCD4TLC["VisitId"].ToString());
ClsUtility.AddParameters("@VisitDate", SqlDbType.VarChar, htCD4TLC["VisitDate"].ToString());
ClsObject PatientRecord = new ClsObject();
return((DataSet)PatientRecord.ReturnObject(ClsUtility.theParams, "pr_Clinical_GetCD4TLCPatientRecordCTC_Constella", ClsUtility.ObjectEnum.DataSet));
}
}
public DataTable GetCustomListUpdatePriortorize(string TableName, int CategoryID, string SRno, int SystemId)
{
TableName = "mst_" + TableName;
ClsObject CustomManager = new ClsObject();
lock (this)
{
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@TableName", SqlDbType.VarChar, TableName);
ClsUtility.AddParameters("@Category", SqlDbType.Int, CategoryID.ToString());
ClsUtility.AddParameters("@SRNo", SqlDbType.VarChar, SRno.ToString());
ClsUtility.AddParameters("@SystemId", SqlDbType.Int, SystemId.ToString());
return((DataTable)CustomManager.ReturnObject(ClsUtility.theParams, "Pr_Admin_GetUpdatePriortorizeCustomListMasters_Constella", ClsUtility.ObjectEnum.DataTable));
}
}
public DataTable IQTouchGetKnhAdultIEData(BIQTouchAdultIE adultIEFields)
{
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@Flag", SqlDbType.Int, ConverTotValue.NullToInt(adultIEFields.Flag).ToString());
ClsUtility.AddParameters("@Ptn_pk", SqlDbType.Int, ConverTotValue.NullToInt(adultIEFields.PtnPk).ToString());
ClsUtility.AddParameters("@LocationId", SqlDbType.Int, ConverTotValue.NullToInt(adultIEFields.LocationId).ToString());
ClsUtility.AddParameters("@VisitPk", SqlDbType.Int, ConverTotValue.NullToInt(adultIEFields.VisitPk).ToString()); // ID here Visit PK
ClsUtility.AddParameters("@ID", SqlDbType.Int, ConverTotValue.NullToInt(adultIEFields.ID).ToString()); // ID here Visit PK
ClsObject GetRecs = new ClsObject();
DataTable regDT = (DataTable)GetRecs.ReturnObject(ClsUtility.theParams, "Pr_IQTouch_Clinical_GetKNHAdultIE", ClsUtility.ObjectEnum.DataTable);
return(regDT);
}
private DataTable GetTestParameters(int LabTestId, int?ParameterId = null)
{
ClsObject obj = new ClsObject();
ClsUtility.Init_Hashtable();
ClsUtility.AddExtendedParameters("@LabTestId", SqlDbType.Int, LabTestId);
if (ParameterId.HasValue)
{
ClsUtility.AddExtendedParameters("@ParameterId", SqlDbType.Int, ParameterId.Value);
}
DataTable dt = (DataTable)obj.ReturnObject(ClsUtility.theParams, "Laboratory_GetLabTestParameters", ClsUtility.ObjectEnum.DataTable);
return(dt);
}
public void AddOrdVisit(int ptnPk, int locationId, DateTime visitDate, int visitType, int userId, DateTime createDate, int moduleId)
{
ClsObject obj = new ClsObject();
ClsUtility.Init_Hashtable();
ClsUtility.AddExtendedParameters("@Ptn_Pk", SqlDbType.Int, ptnPk);
ClsUtility.AddExtendedParameters("@LocationID", SqlDbType.Int, locationId);
ClsUtility.AddExtendedParameters("@VisitDate", SqlDbType.DateTime, visitDate);
ClsUtility.AddExtendedParameters("@VisitType", SqlDbType.Int, visitType);
ClsUtility.AddExtendedParameters("@UserID", SqlDbType.Int, userId);
ClsUtility.AddExtendedParameters("@CreateDate", SqlDbType.DateTime, createDate);
ClsUtility.AddExtendedParameters("@ModuleId", SqlDbType.Int, moduleId);
DataTable dt = (DataTable)obj.ReturnObject(ClsUtility.theParams, "Ord_Visit_Insert", ClsUtility.ObjectEnum.DataTable);
}
/// <summary>
/// Gets the common item list.
/// </summary>
/// <param name="CategoryId">The category identifier.</param>
/// <param name="tableName">Name of the table.</param>
/// <returns></returns>
public DataTable GetCommonItemList(String categoryId, String tableName, int locationId)
{
lock (this)
{
ClsObject ObjCommonItemList = new ClsObject();
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@CategoryId", SqlDbType.VarChar, categoryId.ToString());
ClsUtility.AddParameters("@TableName", SqlDbType.VarChar, tableName.ToString());
ClsUtility.AddExtendedParameters("@LocationId", SqlDbType.Int, locationId);
return
((DataTable)
ObjCommonItemList.ReturnObject(ClsUtility.theParams, "pr_SCM_GetCommonItemList_Futures",
ClsUtility.ObjectEnum.DataTable));
}
}
public List <LabOrder> GetLabOrders(int locationId, string orderStatus, DateTime?dateFrom = null, DateTime?dateTo = null)
{
ClsObject obj = new ClsObject();
ClsUtility.Init_Hashtable();
if (dateFrom.HasValue)
{
ClsUtility.AddExtendedParameters("@DateFrom", System.Data.SqlDbType.DateTime, dateFrom.Value);
}
if (dateTo.HasValue)
{
ClsUtility.AddExtendedParameters("@DateTo", SqlDbType.DateTime, dateTo.Value);
}
ClsUtility.AddExtendedParameters("@LocationId", SqlDbType.Int, locationId);
if (!string.IsNullOrEmpty(orderStatus))
{
ClsUtility.AddParameters("@OrderStatus", SqlDbType.VarChar, orderStatus);
}
DateTime? nullDate = null;
DataTable dt = (DataTable)obj.ReturnObject(ClsUtility.theParams, "Laboratory_GetLabOrder", ClsUtility.ObjectEnum.DataTable);
ClsUtility.Init_Hashtable();
IPatientService service = new BusinessProcess.PatientCore.PatientCoreServices();
obj = null;
var result = (from rowView in dt.AsEnumerable()
select new LabOrder()
{
Id = Convert.ToInt32(rowView["LabOrderId"]),
ClinicalNotes = rowView["ClinicalNotes"].ToString(),
CreateDate = Convert.ToDateTime(rowView["CreateDate"]),
DeleteFlag = Convert.ToBoolean(rowView["DeleteFlag"]),
LocationId = Convert.ToInt32(rowView["LocationId"]),
ModuleId = Convert.ToInt32(rowView["ModuleId"]),
OrderDate = Convert.ToDateTime(rowView["OrderDate"]),
OrderedBy = Convert.ToInt32(rowView["OrderedBy"]),
OrderNumber = rowView["OrderNumber"].ToString(),
PreClinicDate = rowView["PreClinicLabDate"] == DBNull.Value ? nullDate : Convert.ToDateTime(rowView["PreClinicLabDate"]),
PatientPk = Convert.ToInt32(rowView["PatientPk"]),
Client = service.GetPatient(Convert.ToInt32(rowView["PatientPk"])),
UserId = Convert.ToInt32(rowView["UserId"]),
VisitId = Convert.ToInt32(rowView["VisitId"]),
OrderStatus = rowView["OrderStatus"].ToString(),
OrderedTest = this.GetOrderedTests(Convert.ToInt32(rowView["LabOrderId"]))
}).ToList();
return(result);
}
/// <summary>
/// Checks the appointment existance.
/// </summary>
/// <param name="PatientId">The patient identifier.</param>
/// <param name="locationId">The location identifier.</param>
/// <param name="AppDate">The application date.</param>
/// <param name="ReasonId">The reason identifier.</param>
/// <param name="visitId">The visit identifier.</param>
/// <param name="ModuleId">The module identifier.</param>
/// <returns></returns>
public DataTable CheckAppointmentExistance(int patientId, int locationId, DateTime AppDate,
int ReasonId,
int visitId = 0,
int?ModuleId = null)
{
//lock (this)
//{
try
{
DataTable theDt;
//this.Connection = DataMgr.GetConnection();
// this.Transaction = DataMgr.BeginTransaction(this.Connection);
ClsObject obj = new ClsObject();
obj.Connection = this.Connection;
// obj.Transaction = this.Transaction;
ClsUtility.Init_Hashtable();
ClsUtility.AddExtendedParameters("@PatientId", SqlDbType.Int, patientId);
ClsUtility.AddExtendedParameters("@LocationId", SqlDbType.Int, locationId);
ClsUtility.AddExtendedParameters("@AppDate", SqlDbType.DateTime, AppDate);
ClsUtility.AddExtendedParameters("@ReasonId", SqlDbType.Int, ReasonId);
ClsUtility.AddExtendedParameters("@visitId", SqlDbType.Int, visitId);
if (ModuleId.HasValue)
{
ClsUtility.AddExtendedParameters("@ModuleId", SqlDbType.Int, ModuleId.Value);
}
theDt = (DataTable)obj.ReturnObject(ClsUtility.theParams, "pr_Scheduler_CheckAppointmentExistance_Constella", ClsUtility.ObjectEnum.DataTable);
// DataMgr.CommitTransaction(this.Transaction);
DataMgr.ReleaseConnection(this.Connection);
return(theDt);
}
catch
{
// DataMgr.RollBackTransation(this.Transaction);
throw;
}
finally
{
if (this.Connection != null)
{
DataMgr.ReleaseConnection(this.Connection);
}
}
// }
}
public int DeleteCustomFields(int CustomFieldID, int DFlag)
{
try
{
this.Connection = DataMgr.GetConnection();
this.Transaction = DataMgr.BeginTransaction(this.Connection);
ClsObject CustomFields = new ClsObject();
CustomFields.Connection = this.Connection;
CustomFields.Transaction = this.Transaction;
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@CustomFieldID", SqlDbType.Int, CustomFieldID.ToString());
ClsUtility.AddParameters("@ActivateFlag", SqlDbType.Int, DFlag.ToString());
int RowsAffected = (Int32)CustomFields.ReturnObject(ClsUtility.theParams, "pr_Admin_DeleteCustomField_Constella", ClsUtility.ObjectEnum.ExecuteNonQuery);
/*
* if (RowsAffected == 0)
* {
* MsgBuilder theBL = new MsgBuilder();
* theBL.DataElements["MessageText"] = "Error in Deleting Custom Fields record. Try Again..";
* AppException.Create("#C1", theBL);
* }
* else
* {
*
* }
*/
DataMgr.CommitTransaction(this.Transaction);
DataMgr.ReleaseConnection(this.Connection);
return(RowsAffected);
}
catch
{
DataMgr.RollBackTransation(this.Transaction);
throw;
}
finally
{
if (this.Connection != null)
{
DataMgr.ReleaseConnection(this.Connection);
}
}
}
public int SaveAllergyInfo(int Id, int Ptn_Pk, string AllergyType, string Allergen, string otherAllergen, string severity, string typeReaction, int UserId, int DeleteFlag, string dataAllergy)
{
ClsObject FamilyInfo = new ClsObject();
int retval = 0;
try
{
this.Connection = DataMgr.GetConnection();
this.Transaction = DataMgr.BeginTransaction(this.Connection);
FamilyInfo.Connection = this.Connection;
FamilyInfo.Transaction = this.Transaction;
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@Id", SqlDbType.Int, Id.ToString());
ClsUtility.AddParameters("@Ptn_pk", SqlDbType.Int, Ptn_Pk.ToString());
ClsUtility.AddParameters("@vAllergyType", SqlDbType.VarChar, AllergyType.ToString());
ClsUtility.AddParameters("@vAllergen", SqlDbType.VarChar, Allergen.ToString());
ClsUtility.AddParameters("@votherAllergen", SqlDbType.VarChar, otherAllergen.ToString());
ClsUtility.AddParameters("@vTypeReaction", SqlDbType.VarChar, typeReaction.ToString());
ClsUtility.AddParameters("@vSeverity", SqlDbType.VarChar, severity.ToString());
ClsUtility.AddParameters("@UserId", SqlDbType.Int, UserId.ToString());
ClsUtility.AddParameters("@DeleteFlag", SqlDbType.Int, DeleteFlag.ToString());
ClsUtility.AddParameters("@DBKey", SqlDbType.VarChar, ApplicationAccess.DBSecurity);
//if (dataAllergy.DayOfYear != 1)
//{
ClsUtility.AddParameters("@vDataAllergy", SqlDbType.VarChar, dataAllergy.ToString());
//}
retval = (int)FamilyInfo.ReturnObject(ClsUtility.theParams, "Pr_Clinical_SaveAllergyInfo", ClsDBUtility.ObjectEnum.ExecuteNonQuery);
DataMgr.CommitTransaction(this.Transaction);
DataMgr.ReleaseConnection(this.Connection);
}
catch
{
DataMgr.RollBackTransation(this.Transaction);
throw;
}
finally
{
FamilyInfo = null;
if (this.Connection != null)
{
DataMgr.ReleaseConnection(this.Connection);
}
}
return(retval);
}
public void SaveUpdateFormModuleLinkDetail(int intModuleID, ArrayList list, int userId)
{
int intDeleteFlag = 1;
try
{
this.Connection = DataMgr.GetConnection();
this.Transaction = DataMgr.BeginTransaction(this.Connection);
ClsObject ModuleMgr = new ClsObject();
ModuleMgr.Connection = this.Connection;
ModuleMgr.Transaction = this.Transaction;
for (int i = 0; i < list.Count; i++)
{
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@ModuleId", SqlDbType.Int, intModuleID.ToString());
ClsUtility.AddParameters("@FormID", SqlDbType.Int, list[i].ToString());
ClsUtility.AddParameters("@DeleteFlag", SqlDbType.Int, intDeleteFlag.ToString());
ClsUtility.AddParameters("@UserID", SqlDbType.Int, userId.ToString());
Int32 NoRowsEffected = (Int32)ModuleMgr.ReturnObject(ClsUtility.theParams, "pr_FormBuilder_SaveUpdateFormModuleLink_Futures", ClsDBUtility.ObjectEnum.ExecuteNonQuery);
intDeleteFlag = 0;
}
if (list.Count == 0)
{
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@ModuleId", SqlDbType.Int, intModuleID.ToString());
ClsUtility.AddParameters("@DeleteFlag", SqlDbType.Int, intDeleteFlag.ToString());
ClsUtility.AddParameters("@UserID", SqlDbType.Int, userId.ToString());
Int32 NoRowsEffected = (Int32)ModuleMgr.ReturnObject(ClsUtility.theParams, "pr_FormBuilder_SaveUpdateFormModuleLink_Futures", ClsDBUtility.ObjectEnum.ExecuteNonQuery);
intDeleteFlag = 0;
}
DataMgr.CommitTransaction(this.Transaction);
DataMgr.ReleaseConnection(this.Connection);
}
catch
{
DataMgr.RollBackTransation(this.Transaction);
throw;
}
finally
{
if (this.Connection != null)
{
DataMgr.ReleaseConnection(this.Connection);
}
}
}
private void SendtoIL()
{
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(@"C:\Cohort\MoH_731_ADX.xml");
ClsUtility.Init_Hashtable();
//byte[] bytes = Encoding.UTF8.GetBytes(usernamePassword.ToCharArray());
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(DHIS2URL);
try
{
byte[] buffer = Encoding.ASCII.GetBytes(xmlDoc.InnerXml);
//request.Headers["Authorization"] = "Basic " + Convert.ToBase64String(bytes);
request.Method = "POST";
request.Accept = "application/adx+xml";
request.ContentLength = buffer.Length;
request.ContentType = "application/adx+xml";
using (Stream requestStream = request.GetRequestStream())
{
requestStream.Write(buffer, 0, buffer.Length);
requestStream.Close();
}
using (HttpWebResponse response = (HttpWebResponse)request.GetResponse())
{
String respString;
using (StreamReader sr = new StreamReader(response.GetResponseStream()))
{
respString = sr.ReadToEnd();
}
if (response.StatusCode == HttpStatusCode.OK)
{
MessageBox.Show(respString);
}
response.Close();
}
}
catch (Exception ex)
{
Console.WriteLine("{0} {1}", ex.Message, "Post to DHIS ADX");
MessageBox.Show(ex.Message, "Post to DHIS ADX");
}
finally
{ }
Console.ReadLine();
}
public DataSet GetPurcaseOrderItem(int isPO, int UserID, int StoreID)
{
lock (this)
{
ClsUtility.Init_Hashtable();
ClsObject GetPurcahseItem = new ClsObject();
ClsUtility.AddParameters("@isPO", SqlDbType.Int, isPO.ToString());
ClsUtility.AddParameters("@UserID", SqlDbType.Int, UserID.ToString());
ClsUtility.AddParameters("@StoreId", SqlDbType.Int, StoreID.ToString());
return
((DataSet)
GetPurcahseItem.ReturnObject(ClsUtility.theParams, "Pr_SCM_GetPurcaseOrderItem",
ClsUtility.ObjectEnum.DataSet));
}
}