private void Command1_Click(object sender, EventArgs e) { nowConnected = false; CN.OpenConnection(); cmd = new System.Data.Odbc.OdbcCommand("SELECT * FROM UserMaster WHERE UserName='******' AND EncodedPass='******'", CN.DBConnection); Rs1 = cmd.ExecuteReader(); if (Rs1.HasRows) { modMain.UID = txtUser.Text; Rs1.Close(); CN.closeconnection(); RetrieveDialogType frmRet = new RetrieveDialogType(); frmRet.Show(); this.Hide(); } else { Rs1.Close(); CN.closeconnection(); MessageBox.Show("Invalid Login"); txtUser.Focus(); txtUser.SelectionStart = 0; txtUser.SelectionLength = txtUser.Text.Length; } }
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 btnSendNotes_Click(object sender, EventArgs e) { if (DataGridView1.SelectedCells[14].Value.ToString() == true.ToString()) { MessageBox.Show("Report is ready, so you cannot Send / Resend Notes anymore", "TeleRad - Client", MessageBoxButtons.OK); return; } String Notes = ""; Notes = Interaction.InputBox("Enter Note:", "TeleRad - Client", " "); string strSQL = ""; CN.OpenConnection(); Cmd = new System.Data.Odbc.OdbcCommand("SELECT * from Reports WHERE StudyUID='" + DataGridView1.SelectedCells[5].Value.ToString() + "'", CN.DBConnection); Rs1 = Cmd.ExecuteReader(); if (Rs1.HasRows) { if (Notes.Length <= 0) { strSQL = "UPDATE Reports SET IsNotes=0 WHERE StudyUID='" + DataGridView1.SelectedCells[5].Value.ToString() + "'"; } else { strSQL = "UPDATE Reports SET Notes='" + Notes + "', IsNotes=1 WHERE StudyUID='" + DataGridView1.SelectedCells[5].Value.ToString() + "'"; } } else { if (Notes.Length <= 0) { strSQL = "INSERT INTO Reports (StudyUID, IsNotes) VALUES ('" + DataGridView1.SelectedCells[5].Value.ToString() + "',1)"; } else { strSQL = "INSERT INTO Reports (StudyUID, Notes, IsNotes) VALUES ('" + DataGridView1.SelectedCells[5].Value.ToString() + "', '" + Notes + "', 1)"; } } 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); btnRefresh_Click(this, e); }
public bool Show_Reports() { if (string.IsNullOrEmpty(TeleRadPush.modMain.StudyID)) { //MessageBox.Show("Please select any DICOM Image", "TeleRad-Client", MessageBoxButtons.OK) return(true); } CN.OpenConnection(); Cmd = new System.Data.Odbc.OdbcCommand("SELECT * FROM Reports WHERE StudyUID='" + TeleRadPush.modMain.StudyID + "'", CN.DBConnection); Rs1 = Cmd.ExecuteReader(); Rs1.Read(); if (Rs1["IsReports"].ToString() == true.ToString()) { txtReports.Rtf = Rs1["Reports"].ToString(); } else { txtReports.Text = ""; } Rs1.Close(); Cmd.Dispose(); CN.closeconnection(); return(true); }
private void btnToday_Click(object sender, EventArgs e) { CN1.OpenConnection(); CMD1 = new System.Data.Odbc.OdbcCommand("select * from PatientStudyView where datepart(dd,StudyDate)=" + DateTime.Now.Day.ToString() + " and datepart(MM,StudyDate)=" + DateTime.Now.Month.ToString() + " and datepart(yy,StudyDate)=" + DateTime.Now.Year.ToString() + "", CN1.DBConnection); //Dim dtst As New DataSet DicomServerDBDataSet1.PatientStudyViewDataTable table = new DicomServerDBDataSet1.PatientStudyViewDataTable(); System.Data.Odbc.OdbcDataAdapter adptr = new System.Data.Odbc.OdbcDataAdapter(); adptr.SelectCommand = CMD1; adptr.Fill(table); DataGridView1.Refresh(); DataGridView1.DataSource = null; DataGridView1.DataSource = table; this.Cursor = Cursors.Default; GridDesign(); CMD1.Dispose(); CN1.closeconnection(); }
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(); }