12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879 |
- package DAOImplement;
- import HibernateEntities.ModeratorsEntity;
- import HibernateEntities.ProjectsEntity;
- import org.hibernate.Session;
- import org.hibernate.query.Query;
- import javax.jws.WebParam;
- import java.util.ArrayList;
- import java.util.HashMap;
- import java.util.List;
- import static HibernateUtil.HibernateUtil.getSession;
- /**
- * Created by Кинетик on 31.12.2016.
- */
- public class AdminDao {
- public static HashMap<String, ModeratorsEntity> getAdminMap(){
- Session session = getSession();
- Query query = session.createQuery("FROM ModeratorsEntity ");
- List<ModeratorsEntity> res = query.list();
- HashMap<String, ModeratorsEntity> adminsDict = new HashMap<>();
- for(ModeratorsEntity ad: res){
- adminsDict.put(ad.getModFamily()+" "+ad.getModFirstName()+" "+ad.getModSecName(),ad);
- }
- session.close();
- return adminsDict;
- }
- public static ArrayList<String> getAdminList(){
- Session session = getSession();
- Query query = session.createQuery("FROM ModeratorsEntity ");
- List<ModeratorsEntity> res = query.list();
- ArrayList<String> adminsList = new ArrayList<>();
- for(ModeratorsEntity ad: res){
- adminsList.add(ad.getModFamily()+" "+ad.getModFirstName()+" "+ad.getModSecName());
- }
- session.close();
- return adminsList;
- }
- public static void createNewAdmin(ModeratorsEntity admin) {
- Session session = getSession();
- Query query = session.createQuery("select max(modId) from ModeratorsEntity ");
- Integer res = (Integer) query.uniqueResult();
- admin.setModId(res+1);
- session.beginTransaction();
- session.save(admin);
- session.getTransaction().commit();
- session.close();
- }
- public static void updateAdmin (ModeratorsEntity admin) {
- Session session = getSession();
- session.beginTransaction();
- session.update(admin);
- session.getTransaction().commit();
- session.close();
- }
- public static List<ProjectsEntity> getAdminProject(ModeratorsEntity admin) {
- Session session = getSession();
- Query query = session.createQuery("FROM ProjectsEntity Where clId = :modId");
- query.setParameter("modId", admin.getModId());
- List<ProjectsEntity> res = query.list();
- session.close();
- return res;
- }
- public static boolean checkIsAdmin(ModeratorsEntity admin){
- Session session = getSession();
- Query query = session.createQuery("FROM ModeratorsEntity WHERE modFamily = :Family and modFirstName = :Name and modSecName = :SecondName");
- query.setParameter("Family", admin.getModFamily());
- query.setParameter("Name", admin.getModFirstName());
- query.setParameter("SecondName", admin.getModSecName());
- List<ModeratorsEntity> res = query.list();
- if(res.size()==0){
- return false;
- }
- return true;
- }
- }
|