protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName == "Delete") { using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities()) { try { string bed = ((Literal)e.Item.FindControl("Bed")).Text; var beds = (from r in myEntities.Hospital__Bed where (r.H_ID == hid && r.BedNo == bed) select r).Single(); if (beds.Occupied == false) { myEntities.DeleteObject(beds); } myEntities.SaveChanges(); } catch (Exception ex) { //notify = true; //note = ex.Message; } } Response.Redirect("~/Hospital/Management/Beds.aspx"); } }
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName == "Delete") { using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities()) { try { int did = Convert.ToInt32(((Literal)e.Item.FindControl("DID")).Text); var dept = from r in myEntities.Hospital__Department where (r.D_ID == did && r.H_ID == hid) select r; myEntities.DeleteObject(dept.Single()); myEntities.SaveChanges(); } catch (Exception ex) { notify = true; note = ex.Message; } } Response.Redirect("~/Hospital/Management/Departments.aspx"); } }
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e) { using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities()) { try { string cp_id = ((Literal)e.Item.FindControl("CPID")).Text; Hospital__Physician cp = (from r in myEntities.Hospital__Physician where r.CP_ID == cp_id && r.H_ID == hid select r).SingleOrDefault(); switch (e.CommandName) { case "Delete": myEntities.DeleteObject(cp); myEntities.SaveChanges(); break; case "Save": cp.Unit = ((TextBox)e.Item.FindControl("CPUnit")).Text; myEntities.SaveChanges(); break; } Response.Redirect("~/Hospital/Management/Physicians.aspx"); } catch (Exception ex) { //notify = true; //note = ex.Message; } } }
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e) { using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities()) { try { if (e.CommandName == "Delete") { string cp_id = ((Literal)e.Item.FindControl("CPID")).Text; Physician__Patient cp = (from r in myEntities.Physician__Patient where (r.CP_ID == cp_id && r.P_ID == pid) select r).SingleOrDefault(); myEntities.DeleteObject(cp); myEntities.SaveChanges(); } Response.Redirect(String.Format("~/Hospital/PatientInfo/Physicians.aspx?PID={0}", pid)); } catch (Exception ex) { //notify = true; //note = ex.Message; } } }