private void SetADForUpdate(Assignment assignDetail)
{
textBoxAssignID.Text = assignDetail.AssignID.ToString();
textBoxPatientID.Text = assignDetail.PatientID.ToString();
dateCreate.Value = assignDetail.Date;
dateDischarge.Value = assignDetail.DischargedDate;
dateHospitalize.Value = assignDetail.HospitalizateDate;
dateHospitalize.Enabled = false;
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 dtAD = AssignmentDetail.GetListAssignmentDetails(assignDetail.AssignID);
for (int i = 0; i < dtAD.Rows.Count; i++)
{
String staffName = dtAD.Rows[i][2].ToString() + " " + dtAD.Rows[i][3].ToString();
AssignmentDetail newAD = new AssignmentDetail();
newAD.AssignID = Convert.ToInt32(dtAD.Rows[i][0]);
newAD.StaffID = Convert.ToInt32(dtAD.Rows[i][1]);
listAD.Add(newAD);
listBoxCurrentStaff.Items.Add(staffName);
}
if (listBoxCurrentStaff.Items.Count > 0)
listBoxCurrentStaff.SelectedIndex = 0;
}
public static int DeleteAssignmentDetails(AssignmentDetail deleteAD)
{
string sqlDelete = @"DELETE FROM ASSIGNMENTDETAIL
WHERE (ASSIGNID=@ASSIGNID AND STAFFID=@STAFFID)";
SqlParameter[] sqlParameters = { new SqlParameter("@ASSIGNID", deleteAD.AssignID),
new SqlParameter("@STAFFID", deleteAD.StaffID)};
return SqlResult.ExecuteNonQuery(sqlDelete, sqlParameters);
}
public static int InsertAssignmentDetails(AssignmentDetail newAD)
{
String sqlInsert = @"INSERT INTO ASSIGNMENTDETAIL(ASSIGNID, STAFFID)
VALUES (@ASSIGNID,@STAFFID)";
SqlParameter[] sqlParameters = { new SqlParameter("@ASSIGNID", newAD.AssignID),
new SqlParameter("@STAFFID", newAD.StaffID)};
return SqlResult.ExecuteNonQuery(sqlInsert, sqlParameters);
}
public static int DeleteAssignmentDetails(AssignmentDetail deleteAD)
{
string sqlDelete = @"DELETE FROM ASSIGNMENTDETAIL
WHERE (ASSIGNID=@ASSIGNID AND STAFFID=@STAFFID)";
SqlParameter[] sqlParameters = { new SqlParameter("@ASSIGNID", deleteAD.AssignID),
new SqlParameter("@STAFFID", deleteAD.StaffID) };
return(SqlResult.ExecuteNonQuery(sqlDelete, sqlParameters));
}
public static int InsertAssignmentDetails(AssignmentDetail newAD)
{
String sqlInsert = @"INSERT INTO ASSIGNMENTDETAIL(ASSIGNID, STAFFID)
VALUES (@ASSIGNID,@STAFFID)";
SqlParameter[] sqlParameters = { new SqlParameter("@ASSIGNID", newAD.AssignID),
new SqlParameter("@STAFFID", newAD.StaffID) };
return(SqlResult.ExecuteNonQuery(sqlInsert, sqlParameters));
}
private void buttonInsertFunction_Click(object sender, EventArgs e)
{
int selectedStaff = listBoxSystemStaff.SelectedIndex;
if (CheckStaffInAssign(listStaff[selectedStaff].StaffID))
{
MessageBox.Show("Nhân viên đã có trong danh sách phân công chăm sóc bệnh nhân", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
AssignmentDetail newAD = new AssignmentDetail(0, listStaff[selectedStaff].StaffID);
listAD.Add(newAD);
listBoxCurrentStaff.Items.Add(listBoxSystemStaff.Items[selectedStaff].ToString());
listBoxCurrentStaff.SelectedIndex = 0;
}
}