private void detach_Visits(Visit entity)
		{
			this.SendPropertyChanging();
			entity.Doctor = null;
		}
        protected void AddNewDrug_Click(object sender, EventArgs e)
        {
            if (IsValid)
            {
                TableAddDrug.Visible = false;

                DateTime dob = DateTime.Parse(Price.Text);
                String outcome = OutCome.Text;

                int hospitalID = Convert.ToInt32(IDHospital.Text);
                int doctorID = Convert.ToInt32(IDDoctor.Text);
                int patientID = Convert.ToInt32(IDPatient.Text);
                int ICDId = Convert.ToInt32(IDICD.Text);
                int labID = Convert.ToInt32(IDLabOrder.Text);
                int preID = Convert.ToInt32(IDPrescription.Text);

                if (IDEdit.Text == null || IDEdit.Text.Equals(""))
                {
                    var drug = new Visit()
                    {
                        Date = dob,
                        DoctorID = doctorID,
                        PatientID = patientID,
                        HospitalID = hospitalID,
                        ICDID = ICDId,
                        LabID = labID,
                        PrescripID = preID,
                        Outcome = outcome
                    };
                    DataBaseAllDataContext dataAll = new DataBaseAllDataContext();
                    dataAll.Visits.InsertOnSubmit(drug);
                    dataAll.SubmitChanges();

                    ViewState["state"] = "load";
                    GridDrug.DataBind();
                    TableAddDrug.Visible = false;
                    GridDrug.Visible = true;
                }
                else
                {
                    var drug = new Visit()
                    {
                        ID = Convert.ToInt32(IDEdit.Text),
                        Date = dob,
                        DoctorID = doctorID,
                        PatientID = patientID,
                        HospitalID = hospitalID,
                        ICDID = ICDId,
                        LabID = labID,
                        PrescripID = preID,
                        Outcome = outcome
                    };
                    DataBaseAllDataContext dataAll = new DataBaseAllDataContext();

                    var old = (from p in dataAll.Visits
                               where p.ID == Convert.ToInt32(IDEdit.Text)
                               select p).Single();

                    old.Date = drug.Date;
                    old.DoctorID = drug.DoctorID;
                    old.PatientID = drug.PatientID;
                    old.HospitalID = drug.HospitalID;
                    old.ICDID = drug.ICDID;
                    old.LabID = drug.LabID;
                    old.PrescripID = drug.PrescripID;
                    old.Outcome = drug.Outcome;

                    dataAll.SubmitChanges();
                    ViewState["state"] = "load";
                    GridDrug.DataBind();
                    TableAddDrug.Visible = false;
                    GridDrug.Visible = true;
                }
            }
            Session["editVisitID"] = "";
        }
 partial void DeleteVisit(Visit instance);
		private void attach_Visits(Visit entity)
		{
			this.SendPropertyChanging();
			entity.Doctor = this;
		}
 partial void UpdateVisit(Visit instance);
 partial void InsertVisit(Visit instance);
		private void detach_Visits(Visit entity)
		{
			this.SendPropertyChanging();
			entity.Prescription = null;
		}
		private void detach_Visits(Visit entity)
		{
			this.SendPropertyChanging();
			entity.Hospital = null;
		}
		private void attach_Visits(Visit entity)
		{
			this.SendPropertyChanging();
			entity.Hospital = this;
		}