public int PatientUpd(Patient1 s)
{
string sql = $"update Patient set PatientCode='{s.PatientCode}',PatientName='{s.PatientName}',PatientPhone='{s.PatientPhone}',PatientPassWord='******' where PatientId={s.PatientId}";
int h = _db.ExecuteNonQuery(sql);
return(h);
}
public void savePatient()
{
String firstName = txtfirstname.Text;
String LastName = txtlastName.Text;
String MiddleName = txtMiddleName.Text;
DateTime DateOfBirth = Convert.ToDateTime(txtDateOfBirth.Text);
String PatientAddress = txtPatientAddress.Text;
Int32 City_ID = Convert.ToInt32(txtCity_ID.Text);
Int32 ZipCode = Convert.ToInt32(txtZipCode.Text);
String EmergencyContactNumber = txtEmergencyContactNumber.Text;
String EmergencyContactName = txtEmergencyContactName.Text;
Patient1 p = new Patient1();
p.FirstName1 = firstName;
p.LastName1 = LastName;
p.MiddleName1 = MiddleName;
p.Date_Of_Birth1 = DateOfBirth;
p.Patient_Address1 = PatientAddress;
p.City_ID1 = City_ID;
p.Zip_Code1 = ZipCode;
p.Emergency_Contact_Number1 = EmergencyContactNumber;
p.Emergency_Contact_Name1 = EmergencyContactName;
p.User_ID = 1;
p.Patient_ID1 = Int32.Parse(hfpatientID.Value);
patientList.Add(p);
p.insertPatient();
bindGrid();
}
private void button2_Click_1(object sender, EventArgs e)
{
ADDPATIENT formUpdate = new ADDPATIENT("update");
int index = Manageofhospital.listPatient.IndexOf(this.PatientSelected);
ADDPATIENT.patient.Id = PatientSelected.Id;
ADDPATIENT.patient.Name = PatientSelected.Name;
ADDPATIENT.patient.District = PatientSelected.District;
ADDPATIENT.patient.Ward = PatientSelected.Ward;
ADDPATIENT.patient.Indentitycard = PatientSelected.Indentitycard;
ADDPATIENT.patient.Gender = PatientSelected.Gender;
ADDPATIENT.patient.Dateofbirth = PatientSelected.Dateofbirth;
ADDPATIENT.patient.Sick = PatientSelected.Sick;
ADDPATIENT.patient.Nationality = PatientSelected.Nationality;
formUpdate.ShowDialog();
Patient1 a = (Patient1)listPatient[index];
a.Id = ADDPATIENT.patient.Id;
a.Name = ADDPATIENT.patient.Name;
a.District = ADDPATIENT.patient.District;
a.Ward = ADDPATIENT.patient.Ward;
a.Indentitycard = ADDPATIENT.patient.Indentitycard;
a.Gender = ADDPATIENT.patient.Gender;
a.Dateofbirth = ADDPATIENT.patient.Dateofbirth;
a.Sick = ADDPATIENT.patient.Sick;
a.Nationality = ADDPATIENT.patient.Nationality;
ADDPATIENT.patient = null;
LoadPatient();
MessageBox.Show("Update successful");
}
protected void gvPatient_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "cmdedit")
{
Patient1 p = new Patient1();
p.Patient_ID1 = Convert.ToInt32(e.CommandArgument);
p.getPatientDataByID();
txtfirstname.Text = p.FirstName1;
txtlastName.Text = p.LastName1;
txtMiddleName.Text = p.MiddleName1;
txtDateOfBirth.Text = Convert.ToString(p.Date_Of_Birth1);
txtPatientAddress.Text = p.Patient_Address1;
txtCity_ID.Text = Convert.ToString(p.City_ID1);
txtZipCode.Text = Convert.ToString(p.Zip_Code1);
txtEmergencyContactNumber.Text = p.Emergency_Contact_Number1;
txtEmergencyContactName.Text = p.Emergency_Contact_Name1;
hfpatientID.Value = Convert.ToString(p.Patient_ID1);
}
if (e.CommandName == "cmddelete")
{
Patient1 p = new Patient1();
p.Patient_ID1 = Convert.ToInt32(e.CommandArgument);
p.removePatient();
bindGrid();
}
}
public void bindGrid()
{
Patient1 p = new Patient1();
DataSet ds = p.getPatientData();
gvPatient.DataSource = ds;
gvPatient.DataBind();
}
public ActionResult DeleteConfirmed(int id)
{
Patient1 patient1 = db.Patient1.Find(id);
db.Patient1.Remove(patient1);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "patientID,pateintID,patientFirstName,patientLastName,patientPhone,patientCondition,patientSince")] Patient1 patient1)
{
if (ModelState.IsValid)
{
db.Entry(patient1).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(patient1));
}
public ActionResult Create([Bind(Include = "patientID,pateintID,patientFirstName,patientLastName,patientPhone,patientCondition,patientSince")] Patient1 patient1)
{
if (ModelState.IsValid)
{
db.Patient1.Add(patient1);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(patient1));
}
// GET: Patient1/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Patient1 patient1 = db.Patient1.Find(id);
if (patient1 == null)
{
return(HttpNotFound());
}
return(View(patient1));
}
private void button1_Click_1(object sender, EventArgs e)
{
ADDPATIENT formAdd1 = new ADDPATIENT("Add");
formAdd1.ShowDialog();
if (ADDPATIENT.patient != null)
{
Patient1 p = new Patient1(ADDPATIENT.patient);
if (string.IsNullOrEmpty(p.Name.ToString()) || string.IsNullOrEmpty(p.District.ToString()) || string.IsNullOrEmpty(p.Ward.ToString()) || string.IsNullOrEmpty(p.Gender.ToString()) || string.IsNullOrEmpty(p.Indentitycard.ToString()) || string.IsNullOrEmpty(p.Dateofbirth.ToString()) || string.IsNullOrEmpty(p.Sick.ToString()) || string.IsNullOrEmpty(p.Nationality.ToString()))
{
MessageBox.Show("Add successful but empty", "Notification");
}
else
{
listPatient.Add(p);
MessageBox.Show("Add successful", "Notification");
LoadPatient();
}
}
}
