public override OperacijaRezultat izvrsi(ArchitectDatabaseEntities entiteti) { IEnumerable <StatusDb> ieStatus; if (Kriterijum != null) { ieStatus = from status in entiteti.Status where (Kriterijum.IdStatus == null ? true : Kriterijum.IdStatus == status.idStatus) select new StatusDb() { IdStatus = status.idStatus, StatusName = status.statusName }; } else { ieStatus = from status in entiteti.Status select new StatusDb() { IdStatus = status.idStatus, StatusName = status.statusName }; } OperacijaRezultat result = new OperacijaRezultat() { Status = true, Poruka = "Select Roles", DbItems = ieStatus.ToArray() }; result.CheckDbItems(); return(result); }
public override OperacijaRezultat izvrsi(ArchitectDatabaseEntities entiteti) { IEnumerable <RoleDb> ieRole; if (Kriterijum != null) { ieRole = from role in entiteti.Roles where (Kriterijum.IdRole == null ? true : Kriterijum.IdRole == role.idRole) select new RoleDb() { IdRole = role.idRole, RoleName = role.roleName }; } else { ieRole = from role in entiteti.Roles select new RoleDb() { IdRole = role.idRole, RoleName = role.roleName }; } OperacijaRezultat result = new OperacijaRezultat() { Status = true, Poruka = "Select Roles", DbItems = ieRole.ToArray() }; result.CheckDbItems(); return(result); }
public override OperacijaRezultat izvrsi(ArchitectDatabaseEntities entiteti) { IEnumerable <PollAnswersDb> iePollAnswers; if (PollQuestion != null) { iePollAnswers = (from polla in entiteti.PollAnswers where (polla.idPollQuestion == PollQuestion.IdPollQuestion) select new PollAnswersDb() { IdPollAnswer = polla.idPollAnswer, PollAnswer = polla.answer }); } else { iePollAnswers = (from polla in entiteti.PollAnswers select new PollAnswersDb() { IdPollAnswer = polla.idPollAnswer, PollAnswer = polla.answer }); } OperacijaRezultat result = new OperacijaRezultat() { Status = true, Poruka = "poll answers select" }; result.DbItems = iePollAnswers.ToArray(); result.CheckDbItems(); return(result); }
public override OperacijaRezultat izvrsi(ArchitectDatabaseEntities entiteti) { IEnumerable <PollQuestionDb> iePollQuestions; if (Kriterijum != null) { iePollQuestions = from pq in entiteti.PollQuestions where (Kriterijum.IdPollQuestion == null ? true : Kriterijum.IdPollQuestion == pq.idPollQuestion) select new PollQuestionDb() { IdPollQuestion = pq.idPollQuestion, PollQuestion = pq.question }; } else { iePollQuestions = from pq in entiteti.PollQuestions select new PollQuestionDb() { IdPollQuestion = pq.idPollQuestion, PollQuestion = pq.question }; } OperacijaRezultat result = new OperacijaRezultat() { Status = true, Poruka = "poll select" }; result.DbItems = iePollQuestions.ToArray(); result.CheckDbItems(); return(result); }
public override OperacijaRezultat izvrsi(ArchitectDatabaseEntities entiteti) { IEnumerable <PollAnswersDb> iePollAnswers; PollDb[] iePollQuestions; if (Kriterijum != null) { iePollQuestions = (from pollq in entiteti.PollQuestions where (Kriterijum.IdPollQuestion != null ? true : Kriterijum.IdPollQuestion == pollq.idPollQuestion) select new PollDb() { IdPollQuestion = pollq.idPollQuestion, PollQuestion = pollq.question }).ToArray(); iePollAnswers = (from polla in entiteti.PollAnswers where (polla.idPollQuestion == iePollQuestions[0].IdPollQuestion) select new PollAnswersDb() { IdPollAnswer = polla.idPollAnswer, PollAnswer = polla.answer }); iePollQuestions[0].answers = iePollAnswers.ToArray(); } else { iePollQuestions = (from pollq in entiteti.PollQuestions select new PollDb() { IdPollQuestion = pollq.idPollQuestion, PollQuestion = pollq.question }).OrderBy(x => Guid.NewGuid()).Take(1).ToArray(); int id = iePollQuestions[0].IdPollQuestion; iePollAnswers = (from polla in entiteti.PollAnswers where (polla.idPollQuestion == id) select new PollAnswersDb() { IdPollAnswer = polla.idPollAnswer, PollAnswer = polla.answer }); iePollQuestions[0].answers = iePollAnswers.ToArray(); } OperacijaRezultat result = new OperacijaRezultat() { Status = true, Poruka = "poll select" }; result.DbItems = iePollQuestions.ToArray(); result.CheckDbItems(); return(result); }
public override OperacijaRezultat izvrsi(ArchitectDatabaseEntities entiteti) { IEnumerable <ProjectDb> ieProjects; if (Kriterijum != null) { ieProjects = from project in entiteti.Projects where ( (Kriterijum.IdProject == null ? true : Kriterijum.IdProject == project.idProject) && (Kriterijum.IdUser == null ? true : Kriterijum.IdUser == project.idUser) && (Kriterijum.NumberOfLikes == null ? true : Kriterijum.NumberOfLikes < project.numberOfLikes) ) select new ProjectDb() { Description = project.description, IdProject = project.idProject, IdUser = project.idUser, LastTimeChanged = project.lastTimeChanged, NumberOfLikes = project.numberOfLikes, Tag = project.tag, TimeOfPost = project.timeOfPost, Title = project.title, MainImageLink = project.mainImageLink }; } else { ieProjects = from project in entiteti.Projects select new ProjectDb() { Description = project.description, IdProject = project.idProject, IdUser = project.idUser, LastTimeChanged = project.lastTimeChanged, NumberOfLikes = project.numberOfLikes, Tag = project.tag, TimeOfPost = project.timeOfPost, Title = project.title, MainImageLink = project.mainImageLink }; } OperacijaRezultat result = new OperacijaRezultat() { Status = true, Poruka = "Project Select" }; result.DbItems = ieProjects.ToArray(); result.CheckDbItems(); return(result); }
public override OperacijaRezultat izvrsi(ArchitectDatabaseEntities entiteti) { IEnumerable <UserDb> ieUser; if (Kriterijum != null) { ieUser = from user in entiteti.Users where ( (Kriterijum.IdUser == null ? true : Kriterijum.IdUser == user.idUser) && (Kriterijum.Email == null ? true : Kriterijum.Email == user.email) && (Kriterijum.Status == null ? true : Kriterijum.Status == user.idStatus) ) select new UserDb() { IdUser = user.idUser, email = user.email, firstName = user.firstName, lastName = user.lastName, idRole = user.idRole, idStatus = user.idStatus, password = user.password, timeOfRegistration = user.timeOfRegistration }; } else { ieUser = from user in entiteti.Users select new UserDb() { IdUser = user.idUser, email = user.email, firstName = user.firstName, lastName = user.lastName, idRole = user.idRole, idStatus = user.idStatus, password = user.password, timeOfRegistration = user.timeOfRegistration }; } OperacijaRezultat rez = new OperacijaRezultat(); rez.Status = true; rez.Poruka = "Select Users"; rez.DbItems = ieUser.ToArray(); rez.CheckDbItems(); return(rez); }
public override OperacijaRezultat izvrsi(ArchitectDatabaseEntities entiteti) { IEnumerable <ProjectDb> ieProjects; if (Numer != null) { ieProjects = (from project in entiteti.Projects orderby project.timeOfPost descending select new ProjectDb() { IdProject = project.idProject, NumberOfLikes = project.numberOfLikes, Tag = project.tag, Title = project.title, MainImageLink = project.mainImageLink }).Take((int)Numer); } else { ieProjects = (from project in entiteti.Projects orderby project.timeOfPost descending select new ProjectDb() { IdProject = project.idProject, NumberOfLikes = project.numberOfLikes, Tag = project.tag, Title = project.title, MainImageLink = project.mainImageLink }); } OperacijaRezultat result = new OperacijaRezultat() { Status = true, Poruka = "Project Select" }; result.DbItems = ieProjects.ToArray(); result.CheckDbItems(); return(result); }
public override OperacijaRezultat izvrsi(ArchitectDatabaseEntities entiteti) { FullProjectDb full = new FullProjectDb(); full.Project = (from project in entiteti.Projects where (Kriterijum.IdProject == null ? true : Kriterijum.IdProject == project.idProject) select new ProjectDb() { IdProject = project.idProject, IdUser = project.idUser, Description = project.description, MainImageLink = project.mainImageLink, Title = project.title, Tag = project.tag }).ToArray()[0]; IEnumerable <ImageDb> images = from img in entiteti.Images where (Kriterijum.IdProject == null ? true : Kriterijum.IdProject == img.idProject) select new ImageDb() { IdImage = img.idImage, BigPictureUrl = img.bigPictureUrl, ImageName = img.imageName, ImgAlt = img.imgAlt, SmallPictureUrl = img.smallPictureUrl }; full.Images = images.ToArray(); OperacijaRezultat result = new OperacijaRezultat(); DbItem[] i = new DbItem[1]; i[0] = full; result.DbItems = i; result.Status = true; result.CheckDbItems(); return(result); }
public override OperacijaRezultat izvrsi(ArchitectDatabaseEntities entiteti) { IEnumerable <ImageDb> ieImages; if (Kriterijum != null) { ieImages = from img in entiteti.Images where (Kriterijum.IdProject == null ? true : Kriterijum.IdProject == img.idProject) select new ImageDb() { BigPictureUrl = img.bigPictureUrl, IdImage = img.idImage, ImageName = img.imageName, ImgAlt = img.imgAlt, SmallPictureUrl = img.smallPictureUrl }; } else { ieImages = from img in entiteti.Images select new ImageDb() { BigPictureUrl = img.bigPictureUrl, IdImage = img.idImage, ImageName = img.imageName, ImgAlt = img.imgAlt, SmallPictureUrl = img.smallPictureUrl }; } OperacijaRezultat result = new OperacijaRezultat(); result.DbItems = ieImages.ToArray(); result.Status = true; result.CheckDbItems(); return(result); }
public override OperacijaRezultat izvrsi(ArchitectDatabaseEntities entiteti) { IEnumerable <MenuDb> ieMenu; if (Kriterijum != null) { ieMenu = from menu in entiteti.Menus where ((Kriterijum.IdMenu == null ? true : Kriterijum.IdMenu == menu.idMenu) && (Kriterijum.idRole == null ? true : Kriterijum.idRole <= menu.idRole)) select new MenuDb() { IdMenu = menu.idMenu, Link = menu.link, Title = menu.title }; } else { ieMenu = from menu in entiteti.Menus select new MenuDb() { IdMenu = menu.idMenu, Link = menu.link, Title = menu.title, IdRole = menu.idRole }; } OperacijaRezultat rez = new OperacijaRezultat(); rez.Status = true; rez.Poruka = "Select Menu"; rez.DbItems = ieMenu.ToArray(); rez.CheckDbItems(); return(rez); }