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