//enables te add guardian button and disables the view guardian button if guardian already exists for the 'i' student and viceversa private void RowWork() { if (GridView1.DataSource != null) { using (SampleDataContext context = new SampleDataContext()) { for (int i = 0; i < GridView1.Rows.Count; i++) { LinkButton lb_add = (LinkButton)GridView1.Rows[i].FindControl("AddGuardian"); int id = Convert.ToInt32(lb_add.CommandArgument); LinkButton lb_view = (LinkButton)GridView1.Rows[i].FindControl("ViewSingleGuardian"); guardian g_check = context.guardians.Where(x => x.std_id == id).SingleOrDefault(); if (g_check != null) { lb_add.Enabled = false; lb_view.Enabled = true; } else { lb_add.Enabled = true; lb_view.Enabled = false; } } } } }
private void Update(int id) { using (SampleDataContext context = new SampleDataContext()) { guardian g = context.guardians.Where(x => x.id == id).SingleOrDefault(); int s_id = Convert.ToInt32(txtStd_id.Text); if (context.students.Where(x => x.std_id == s_id).Single() != null) { g.g_Fname = txtFname.Text; g.g_Lname = txtLname.Text; g.g_Address = txtAddress.Text; g.std_id = s_id; context.SubmitChanges(); GetData(); Clear(); } else { Response.Write("<script>alert('Student ID Not Found!!')</script>"); } } }
protected void dltGuardian_Click(object sender, EventArgs e) { int i = Convert.ToInt32((sender as LinkButton).CommandArgument); using (SampleDataContext context = new SampleDataContext()) { guardian g = context.guardians.Where(x => x.id == i).SingleOrDefault(); g.std_id = null; context.SubmitChanges(); context.guardians.DeleteOnSubmit(g); context.SubmitChanges(); GridView2.DataSource = null; } GetData(); Clear(); }
protected void updGuardian_Click(object sender, EventArgs e) { hf1.Value = (sender as LinkButton).CommandArgument; int i = Convert.ToInt32(hf1.Value); btn_Update.Enabled = true; using (SampleDataContext context = new SampleDataContext()) { guardian g = context.guardians.Where(x => x.id == i).Single(); if (g != null) { txtFname.Text = g.g_Fname; txtLname.Text = g.g_Lname; txtAddress.Text = g.g_Address; txtStd_id.Text = g.std_id.ToString(); } } }
protected void Delete_Click(object sender, EventArgs e) { HideGrid(); hf1.Value = (sender as LinkButton).CommandArgument; i = Convert.ToInt32(hf1.Value); using (SampleDataContext context = new SampleDataContext()) { guardian g = context.guardians.Where(x => x.std_id == i).SingleOrDefault(); if (g != null) { g.std_id = null; context.SubmitChanges(); } student std = context.students.SingleOrDefault(x => x.std_id == i); context.students.DeleteOnSubmit(std); context.SubmitChanges(); Clear(); GetData(); } }
protected void adGuardianBtn_Click(object sender, EventArgs e) { if (isValid()) { using (SampleDataContext dbcontext = new SampleDataContext()) { guardian newg = new guardian() { g_Fname = txtGuardianFName.Text, g_Lname = txtGuardianLname.Text, g_Address = txtGuardianAddress.Text, std_id = Convert.ToInt32(hf2.Value) }; dbcontext.guardians.InsertOnSubmit(newg); dbcontext.SubmitChanges(); Response.Redirect("~/Guardian.aspx"); } } else { Response.Write("<script>alert('Cannot Process Request due to validation error')</script>"); } }
private void detach_guardians(guardian entity) { this.SendPropertyChanging(); entity.student = null; }
private void attach_guardians(guardian entity) { this.SendPropertyChanging(); entity.student = this; }
partial void Deleteguardian(guardian instance);
partial void Updateguardian(guardian instance);
partial void Insertguardian(guardian instance);