void fn_Remove_HealthStatus(int id)
{
tbl_HealthStatus hs = new tbl_HealthStatus();
hs = db.tbl_HealthStatus.Find(id);
db.tbl_HealthStatus.Remove(hs);
db.SaveChanges();
fn_LoadAllHealthStatus();
}
private void Button1_Click(object sender, EventArgs e)
{
tbl_HealthStatus hs = new tbl_HealthStatus();
hs.name = textBox1.Text;
db.tbl_HealthStatus.Add(hs);
db.SaveChanges();
fn_LoadAllHealthStatus();
}
private void Button3_Click(object sender, EventArgs e)
{
tbl_HealthStatus hs = new tbl_HealthStatus();
hs = db.tbl_HealthStatus.Find(7);
hs.name = hs.name + "*";
db.Entry(hs).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
fn_LoadAllHealthStatus();
}
void fn_Update_HealthStatus(int id, string name)
{
tbl_HealthStatus hs = new tbl_HealthStatus();
hs = db.tbl_HealthStatus.Find(7);
hs.name = name;
db.Entry(hs).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
fn_LoadAllHealthStatus();
}
private void Button2_Click(object sender, EventArgs e)
{
tbl_HealthStatus hs = new tbl_HealthStatus();
hs = db.tbl_HealthStatus.Find(6);
hs.name = hs.name;
hs.name = hs.name.Remove('*');
db.tbl_HealthStatus.Remove(hs);
db.SaveChanges();
fn_LoadAllHealthStatus();
}
