private void InsertNotes() { Notes = Interaction.InputBox("Enter Note:", "TeleRad - Client", " "); string strSQL = ""; string centre = " "; Myconnectionclass CN2 = new Myconnectionclass(); OdbcCommand Cmd2; OdbcDataReader Rs2; CN2.OpenConnection(); Cmd2 = new System.Data.Odbc.OdbcCommand("SELECT * from UserMaster WHERE UserName='******'", CN2.DBConnection); Rs2 = Cmd2.ExecuteReader(); if (Rs2.HasRows) { centre = Rs2["Centre"].ToString(); } Rs2.Close(); Cmd2.Dispose(); CN2.closeconnection(); CN.OpenConnection(); Cmd = new System.Data.Odbc.OdbcCommand("SELECT * from Reports WHERE StudyUID='" + StID + "'", CN.DBConnection); Rs1 = Cmd.ExecuteReader(); if (Rs1.HasRows) { if (Notes.Length <= 0) { strSQL = "UPDATE Reports SET IsNotes=0, Centre='" + centre + "' WHERE StudyUID='" + StID + "'"; } else { strSQL = "UPDATE Reports SET Notes='" + Notes + "', IsNotes=1, Centre='" + centre + "' WHERE StudyUID='" + StID + "'"; } } else { if (Notes.Length <= 0) { strSQL = "INSERT INTO Reports (StudyUID, IsNotes,Centre) VALUES ('" + StID + "',1,'" + centre + "')"; } else { strSQL = "INSERT INTO Reports (StudyUID, Notes, IsNotes,Centre) VALUES ('" + StID + "', '" + Notes + "', 1,'" + centre + "')"; } } Rs1.Close(); Cmd.Dispose(); CN.closeconnection(); CN.OpenConnection(); Cmd = new System.Data.Odbc.OdbcCommand(strSQL, CN.DBConnection); Rs1 = Cmd.ExecuteReader(); Rs1.Close(); Cmd.Dispose(); CN.closeconnection(); MessageBox.Show("Successfully Sent Study", "TeleRad - Client", MessageBoxButtons.OK); }
private void btnViewNotes_Click(object sender, EventArgs e) { if (DataGridView1.SelectedCells[13].Value.ToString() == false.ToString()) { MessageBox.Show("No Notes to view", "TeleRad - Client", MessageBoxButtons.OK); return; } Myconnectionclass CN = new Myconnectionclass(); OdbcCommand Cmd; OdbcDataReader Rs1; CN.OpenConnection(); Cmd = new System.Data.Odbc.OdbcCommand("SELECT * FROM Reports WHERE StudyUID='" + DataGridView1.SelectedCells[5].Value.ToString() + "'", CN.DBConnection); Rs1 = Cmd.ExecuteReader(); Rs1.Read(); if (Convert.ToBoolean(Rs1["IsNotes"]) == true) { MessageBox.Show("Notes sent: " + Rs1["Notes"].ToString(), "TeleRad - Client", MessageBoxButtons.OK); } Rs1.Close(); Cmd.Dispose(); CN.closeconnection(); }