protected void gvSer_RowDeleting(object sender, GridViewDeleteEventArgs e) { int id = Convert.ToInt32(gvSer.Rows[e.RowIndex].Cells[7].Text); using (ClubDBEntities club = new ClubDBEntities()) { // check that the service is not attached var att = club.InvoiceServices.Where(a => a.ServiceID == id).FirstOrDefault(); var re = club.Services.Where(a => a.ServiceID == id).First(); if (att == null) { club.Services.DeleteObject(re); club.SaveChanges(); } else { re.Deleted = true; club.SaveChanges(); } gvSer.DataSource = club.getServices(); gvSer.DataBind(); string Message = " تم الحذف "; ScriptManager.RegisterStartupScript(Page, this.GetType(), "alert", string.Format("alert('{0}');", Message), true); } }
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 Page_Load(object sender, EventArgs e) { using (ClubDBEntities club = new ClubDBEntities()) { GridView1.DataSource = club.getServices(); GridView1.DataBind(); } //ReportDocument report = new ReportDocument(); //report.Load(Server.MapPath("DischargeCR.rpt")); //using (ClubDBEntities club = new ClubDBEntities()) //{ // DateTime date = new DateTime(2011, 12, 29); // report.SetDataSource(club.getDischargeReport(1)); // CrystalReportViewer1.ReportSource = report; //} //ReportDocument report = new ReportDocument(); //report.Load(Server.MapPath("test.rpt")); //ClubDBEntities club = new ClubDBEntities(); //report.SetDataSource(club.getInvoiceHeader(102)); //CrystalReportViewer1.ReportSource = report; //Roles.CreateRole(ERoles.InternalS.ToString()); //Roles.CreateRole(ERoles.Manager.ToString()); //Roles.CreateRole(ERoles.Nutritionist.ToString()); //Roles.CreateRole(ERoles.PhysicalS.ToString()); //Roles.CreateRole(ERoles.Receptionist.ToString()); }
protected void btnSAdd_Click(object sender, EventArgs e) { bool sub = (rbSType.SelectedIndex == 0) ? false : true; string name = tbSName.Text; decimal price = Convert.ToDecimal(tbPrice.Text); int days = string.IsNullOrEmpty(tbDays.Text)?0:Convert.ToInt32(tbDays.Text); int dep = Convert.ToInt32(ddlSDep.SelectedValue); using (ClubDBEntities club = new ClubDBEntities()) { var ser = club.Services.Where(a => a.ServiceID == EditSer).First(); ser.Name = name; ser.Sub = sub; ser.Price = price; ser.TotalDays = days; ser.DepID = dep; club.SaveChanges(); gvSer.DataSource = club.getServices(); gvSer.DataBind(); resetSer(); } }
protected void gvSer_RowDeleting(object sender, GridViewDeleteEventArgs e) { int id = Convert.ToInt32(gvSer.Rows[e.RowIndex].Cells[7].Text); using (ClubDBEntities club = new ClubDBEntities()) { try { var re = club.Services.Where(a => a.ServiceID == id).First(); club.Services.DeleteObject(re); club.SaveChanges(); gvSer.DataSource = club.getServices(); gvSer.DataBind(); string Message = " تم الحذف "; ScriptManager.RegisterStartupScript(Page, this.GetType(), "alert", string.Format("alert('{0}');", Message), true); } catch { lblError.Text = "لايمكن الحذف"; lblError.Visible = true; } } }