private void DeathManager_FormClosing(object sender, FormClosingEventArgs e) { if (!string.IsNullOrEmpty(textBox1.Text)) { SetUse(int.Parse(textBox1.Text), EnvMethods.GetCurrentUser(), true); } }
private void LinkLabel2_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { if (!string.IsNullOrEmpty(textBox1.Text)) { SetUse(int.Parse(textBox1.Text), EnvMethods.GetCurrentUser(), true); } FillDataGrid(GetCommand(), sfDataGrid1, false); }
private void LinkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { if (!string.IsNullOrEmpty(textBox1.Text)) { SetUse(int.Parse(textBox1.Text), EnvMethods.GetCurrentUser(), true); } Application.Exit(); }
private void SfDataGrid1_CellClick(object sender, Syncfusion.WinForms.DataGrid.Events.CellClickEventArgs e) { if (e.DataRow.RowIndex >= 1) { DisableButtons(); var rowData = sfDataGrid1.GetRecordAtRowIndex(e.DataRow.RowIndex); var propertyCollection = sfDataGrid1.View.GetPropertyAccessProvider(); var id = propertyCollection.GetValue(rowData, "ID").ToString(); var ssn = propertyCollection.GetValue(rowData, "SSN").ToString(); var dod = propertyCollection.GetValue(rowData, "DOD").ToString(); var intId = int.Parse(id); if (!string.IsNullOrEmpty(textBox1.Text) && textBox1.Text != id) { var oldId = int.Parse(textBox1.Text); SetUse(oldId, EnvMethods.GetCurrentUser(), true); } if (DbInteractions.CheckMethods.RecordInUseBy(intId, EnvMethods.GetCurrentUser()) == string.Empty) { SetUse(intId, EnvMethods.GetCurrentUser(), false); textBox1.Text = id; textBox2.Text = ssn; textBox3.Text = dod; GetObitExtras(intId); if (string.IsNullOrEmpty(dod)) { textBox3.ReadOnly = false; } else { textBox3.ReadOnly = true; } var pdQuery = "SELECT AVSRecNo, DateRecd, DOB, PatFName as FName, PatMName as MName, PatLName as LName, ViatorState as 'State', " + "PatientType as Diagnosis, Mortality as '%', PredictionMths AS 'LE', prediction as Comments FROM PersonalData WHERE SSN LIKE @VAL ORDER BY AVSRecNo DESC"; var cmd = new SqlCommand(cmdText: pdQuery); cmd.Parameters.Add("@VAL", SqlDbType.VarChar).Value = ssn; FillDataGrid(cmd, sfDataGrid2, false); } else { CheckUseStatus(intId); } EnableButtons(); } }
private void ComboBox1_SelectedIndexChanged(object sender, EventArgs e) { DisableButtons(); if (!string.IsNullOrEmpty(textBox1.Text)) { SetUse(int.Parse(textBox1.Text), EnvMethods.GetCurrentUser(), true); } var cmd = GetCommand(); // Console.WriteLine(cmd.CommandText); FillDataGrid(cmd, sfDataGrid1, true); EnableButtons(); }
private void NotDeadBtn_Click(object sender, EventArgs e) { DisableButtons(); if (string.IsNullOrEmpty(DbInteractions.CheckMethods.RecordInUseBy(int.Parse(textBox1.Text), EnvMethods.GetCurrentUser()))) { var ignoreReason = new IgnoreReasonDlg(); var dialogResult = ignoreReason.ShowDialog(); if (dialogResult == DialogResult.Cancel) { EnableButtons(); return; } var ignoreText = ignoreReason.IgnoreText; var id = textBox1.Text; var ssn = textBox2.Text; var user = EnvMethods.GetCurrentUser(); var ignoreQuery = "UPDATE tLegacyDeaths SET ignore = 1, SSN = NULL, hasMatch = 0, src = NULL, LastEditedByUser = @USR, " + "ignoreReason = @IGNORE, LastEditedDate = GETDATE() WHERE ID = @ID AND ssn = @SSN"; using (var conn = new SqlConnection(DbInteractions.Utils.GetConn())) { using (var cmd = new SqlCommand(ignoreQuery, conn)) { cmd.CommandType = CommandType.Text; cmd.Parameters.Add("@ID", SqlDbType.Int).Value = id; cmd.Parameters.Add("@SSN", SqlDbType.VarChar).Value = ssn; cmd.Parameters.Add("@USR", SqlDbType.VarChar).Value = user; cmd.Parameters.Add("@IGNORE", SqlDbType.VarChar).Value = ignoreText; cmd.Connection.Open(); cmd.ExecuteNonQuery(); } } MessageBox.Show($"{id} marked as not dead", "Info"); var endCmd = GetCommand(); FillDataGrid(endCmd, sfDataGrid1, true); SetUse(int.Parse(textBox1.Text), EnvMethods.GetCurrentUser(), true); } else { CheckUseStatus(int.Parse(textBox1.Text)); } EnableButtons(); }
private void CheckUseStatus(int recId) { var currentUser = EnvMethods.GetCurrentUser(); var inUseBy = DbInteractions.CheckMethods.RecordInUseBy(recId, currentUser); var msg = $"Record in use by {inUseBy}.\n\n Would you like to remove them from the record?"; if (inUseBy != string.Empty) { var msgBox1Result = MessageBox.Show(msg, "Warning", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation); if (msgBox1Result == DialogResult.Yes) { var msgBox2Result = MessageBox.Show("Are you sure?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (msgBox2Result == DialogResult.Yes) { SetUse(recId, currentUser, false); } } } }
public static void SetDeathPd(string ssn, string dod) { using (var conn = new SqlConnection(Utils.GetConn())) { using (var cmd = new SqlCommand("sp_ViatorDied", conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@SSN", SqlDbType.VarChar).Value = ssn; cmd.Parameters.Add("@Died", SqlDbType.DateTime).Value = dod; cmd.Parameters.Add("@SSADeathMaster", SqlDbType.Bit).Value = 0; cmd.Parameters.Add("@SSDI", SqlDbType.Bit).Value = 0; cmd.Parameters.Add("@Website", SqlDbType.Bit).Value = 0; cmd.Parameters.Add("@WebsiteComment", SqlDbType.VarChar).Value = " "; cmd.Parameters.Add("@Emails", SqlDbType.Bit).Value = 0; cmd.Parameters.Add("@EmailsComment", SqlDbType.VarChar).Value = " "; cmd.Parameters.Add("@Other", SqlDbType.Bit).Value = 1; cmd.Parameters.Add("@OtherComment", SqlDbType.VarChar).Value = $"LDS: {EnvMethods.GetCurrentUser()}"; cmd.Parameters.Add("@UsrName", SqlDbType.VarChar).Value = $"LDS: {EnvMethods.GetCurrentUser()}"; cmd.Parameters.Add("@DMFMatching", SqlDbType.Bit).Value = 0; cmd.Parameters.Add("@SSADeathMasterComment", SqlDbType.VarChar).Value = " "; cmd.Parameters.Add("@DODPriorDateCompleted", SqlDbType.Bit).Value = 0; cmd.Parameters.Add("@Comment", SqlDbType.VarChar).Value = " "; cmd.Parameters.Add("@Comserv", SqlDbType.Bit).Value = 0; // Console.WriteLine(cmd.CommandText); cmd.Connection.Open(); cmd.ExecuteNonQuery(); } } }
private void DeadBtn_Click(object sender, EventArgs e) { DisableButtons(); if (string.IsNullOrEmpty(DbInteractions.CheckMethods.RecordInUseBy(int.Parse(textBox1.Text), EnvMethods.GetCurrentUser()))) { if (string.IsNullOrEmpty(textBox3.Text)) { MessageBox.Show("Please Enter a DOD"); return; } var id = textBox1.Text; var ssn = textBox2.Text; var dod = textBox3.Text + " 00:00:00"; var newCmd = GetCommand(); if (id.Length == 0 || ssn.Length == 0) { MessageBox.Show("Please select a row", "Warning"); } else { var success = false; if (DbInteractions.CheckMethods.IsDead(ssn, ld: false) == false && DbInteractions.CheckMethods.IsDead(ssn, ld: true) == false) { try { DbInteractions.AlterMethods.SetDeathPd(ssn, dod); var legacyQuery = "IF (SELECT DOD FROM tLegacyDeaths WHERE id = 2526679) IS NULL UPDATE tLegacyDeaths SET isDead = 1, ignore = 1, " + "DOD = @DOD, LastEditedDate = GETDATE() WHERE ID = @ID ELSE UPDATE tLegacyDeaths SET isDead = 1, ignore = 1, LastEditedDate = GETDATE() WHERE ID = @ID"; using (var conn = new SqlConnection(DbInteractions.Utils.GetConn())) { using (var cmd = new SqlCommand(cmdText: legacyQuery, conn)) { cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@ID", id); cmd.Parameters.AddWithValue("@DOD", dod); cmd.Connection.Open(); cmd.ExecuteNonQuery(); } } success = true; } catch (Exception ex) { MessageBox.Show(ex.StackTrace, "Critical Error"); MessageBox.Show(ex.Message, "Critical Error"); } finally { if (success) { MessageBox.Show($"{ssn} successfully Marked as dead", "Info"); FillDataGrid(newCmd, sfDataGrid1, true); } } } else if (DbInteractions.CheckMethods.IsDead(ssn, ld: false) == false && DbInteractions.CheckMethods.IsDead(ssn, ld: true)) { MessageBox.Show($"{ssn} is marked as dead in the Legacy Deaths table.\nPlease notify IT.", "Error"); FillDataGrid(newCmd, sfDataGrid1, true); } else if (DbInteractions.CheckMethods.IsDead(ssn, ld: false) && DbInteractions.CheckMethods.IsDead(ssn, ld: true) == false) { MessageBox.Show("The viator is already dead.\nUpdating table...", "Info"); var query = "UPDATE tLegacyDeaths SET isDead = 1 WHERE SSN = @SSN"; using (var conn = new SqlConnection(DbInteractions.Utils.GetConn())) { using (var cmd = new SqlCommand(query, conn)) { cmd.Parameters.AddWithValue("@SSN", ssn); cmd.Connection.Open(); cmd.ExecuteNonQuery(); } } FillDataGrid(newCmd, sfDataGrid1, true); } else { MessageBox.Show("The viator has already been marked as dead", "Info"); FillDataGrid(newCmd, sfDataGrid1, true); } } SetUse(int.Parse(textBox1.Text), EnvMethods.GetCurrentUser(), true); } else { CheckUseStatus(int.Parse(textBox1.Text)); } EnableButtons(); }