public bool AddNewUser(string Login, string Password, HashSet <string> Roles)
{
try
{
if (Login == null || Password == null)
{
return(false);
}
foreach (User item in _userDao.GetAllUsers())
{
if (item.Login == Login)
{
return(false);
}
}
User user = new User {
Login = Login, Password = Password
};
if (Roles == null)
{
user.Roles = new HashSet <string>();
}
else
{
user.Roles = Roles;
}
return(_userDao.AddNewUser(user));
}
catch (Exception ex)
{
MyLogger.AddLog(ex.Message, ex.StackTrace);
Logger.Log.Error(ex.Message);
return(false);
}
}
public IEnumerable <Comment> GetAllCommentPhoto(int PhotoID)
{
try
{
LinkedList <Comment> AllComment = new LinkedList <Comment>();
using (SqlConnection con = new SqlConnection(conStr))
{
SqlCommand cmd = con.CreateCommand();
con.Open();
cmd.CommandText = "dbo.GetAllCommentPhoto";
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SqlDataReader sqlDataReader = cmd.ExecuteReader();
while (sqlDataReader.Read())
{
int Id = (int)sqlDataReader["Id"];
string Author = (string)sqlDataReader["Author"];
int IDPhoto = (int)sqlDataReader["PhotoID"];
string TextComment = (string)sqlDataReader["TextComment"];
if (IDPhoto == PhotoID)
{
AllComment.AddLast(new Comment {
ID = Id, Author = Author, PhotoID = PhotoID, TextComment = TextComment
});
}
}
}
return(AllComment);
}
catch (Exception ex)
{
MyLogger.AddLog(ex.Message, ex.StackTrace);
Logger.Log.Error(ex.Message);
return(null);
}
}
public bool LikePhoto(int PhotoId, int LikedUserId)
{
try
{
Photo photo = GetPhotoById(PhotoId);
bool UserInArray = false;
foreach (int item in photo.LikeUsersList)
{
if (item == LikedUserId)
{
UserInArray = true;
}
}
if (!UserInArray)
{
return(_photoDao.LikePhoto(PhotoId, LikedUserId));
}
else
{
return(_photoDao.RemoveLikePhoto(PhotoId, LikedUserId));
}
}
catch (Exception ex)
{
MyLogger.AddLog(ex.Message, ex.StackTrace);
Logger.Log.Error(ex.Message);
return(false);
}
}
public bool EditPhoto(int PhotoId, string NewTitle, string NewCounry)
{
try
{
if (PhotoId == 0 || (NewTitle == "" && NewCounry == ""))
{
return(false);
}
if (NewTitle == "")
{
NewTitle = _photoDao.GetPhotoById(PhotoId).Title;
}
if (NewCounry == "")
{
NewCounry = _photoDao.GetPhotoById(PhotoId).Country;
}
return(_photoDao.EditPhoto(PhotoId, NewTitle, NewCounry));
}
catch (Exception ex)
{
MyLogger.AddLog(ex.Message, ex.StackTrace);
Logger.Log.Error(ex.Message);
return(false);
}
}
public User GetUserById(int UserID)
{
try
{
return(_userDao.GetUserById(UserID));
}
catch (Exception ex)
{
MyLogger.AddLog(ex.Message, ex.StackTrace);
Logger.Log.Error(ex.Message);
return(null);
}
}
public bool RemovePhoto(int PhotoId)
{
try
{
return(_photoDao.RemovePhoto(PhotoId));
}
catch (Exception ex)
{
MyLogger.AddLog(ex.Message, ex.StackTrace);
Logger.Log.Error(ex.Message);
return(false);
}
}
public IEnumerable <Photo> GetAllPhoto()
{
try
{
HashSet <Photo> AllPhoto = new HashSet <Photo>();
using (SqlConnection con = new SqlConnection(conStr))
{
SqlCommand cmd = con.CreateCommand();
con.Open();
cmd.CommandText = "dbo.GetAllPhoto";
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SqlDataReader sqlDataReader = cmd.ExecuteReader();
User[] usersAttachment = new User[] { };
while (sqlDataReader.Read())
{
int Id = (int)sqlDataReader["Id"];
string Title = (string)sqlDataReader["Title"];
string Country = (string)sqlDataReader["Country"];
int AuthorId = (int)sqlDataReader["AuthorId"];
byte[] Image = Convert.FromBase64String((string)sqlDataReader["Image"]);
int LikeAuthorId = 0;
HashSet <int> LikeUsersList = new HashSet <int> {
};
if (!System.DBNull.Value.Equals(sqlDataReader["User_Id"]))
{
LikeAuthorId = (int)sqlDataReader["User_Id"];
LikeUsersList.Add(LikeAuthorId);
}
Photo photo = new Photo {
Id = Id, Title = Title, Country = Country, AuthorId = AuthorId, LikeUsersList = LikeUsersList, Image = Image
};
Photo SerchPhoto = AllPhoto.FirstOrDefault(element => element.Id == photo.Id);
if (SerchPhoto != null && LikeAuthorId != 0)
{
SerchPhoto.LikeUsersList.Add(LikeAuthorId);
}
else
{
AllPhoto.Add(photo);
}
}
}
return(AllPhoto);
}
catch (Exception ex)
{
MyLogger.AddLog(ex.Message, ex.StackTrace);
Logger.Log.Error(ex.Message);
return(null);
}
}
public IEnumerable <User> GetAllUsers()
{
try
{
HashSet <User> AllUsers = new HashSet <User>();
using (SqlConnection con = new SqlConnection(conStr))
{
SqlCommand cmd = con.CreateCommand();
con.Open();
cmd.CommandText = "dbo.GetAllUsers";
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SqlDataReader sqlDataReader = cmd.ExecuteReader();
User[] usersAttachment = new User[] { };
while (sqlDataReader.Read())
{
int Id = (int)sqlDataReader["Id"];
string Login = (string)sqlDataReader["Login"];
string Password = (string)sqlDataReader["Password"];
string Role = "";
HashSet <string> Roles = new HashSet <string> {
};
if (!System.DBNull.Value.Equals(sqlDataReader["RoleName"]))
{
Role = (string)sqlDataReader["RoleName"];
Roles.Add(Role);
}
User user = new User {
Id = Id, Login = Login, Password = Password, Roles = Roles
};
User SerchUser = AllUsers.FirstOrDefault(element => element.Login == user.Login);
if (SerchUser != null && Role != "")
{
SerchUser.Roles.Add(Role);
}
else
{
AllUsers.Add(user);
}
}
}
return(AllUsers);
}
catch (Exception ex)
{
MyLogger.AddLog(ex.Message, ex.StackTrace);
Logger.Log.Error(ex.Message);
return(null);
}
}
public bool RemoveUserRole(int UserID, string RoleName)
{
try
{
if (UserID == 0 || RoleName == null || RoleName == "")
{
return(false);
}
return(_userDao.RemoveUserRole(UserID, RoleName));
}
catch (Exception ex)
{
MyLogger.AddLog(ex.Message, ex.StackTrace);
Logger.Log.Error(ex.Message);
return(false);
}
}
public Photo GetPhotoById(int PhotoId)
{
try
{
if (PhotoId == 0)
{
return(null);
}
return(_photoDao.GetPhotoById(PhotoId));
}
catch (Exception ex)
{
MyLogger.AddLog(ex.Message, ex.StackTrace);
Logger.Log.Error(ex.Message);
return(null);
}
}
public bool RemoveComment(int ID)
{
try
{
if (ID == 0)
{
return(false);
}
return(_commentDao.RemoveComment(ID));
}
catch (Exception ex)
{
MyLogger.AddLog(ex.Message, ex.StackTrace);
Logger.Log.Error(ex.Message);
return(false);
}
}
public bool AddPhoto(string Title, string Country, byte[] Image, int AuthorId)
{
try
{
if (Title == null || Country == null || Image == null || AuthorId == 0)
{
return(false);
}
Photo photo = new Photo {
AuthorId = AuthorId, Country = Country, Image = Image, Title = Title, LikeUsersList = new HashSet <int>()
};
return(_photoDao.AddPhoto(photo));
}
catch (Exception ex)
{
MyLogger.AddLog(ex.Message, ex.StackTrace);
Logger.Log.Error(ex.Message);
return(false);
}
}
public bool AddComment(int PhotoID, string Author, string TextComment)
{
try
{
if (PhotoID == 0 || Author == null || TextComment == null)
{
return(false);
}
Comment comment = new Comment {
PhotoID = PhotoID, Author = Author, TextComment = TextComment
};
return(_commentDao.AddComment(comment));
}
catch (Exception ex)
{
MyLogger.AddLog(ex.Message, ex.StackTrace);
Logger.Log.Error(ex.Message);
return(false);
}
}
