private void SetSDForUpdate(Surgical sDetail)
{
textBoxPatientID.Text = sDetail.PatientID.ToString();
textBoxSurgicalID.Text = sDetail.SurgicalID.ToString();
dateCreate.Value = sDetail.Date;
textBoxDescription.Text = sDetail.Description;
comboBoxState.SelectedIndex = sDetail.State;
DataTable dtStaff = Staff.GetListStaff();
for (int i = 0; i < dtStaff.Rows.Count; i++)
{
String staffName = dtStaff.Rows[i][6].ToString() + " " + dtStaff.Rows[i][5].ToString();
Staff newStaff = Staff.GetStaff(Convert.ToInt32(dtStaff.Rows[i][0]));
listStaff.Add(newStaff);
listBoxSystemStaff.Items.Add(staffName);
}
listBoxSystemStaff.SelectedIndex = 0;
DataTable dtSD = SurgicalDetail.GetListSurgicalDetail(sDetail.SurgicalID);
for (int i = 0; i < dtSD.Rows.Count; i++)
{
String staffName = dtSD.Rows[i][2].ToString() + " " + dtSD.Rows[i][3].ToString();
SurgicalDetail newSD = new SurgicalDetail();
newSD.SurgicalID = Convert.ToInt32(dtSD.Rows[i][0]);
newSD.StaffID = Convert.ToInt32(dtSD.Rows[i][1]);
listSD.Add(newSD);
listBoxCurrentStaff.Items.Add(staffName);
}
if (listBoxCurrentStaff.Items.Count > 0)
listBoxCurrentStaff.SelectedIndex = 0;
}
public static int InsertSurgicalDetail(SurgicalDetail newSD)
{
String sqlInsert = @"INSERT INTO SURGICALDETAIL (SURGICALID, STAFFID)
VALUES (@SURGICALID,@STAFFID)";
SqlParameter[] sqlParameters = { new SqlParameter("@SURGICALID", newSD.SurgicalID),
new SqlParameter("@STAFFID", newSD.StaffID)};
return SqlResult.ExecuteNonQuery(sqlInsert, sqlParameters);
}
public static int InsertSurgicalDetail(SurgicalDetail newSD)
{
String sqlInsert = @"INSERT INTO SURGICALDETAIL (SURGICALID, STAFFID)
VALUES (@SURGICALID,@STAFFID)";
SqlParameter[] sqlParameters = { new SqlParameter("@SURGICALID", newSD.SurgicalID),
new SqlParameter("@STAFFID", newSD.StaffID) };
return(SqlResult.ExecuteNonQuery(sqlInsert, sqlParameters));
}
private void buttonInsertFunction_Click(object sender, EventArgs e)
{
int selectedStaff = listBoxSystemStaff.SelectedIndex;
if (CheckStaffInSurgical(listStaff[selectedStaff].StaffID))
{
MessageBox.Show("Nhân viên đã có trong danh sách tham gia ca phẩu thuật", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
SurgicalDetail newSD = new SurgicalDetail(0, listStaff[selectedStaff].StaffID);
listSD.Add(newSD);
listBoxCurrentStaff.Items.Add(listBoxSystemStaff.Items[selectedStaff].ToString());
listBoxCurrentStaff.SelectedIndex = 0;
}
}