// Done
protected void PatientDataGrid_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
patientid = Convert.ToInt32(PatientDataGrid.DataKeys[e.RowIndex].Values["patient_ID"].ToString());
if (patientid != 0)
{
using (ClinicManagementSystemDataContext dbcontext = new ClinicManagementSystemDataContext())
{
TBLPATIENT patient = dbcontext.TBLPATIENTs.SingleOrDefault(p => p.patient_ID == patientid);
dbcontext.TBLPATIENTs.DeleteOnSubmit(patient);
dbcontext.SubmitChanges();
GetPatientData();
}
}
}
private void InsertPatient()
{
using (ClinicManagementSystemDataContext dbcontext = new ClinicManagementSystemDataContext())
{
TBLPATIENT newPatient = new TBLPATIENT()
{
patient_Name = Patient_NameTB.Text,
patient_Gender = GenderDropDownList.SelectedValue,
patient_BirthDate = PatientBirthTB.Text,
/* patient_BirthDate = DateTime.Parse(PatientBirth.Text),*/
patient_Height = Patient_Height.Text,
patient_Weight = Int32.Parse(Patient_Weight.Text),
patient_Phone = Patient_Phone.Text,
patient_Email = Patient_EAddressTB.Text,
patient_Address = PatientAddressTB.Text
};
dbcontext.TBLPATIENTs.InsertOnSubmit(newPatient);
dbcontext.SubmitChanges();
}
}
