private void button_MouseCliked(object sender, EventArgs e)
{
Guna.UI2.WinForms.Guna2Button bt = (Guna.UI2.WinForms.Guna2Button)sender;
var _filter = bt.Tag.ToString();
var dh = new dataset.yakkumdbTableAdapters.fa_rx_templateTableAdapter();
dh.FillByNamaJEnis(yakkumdb.fa_rx_template, _filter, "Diagnosa");
DataTable dt = dh.GetDataByNamaJenis(_filter, "Diagnosa");
foreach (DataRow r in dt.Rows)
{
DataGridViewRow row = (DataGridViewRow)dgvDiagnosa.Rows[0].Clone();
row.Cells[1].Value = r["icd_code"].ToString();
row.Cells[2].Value = r["icd_desc"].ToString();
dgvDiagnosa.Rows.Add(row);
}
dh.FillByNamaJEnis(yakkumdb.fa_rx_template, _filter, "Prosedur");
DataTable dt2 = dh.GetDataByNamaJenis(_filter, "Prosedur");
foreach (DataRow r in dt2.Rows)
{
DataGridViewRow row2 = (DataGridViewRow)dgvProcedure.Rows[0].Clone();
row2.Cells[1].Value = r["icd_code"].ToString();
row2.Cells[2].Value = r["icd_desc"].ToString();
dgvProcedure.Rows.Add(row2);
}
}
private void btnSimpan_Click(object sender, EventArgs e)
{
if (txtNama.Text == "")
{
MessageBox.Show("Masukkan Nama Template");
}
else
{
var dh = new dataset.yakkumdbTableAdapters.fa_rx_templateTableAdapter();
for (int i = 0; i < dgvDiagnosa.RowCount - 1; i++)
{
if (dgvDiagnosa.Rows[i].Cells[1].Value.Equals(null))
{
}
else
{
dh.InsertQuery(
txtNama.Text,
dgvDiagnosa.Rows[i].Cells[1].Value.ToString(),
dgvDiagnosa.Rows[i].Cells[2].Value.ToString(),
"Diagnosa"
);
}
}
for (int i = 0; i < dgvProcedure.RowCount - 1; i++)
{
if (dgvProcedure.Rows[i].Cells[1].Value.Equals(null))
{
}
else
{
dh.InsertQuery(
txtNama.Text,
dgvProcedure.Rows[i].Cells[1].Value.ToString(),
dgvProcedure.Rows[i].Cells[2].Value.ToString(),
"Prosedur"
);
}
}
this.Close();
}
}
private void LoadTemplate()
{
//Guna.UI2.WinForms.Guna2Button button = new Guna.UI2.WinForms.Guna2Button();
var dh = new dataset.yakkumdbTableAdapters.fa_rx_templateTableAdapter();
dh.FillByDistinct(yakkumdb.fa_rx_template);
DataTable dt = dh.GetDataByDistinct();
foreach (DataRow r in dt.Rows)
{
//MessageBox.Show(r["nama_template"].ToString());
Guna.UI2.WinForms.Guna2Button button = new Guna.UI2.WinForms.Guna2Button();
button.Tag = r["nama_template"].ToString();
button.Text = r["nama_template"].ToString();
button.AutoRoundedCorners = true;
button.AutoSize = true;
flowLayoutPanel1.Controls.Add(button);
button.Click += button_MouseCliked;
}
}
