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 Insert_Click(object sender, EventArgs e) { using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities()) { try { Hospital__Physician relation = new Hospital__Physician(); relation.CP_ID = cpid; relation.H_ID = hid; relation.UpdatedBy = Profile.UserName; relation.UpdateDateTime = DateTime.Now; relation.UpdateUserName = Profile.Name; myEntities.AddToHospital__Physician(relation); myEntities.SaveChanges(); } catch (Exception ex) { Notification.Text = ex.Message; } } Response.Redirect("~/Hospital/Management/Physicians.aspx"); }