public bool Insert(staff nv) { try { db.staffs.InsertOnSubmit(nv); var permissions = from p in db.permissions select p; foreach (permission p in permissions) { staff_permission sp = new staff_permission(); sp.permission = p; sp.staff = nv; sp.created = DateTime.Now; sp.allow = false; db.staff_permissions.InsertOnSubmit(sp); } db.SubmitChanges(); return(true); } catch (Exception ex) { throw ex; } }
public bool Delete(staff nv) { try { staff_permission p = db.staff_permissions.Where(t => t.staff_id.Equals(nv.id)).FirstOrDefault(); if (p != null) { return(false); } return(true); } catch (Exception ex) { throw ex; } }