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