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");
}
