private void SetPDetailForUpdate(Prescription pDetail)
{
textBoxPrescriptionID.Text = pDetail.PrescriptionID.ToString();
textBoxPatientID.Text = pDetail.PatientID.ToString();
textBoxStaffID.Text = pDetail.StaffID.ToString();
dateCreate.Value = pDetail.Date;
DataTable dtMedicine = Medicine.GetListMedicine();
for (int i = 0; i < dtMedicine.Rows.Count; i++)
{
Medicine newMedicine = Medicine.GetMedicine(Convert.ToInt32(dtMedicine.Rows[i][0]));
listMedicine.Add(newMedicine);
comboBoxMedicine.Items.Add(newMedicine.MedicineName);
comboBoxMedicine.AutoCompleteCustomSource.Add(newMedicine.MedicineName);
}
comboBoxMedicine.SelectedIndex = 0;
DataTable dtPD = PrescriptionDetail.GetListPrescriptionDetail(pDetail.PrescriptionID);
for (int i = 0; i < dtPD.Rows.Count; i++)
{
PrescriptionDetail newDP = new PrescriptionDetail();
newDP.PrescriptionID = Convert.ToInt32(dtPD.Rows[i][0]);
newDP.MedicineID = Convert.ToInt32(dtPD.Rows[i][1]);
newDP.Quantity = Convert.ToInt16(dtPD.Rows[i][2]);
newDP.Instruction = dtPD.Rows[i][3].ToString();
listDP.Add(newDP);
Medicine newMedicine = Medicine.GetMedicine(newDP.MedicineID);
listSelectedMedicine.Items.Add(newMedicine.MedicineName);
}
if (listSelectedMedicine.Items.Count > 0)
listSelectedMedicine.SelectedIndex = 0;
}
public FormPrescriptionDetail(Prescription pDetail,String userAction)
{
InitializeComponent();
this.PDetail = pDetail;
this.UserAction = userAction;
SetPDetailForUpdate(pDetail);
}
public static int InsertPrescription(Prescription newP)
{
String sqlInsert = @"INSERT INTO PRESCRIPTION(STAFFID, PATIENTID, DATE)
VALUES (@STAFFID,@PATIENTID,@DATE)";
SqlParameter[] sqlParameters = { new SqlParameter("@STAFFID", newP.StaffID),
new SqlParameter("@PATIENTID", newP.PatientID),
new SqlParameter("@DATE",newP.Date)};
return SqlResult.ExecuteNonQuery(sqlInsert, sqlParameters);
}
public static int UpdatePrescription(Prescription updateP)
{
string sqlUpdate = @"UPDATE PRESCRIPTION
SET PATIENTID =@PATIENTID, DATE =@DATE
WHERE PRESCRIPTIONID=@PRESCRIPTIONID ";
SqlParameter[] sqlParameters = { new SqlParameter("@PRESCRIPTIONID", updateP.PrescriptionID),
new SqlParameter("@PATIENTID", updateP.PatientID),
new SqlParameter("@DATE", updateP.Date)};
return SqlResult.ExecuteNonQuery(sqlUpdate, sqlParameters);
}
public static Prescription GetPrescription(int pID)
{
Prescription newPrescription = new Prescription();
string sqlSelect = @"SELECT PRESCRIPTIONID, STAFFID, PATIENTID, DATE
FROM PRESCRIPTION
WHERE PRESCRIPTIONID=@PRESCRIPTIONID";
SqlParameter[] sqlParameters = { new SqlParameter("@PRESCRIPTIONID", pID) };
DataTable dataTable = SqlResult.ExecuteQuery(sqlSelect, sqlParameters);
if (dataTable.Rows.Count > 0)
{
newPrescription.PrescriptionID = Convert.ToInt32(dataTable.Rows[0][0]);
newPrescription.StaffID = Convert.ToInt32(dataTable.Rows[0][1]);
newPrescription.PatientID = Convert.ToInt32(dataTable.Rows[0][2]);
newPrescription.Date = DateTime.Parse(dataTable.Rows[0][3].ToString());
}
return newPrescription;
}
public FormPrescriptionDetail(Prescription pDetail)
{
InitializeComponent();
this.PDetail = pDetail;
}
private void buttonOk_Click(object sender, EventArgs e)
{
try
{
Prescription newPrescription = new Prescription();
newPrescription.Date = dateCreate.Value;
newPrescription.PatientID = int.Parse(textBoxPatientID.Text);
newPrescription.StaffID = int.Parse(textBoxStaffID.Text);
if(this.UserAction=="edit")
{
newPrescription.PrescriptionID = Convert.ToInt32(textBoxPrescriptionID.Text);
DialogResult dialogResult = MessageBox.Show("Xác nhận cập nhập thông tin toa thuốc", "Thông báo", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (dialogResult == DialogResult.OK)
{
if (Prescription.UpdatePrescription(newPrescription) > 0)
{
PrescriptionDetail.DeletePrescriptionDetail(newPrescription.PrescriptionID);
for (int i = 0; i < listDP.Count; i++)
{
PrescriptionDetail newPD = listDP[i];
newPD.PrescriptionID = Convert.ToInt32(textBoxPrescriptionID.Text);
PrescriptionDetail.InsertPrescriptionDetail(newPD);
}
listDP.Clear();
MessageBox.Show("Cập nhập thông tin toa thuốc thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
else
{
newPrescription.PrescriptionID = 0;
if (Prescription.InsertPrescription(newPrescription) > 0)
{
int prescriptionID = Prescription.GetPrescriptionInsertedID();
for (int i = 0; i < listDP.Count; i++)
{
listDP[i].PrescriptionID = prescriptionID;
PrescriptionDetail.InsertPrescriptionDetail(listDP[i]);
}
MessageBox.Show("Thêm toa thuốc thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
listDP.Clear();
}
}
}
catch
{
MessageBox.Show("Lỗi dữ liệu", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
this.Close();
}