public override OperationResult Execute(AspSiteBazaEntities entities)
{
IEnumerable <SingleDto> ieSingle =
from s in entities.Products
where s.product_id == this.id
select new SingleDto
{
Id = s.product_id,
Description = s.description,
Header = s.header,
Pictures = (from pic in s.Pictures
select new PictureDto
{
Alt = pic.alt,
Src = pic.src,
Id = pic.picture_id
}).ToList()
};
SingleDto[] single = ieSingle.ToArray();
OperationResult result = new OperationResult();
result.Items = single;
result.Status = true;
return(result);
}
//public int id;
public override OperationResult Execute(AspSiteBazaEntities entities)
{
IEnumerable <UserDetailsDto> ieUsers =
from i in entities.AspNetUsers
select new UserDetailsDto
{
UUID = i.Id,
UserName = i.UserName,
Email = i.Email,
PasswordHash = i.PasswordHash
};
if (!Criteria.Uuid.IsNullOrWhiteSpace())
{
ieUsers = ieUsers.Where(r => r.UUID == Criteria.Uuid);
}
//if (!Criteria.Name.IsNullOrWhiteSpace())
//{
// ieUsers = ieUsers.Where(r => r.UserName == Criteria.Name);
//}
UserDetailsDto[] user = ieUsers.ToArray();
OperationResult result = new OperationResult();
result.Status = true;
result.Items = user;
return(result);
}
public override OperationResult Execute(AspSiteBazaEntities entities)
{
IEnumerable <SingleDto> ieSingle =
from s in entities.Products
select new SingleDto
{
Id = s.product_id,
Description = s.description,
Header = s.header,
Pictures = (from pic in s.Pictures
select new PictureDto
{
Alt = pic.alt,
Src = pic.src,
Id = pic.picture_id
}).ToList()
};
if (Criteria.Id != 0)
{
ieSingle = ieSingle.Where(r => r.Id == Criteria.Id);
}
if (!Criteria.Name.IsNullOrWhiteSpace())
{
ieSingle = ieSingle.Where(r => r.Header == Criteria.Name);
}
SingleDto[] single = ieSingle.ToArray();
OperationResult result = new OperationResult();
result.Items = single;
result.Status = true;
return(result);
}
public override OperationResult Execute(AspSiteBazaEntities entities)
{
AspNetRole role = new AspNetRole();
role.Name = this.Role.Name;
role.Id = Guid.NewGuid().ToString();
entities.AspNetRoles.Add(role);
entities.SaveChanges();
return(base.Execute(entities));
}
public override OperationResult Execute(AspSiteBazaEntities entities)
{
AspNetUser user = new AspNetUser();
user.UserName = this.User.UserName;
user.Id = Guid.NewGuid().ToString();
user.Email = this.User.Email;
user.PasswordHash = this.User.PasswordHash;
entities.AspNetUsers.Add(user);
entities.SaveChanges();
return(base.Execute(entities));
}
public override OperationResult Execute(AspSiteBazaEntities entities)
{
Comment com = new Comment
{
product_id = komentar_prenos.ProductId,
user_id = komentar_prenos.UserId,
content = komentar_prenos.Content
};
entities.Comments.Add(com);
entities.SaveChanges();
return(base.Execute(entities));
}
public override OperationResult Execute(AspSiteBazaEntities entities)
{
Contact contact = new Contact();
contact.email = this.Dto.Email;
contact.message = this.Dto.Message;
contact.website = this.Dto.Website;
entities.Contacts.Add(contact);
entities.SaveChanges();
return(base.Execute(entities));
}
public override OperationResult Execute(AspSiteBazaEntities entities)
{
IEnumerable <MessageDto> ieMessage =
from m in entities.Contacts
select new MessageDto
{
Message = m.message,
Website = m.website,
Email = m.email
};
OperationResult result = new OperationResult();
result.Status = true;
result.Items = ieMessage.ToArray();
return(result);
}
public override OperationResult Execute(AspSiteBazaEntities entities)
{
IEnumerable <WholeUserDto> ieUsers =
from u in entities.AspNetUsers
select new WholeUserDto
{
UserName = u.UserName,
Email = u.Email,
//Role = new AspNetRole(),
};
OperationResult result = new OperationResult();
result.Items = ieUsers.ToArray();
result.Status = true;
return(result);
}
public override OperationResult Execute(AspSiteBazaEntities entities)
{
AspNetUser user = entities.AspNetUsers.Where(r => r.Id == Uuid).FirstOrDefault();
if (user != null)
{
entities.AspNetUsers.Remove(user);
entities.SaveChanges();
return(base.Execute(entities));
}
else
{
OperationResult result = new OperationResult();
result.Status = false;
result.Message = "The user doesn't exist.";
return(result);
}
}
public override OperationResult Execute(AspSiteBazaEntities entities)
{
AspNetRole role = entities.AspNetRoles.Where(r => r.Id == Role.UUID).FirstOrDefault();
if (role != null)
{
role.Name = Role.Name;
entities.SaveChanges();
return(base.Execute(entities));
}
else
{
OperationResult result = new OperationResult();
result.Status = false;
result.Message = "The role doesn't exist or has some users";
return(result);
}
}
public override OperationResult Execute(AspSiteBazaEntities entities)
{
IEnumerable <AuthorDto> ieAuthor =
from a in entities.Authors
select new AuthorDto
{
About = a.about,
Id = a.author_id,
Name = a.name
};
AuthorDto[] author = ieAuthor.ToArray();
OperationResult op = new OperationResult();
op.Status = true;
op.Items = author;
return(op);
}
public override OperationResult Execute(AspSiteBazaEntities entities)
{
IEnumerable <ContactDto> ieContact =
from c in entities.Finds
select new ContactDto
{
Id = c.find_id,
Email = c.email,
Address = c.address,
Number = c.number
};
ContactDto[] contact = ieContact.ToArray();
OperationResult result = new OperationResult();
result.Status = true;
result.Items = contact;
return(result);
}
public override OperationResult Execute(AspSiteBazaEntities entities)
{
SliderDto dto = new SliderDto();
IEnumerable <PictureDto> iePictures =
from p in entities.Sliders
select new PictureDto
{
Alt = p.Picture.alt,
Src = p.Picture.src
};
dto.Pictures = iePictures.ToList();
OperationResult result = new OperationResult();
result.Status = true;
result.Items = new BaseDto[1];
result.Items[0] = dto;
return(result);
}
public override OperationResult Execute(AspSiteBazaEntities entities)
{
//Comment comment = new Comment();
//UserDto user = new UserDto();
//comment.comment_id = this.Comment.Id+1;
//comment.content = this.Comment.Content;
//comment.product_id = this.Comment.ProductId;
//comment.user_id = user.UUID;
//Comment comment = new Comment
//{
// product_id =
//}
//entities.Comments.Add(comment);
//entities.SaveChanges();
return(base.Execute(entities));
}
public override OperationResult Execute(AspSiteBazaEntities entities)
{
IEnumerable <UserDetailsDto> ieUsers =
from i in entities.AspNetUsers
where i.Id == this.id
select new UserDetailsDto
{
UserName = i.UserName,
Email = i.Email,
PasswordHash = i.PasswordHash
};
UserDetailsDto[] user = ieUsers.ToArray();
OperationResult result = new OperationResult();
result.Status = true;
result.Items = user;
return(result);
}
public override OperationResult Execute(AspSiteBazaEntities entities)
{
Product sing = new Product();
sing.header = Dto.Header;
sing.description = this.Dto.Description;
foreach (var picture in this.Dto.Pictures)
{
Picture p = new Picture
{
alt = picture.Alt,
src = picture.Src
};
sing.Pictures.Add(p);
}
entities.Products.Add(sing);
entities.SaveChanges();
return(base.Execute(entities));
}
public override OperationResult Execute(AspSiteBazaEntities entities)
{
//Product single = entities.Products.Find(Id);
Product single = entities.Products.Where(r => r.product_id == Id).FirstOrDefault();
if (single != null)
{
//entities.Entry(single).State = System.Data.Entity.EntityState.Deleted;
entities.Products.Remove(single);
entities.SaveChanges();
return(base.Execute(entities));
}
else
{
OperationResult result = new OperationResult();
result.Status = false;
result.Message = "The post doesn't exist.";
return(result);
}
}
public override OperationResult Execute(AspSiteBazaEntities entities)
{
AspNetUser user = entities.AspNetUsers.Where(r => r.Id == User.UUID).FirstOrDefault();
if (user != null)
{
user.UserName = User.UserName;
user.Email = User.Email;
user.PasswordHash = User.PasswordHash;
entities.SaveChanges();
return(base.Execute(entities));
}
else
{
OperationResult result = new OperationResult();
result.Status = false;
result.Message = "The user doesn't exist.";
return(result);
}
}
public override OperationResult Execute(AspSiteBazaEntities entities)
{
IEnumerable <CommentDto> ieComment =
from com in entities.Comments
where com.product_id == this.id
select new CommentDto
{
Content = com.content,
UserId = com.user_id,
ProductId = com.product_id,
User = (from user in entities.AspNetUsers
select new UserDto
{
UserName = user.UserName
}).ToList()
};
OperationResult result = new OperationResult();
CommentDto[] comment = ieComment.ToArray();
result.Items = comment;
result.Status = true;
return(result);
}
public override OperationResult Execute(AspSiteBazaEntities entities)
{
IEnumerable <RoleDto> ieRoles =
from r in entities.AspNetRoles
select new RoleDto
{
Name = r.Name,
UUID = r.Id
};
if (!Criteria.Uuid.IsNullOrWhiteSpace())
{
ieRoles = ieRoles.Where(r => r.UUID == Criteria.Uuid);
}
if (!Criteria.Name.IsNullOrWhiteSpace())
{
ieRoles = ieRoles.Where(r => r.Name == Criteria.Name);
}
OperationResult result = new OperationResult();
result.Items = ieRoles.ToArray();
result.Status = true;
return(result);
}
public abstract OperationResult Execute(AspSiteBazaEntities entities);
