public static void InsertStudyGroup(object studyId, object referringPhysicianId, object userId)
{
RISDatabaseAccessLayer databaseAccess = new RISDatabaseAccessLayer();
SqlConnection connection = (SqlConnection)databaseAccess.GetConnection();
connection.Open();
SqlCommand command = new SqlCommand("sp_insert_study_group", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@studyId", studyId);
command.Parameters.AddWithValue("@userId", referringPhysicianId);
command.Parameters.AddWithValue("@adminUserId", userId);
command.ExecuteNonQuery();
}
public static DataTable GetAllUsers()
{
RISDatabaseAccessLayer databaseAccess = new RISDatabaseAccessLayer();
SqlConnection connection = (SqlConnection)databaseAccess.GetConnection();
connection.Open();
SqlCommand command = new SqlCommand("SELECT [UserId], [LoginName], [Password], [Name], [IsActive] FROM [tUsers]", connection);
command.CommandType = CommandType.Text;
SqlDataAdapter da = new SqlDataAdapter(command);
DataTable dtResults = new DataTable();
da.Fill(dtResults);
connection.Close();
return dtResults;
}
public static DataTable GetUserGroupsWithDefaults(int userid)
{
RISDatabaseAccessLayer databaseAccess = new RISDatabaseAccessLayer();
SqlConnection connection = (SqlConnection)databaseAccess.GetConnection();
connection.Open();
SqlCommand command = new SqlCommand("sp_get_groups_for_user_defaults", connection);
command.Parameters.AddWithValue("@userid", userid);
command.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(command);
DataTable dtResults = new DataTable();
da.Fill(dtResults);
connection.Close();
return dtResults;
}
private void BindList()
{
RISDatabaseAccessLayer dataAccess = new RISDatabaseAccessLayer();
SqlConnection connection = (SqlConnection)dataAccess.GetConnection();
connection.Open();
SqlCommand command = new SqlCommand("sp_get_roles_for_user", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@userId", loggedInUserId);
SqlDataReader reader = command.ExecuteReader();
ddlRoles.DataSource = reader;
ddlRoles.DataMember = "Name";
ddlRoles.DataTextField = "Name";
ddlRoles.DataValueField = "RoleId";
ddlRoles.DataBind();
connection.Close();
}
public static int GetRoleCount(int userId)
{
int numOfRoles = 0;
RISDatabaseAccessLayer databaseAccess = new RISDatabaseAccessLayer();
SqlConnection connection = (SqlConnection)databaseAccess.GetConnection();
connection.Open();
SqlCommand command = new SqlCommand("sp_get_num_user_roles", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@userId", userId);
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
numOfRoles = reader.GetInt32(0);
}
connection.Close();
return numOfRoles;
}
public static void BindModalitiesDDL(string addText, DropDownList ddl)
{
RISDatabaseAccessLayer dataAccess = new RISDatabaseAccessLayer();
SqlConnection connection = (SqlConnection)dataAccess.GetConnection();
connection.Open();
SqlCommand command = new SqlCommand("sp_get_modalities", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@addText", addText);
SqlDataReader reader = command.ExecuteReader();
ddl.DataSource = reader;
ddl.DataMember = "Name";
ddl.DataTextField = "Name";
ddl.DataValueField = "ModalityId";
ddl.DataBind();
reader.Close();
connection.Close();
}
private void FillTemplatesList()
{
RISDatabaseAccessLayer db = new RISDatabaseAccessLayer();
string query = "select tTemplates.TemplateId,tTemplates.[Name] from tTemplates "
+ " inner join tTemplateUsers on tTemplates.TemplateId = tTemplateUsers.TemplateId "
+ " inner join tModalities on tTemplates.ModalityId = tModalities.ModalityId "
+ " where tTemplateUsers.UserId = " + Request["userId"]
+ " and tModalities.Name = '" + Request["modalityName"] + "'";
SqlConnection con = (SqlConnection)db.GetConnection();
SqlCommand cmd = new SqlCommand(query, con);
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
da.SelectCommand = cmd;
da.Fill(dt);
//Populating Drop down list of templates
if (dt.Rows.Count > 0)
{
DropDownList ddlTemplates = new DropDownList();
ddlTemplates.ID = "ddlTemplates";
ddlTemplates.DataSource = dt;
ddlTemplates.DataTextField = "Name";
ddlTemplates.DataValueField = "TemplateId";
ddlTemplates.DataBind();
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
Label label = new Label();
label.ID = "lblTemplate";
label.Text = "Template:";
label.RenderControl(oHtmlTextWriter);
ddlTemplates.RenderControl(oHtmlTextWriter);
Response.Write(oHtmlTextWriter.InnerWriter);
Response.Write("<input id='btnLoadTemplate' type='button' value='Apply Template' onclick='getReportText()'/>");
Response.End();
}
else
{
Response.Write("<i>No Templates Found</i>");
Response.End();
}
}
protected override void Page_Load_Extended(object sender, EventArgs e)
{
int studyId = int.Parse(Request[ParameterNames.Request.StudyId]);
SqlConnection connection = null;
SqlCommand command = null;
SqlDataReader reader = null;
try
{
StringBuilder query = new StringBuilder(" SELECT tImages.Path FROM tImages ");
query.Append(" INNER JOIN tSeries ON tSeries.SeriesId = tImages.SeriesId ");
query.Append(" WHERE tSeries.StudyId = @StudyId ");
RISDatabaseAccessLayer risDatabase = new RISDatabaseAccessLayer();
connection = (SqlConnection)risDatabase.GetConnection();
connection.Open();
command = new SqlCommand(query.ToString(), connection);
command.Parameters.AddWithValue("@StudyId", studyId);
reader = command.ExecuteReader();
int count = 1;
while (reader.Read())
{
appletParams.Append(getAppletParam(count++, reader.GetString(0)));
}
if (appletParams.Length > 0)
{
Log(studyId);
}
else
{
Session[ParameterNames.Session.ErrorMessage] = "No files found for the study";
Response.Redirect("~/SharedPages/ErrorPage.aspx");
}
}
finally
{
if (reader != null) reader.Close();
//if (command != null) command.Close();
if (connection != null) connection.Close();
}
}
private ArrayList GetRISList()
{
RISObject risObject = GetRISObject();
QueryBuilder query = risObject.GetSelectQuery();
query.AddText(GetRISWhereClause());
RISDatabaseAccessLayer dataAccessLayer = new RISDatabaseAccessLayer();
SqlDataReader reader = (SqlDataReader)dataAccessLayer.ExecuteQuery(query);
ArrayList risObjects = new ArrayList();
while (reader.Read())
{
risObject.Load(reader);
risObjects.Add(risObject);
risObject = GetRISObject();
}
reader.Close();
dataAccessLayer.CloseConnection();
return risObjects;
}
protected override void PerformPostSaveTasks(RISObject risObject)
{
if (hospital != null)
{
StudyObject risStudy = (StudyObject)risObject;
RISDatabaseAccessLayer databaseAccessLayer = new RISDatabaseAccessLayer();
SqlConnection connection = (SqlConnection)databaseAccessLayer.GetConnection();
connection.Open();
SqlCommand command = new SqlCommand("sp_insert_study_group", connection);
command.Parameters.AddWithValue("@studyId", risStudy.GetPrimaryKey().Value);
command.Parameters.AddWithValue("@hospitalId", hospital.HospitalId.Value);
command.Parameters.AddWithValue("@adminUserId", GenericDataMigrator.AdminUserId);
command.CommandType = CommandType.StoredProcedure;
command.ExecuteNonQuery();
connection.Close();
}
}
public List<StudyListPageObject> GetData()
{
SqlConnection connection = null;
List<StudyListPageObject> data = new List<StudyListPageObject>();
try
{
RISDatabaseAccessLayer dal = new RISDatabaseAccessLayer();
connection = (SqlConnection)dal.GetConnection();
connection.Open();
SqlCommand command = GetQuery(QueryType.SELECT);
command.Connection = connection;
SqlDataReader reader = command.ExecuteReader();
while(reader.Read())
{
data.Add(GetStudyListPageObject(reader));
}
reader.Close();
}
finally
{
if(connection != null)connection.Close();
}
return data;
}
private void BindBodyPart(int modalityId)
{
RISDatabaseAccessLayer db = new RISDatabaseAccessLayer();
string query = "SELECT '[-- Select --]' AS BodyPart UNION select DISTINCT BodyPart AS BodyPart from tTemplates "
+ " WHERE tTemplates.ModalityId = " + modalityId;
SqlConnection con = (SqlConnection)db.GetConnection();
SqlCommand cmd = new SqlCommand(query, con);
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
da.SelectCommand = cmd;
da.Fill(dt);
//Populating Drop down list of templates
if (dt.Rows.Count > 0)
{
ddlBodyParts.DataSource = dt;
ddlBodyParts.DataTextField = "BodyPart";
ddlBodyParts.DataValueField = "BodyPart";
ddlBodyParts.DataBind();
}
}
private void fillAllRolesList()
{
RISDatabaseAccessLayer dataAccess = new RISDatabaseAccessLayer();
SqlConnection connection = (SqlConnection)dataAccess.GetConnection();
connection.Open();
SqlCommand command = new SqlCommand("select RoleId,Name from tRoles", connection);
BindListBox(command, lbOtherRoles);
connection.Close();
}
protected override void Page_Load_Extended(object sender, EventArgs e)
{
if (IsPostBack == false)
{
if (Request[Params.UserId] != null)
{
lbUserId.Text = Request[Params.UserId];
UserObject user = new UserObject();
user.UserId.Value = int.Parse(lbUserId.Text.Trim());
user.Load();
if (user.IsLoaded)
{
tbLoginName.Text = user.LoginName.Value.ToString();
tbLoginName.Enabled = false;
tbPassword.Text = user.Password.Value.ToString();
tbConfirmPassword.Text = user.Password.Value.ToString();
string strFirstName = "";
string strLastName = "";
RISUtility.GetFirstLastName(user.Name.Value.ToString(), ref strFirstName, ref strLastName);
tbFirstName.Text = strFirstName.Trim();
tbLastName.Text = strLastName.Trim();
cbIsActive.Checked = (bool)user.IsActive.Value;
}
RISDatabaseAccessLayer dataAccess = new RISDatabaseAccessLayer();
SqlConnection connection = (SqlConnection)dataAccess.GetConnection();
connection.Open();
SqlCommand command = new SqlCommand("sp_get_roles_for_user", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@userId", int.Parse(Request[Params.UserId]));
BindListBox(command, lbUserRoles);
SqlCommand command2 = new SqlCommand("sp_get_roles_not_for_user", connection);
command2.CommandType = CommandType.StoredProcedure;
command2.Parameters.AddWithValue("@userId", int.Parse(Request[Params.UserId]));
BindListBox(command2, lbOtherRoles);
connection.Close();
}
else
{
fillAllRolesList();
}
}
}
//public StudyListModal(int currentPage,int sortBy,string isAsc,string hdPatientId,string patientId,string patientName,int modalityId,int studyStatusId,string procedure,string radiologist,string physician,DateTime fromDate,DateTime toDate,int loggedInUseRoleId,int loggedInUserId)
//{
// this.currentPage = currentPage;
// this.sortBy = sortBy;
// this.isAsc = isAsc;
// this.hdPatientId = hdPatientId;
// this.patientId = patientId;
// this.patientName = patientName;
// this.modalityId = modalityId;
// this.studyStatusId = studyStatusId;
// this.procedure = procedure;
// this.radiologist = radiologist;
// this.physician = physician;
// this.fromDate = fromDate;
// this.examDate = -2;
// this.toDate = toDate;
// this.loggedInUserRoleId = loggedInUserRoleId;
// this.loggedInUserId = loggedInUserId;
//}
public int GetRecordCount()
{
SqlConnection connection = null;
int recCount = 0;
try
{
RISDatabaseAccessLayer dal = new RISDatabaseAccessLayer();
connection = (SqlConnection)dal.GetConnection();
connection.Open();
SqlCommand command = GetQuery(QueryType.COUNT);
command.Connection = connection;
recCount = (int)command.ExecuteScalar();
}
finally
{
if (connection != null) connection.Close();
}
return recCount;
}
public static void BindUserDDLForGroup(int roleId, int groupId,string addText, DropDownList ddl)
{
RISDatabaseAccessLayer dataAccess = new RISDatabaseAccessLayer();
SqlConnection connection = (SqlConnection)dataAccess.GetConnection();
connection.Open();
SqlCommand command = new SqlCommand("sp_get_users_for_role_in_group", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@roleId", roleId);
command.Parameters.AddWithValue("@groupId", groupId);
command.Parameters.AddWithValue("@addText", addText);
SqlDataReader reader = command.ExecuteReader();
ddl.DataSource = reader;
ddl.DataMember = "Name";
ddl.DataTextField = "Name";
ddl.DataValueField = "UserId";
ddl.DataBind();
reader.Close();
connection.Close();
}
protected override void Page_Load_Extended(object sender, EventArgs e)
{
startPage = int.Parse(intStartPage.Value);
endPage = startPage + WebConstants.Pages -1;
if (IsPostBack == false)
{
FillDDL();
if (loggedInUserRoleId == Constants.Roles.Radiologist)
{
lblClient.Visible = true;
ddlClient.Visible = true;
//ddlClient.DataSource
RISDatabaseAccessLayer db = new RISDatabaseAccessLayer();
string query = "select ClientId,Name from tClients";
SqlConnection con = (SqlConnection)db.GetConnection();
SqlCommand cmd = new SqlCommand(query, con);
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
da.SelectCommand = cmd;
da.Fill(dt);
//Populating Drop down list of templates
if (dt.Rows.Count > 0)
{
ddlClient.DataSource = dt;
ddlClient.DataTextField = "Name";
ddlClient.DataValueField = "ClientId";
ddlClient.DataBind();
}
}
}
/*
if (hfCarryStatus.Value.ToString() != "x")
{
string labels = hfCarryStatus.Value.ToString();
string[] labelsArray = labels.Split(',');
foreach (string label in labelsArray)
{
cblStatus.Items.FindByText(label).Selected = true;
}
}
else
{
cblStatus.Items.FindByText("[All]").Selected = true;
statusText.Text = "[All]";
}
if (hfCarryModality.Value.ToString() != "x")
{
string labels = hfCarryModality.Value.ToString();
string[] labelsArray = labels.Split(',');
foreach (string label in labelsArray)
{
cblModality.Items.FindByText(label).Selected = true;
}
}
else
{
cblModality.Items.FindByText("[All]").Selected = true;
modalityText.Text = "[All]";
}
*/
if (Request["hfAction"] != null)
{
if (Request["hfAction"] == "release")
{
if (Request["releaseToRad"] != null)
{
string[] studyIds = Request["releaseToRad"].Split(',');
foreach (string studyId in studyIds)
{
StudyObject study = new StudyObject();
study.StudyId.Value = studyId;
study.Load(loggedInUserId);
if (study.IsLoaded)
{
if (study.HospitalId.Value != null && study.ReferringPhysicianId.Value != null)
{
study.StudyStatusId.Value = Constants.StudyStatusTypes.New;
study.Save(loggedInUserId);
}
else
{
SetErrorMessage("One or more exams could not be released to Radiologists as they have missing data");
}
}
}
}
}
}
ExecuteProcedure();
ClearData();
StringBuilder url = new StringBuilder();
url.Append("http://").Append(Request.Url.Authority);
if(Request.ApplicationPath.Length > 0)
url.Append(Request.ApplicationPath).Append("/");
url.Append("WebServices/");
hfWebServicesHomeURL.Value = url.ToString();
url.Append("FindingService.asmx");
hfSURL.Value = url.ToString();
hfLoggedInUserId.Value = loggedInUserId.ToString();
hfLoggedInUserName.Value = loggedInUser.Name.Value.ToString();
hfLoggedInUserRoleId.Value = loggedInUserRoleId.ToString();
}
