public DataSet FindPatient(string strFind, string dataSet) { SqlCommand com = DataAccessHelper.CreateCommand("spFindPatient"); DataAccessHelper.AddStringInputParam(com, "strFind", strFind); DataAccessHelper.AddLongStringInputParam(com, "dataSet", dataSet); return(DataAccessHelper.GetList(com)); }
//contact status must select within the dataset public DataSet GetDistinctContactStatus(string dataSet) { SqlCommand com = DataAccessHelper.CreateCommand("spGetDistinctPtContactStatus"); DataAccessHelper.AddLongStringInputParam(com, "dataSet", dataSet); DataSet statusDs = DataAccessHelper.GetList(com); return(statusDs); }
public DataSet GetEformsClinicList(string datasetSql, string apptPhysician, string apptClinicDate) { SqlCommand com = DataAccessHelper.CreateCommand("spListEFormClinic"); DataAccessHelper.AddLongStringInputParam(com, "Dataset", datasetSql); DataAccessHelper.AddStringInputParam(com, "ApptPhysician", apptPhysician); //DataAccessHelper.AddStringInputParam(com, "ApptClinicDate", apptClinicDate); DataAccessHelper.AddDateTimeInputParam(com, "ApptClinicDate", DataAccessHelper.ToDBDate(apptClinicDate)); return(DataAccessHelper.GetRecord(com)); }
public bool UpdateGroupAccessCode(int groupId, string groupAccessCode) { SqlCommand com = DataAccessHelper.CreateCommand("spUpdateGroupAccessCode"); DataAccessHelper.AddIntInputParam(com, "GroupId", groupId); DataAccessHelper.AddLongStringInputParam(com, "GroupAccessCode", groupAccessCode); DataAccessHelper.AddDateTimeInputParam(com, "UpdatedTime", DateTime.Now); DataAccessHelper.ExecuteScalar(com); return(true); }
//public int InsertRole(string role, string roleDescription) //{ // SqlCommand com = DataAccessHelper.CreateCommand("spInsertRolesRecord"); // DataAccessHelper.AddStringInputParam(com, "Role", role); // DataAccessHelper.AddLongStringInputParam(com, "RoleDescription", roleDescription); // DataAccessHelper.AddDateTimeInputParam(com, "EnteredTime", DateTime.Now); // DataAccessHelper.AddDateTimeInputParam(com, "UpdatedTime", DateTime.Now); // DataAccessHelper.AddDateTimeInputParam(com, "DeactivatedTime", null); // DataAccessHelper.AddIntOutputParam(com, "NewPrimaryKey"); // Hashtable outParams = DataAccessHelper.ExecuteScalar(com); // if(outParams["NewPrimaryKey"] != System.DBNull.Value) // { // return (int)outParams["NewPrimaryKey"]; // } // else // { // return -1; // } //} public bool UpdateRole(int roleId, string role, string roleDescription) { SqlCommand com = DataAccessHelper.CreateCommand("spUpdateRolesRecord"); DataAccessHelper.AddIntInputParam(com, "RoleId", roleId); //DataAccessHelper.AddIntInputParam(com, "RoleId", roleId); DataAccessHelper.AddStringInputParam(com, "Role", role); DataAccessHelper.AddLongStringInputParam(com, "RoleDescription", roleDescription); DataAccessHelper.AddDateTimeInputParam(com, "UpdatedTime", DateTime.Now); DataAccessHelper.AddDateTimeInputParam(com, "DeactivatedTime", null); DataAccessHelper.ExecuteScalar(com); return(true); }
public DataSet FindPatientByIdentifier(string strFind, string idType, string dataSet) { // special case if (idType == "Study Id") { return(FindPatientByStudyId(strFind, dataSet)); } else { SqlCommand com = DataAccessHelper.CreateCommand("spFindPatient"); DataAccessHelper.AddStringInputParam(com, "strFind", strFind); DataAccessHelper.AddStringInputParam(com, "strIdType", idType); DataAccessHelper.AddLongStringInputParam(com, "dataSet", dataSet); return(DataAccessHelper.GetList(com)); } }
//TODO: remove this and use Biz Object to update from admin //TODO: remove hardcoded group access code public bool InsertGroup(int roleId, string groupName, string groupDescription) { SqlCommand com = DataAccessHelper.CreateCommand("spInsertGroupsRecord"); DataAccessHelper.AddIntInputParam(com, "RoleId", roleId); DataAccessHelper.AddStringInputParam(com, "GroupName", groupName); DataAccessHelper.AddLongStringInputParam(com, "GroupDescription", groupDescription); // This access code gives access to all standard tabs and menus // When admin is revised, this should no longer be hardcoded and should become part of the // workflow DataAccessHelper.AddStringInputParam(com, "GroupAccessCode", "1FE1FC1F81C0000000"); DataAccessHelper.AddDateTimeInputParam(com, "EnteredTime", DateTime.Now); DataAccessHelper.AddDateTimeInputParam(com, "UpdatedTime", DateTime.Now); DataAccessHelper.AddDateTimeInputParam(com, "DeactivatedTime", null); DataAccessHelper.ExecuteScalar(com); return(true); }
/// <summary> /// Populates all drop down menus other than clinic and last name: Categories, Protocols, Contact Status and Referring Physician /// </summary> /// <param name="dataSetId">sql string DatasetId in Session</param> /// <param name="listName">List name, eg, Protocol, Category..</param> /// <param name="listValue">The selected option, eg, 00-290 (protocol value)</param> /// <param name="orderBy">Order by defaults to alphabetical</param> /// <param name="startRow">Start row for lists greater than 200</param> /// <param name="numRows">The number of rows to display</param> /// <returns>Dataset of patients that match criteria name and type and in working dataset</returns> public DataSet ListPatients(string dataSet, string listName, string listValue, string listModifier, string orderBy, int startRow, int numRows, string listUser) { SqlCommand com = DataAccessHelper.CreateCommand("spListPatients"); DataAccessHelper.AddLongStringInputParam(com, "DataSet", dataSet); DataAccessHelper.AddStringInputParam(com, "listName", listName); DataAccessHelper.AddStringInputParam(com, "listValue", listValue); if (listModifier != null && !listModifier.Equals("")) { DataAccessHelper.AddStringInputParam(com, "listModifier", listModifier); } if (orderBy != null && !orderBy.Equals("")) { DataAccessHelper.AddStringInputParam(com, "orderByField", orderBy); } if (listUser != null && !listUser.Equals("")) { DataAccessHelper.AddStringInputParam(com, "UserName", listUser); } return(DataAccessHelper.GetList(com, startRow, numRows)); }