private void frm_Patient_Detail_Edit_Load(object sender, EventArgs e)
{
try
{
if (GlobalVariable._Patient_id != "")
{
txtId.Text = GlobalVariable._Patient_id;
RetrieveData(int.Parse(GlobalVariable._Patient_id));
GlobalVariable._Patient_id = "";
GlobalMethod.getGreenRed("md_status", dgvMd, "Inactive");
}
txtTel.KeyPress += new KeyPressEventHandler(EventHandler.TextBoxNumberOnly);
txtKhFname.KeyPress += new KeyPressEventHandler(EventHandler.TextBoxTextOnly);
txtKhLname.KeyPress += new KeyPressEventHandler(EventHandler.TextBoxTextOnly);
txtFname.KeyPress += new KeyPressEventHandler(EventHandler.TextBoxTextOnly);
txtLname.KeyPress += new KeyPressEventHandler(EventHandler.TextBoxTextOnly);
txtNati.KeyPress += new KeyPressEventHandler(EventHandler.TextBoxTextOnly);
txtJob.KeyDown += new KeyEventHandler(EventHandler.TextBoxClearBackPress);
txtJob.Leave += new System.EventHandler(EventHandler.TextBoxLeaveReturnDefalut);
txtAddress.KeyDown += new KeyEventHandler(EventHandler.TextBoxClearBackPress);
txtAddress.Leave += new System.EventHandler(EventHandler.TextBoxLeaveReturnDefalut);
}
catch (Exception t)
{
GlobalMethod.HandleException("frm_Patient_Detail_Load :" + t.Message);
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
foreach (DataGridViewRow row in dgvMd.Rows)
{
if (row.Cells["md_id"].Value.ToString() == cboMd.SelectedValue.ToString())
{
MyMSB.Show("ប្រវតិ្តវេជ្ជសាស្រ្តបានបញ្ចូលរួចហើយ", "0", false);
return;
}
}
dgvMd.Rows.Add(txtId.Text, cboMd.SelectedValue, GlobalMethod.getCboData(cboMd, "md_name"), txtDes.Text, "Active");
if (dgvMd.Rows.Count > 0)
{
StoreProcedure.spd_insert_patient_md(dgvMd);
}
GlobalMethod.getGreenRed("md_status", dgvMd, "Inactive");
}
private void frm_Patient_Detail_Edit_Activated(object sender, EventArgs e)
{
dgvMd.Rows.Clear();
DataTable dt = this.fun_getActiveMedicalHistoryForSpecificPaientTableAdapter.GetData(int.Parse(txtId.Text));
foreach (DataRow row in dt.Rows)
{
dgvMd.Rows.Add(
row["pat_id"].ToString(),
row["md_id"].ToString(),
row["md_name"].ToString(),
row["md_description"].ToString(),
row["md_status"].ToString()
);
}
GlobalMethod.getGreenRed("md_status", dgvMd, "Inactive");
}
private void frm_Patient_Detail_Load(object sender, EventArgs e)
{
try
{
if (GlobalVariable._Patient_id != "")
{
txtId.Text = GlobalVariable._Patient_id;
RetrieveData(int.Parse(GlobalVariable._Patient_id));
txtAppoint.Text = Convert.ToDateTime(txtAppoint.Text).ToString("dd-MM-yyyy");
GlobalVariable._Patient_id = "";
GlobalMethod.getGreenRed("md_status", fun_getActiveMedicalHistoryForSpecificPaientDataGridView, "Inactive");
}
}
catch (Exception t)
{
GlobalMethod.HandleException("frm_Patient_Detail_Load :" + t.Message);
}
}
private void btnInactive_Click(object sender, EventArgs e)
{
string md_status, pat_id, md_id;
pat_id = txtId.Text;
md_id = dgvMd.CurrentRow.Cells["md_id"].Value.ToString();
if (dgvMd.CurrentRow.Cells["md_status"].Value.ToString() == "Inactive")
{
dgvMd.CurrentRow.Cells["md_status"].Value = "Active";
md_status = "Active";
}
else
{
dgvMd.CurrentRow.Cells["md_status"].Value = "Inactive";
md_status = "Inactive";
}
GlobalMethod.getGreenRed("md_status", dgvMd, "Inactive");
StoreProcedure.spd_update_mdHistoryByPatID(int.Parse(pat_id), int.Parse(md_id), md_status);
}
private void RetrieveData(int v)
{
DataTable dt;
this.fun_getPatientByIDTableAdapter.Fill(dentist_DS.fun_getPatientByID, v);
dt = this.fun_getPatientByIDTableAdapter.GetData(v);
string[] spl = dt.Rows[0]["pat_app_time"].ToString().Split(':');
nudHour.Value = Convert.ToDecimal(spl[0]);
nudMinute.Value = Convert.ToDecimal(spl[1]);
//this.fun_getActiveMedicalHistoryForSpecificPaientTableAdapter.Fill(dentist_DS.fun_getActiveMedicalHistoryForSpecificPaient, v);
this.fun_getMedicalHistoryForSpecificPatientTableAdapter.Fill(dentist_DS.fun_getMedicalHistoryForSpecificPatient, v);
dt = this.fun_getActiveMedicalHistoryForSpecificPaientTableAdapter.GetData(v);
foreach (DataRow row in dt.Rows)
{
dgvMd.Rows.Add(
row["pat_id"].ToString(),
row["md_id"].ToString(),
row["md_name"].ToString(),
row["md_description"].ToString(),
row["md_status"].ToString()
);
}
GlobalMethod.getGreenRed("md_status", dgvMd, "Inactive");
}