private void frm_Ultrasound_FormClosing(object sender, FormClosingEventArgs e) { fmain.Ultrasount = true; fmain.ts_PrintPreview_Ultra.Enabled = false; fmain.ts_add_ultrasound.Enabled = true; fmain.ts_edit_ultrasound.Enabled = false; fmain.ts_delete_ultrasound.Enabled = false; fmain.ts_save_ultrasound.Enabled = false; fmain.ts_cancel_ultrasound.Enabled = false; fmain.ts_search_ultrasound.Enabled = true; fmain.ts_print_ultrasound.Enabled = false; ClassSql.DbClose(); // fmain.Strip_sub.Visible = false; }
private void frm_patientInfo_FormClosing(object sender, FormClosingEventArgs e) { ClassSql.DbClose(); fmain.f_PatientInfo = true; fmain.ts_add_profile.Enabled = true; fmain.ts_edit_profile.Enabled = true; fmain.ts_del_profile.Enabled = true; fmain.ts_save_profile.Enabled = false; fmain.ts_search_profile.Enabled = true; fmain.ts_print_profile.Enabled = false; fmain.ts_cancel_profile.Enabled = false; fmain.ts_First_Record.Enabled = true; fmain.ts_prev_record.Enabled = true; fmain.ts_next_Record.Enabled = true; fmain.ts_last_Record.Enabled = true; }
private void frm_visit_FormClosing(object sender, FormClosingEventArgs e) { // fmain.Strip_sub.Visible = false; Main.f_visit = true; ClassSql.DbClose(); if (backgroundWorker1.IsBusy) { backgroundWorker1.CancelAsync(); } }
private void dg_result_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex == 5) { dg_result.ReadOnly = false; dgcn = this.dg_result.SelectedRows[0].Cells["cn"].Value.ToString(); // string status = Convert.ToString((dg_result.Rows[0].Cells["Status"] as DataGridViewComboBoxCell).FormattedValue.ToString()); try { // ClassSql a = new ClassSql(); // a.ExecuteQuery("Update t_result_main SET status = '" + status.ToString() + "' where cn ='"+cn.ToString()+"' "); // MessageBox.Show(status.ToString()); } catch (Exception ex) { MessageBox.Show(this, string.Format("An error occured {0}", ex.Message), Properties.Settings.Default.SystemName.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } finally { if (ClassSql.cnn != null) { ClassSql.DbClose(); } if (ClassSql.dr != null) { ClassSql.dr.Close(); } } } else { dg_result.ReadOnly = true; } }
//private void cmd_add_Employer_Click(object sender, EventArgs e) //{ // ClassSql a = new ClassSql(); // if (a.CountColumn("Select * from tbl_employer where Employer = '" + Tool.ReplaceString(cbo_employer.Text) + "'") >= 1) // { // MessageBox.Show("Employer name already exist", Properties.Settings.Default.SystemName.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Exclamation); // return; // } // else // { // a.ExecuteQuery("Insert into tbl_employer (Employer) values('" + Tool.ReplaceString(cbo_employer.Text) + "')"); // MessageBox.Show("Employer name added", Properties.Settings.Default.SystemName.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Information); // } //} private void frm_addPatient_FormClosing(object sender, FormClosingEventArgs e) { ClassSql.DbClose(); }
private void frm_Tumor_Immunological_FormClosing(object sender, FormClosingEventArgs e) { fmain.Tumor = true; fmain.ts_add_tumor.Enabled = true; fmain.ts_edit_tumor.Enabled = false; fmain.ts_delete_tumor.Enabled = false; fmain.ts_save_tumor.Enabled = false; fmain.ts_search_tumor.Enabled = true; fmain.ts_print_tumor.Enabled = false; fmain.ts_cancel_tumor.Enabled = false; ClassSql.DbClose(); }
private void frm_Approval_FormClosing(object sender, FormClosingEventArgs e) { fmain.Approval = true; ClassSql.DbClose(); }