//To Update user
public int UpdateUser(UserDTO entity)
{
try
{
UsersDAL user = new UsersDAL();
PictureDAL picture = new PictureDAL();
if (entity != null)
{
user.Id = entity.Id;
user.FirstName = entity.FirstName;
user.Surname = entity.Surname;
user.Email = entity.Email;
user.Password = entity.Password;
user.RoleId = entity.RoleId == 0 ? 1 : entity.RoleId;
if (entity.Picture != null)
{
picture.Image = entity.Picture.Image;
picture.UserId = entity.Id;
}
}
_unitOfWork.UserRepository.Update(user, picture);
_unitOfWork.Save();
return(1);
}
catch
{
throw;
}
}
public List <ArticleImage> GetPictureById(int articleId)
{
var pictures = new List <PictureDAL>();
using (SqlConnection conn = new SqlConnection(connString))
{
conn.Open();
SqlCommand cmd = new SqlCommand("PS_GetPictureByArticleId", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@articleId", articleId));
using (SqlDataReader rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
var picture = new PictureDAL();
picture.ArticleId = (int)rdr["ArticleId"];
picture.PictureId = (int)rdr["PictureId"];
picture.Picture = (string)rdr["Picture"];
pictures.Add(picture);
}
}
}
//var articleImages = new List<ArticleImage>();
//foreach (var picture in pictures)
//{
// articleImages.Add ( picture.ToDomain());
//}
//return articleImages;
List <ArticleImage> articleImages = pictures.Select(picture => picture.ToDomain()).ToList();
return(articleImages);
}
// Register user
public override void Create(UsersDAL user)
{
user.Password = generatePasswordHash(user.Password);
PictureDAL picture = new PictureDAL();
_dbContext.Pictures.Add(picture);
user.Picture = picture;
_dbContext.Set <UsersDAL>().Add(user);
}
// Register user
public void Create(UsersDAL user, PictureDAL picture)
{
//user.PictureId = picture.Id;
//user.Password = generatePasswordHash(user.Password);
//_dbContext.Set<UsersDAL>().Add(user);
//_dbContext.Set<PictureDAL>().Add(picture);
user.Password = generatePasswordHash(user.Password);
_dbContext.Users.Add(user);
picture.UserId = user.Id;
_dbContext.Pictures.Add(picture);
}
public void Update(UsersDAL user, PictureDAL picture)
{
UsersDAL oldUser = _dbContext.Users.Find(user.Id);
PictureDAL oldPicture = _dbContext.Pictures.FirstOrDefault(x => x.UserId == user.Id);
user.Picture = oldPicture;
if (user.Password != oldUser.Password)
{
user.Password = generatePasswordHash(user.Password);
}
_dbContext.Entry(oldUser).State = EntityState.Detached;
_dbContext.Entry(oldPicture).State = EntityState.Detached;
_dbContext.Entry(user).State = EntityState.Modified;
//PictureDAL oldPicture = _dbContext.Pictures.FirstOrDefault(x => x.UserId == user.Id);
if (oldPicture != null && picture != null)
{
oldPicture.Image = picture.Image;
}
_dbContext.Entry(oldPicture).State = EntityState.Modified;
}
//To Add new user
public int AddUser(UserDTO userEntity)
{
try
{
UsersDAL user = new UsersDAL();
PictureDAL picture = new PictureDAL();
if (userEntity != null)
{
user.Id = userEntity.Id;
user.FirstName = userEntity.FirstName;
user.Surname = userEntity.Surname;
user.Email = userEntity.Email;
user.Password = userEntity.Password;
user.RoleId = userEntity.RoleId == 0 ? 1 : userEntity.RoleId;
}
_unitOfWork.UserRepository.Create(user);
_unitOfWork.Save();
return(1);
}
catch
{
throw;
}
}
public void PictureUpdate(PictureDAL picture)
{
PictureDAL pictureDAL = _dbContext.Pictures.Find(picture.Id);
pictureDAL.Image = picture.Image;
}
//public static int Update(int Id, int fileSize, byte[] bytes)
//{
// return PictureDAL.Update(Id,fileSize,bytes);
//}
public static int Remove(int Id)
{
return(PictureDAL.Remove(Id));
}
public static int AddPictureUser(int picId, Guid UserId)
{
return(PictureDAL.AddPictureUser(picId, UserId));
}
public static int AddandGetId(string fileName, int fileSize, byte[] bytes, Guid userId)
{
return(PictureDAL.AddandGetId(fileName, fileSize, bytes, userId));
}
public static object GetImageOnlyByUserId(Guid userId)
{
return(PictureDAL.GetImageOnlyByUserId(userId));
}
public static int GetLatestId()
{
return(PictureDAL.GetLatestId());
}
public static object GetImageOnlyById(int Id)
{
return(PictureDAL.GetImageOnlyById(Id));
}
public static DataTable GetById(int Id)
{
return(PictureDAL.GetById(Id));
}
public static DataTable GetAll()
{
return(PictureDAL.GetAll());
}
