private static bool ExecuteDB(TeamMember Tmember, DBQueryType queryType) { using (spiffaiwebEntities db = LoadDB()) { switch (queryType) { case DBQueryType.Add: db.TeamMembers.Add(Tmember); break; case DBQueryType.Update: db.TeamMembers.Attach(Tmember); db.Entry(Tmember).State = System.Data.Entity.EntityState.Modified; break; case DBQueryType.Delete: db.TeamMembers.Remove(Tmember); break; default: break; } db.SaveChanges(); } return true; }
private static bool ExecuteDB(webpages_Roles WpRoles, DBQueryType queryType) { using (spiffaiwebEntities db = LoadDB()) { switch (queryType) { case DBQueryType.Add: db.webpages_Roles.Add(WpRoles); break; case DBQueryType.Update: db.webpages_Roles.Attach(WpRoles); db.Entry(WpRoles).State = System.Data.Entity.EntityState.Modified; break; case DBQueryType.Delete: db.webpages_Roles.Remove(WpRoles); break; default: break; } db.SaveChanges(); } return true; }
private static bool ExecuteDB(ProjectVersion Pversion, DBQueryType queryType) { using (spiffaiwebEntities db = LoadDB()) { switch (queryType) { case DBQueryType.Add: db.ProjectVersions.Add(Pversion); break; case DBQueryType.Update: db.ProjectVersions.Attach(Pversion); db.Entry(Pversion).State = System.Data.Entity.EntityState.Modified; break; case DBQueryType.Delete: db.ProjectVersions.Remove(Pversion); break; default: break; } db.SaveChanges(); } return true; }
private static bool ExecuteDB(UserProfile usrprof, DBQueryType queryType) { using (spiffaiwebEntities db = LoadDB()) { switch (queryType) { case DBQueryType.Add: db.UserProfiles.Add(usrprof); break; case DBQueryType.Update: db.UserProfiles.Attach(usrprof); db.Entry(usrprof).State = System.Data.Entity.EntityState.Modified; break; case DBQueryType.Delete: db.UserProfiles.Remove(usrprof); break; default: break; } db.SaveChanges(); } return true; }