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)
{
if (Project != null)
{
entiteti.spInsertProject(Project.IdUser, Project.Title, Project.Tag, Project.Description, Project.MainImageLink);
}
OperacijaRezultat rez = new OperacijaRezultat()
{
HaveItems = false, Status = true
};
return(rez);
}
public override OperacijaRezultat izvrsi(ArchitectDatabaseEntities entiteti)
{
if (User != null)
{
entiteti.spInsertUser(User.firstName, User.lastName, User.email, BCrypt.Net.BCrypt.HashPassword(User.password), User.makeVerificationCode(), User.idRole, User.idStatus);
}
OperacijaRezultat rez = new OperacijaRezultat()
{
HaveItems = false, Status = true
};
return(rez);
}
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 OperacijaRezultat izvrsiOperaciju(Operacija op)
{
try
{
return(op.izvrsi(this.entiteti));
}
catch (Exception e)
{
OperacijaRezultat obj = new OperacijaRezultat();
obj.Status = false;
#if DEBUG
obj.Poruka = e.Message;
#endif
return(obj);
}
}
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)
{
int num = (from votes in entiteti.PollVotes
join answer in entiteti.PollAnswers on votes.idAnswer equals answer.idPollAnswer
where Vote.IpAddress == votes.ipAddress && Vote.IdQuestion == answer.idPollQuestion
select votes).Count();
OperacijaRezultat result = new OperacijaRezultat()
{
Poruka = "inserting poll vote"
};
if (num == 0)
{
entiteti.spInsertPollVote(Vote.IpAddress, Vote.IdAnswer);
result.Status = true;
}
else
{
result.Status = false;
}
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);
}
