protected void btnAdd_Click(object sender, EventArgs e) { switch (rbAdd.SelectedIndex) { case 0: pnlEmp.Visible = true; pnlDep.Visible = false; pnlService.Visible = false; pnlWith.Visible = false; using (ClubDBEntities club = new ClubDBEntities()) { gvEmp.DataSource = club.getEmployees(); gvEmp.DataBind(); } break; case 1: pnlEmp.Visible = false; pnlDep.Visible = false; pnlService.Visible = true; pnlWith.Visible = false; using (ClubDBEntities club = new ClubDBEntities()) { var r = club.getServices(); gvSer.DataSource = r; gvSer.DataBind(); } break; case 2: pnlEmp.Visible = false; pnlDep.Visible = true; pnlService.Visible = false; pnlWith.Visible = false; using (ClubDBEntities club = new ClubDBEntities()) { var r = from i in club.Departments orderby i.DepID select i ; gvDep.DataSource = r; gvDep.DataBind(); } break; case 3: pnlEmp.Visible = false; pnlDep.Visible = false; pnlService.Visible = false; pnlWith.Visible = true; using (ClubDBEntities club = new ClubDBEntities()) { var result = club.getWithTypes(); gvWith.DataSource = result; gvWith.DataBind(); } break; } }
protected void btnWSave_Click(object sender, EventArgs e) { string name = tbWName.Text; int dep = Convert.ToInt32(ddlWDep.SelectedValue); using (ClubDBEntities club = new ClubDBEntities()) { var u = (from i in club.WithTypes where i.ID == EditWith select i).First(); u.Name = name; u.Department = dep; club.SaveChanges(); tbWName.Text = ""; ddlWDep.SelectedIndex = 0; withTable.Visible = false; gvWith.DataSource = club.getWithTypes(); gvWith.DataBind(); } }
protected void gvWith_RowDeleting(object sender, GridViewDeleteEventArgs e) { int id = Convert.ToInt32(gvWith.Rows[e.RowIndex].Cells[4].Text); using (ClubDBEntities club = new ClubDBEntities()) { try { var re = club.WithTypes.Where(a => a.ID == id).First(); club.WithTypes.DeleteObject(re); club.SaveChanges(); gvWith.DataSource = club.getWithTypes(); gvWith.DataBind(); string Message = " تم الحذف "; ScriptManager.RegisterStartupScript(Page, this.GetType(), "alert", string.Format("alert('{0}');", Message), true); } catch { lblError.Text = "لايمكن الحذف"; lblError.Visible = true; } } }