//Submit Add Form protected void AddPrescriptionGroupButton_Click(object sender, EventArgs e) { Button btn = (Button)sender; String btnId = btn.ID; if (btnId.Equals("AddPrescriptionButton")) { if (IsValid) { System.Threading.Thread.Sleep(3000); var doctorName = NameTextBox.Text; var doctorId = GetGroupId(doctorName)[0]; var dateVisited = Convert.ToDateTime(VisitedDateTextBox.Text); var prescription = new Prescription() { doctorId = doctorId, dateWritten = dateVisited }; _dataContext.Prescriptions.InsertOnSubmit(prescription); _dataContext.SubmitChanges(); PrescriptionList.DataBind(); //USe for Testing //Debug.WriteLine("Doctor Name: " + doctorId); //Debug.WriteLine("Date Visisted: " + dateVisited); ResetInputField(); } } else if (btnId.Equals("ResetPrescriptionGroupButton")) { ResetInputField(); } }
partial void DeletePrescription(Prescription instance);
partial void UpdatePrescription(Prescription instance);
partial void InsertPrescription(Prescription instance);
private void detach_Prescriptions(Prescription entity) { this.SendPropertyChanging(); entity.Doctor = null; }
//Control Update Process protected void UpdateButton_Click(object sender, EventArgs e) { if (IsValid) { System.Threading.Thread.Sleep(3000); var editedRowIndex = PrescriptionList.EditIndex; var lblId = PrescriptionList.Rows[editedRowIndex].FindControl("EditId") as Label; var txtbDName = PrescriptionList.Rows[editedRowIndex].FindControl("EditDName") as TextBox; var txtbDate = PrescriptionList.Rows[editedRowIndex].FindControl("EditDate") as TextBox; var id = long.Parse(lblId.Text); var doctorId = GetGroupId(txtbDName.Text)[0]; var date = Convert.ToDateTime(txtbDate.Text); var prescription = new Prescription() { prescriptionId = id, doctorId = doctorId, dateWritten = date }; _dataContext.Prescriptions.Attach(prescription); _dataContext.Refresh(RefreshMode.KeepCurrentValues, prescription); _dataContext.SubmitChanges(); PrescriptionList.EditIndex = -1; //Use For Debug passed value //Debug.WriteLine("id: " + id); //Debug.WriteLine("DName: " + doctorId); //Debug.WriteLine("Date: " + date); } }