protected void BindListView(string selectOrder = "LPAD(ward_name,64)")
{
string query = DataProvider.Wards.fillListView(selectOrder);
DataTable dt = HospitalClass.getDataTable(query);
BindListView(dt);
}
protected void EmailButton_Click(object sender, EventArgs e)
{
try
{
string emailInfo = DataProvider.ChangePassword.getEmailPassword(EmailBox.Text.Trim().ToUpper()); //get user's email
DataTable dt = HospitalClass.getDataTable(emailInfo);
if (dt.Rows.Count > 0)
{
string firstName = HospitalClass.PascalCasing(dt.Rows[0][0].ToString());
string userId = dt.Rows[0][1].ToString();
string password = HospitalClass.Decrypt(dt.Rows[0][2].ToString());
string message = string.Format("Good day user {0}.\r\n\r\nYour user Id is: {1}\r\nYour password is: {2}", firstName, userId, password);
MailMessage myMessage = new MailMessage();
myMessage.Body = message;
//myMessage.From = new MailAddress(EmailBox.Text, UsernameBox.Text); //Unneccesary, set at web.config
myMessage.To.Add(new MailAddress(EmailBox.Text.Trim()));
SmtpClient mySender = new SmtpClient();
mySender.Send(myMessage); //uses config file settings to send message
string updaterId = "",
updateCode = "PWD_SND";
if (Session["SuperUser"] != null)
{
updaterId = (string)Session["SuperUser"];
}
else if (Session["Admin"] != null)
{
updaterId = (string)Session["Admin"];
}
else
{
updaterId = (string)Session["User"];
}
List <string> values = new List <string>();
values.Add(HospitalClass.getTransactionId());
values.Add(updateCode);
values.Add(updaterId);
values.Add((string)Session["User"]);
int status = DataConsumer.executeProcedure("audit_trail_proc", values);
EmailLabel.CssClass = "success normal";
EmailLabel.Text = "Successful.<br/>Check your E-mail box for details.";
}
else
{
EmailLabel.CssClass = "error paraNormal";
if (EmailBox.Text.Length == 0)
{
EmailLabel.Text = "Please enter an email";
}
else
{
EmailLabel.Text = "Email does not exist";
}
}
}
catch (Exception ex)
{
EmailLabel.CssClass = "error paraNormal";
EmailLabel.Text = "Error: " + ex.Message;
}
}
protected void DiscAllButton_Click(object sender, EventArgs e)
{
string updaterId = "",
updateCode = "DISC_DWA";
if (Session["SuperUser"] != null)
{
updaterId = (string)Session["SuperUser"];
}
else
{
updaterId = (string)Session["Admin"];
}
List <string> values = new List <string>();
values.Add(DeptNameLabel.Text);
values.Add("");
values.Add(HospitalClass.getTransactionId());
values.Add(updateCode);
values.Add(updaterId);
values.Add("all");
int status = DataConsumer.executeProcedure("dept_ward_disc", values);
StatusLabel.CssClass = "success";
StatusLabel.Text = "Successful removal.<br/>Department name: " + DeptNameLabel.Text + ".<br/>Number of wards removed: " +
ListView1.Items.Count;
BindListView();
CancelButton_Click(new object(), new EventArgs());
}
private void BindListView(string selectOrder = "to_number(trans_id) desc")
{
SqlDataSource1.ConnectionString = HospitalClass.getConnectionString().Substring(0, 60);
SqlDataSource1.ProviderName = "System.Data.OracleClient";
SqlDataSource1.SelectCommand = DataProvider.DeleteInformationPage.getGeneralInfo(selectOrder);
ListView1.DataSourceID = "SqlDataSource1";
ListView1.DataBind();
}
protected void BindListView()
{
SqlDataSource1.ConnectionString = HospitalClass.getConnectionString().Substring(0, 60);
SqlDataSource1.ProviderName = "System.Data.OracleClient";
SqlDataSource1.SelectCommand = DataProvider.DiscDeptWard.addWardsToListView(DeptNameLabel.Text);
ListView1.DataSourceID = "SqlDataSource1";
ListView1.DataBind();
}
protected void BindListView(string selectOrder = "dept_name")
{
SqlDataSource1.ConnectionString = HospitalClass.getConnectionString().Substring(0, 60);
SqlDataSource1.ProviderName = "System.Data.OracleClient";
SqlDataSource1.SelectCommand = DataProvider.Departments.fillListView(selectOrder);
ListView1.DataSourceID = "SqlDataSource1";
ListView1.DataBind();
}
protected void LogOutLinkButton_Click(object sender, EventArgs e)
{
string updateCode = "",
updaterId = "",
userId = "";
//set update code
if (Session["User"].ToString().StartsWith("SUP"))
{
updateCode = "SUP_LGO";
}
else if (Session["User"].ToString().StartsWith("ADM"))
{
updateCode = "ADM_LGO";
}
else if (Session["User"].ToString().StartsWith("DC"))
{
updateCode = "DOC_LGO";
}
else if (Session["User"].ToString().StartsWith("ST"))
{
updateCode = "STF_LGO";
}
else
{
updateCode = "PAT_LGO";
}
//set updater id
if (Session["SuperUser"] != null)
{
updaterId = Session["SuperUser"].ToString();
}
else if (Session["Admin"] != null)
{
updaterId = Session["Admin"].ToString();
}
else
{
updaterId = Session["User"].ToString();
}
//set user id
userId = Session["User"].ToString();
//dispose sessions
Session["SuperUser"] = null;
Session["Admin"] = null;
Session["User"] = null;
List <string> values = new List <string>();
values.Add(HospitalClass.getTransactionId());
values.Add(updateCode);
values.Add(updaterId);
values.Add(userId);
int status = DataConsumer.executeProcedure("audit_trail_proc", values);
Response.Redirect("~/Login.aspx");
}
protected void populateDeptList()
{
string getDeptsQuery = DataProvider.DiscDeptWard.getDepartments();
DataTable dt = HospitalClass.getDataTable(getDeptsQuery);
DeptList.DataSource = dt;
DeptList.DataTextField = "DEPT_NAME";
DeptList.DataBind();
DeptList.Items.Insert(0, new ListItem("Please select..."));
}
protected void populateWardList()
{
string getWardsQuery = DataProvider.RelDeptWardPage.getWards();
DataTable dt = HospitalClass.getDataTable(getWardsQuery);
WardList.DataSource = dt;
WardList.DataTextField = "WARD_NAME";
WardList.DataBind();
WardList.Items.Insert(0, new ListItem("Please select..."));
}
protected void DeleteButton_Click(object sender, EventArgs e)
{
try
{
addDelDiv.Visible = false;
if (ListView1.SelectedIndex >= 0)
{
string deptName = ((Label)ListView1.Items[ListView1.SelectedIndex].FindControl("DeptNameLabel")).Text;
if (((Label)ListView1.Items[ListView1.SelectedIndex].FindControl("DeptWardsLabel")).Text == "0")
{
string updaterId = "",
updateCode = "DEPT_DEL";
if (Session["SuperUser"] != null)
{
updaterId = (string)Session["SuperUser"];
}
else
{
updaterId = (string)Session["Admin"];
}
List <string> values = new List <string>();
values.Add("");
values.Add(deptName);
values.Add("");
values.Add("");
values.Add(HospitalClass.getTransactionId());
values.Add(updateCode);
values.Add(updaterId);
values.Add("delete");
int status = DataConsumer.executeProcedure("dept_proc", values);
StatusLabel.CssClass = "success normal";
StatusLabel.Text = "Successful department deletion.<br>Department Id: " + ((Label)ListView1.Items[ListView1.SelectedIndex].FindControl("DeptIdLabel")).Text +
"<br/>Department Name: " + deptName + ".";
SortButton_Click(new object(), new EventArgs());
}
else
{
StatusLabel.CssClass = "error normal";
StatusLabel.Text = "This department is already linked to ward(s).<br/>Disconnect/Unrelate before deleting.";
}
}
else
{
StatusLabel.CssClass = "error paraNormal";
StatusLabel.Text = "No item selected for deletion";
}
ListView1.SelectedIndex = -1;
}
catch (Exception ex)
{
StatusLabel.CssClass = "error paraNormal";
StatusLabel.Text = "Error: " + ex.Message;
HospitalClass.Log(ex);
}
}
protected void DivAddButton_Click(object sender, EventArgs e)
{
if (DivOrganList.SelectedIndex != 0 && DivDescBox.Text.Length > 2 && DivStatusList.SelectedIndex != 0 && DivUserIdBox.Text.StartsWith("PAT"))
{
string updaterId = "",
updateCode = "DISB_ADD";
if (Session["SuperUser"] != null)
{
updaterId = (string)Session["SuperUser"];
}
else
{
updaterId = (string)Session["Admin"];
}
List <string> values = new List <string>();
values.Add(DivOrganList.SelectedItem.Text);
values.Add(DivDescBox.Text);
values.Add(DivStatusList.SelectedItem.Text);
values.Add(HospitalClass.getTransactionId());
values.Add(updateCode);
values.Add(updaterId);
values.Add(DivUserIdBox.Text);
values.Add("insert");
int status = DataConsumer.executeProcedure("pat_disab_proc", values);
DivStatusLabel.CssClass = "success normal";
DivStatusLabel.Text = "Successfully added.<br/>Patient Id: " + DivUserIdBox.Text + ". <br/>Affected Organ: " + DivOrganList.SelectedItem.Text;
StatusLabel.CssClass = "success paraNormal";
StatusLabel.Text = "Done";
BindListView();
BindSearchListView();
}
else
{
StatusLabel.CssClass = "error paraNormal";
StatusLabel.Text = "User input error below";
DivStatusLabel.CssClass = "error paraNormal";
if (!DivUserIdBox.Text.StartsWith("PAT"))
{
DivStatusLabel.Text = "This user is not a patient. Please login using patient id";
}
else if (DivOrganList.SelectedIndex == 0)
{
DivStatusLabel.Text = "Please select an organ";
}
else if (DivDescBox.Text.Length <= 2)
{
DivStatusLabel.Text = "Please enter a valid description";
}
else
{
DivStatusLabel.Text = "Please select a status";
}
}
ListView1.SelectedIndex = -1;
}
protected void DeleteButton_Click(object sender, EventArgs e)
{
if (ListView1.SelectedIndex >= 0)
{
string updaterId = "",
updateCode = "";
if (Session["SuperUser"] != null)
{
updaterId = (string)Session["SuperUser"];
}
else
{
updaterId = (string)Session["Admin"];
}
if (RoleList.SelectedIndex == 0)
{
updateCode = "DOC_WKDL";
}
else
{
updateCode = "STF_WKDL";
}
List <string> values = new List <string>();
values.Add(((Label)ListView1.Items[ListView1.SelectedIndex].FindControl("WorkPlaceLabel")).Text);
values.Add("");
values.Add(((Label)ListView1.Items[ListView1.SelectedIndex].FindControl("PositionLabel")).Text);
values.Add("");
values.Add("");
values.Add(HospitalClass.getTransactionId());
values.Add(updateCode);
values.Add(updaterId);
values.Add(((Label)ListView1.Items[ListView1.SelectedIndex].FindControl("UserIdLabel")).Text);
if (RoleList.SelectedIndex == 0)
{
values.Add("doc delete");
}
else
{
values.Add("stf delete");
}
int status = DataConsumer.executeProcedure("docstf_wk_proc", values);
StatusLabel.CssClass = "success paraNormal";
StatusLabel.Text = "Successfully deleted";
BindListView();
BindSearchListView();
}
else
{
StatusLabel.CssClass = "error paraNormal";
StatusLabel.Text = "No item selected for deletion";
}
ListView1.SelectedIndex = -1;
}
/// <summary>
/// Execute create, update, delete and other non-selecting queries
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public static int executeQuery(string query)
{
using (OracleConnection con = new OracleConnection(HospitalClass.getConnectionString()))
{
using (OracleCommand cmd = new OracleCommand(query, con))
{
con.Open();
cmd.CommandType = CommandType.Text; //default
return(cmd.ExecuteNonQuery());
}
}
}
protected void ChangeButton_Click(object sender, EventArgs e)
{
try
{
string checkPassword = DataProvider.ChangePassword.getPassword(Session["User"].ToString()); //get the former password and check
DataTable dt = HospitalClass.getDataTable(checkPassword);
if (dt.Rows[0][0].ToString() == HospitalClass.Encrypt(OldPasswordBox.Text) && OldPasswordBox.Text != NewPasswordBox.Text)
{
string updaterId = "",
updateCode = "PWD_CHG";
if (Session["SuperUser"] != null)
{
updaterId = (string)Session["SuperUser"];
}
else if (Session["Admin"] != null)
{
updaterId = (string)Session["Admin"];
}
else
{
updaterId = (string)Session["User"];
}
List <string> values = new List <string>();
values.Add(HospitalClass.Encrypt(NewPasswordBox.Text));
values.Add(HospitalClass.getTransactionId());
values.Add(updateCode);
values.Add(updaterId);
values.Add((string)Session["User"]);
int status = DataConsumer.executeProcedure("pwd_change", values);
UserStatusLabel.CssClass = "success paraNormal";
UserStatusLabel.Text = "Password was successfully changed";
}
else
{
UserStatusLabel.CssClass = "error normal";
if (OldPasswordBox.Text == NewPasswordBox.Text)
{
UserStatusLabel.Text = "Same password entered";
}
else
{
UserStatusLabel.Text = "Wrong password entered.<br/>Meet the system administrator for assistance";
}
}
}
catch (Exception ex)
{
UserStatusLabel.CssClass = "error paraNormal";
UserStatusLabel.Text = "Error: " + ex.Message;
HospitalClass.Log(ex);
}
}
public void BindSearchListView()
{
SearchDiv.Visible = true;
SearchUserIdLabel.Text = "";
SearchNameLabel.Text = "";
SearchStatusLabel.CssClass = "error";
if (SearchBox.Text.Trim().Length == 11 && ((SearchBox.Text.Trim().ToUpper().StartsWith("DC") && RoleList.SelectedIndex == 0) ||
SearchBox.Text.Trim().ToUpper().StartsWith("ST") && RoleList.SelectedIndex == 1))
{
SearchListView.Visible = true;
SqlDataSource2.ConnectionString = HospitalClass.getConnectionString().Substring(0, 60);
SqlDataSource2.ProviderName = "System.Data.OracleClient";
if (RoleList.SelectedIndex == 0)
{
SqlDataSource2.SelectCommand = DataProvider.DoctorStaffHistory.fillListViewDoc(SearchBox.Text.Trim().ToUpper());
}
else
{
SqlDataSource2.SelectCommand = DataProvider.DoctorStaffHistory.fillListViewStf(SearchBox.Text.Trim().ToUpper());
}
SearchListView.DataSourceID = "SqlDataSource2";
SearchListView.DataBind();
if (SearchListView.Items.Count == 0)
{
SearchStatusLabel.Text = "Not found";
}
else
{
completeAction();
}
}
else
{
SearchListView.Visible = false;
if (SearchBox.Text.Trim().Length == 0)
{
SearchStatusLabel.Text = "No value entered";
}
else if (SearchBox.Text.Trim().ToUpper().StartsWith("DC"))
{
SearchStatusLabel.Text = "Invalid staff id";
}
else if (SearchBox.Text.Trim().ToUpper().StartsWith("ST"))
{
SearchStatusLabel.Text = "Invalid doctor id";
}
else
{
SearchStatusLabel.Text = "Invalid employee Id";
}
}
}
protected void DeptAddButton_Click(object sender, EventArgs e)
{
try
{
DeptAddLabel.CssClass = "error";
string checkQuery = DataProvider.DeptWardPage.verifyDeptAdd(DeptAddNameBox.Text);
DataTable dt = HospitalClass.getDataTable(checkQuery);
if (DeptAddNameBox.Text.Trim().Length > 2 && DeptAddDescBox.Text.Trim().Length > 3 && dt.Rows.Count == 0)
{
string updateCode = "DEPT_ADD";
string updaterId = "";
if (Session["SuperUser"] != null)
{
updaterId = Session["SuperUser"].ToString();
}
else
{
updaterId = Session["Admin"].ToString();
}
List <string> values = new List <string>();
values.Add(DeptAddNameBox.Text.Trim());
values.Add(DeptAddDescBox.Text);
values.Add(updateCode);
values.Add(updaterId);
values.Add("insert");
int status = DataConsumer.executeProcedure("add_del_dept", values);
DeptAddLabel.CssClass = "success";
DeptAddLabel.Text = "Operation Successful.<br/>Department added: " + DeptAddNameBox.Text.Trim();
populateLists();
}
else
{
if (dt.Rows.Count != 0)
{
DeptAddLabel.Text = "This department exists";
}
else if (DeptAddNameBox.Text.Trim().Length <= 2)
{
DeptAddLabel.Text = "Enter a valid department name";
}
else
{
DeptAddLabel.Text = "Enter a valid department description";
}
}
}
catch (Exception ex)
{
DeptAddLabel.Text = "Error: " + ex.Message;
HospitalClass.Log(ex);
}
}
/// <summary>
/// Sends a picture encoded as a byte array to the database
/// </summary>
/// <param name="query"></param>
/// <param name="a"></param>
/// <returns></returns>
public static int sendPictureToDatabase(string query, byte[] a)
{
using (OracleConnection con = new OracleConnection(HospitalClass.getConnectionString()))
{
using (OracleCommand cmd = new OracleCommand(query, con))
{
con.Open();
cmd.Parameters.AddWithValue("image", a);
int rowsAffected = cmd.ExecuteNonQuery();
return(rowsAffected);
}
}
}
protected void getPasswordButton_Click(object sender, EventArgs e)
{
try
{
string getPassword = DataProvider.ChangePassword.getPassword(UserIdBox.Text.Trim().ToUpper()); //get the user's password
DataTable dt = HospitalClass.getDataTable(getPassword);
if (UserIdBox.Text.Trim().Length == 6 || UserIdBox.Text.Trim().Length == 11 && dt.Rows.Count > 0) //unnecessary due to access restrictions
{
string updaterId = "",
updateCode = "PWD_GET";
if (Session["SuperUser"] != null)
{
updaterId = (string)Session["SuperUser"];
}
else
{
updaterId = (string)Session["Admin"];
}
List <string> values = new List <string>();
values.Add(HospitalClass.getTransactionId());
values.Add(updateCode);
values.Add(updaterId);
values.Add(UserIdBox.Text.Trim().ToUpper());
int status = DataConsumer.executeProcedure("audit_trail_proc", values);
PasswordStatusLabel.CssClass = "success paraNormal";
PasswordStatusLabel.Text = "Your password is: " + HospitalClass.Decrypt(dt.Rows[0][0].ToString()); //display password
}
else
{
PasswordStatusLabel.CssClass = "error paraNormal";
if (dt.Rows.Count == 0)
{
PasswordStatusLabel.Text = UserIdBox.Text.Trim().ToUpper() + " is not a user on this system";
}
else if (UserIdBox.Text.Length == 0)
{
PasswordStatusLabel.Text = "User Id cannot be empty";
}
else
{
PasswordStatusLabel.Text = UserIdBox.Text.Trim().ToUpper() + " is not a valid id";
}
}
}
catch (Exception ex)
{
UserStatusLabel.CssClass = "error paraNormal";
UserStatusLabel.Text = "Error: " + ex.Message;
HospitalClass.Log(ex);
}
}
public void completeAction()
{
System.Data.DataTable nameDt = HospitalClass.getDataTable(DataProvider.Patients.getName(SearchBox.Text.Trim().ToUpper()));
SearchNameLabel.Text = "Name: " + HospitalClass.PascalCasing(nameDt.Rows[0][0].ToString()) + ", " +
HospitalClass.PascalCasing(nameDt.Rows[0][1].ToString());
if (!DBNull.Value.Equals(nameDt.Rows[0][2]))
{
SearchNameLabel.Text += " " + HospitalClass.PascalCasing(nameDt.Rows[0][2].ToString());
}
SearchNameLabel.Text += "<br/>User Id: ";
SearchUserIdLabel.Text = SearchBox.Text.Trim().ToUpper();
SearchStatusLabel.CssClass = "success";
SearchStatusLabel.Text = "Found";
}
/// <summary>
/// Returns the last transaction Id + 1 from the audit trail
/// </summary>
/// <returns></returns>
internal static string getTransactionId()
{
string lastId = DataProvider.GeneralClass.getLastTransactionId();
DataTable dt = HospitalClass.getDataTable(lastId);
if (dt.Rows[0][0].ToString() == "")
{
return("1");
}
else
{
int newId = int.Parse(dt.Rows[0][0].ToString()) + 1;
return(newId.ToString());
}
}
protected void SubmitButton_Click(object sender, EventArgs e)
{
string checkTopicExist = DataProvider.AddInformationPage.checkTopic(TopicBox.Text.Trim());
DataTable dt = HospitalClass.getDataTable(checkTopicExist);
if ((UserIdBox.Text.Length >= 3 && UserIdBox.Text.Length <= 32) && (TopicBox.Text.Trim().Length >= 2 && TopicBox.Text.Length <= 32) &&
(InfoBox.Text.Length >= 4 && InfoBox.Text.Length <= 256) && RecipientList.SelectedIndex != 0 && dt.Rows.Count == 0)
{
List <string> values = new List <string>();
values.Add(InfoBox.Text);
values.Add(RecipientList.SelectedItem.Value);
values.Add(HospitalClass.PascalCasing(TopicBox.Text.Trim()));
values.Add(HospitalClass.getTransactionId());
values.Add("INFO_ADD");
values.Add(UpdaterId());
values.Add(UserIdBox.Text);
values.Add("");
values.Add("insert");
int status = DataConsumer.executeProcedure("info_proc", values);
StatusLabel.CssClass = "success";
StatusLabel.Text = "Successful.<br/>Updater: " + UpdaterId() + ".";
}
else
{
StatusLabel.CssClass = "error";
if (dt.Rows.Count != 0)
{
StatusLabel.Text = "This topic already exists. Choose another topic name";
}
else if (RecipientList.SelectedIndex == 0)
{
StatusLabel.Text = "Please select a recipient classification";
}
else if (!(UserIdBox.Text.Length >= 3 && UserIdBox.Text.Length <= 32))
{
StatusLabel.Text = "Please enter a valid user Id.<br/>Between 6 and 32 characters";
}
else if ((TopicBox.Text.Length >= 2 && TopicBox.Text.Length <= 32))
{
StatusLabel.Text = "Please enter a valid topic.<br/>Between 2 and 32 characters";
}
else
{
StatusLabel.Text = "Please enter valid information.<br/>Between 4 and 256 characters";
}
}
}
/// <summary>
/// Executes a procedure with given input values as a generic string list
/// </summary>
/// <param name="procedureName"></param>
/// <param name="values"></param>
/// <returns></returns>
public static int executeProcedure(string procedureName, List <string> values)
{
using (OracleConnection con = new OracleConnection(HospitalClass.getConnectionString()))
{
using (OracleCommand cmd = new OracleCommand(procedureName, con))
{
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
for (int i = 1; i <= values.Count; i++)
{
cmd.Parameters.AddWithValue("param" + i, values[i - 1]).Direction = ParameterDirection.Input;
}
int rowsAffected = cmd.ExecuteNonQuery();
return(rowsAffected);
}
}
}
protected void DeptDelButton_Click(object sender, EventArgs e)
{
try
{
if (DeptDelList.SelectedIndex != 0 && DeptDelCheckBox.Checked)
{
string updateCode = "DEPT_DEL";
string updaterId = "";
if (Session["SuperUser"] != null)
{
updaterId = Session["SuperUser"].ToString();
}
else
{
updaterId = Session["Admin"].ToString();
}
List <string> values = new List <string>();
values.Add(DeptDelList.SelectedItem.Text);
values.Add("X");
values.Add(updateCode);
values.Add(updaterId);
values.Add("delete");
int status = DataConsumer.executeProcedure("add_del_dept", values);
DeptDelLabel.CssClass = "success";
DeptDelLabel.Text = "Operation Successful.<br/>Department deleted: " + DeptDelList.SelectedItem.Text;
populateLists();
}
else
{
DeptDelLabel.CssClass = "error";
if (DeptDelList.SelectedIndex == 0)
{
DeptDelLabel.Text = "Please select a department to delete";
}
else
{
DeptDelLabel.Text = "Please tick the checkbox to enforce deletion";
}
}
}
catch (Exception ex)
{
DeptDelLabel.Text = "Error: " + ex.Message;
HospitalClass.Log(ex);
}
}
protected void BindListView()
{
SqlDataSource1.ConnectionString = HospitalClass.getConnectionString().Substring(0, 60);
SqlDataSource1.ProviderName = "System.Data.OracleClient";
if (RoleList.SelectedIndex == 0)
{
SqlDataSource1.SelectCommand = DataProvider.DoctorStaffHistory.fillListViewDoc();
NameLabel.Text = "Work History (All Doctors)";
HeadLabel.Text = "Doctor's Employment History";
}
else
{
SqlDataSource1.SelectCommand = DataProvider.DoctorStaffHistory.fillListViewStf();
NameLabel.Text = "Work History (All Staff)";
HeadLabel.Text = "Staff's Employment History";
}
ListView1.DataSourceID = "SqlDataSource1";
ListView1.DataBind();
}
protected void RoleList_SelectedIndexChanged(object sender, EventArgs e)
{
if (RoleList.SelectedIndex == 0)
{
StatusLabel.Text = "Please select a a role (or update user information)";
}
else if (RoleList.SelectedIndex == 3)
{
UserIdBox.Text = Session["User"].ToString();
if (Session["User"].ToString().StartsWith("ADM") || Session["User"].ToString().StartsWith("SUP"))
{
Populate();
}
else
{
ValidateButton.Visible = false;
StatusLabel.Text = "This user's information cannot be updated here.<br/>Go to user profile page";
}
}
else
{
//redundant except if an administrator can register other administrators
if (Session["SuperUser"] == null && RoleList.SelectedIndex == 1)
{
StatusLabel.CssClass = "error paraNormal";
StatusLabel.Text = "You cannot register this user";
ValidateButton.Visible = false;
}
string lastIdQuery = "";
if (RoleList.SelectedIndex == 1)
{
lastIdQuery = DataProvider.RegistrationPage.LastIdQuery("SUP"); //returns an empty string for no value
}
else
{
lastIdQuery = DataProvider.RegistrationPage.LastIdQuery("ADM");
}
DataTable lastDt = HospitalClass.getDataTable(lastIdQuery);
UserIdBox.Text = getNewSuperuserAdminId(lastDt);
ClearAll();
}
}
protected void RelateButton_Click(object sender, EventArgs e)
{
string updaterId = "",
updateCode = "DEPT_WRD";
if (Session["SuperUser"] != null)
{
updaterId = (string)Session["SuperUser"];
}
else
{
updaterId = (string)Session["Admin"];
}
List <string> values = new List <string>();
for (int i = 0; i < ListView1.Items.Count; i++)
{
values.Add(DeptNameLabel.Text);
values.Add(((Label)ListView1.Items[i].FindControl("WardNameLabel")).Text);
values.Add("");
values.Add("");
values.Add("");
values.Add("add");
int status = DataConsumer.executeProcedure("dept_ward_rel", values);
values.Clear();
}
values.Add(DeptNameLabel.Text);
values.Add("");
values.Add(HospitalClass.getTransactionId());
values.Add(updateCode);
values.Add(updaterId);
values.Add("final");
int statusFinal = DataConsumer.executeProcedure("dept_ward_rel", values);
StatusLabel.CssClass = "success";
StatusLabel.Text = "Successful relationship.<br/>Department Name: " + DeptNameLabel.Text + "<br/>Ward added: " +
ListView1.Items.Count.ToString() + ".";
clearWardTemp();
DeptNameLabel.Text = "";
noDeptSelected();
populateDeptList();
}
protected void DiscOneButton_Click(object sender, EventArgs e)
{
if (ListView1.SelectedIndex >= 0)
{
string updaterId = "",
updateCode = "DISC_DW1";
if (Session["SuperUser"] != null)
{
updaterId = (string)Session["SuperUser"];
}
else
{
updaterId = (string)Session["Admin"];
}
List <string> values = new List <string>();
values.Add(DeptNameLabel.Text);
values.Add(((Label)ListView1.Items[ListView1.SelectedIndex].FindControl("WardNameLabel")).Text);
values.Add(HospitalClass.getTransactionId());
values.Add(updateCode);
values.Add(updaterId);
values.Add("one");
int status = DataConsumer.executeProcedure("dept_ward_disc", values);
StatusLabel.CssClass = "success";
StatusLabel.Text = "Successful removal.<br/>Disconnected ward name: " +
((Label)ListView1.Items[ListView1.SelectedIndex].FindControl("WardNameLabel")).Text;
BindListView();
if (ListView1.Items.Count <= 0)
{
CancelButton_Click(new object(), new EventArgs());
}
}
else
{
StatusLabel.CssClass = "error paraNormal";
if (ListView1.SelectedIndex < 0)
{
StatusLabel.Text = "No item selected for disconnection/unrelation";
}
}
ListView1.SelectedIndex = -1;
}
protected void DeleteButton_Click(object sender, EventArgs e)
{
if (ListView1.SelectedIndex >= 0)
{
string topic = ((Label)ListView1.Items[ListView1.SelectedIndex].FindControl("TopicLabel")).Text;
List <string> values = new List <string>();
values.Add(topic);
values.Add(HospitalClass.getTransactionId());
values.Add("INFO_DEL");
values.Add(UpdaterId());
int status = DataConsumer.executeProcedure("info_del_proc", values);
TopicDelLabel.CssClass = "success";
TopicDelLabel.Text = "Topic Deleted: " + topic;
SortButton_Click(new object(), new EventArgs());
}
else
{
TopicDelLabel.CssClass = "error paraNormal";
TopicDelLabel.Text = "No item selected for deletion";
}
}
protected void StaffRadioButton_CheckedChanged(object sender, EventArgs e)
{
try
{
InfoDiv.Visible = true;
DocRoleTable.Visible = false;
StfRoleTable.Visible = true;
RegLabel.Text = "Staff's Registration Page";
string stfQuery = DataProvider.RegistrationPage.StfListQuery();
DataTable dt = HospitalClass.getDataTable(stfQuery); //populate drop down list for staffs
StfRoleList.DataSource = dt;
StfRoleList.DataTextField = "DESCRIPTION";
StfRoleList.DataValueField = "ROLE_ID";
StfRoleList.DataBind();
StfRoleList.Items.Insert(0, new ListItem("Please select..."));
}
catch (Exception ex)
{
StatusLabel.Text = "Error: " + ex.Message;
HospitalClass.Log(ex);
}
}
protected void DeptSelectButton_Click(object sender, EventArgs e)
{
if (DeptList.SelectedIndex != 0)
{
deptSelected();
string getDeptTableInfoQuery = DataProvider.DiscDeptWard.getDeptInfo(DeptList.SelectedItem.Text);
DataTable dt = HospitalClass.getDataTable(getDeptTableInfoQuery);
DeptIdLabel.Text = dt.Rows[0]["DEPT_ID"].ToString();
DeptNameLabel.Text = dt.Rows[0]["DEPT_NAME"].ToString();
DeptDescLabel.Text = dt.Rows[0]["DESCRIPTION"].ToString();
CancelButton.Visible = true;
BindListView();
StatusLabel.CssClass += " addColor";
StatusLabel.Text = "choose wards to be unrelated from table above";
}
else
{
StatusLabel.CssClass = "error";
StatusLabel.Text = "Please select a department";
}
ListView1.SelectedIndex = -1;
}
