public FormHCDetail(HospitalizationCertificate hcDetail, String userAction)
{
InitializeComponent();
this.HCDetail = hcDetail;
this.UserAction = userAction;
SetHCDetail(hcDetail);
}
public static int InsertHC(HospitalizationCertificate newHC)
{
String sqlInsert = @"INSERT INTO HOSPITALIZATIONCERTIFICATE(PATIENTID, STAFFID, REASON, DATE, STATE)
VALUES (@PATIENTID,@STAFFID,@REASON,@DATE,@STATE)";
SqlParameter[] sqlParameters = { new SqlParameter("@PATIENTID", newHC.PatientID),
new SqlParameter("@STAFFID", newHC.StaffID),
new SqlParameter("@REASON", newHC.Reason),
new SqlParameter("@DATE", newHC.Date),
new SqlParameter("@STATE", newHC.State)};
return SqlResult.ExecuteNonQuery(sqlInsert, sqlParameters);
}
private void SetHCDetail(HospitalizationCertificate hcDetail)
{
textBoxHCID.Text = hcDetail.HCID.ToString();
textBoxStaffID.Text = hcDetail.StaffID.ToString();
textBoxPatientID.Text = hcDetail.PatientID.ToString();
textBoxReason.Text = hcDetail.Reason;
dateHospitalizate.Value = hcDetail.Date;
comboBoxState.SelectedIndex = hcDetail.State;
comboBoxState.Enabled = false;
}
public static int InsertHC(HospitalizationCertificate newHC)
{
String sqlInsert = @"INSERT INTO HOSPITALIZATIONCERTIFICATE(PATIENTID, STAFFID, REASON, DATE, STATE)
VALUES (@PATIENTID,@STAFFID,@REASON,@DATE,@STATE)";
SqlParameter[] sqlParameters = { new SqlParameter("@PATIENTID", newHC.PatientID),
new SqlParameter("@STAFFID", newHC.StaffID),
new SqlParameter("@REASON", newHC.Reason),
new SqlParameter("@DATE", newHC.Date),
new SqlParameter("@STATE", newHC.State) };
return(SqlResult.ExecuteNonQuery(sqlInsert, sqlParameters));
}
public static int UpdateHC(HospitalizationCertificate updateHC)
{
string sqlUpdate = @"UPDATE HOSPITALIZATIONCERTIFICATE
SET PATIENTID =@PATIENTID, STAFFID =@STAFFID, REASON =@REASON, DATE =@DATE, STATE =@STATE
WHERE HCID=@HCID ";
SqlParameter[] sqlParameters = { new SqlParameter("@HCID", updateHC.HCID ),
new SqlParameter("@PATIENTID", updateHC.PatientID),
new SqlParameter("@STAFFID", updateHC.StaffID),
new SqlParameter("@REASON", updateHC.Reason),
new SqlParameter("@DATE", updateHC.Date),
new SqlParameter("@STATE", updateHC.State)};
return SqlResult.ExecuteNonQuery(sqlUpdate, sqlParameters);
}
public static int UpdateHC(HospitalizationCertificate updateHC)
{
string sqlUpdate = @"UPDATE HOSPITALIZATIONCERTIFICATE
SET PATIENTID =@PATIENTID, STAFFID =@STAFFID, REASON =@REASON, DATE =@DATE, STATE =@STATE
WHERE HCID=@HCID ";
SqlParameter[] sqlParameters = { new SqlParameter("@HCID", updateHC.HCID),
new SqlParameter("@PATIENTID", updateHC.PatientID),
new SqlParameter("@STAFFID", updateHC.StaffID),
new SqlParameter("@REASON", updateHC.Reason),
new SqlParameter("@DATE", updateHC.Date),
new SqlParameter("@STATE", updateHC.State) };
return(SqlResult.ExecuteNonQuery(sqlUpdate, sqlParameters));
}
public static HospitalizationCertificate GetHC(int hCID)
{
HospitalizationCertificate hC = new HospitalizationCertificate();
string sqlSelect = @"SELECT HCID, PATIENTID, STAFFID, REASON, DATE, STATE
FROM HOSPITALIZATIONCERTIFICATE
WHERE HCID=@HCID";
SqlParameter[] sqlParameters = { new SqlParameter("@HCID", hCID) };
DataTable dataTable = SqlResult.ExecuteQuery(sqlSelect, sqlParameters);
if (dataTable.Rows.Count > 0)
{
hC.HCID = Convert.ToInt32(dataTable.Rows[0][0]);
hC.PatientID = Convert.ToInt32(dataTable.Rows[0][1]);
hC.StaffID = Convert.ToInt32(dataTable.Rows[0][2]);
hC.Reason = (String)dataTable.Rows[0][3];
hC.Date = (DateTime)dataTable.Rows[0][4];
hC.State = (int)dataTable.Rows[0][5];
}
return hC;
}
public static HospitalizationCertificate GetHC(int hCID)
{
HospitalizationCertificate hC = new HospitalizationCertificate();
string sqlSelect = @"SELECT HCID, PATIENTID, STAFFID, REASON, DATE, STATE
FROM HOSPITALIZATIONCERTIFICATE
WHERE HCID=@HCID";
SqlParameter[] sqlParameters = { new SqlParameter("@HCID", hCID) };
DataTable dataTable = SqlResult.ExecuteQuery(sqlSelect, sqlParameters);
if (dataTable.Rows.Count > 0)
{
hC.HCID = Convert.ToInt32(dataTable.Rows[0][0]);
hC.PatientID = Convert.ToInt32(dataTable.Rows[0][1]);
hC.StaffID = Convert.ToInt32(dataTable.Rows[0][2]);
hC.Reason = (String)dataTable.Rows[0][3];
hC.Date = (DateTime)dataTable.Rows[0][4];
hC.State = (int)dataTable.Rows[0][5];
}
return(hC);
}
private void buttonOk_Click(object sender, EventArgs e)
{
if (!superValidator1.Validate())
return;
try
{
if (UserAction == "edit")
{
HospitalizationCertificate newHC = new HospitalizationCertificate();
newHC.HCID = int.Parse(textBoxHCID.Text);
newHC.PatientID = int.Parse(textBoxPatientID.Text);
newHC.StaffID = int.Parse(textBoxStaffID.Text);
newHC.Reason = textBoxReason.Text;
newHC.State = (int)comboBoxState.SelectedIndex;
newHC.Date = dateHospitalizate.Value;
DialogResult dialogResult = MessageBox.Show("Xác nhận cập nhập thông tin giấy nhập viện", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dialogResult==DialogResult.Yes)
{
if (HospitalizationCertificate.UpdateHC(newHC) > 0)
MessageBox.Show("Cập nhập thông tin giấy nhập viện thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
if (HospitalizationCertificate.IsPatientHadHC(int.Parse(textBoxPatientID.Text)))
{
MessageBox.Show("Bệnh nhân đã có giấy nhập viện", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
HospitalizationCertificate newHC = new HospitalizationCertificate();
newHC.HCID = 0;
newHC.PatientID = int.Parse(textBoxPatientID.Text);
newHC.StaffID = int.Parse(textBoxStaffID.Text);
newHC.Reason = textBoxReason.Text;
newHC.State = 0;
newHC.Date = dateHospitalizate.Value;
if (HospitalizationCertificate.InsertHC(newHC) > 0)
MessageBox.Show("Thêm giấy nhập viện thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
catch
{
MessageBox.Show("Lỗi dữ liệu", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
this.Close();
}
