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; }