public bool SaveLabTestRemarks(PatientRegistration pr, LabTestRemarks Remarks) { try { con = new OleDbConnection(); this.readconfile = new ReadConfigFile(); con.ConnectionString = this.readconfile.ConfigString(ConfigFiles.ProjectConfigFile); con.Open(); tran = con.BeginTransaction(); cmd = new OleDbCommand(); cmd.Connection = con; cmd.Transaction = tran; cmd.CommandText = "Update LabTestPerformed set Remarks='" + Remarks.Remarks + "',TestPerformed = " + Remarks.IsTestPerformed + " where TokenNumber=" + pr.TokenNumber + " and TokenDate='" + pr.TokenDate.ToShortDateString() + "' and TokenMonthYear=" + pr.TokenMonthYear + " and LabTestID=" + Remarks.LabTest.LabTestId; cmd.ExecuteNonQuery(); tran.Commit(); return(true); } catch (Exception ex) { tran.Rollback(); throw ex; } finally { con.Close(); } }
private void btnSaveRemarks_Click(object sender, EventArgs e) { LabTestRemarks ltr = new LabTestRemarks(); if (lstLabTest.Items.Count > 0) { if (this.lstLabTest.SelectedItem == null) { MessageBox.Show("Please Select the Test to Give Remarks", "Remarks"); return; } ltr.LabTest = (LabTest)this.lstLabTest.SelectedItem; ltr.Remarks = this.txtRemarks.Text.Trim(); ltr.IsTestPerformed = true; if (MessageBox.Show("Do you want to Save Remarks? ", "Save Remarks", MessageBoxButtons.YesNo) == DialogResult.No) { return; } if (new PatientBLL().SaveLabTestRemarks(pr, ltr) == true) { MessageBox.Show("Congratulations Remarks Saved Successfully!!!", "Remarks Saved"); lstLabTest.Items.RemoveAt(lstLabTest.SelectedIndex); this.txtRemarks.Text = string.Empty; } } if (lstLabTest.Items.Count == 0) { LoadTokens(); this.txtRemarks.Text = string.Empty; } }
public bool SaveLabTestRemarks(PatientRegistration pr, LabTestRemarks ltr) { return(new PatientDAL().SaveLabTestRemarks(pr, ltr)); }