Exemplo n.º 1
0
 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;
 }
Exemplo n.º 2
0
 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;
 }
Exemplo n.º 3
0
 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;
 }
Exemplo n.º 4
0
 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;
 }