public Users Create(Users newUser, string pass)
{
newUser.RulesId = 1;
newUser.PositionId = 1;
Console.WriteLine("Create user!");
if (string.IsNullOrWhiteSpace(pass))
{
throw new AppException("Password is required");
}
using (servicedbContext db = new servicedbContext())
{
if (_context.Users.Any(x => x.Email == newUser.Email))
{
throw new ApplicationException("Username " + newUser.Email + " is already taken");
}
}
byte[] passHash, passSalt;
CreatePasswordHash(pass, out passHash, out passSalt);
newUser.PassHash = passHash;
newUser.PassSalt = passSalt;
using (servicedbContext db = new servicedbContext()){
db.Users.Add(newUser);
db.SaveChanges();
}
return(newUser);
}
public Users GetById(int id)
{
using (servicedbContext db = new servicedbContext())
{
return(db.Users.Find(id));
}
}
public async Task <IActionResult> UploadFile(IFormFile image)
{
var images = Request.Form.Files;
if (images == null || images.Count == 0)
{
return(Content("image not selected"));
}
foreach (var item in images)
{
var path = Path.Combine(
Directory.GetCurrentDirectory(), "files",
item.FileName);
using (var stream = new FileStream(path, FileMode.Create))
{
await item.CopyToAsync(stream);
}
Images newImage = new Images();
newImage.Name = item.Name;
newImage.Path = path;
using (servicedbContext db = new servicedbContext())
{
db.Images.Add(newImage);
db.SaveChanges();
}
}
return(RedirectToAction("LastImage"));
}
public IActionResult LastAddress()
{
using (servicedbContext db = new servicedbContext())
{
return(Ok(db.Addresses.Last()));
}
}
public IActionResult LastImage()
{
using (servicedbContext db = new servicedbContext())
{
return(Ok(db.Images.Last()));
}
}
public IActionResult GetById(int id)
{
using (servicedbContext db = new servicedbContext())
{
return(Ok(db.Images.Find(id)));
}
}
public IActionResult PostOrders([FromBody] OrderDto orderDto)
{
Console.WriteLine("Post order:");
if (ModelState.IsValid)
{
Orders neworder = new Orders();
neworder.Caption = orderDto.Caption.Trim();
neworder.Description = orderDto.Description.Trim();
neworder.Cost = orderDto.Cost;
neworder.Url = DateTime.Now.ToString();
neworder.UpTo = orderDto.UpTo;
neworder.UsersId = 1;
using (servicedbContext db = new servicedbContext())
{
Console.WriteLine("Post order: " + neworder.Caption.ToString());
db.Orders.Add(neworder);
Companyorders newRelation = new Companyorders();
newRelation.IdCompanies = orderDto.CompanyId;
newRelation.IdOrders = neworder.IdOrders;
db.Companyorders.Add(newRelation);
db.SaveChanges();
Console.WriteLine("Post response order: " + neworder.Caption.ToString());
return(Ok(neworder));
}
}
else
{
Console.WriteLine(ModelState.ValidationState);
return(BadRequest(ModelState.ValidationState));
}
}
public IActionResult GetFiltered(int id)
{
if (id == null || id == 0)
{
return(BadRequest());
}
List <Orders> ordList = new List <Orders>();
using (servicedbContext db = new servicedbContext())
{
IEnumerable <Companyorders> companyOrds = db.Companyorders.Where(co => co.IdCompanies == id).ToList();
if (companyOrds == null || companyOrds.Count() == 0)
{
return(BadRequest("No orders for company!"));
}
foreach (var co in companyOrds)
{
ordList.Add(db.Orders.Where(o => o.IdOrders == co.IdOrders).FirstOrDefault());
}
}
IEnumerable <Orders> ords = ordList;
Console.WriteLine("Get response filter!");
return(Ok(ords));
}
public IEnumerable <Users> GetAll()
{
using (servicedbContext db = new servicedbContext())
{
return(db.Users);
}
}
public IEnumerable <Addresses> GetAll()
{
using (servicedbContext db = new servicedbContext())
{
IEnumerable <Addresses> addr = db.Addresses.Where(a => a.IsDeleted == 0).ToList();
return(addr);
}
}
public IEnumerable <Companies> GetAll()
{
using (servicedbContext db = new servicedbContext())
{
IEnumerable <Companies> companies = db.Companies.Where(c => c.IsDeleted == 0).ToList();
Console.WriteLine("Get response Companies!");
return(companies);
}
}
public Companies Create(Companies company)
{
using (servicedbContext db = new servicedbContext())
{
db.Companies.Add(company);
db.SaveChanges();
}
return(company);
}
public IEnumerable <Orders> GetOrders()
{
using (servicedbContext db = new servicedbContext())
{
IEnumerable <Orders> tender = db.Orders.Where(o => o.IsDeleted == 0).ToList();
Console.WriteLine("Get response orders!");
return(tender);
}
}
public IActionResult GetById(int?id)
{
if (id == null || id == 0)
{
return(BadRequest());
}
using (servicedbContext db = new servicedbContext())
{
var company = db.Companies.Where(c => c.IsDeleted == 0 && c.IdCompany == id).First();
var companyDto = _mapper.Map <CompanyDto>(company);
Console.WriteLine("Get response Companies by ID!");
return(Ok(companyDto));
}
}
public IActionResult Authenticate([FromBody] UserDto userDto)
{
var authUser = _userService.Authenticate(userDto.Email, userDto.Pass);
if (authUser == null)
{
return(Unauthorized());
}
var tokenHandler = new JwtSecurityTokenHandler();
var key = Encoding.ASCII.GetBytes(_appSettings.Secret);
var tokenDescriptor = new SecurityTokenDescriptor
{
Subject = new ClaimsIdentity(new Claim[]
{
new Claim(ClaimTypes.Name, authUser.IdUsers.ToString())
}),
Expires = DateTime.UtcNow.AddDays(7),
SigningCredentials = new SigningCredentials(new SymmetricSecurityKey(key),
SecurityAlgorithms.HmacSha256Signature)
};
var token = tokenHandler.CreateToken(tokenDescriptor);
var tokenString = tokenHandler.WriteToken(token);
servicedbContext context = new servicedbContext();
var rules = context.Rules.Where(r => r.IdRules == authUser.RulesId).FirstOrDefault();
var company = context.Companies.Where(c => c.IdCompany == authUser.CompanyId).FirstOrDefault();
Console.WriteLine("Return auth of " + authUser.Email);
return(Ok(new {
IdUser = authUser.IdUsers,
Email = authUser.Email,
LastName = authUser.LastName,
FirstName = authUser.FirstName,
SecondName = authUser.SecondName,
Telephone = authUser.Telephone,
isDeleted = authUser.IsDeleted,
isBlocked = authUser.IsBlocked,
Rule = rules.Name,
Company = company.IdCompany,
Token = tokenString
}));
}
public Users Authenticate(string email, string pass)
{
if (string.IsNullOrWhiteSpace(email) || string.IsNullOrEmpty(pass))
{
return(null);
}
using (servicedbContext db = new servicedbContext())
{
var authUser = db.Users.SingleOrDefault(x => x.Email == email);
if (authUser == null)
{
return(null);
}
if (!VerifyPasswordHash(pass, authUser.PassHash, authUser.PassSalt))
{
return(null);
}
return(authUser);
}
}
public IActionResult Create([FromBody] AddressDto address)
{
if (ModelState.IsValid)
{
Addresses newAddr = new Addresses();
newAddr.Street = address.Street;
newAddr.Number = address.Number;
newAddr.Flat = address.Flat;
newAddr.CityId = 1;
using (servicedbContext db = new servicedbContext())
{
db.Addresses.Add(newAddr);
db.SaveChanges();
}
return(Ok(new{
IdAddress = newAddr.IdAddress
}));
}
else
{
return(BadRequest(ModelState.ValidationState));
}
}
public UserService()
{
_context = new servicedbContext();
}
