public Users create(Users newUser)
{
var usr = _context.Add(newUser).Entity;
_context.SaveChanges();
return(usr);
}
public Machine Subscribe(Machine serviceInfo)
{
var result = _context.Machines.Add(serviceInfo);
_context.SaveChanges();
return(result.Entity);
}
public async Task <IActionResult> PostFile([FromRoute] short id, IFormFile uploadedFile)
{
try
{
using (var memoryStream = new MemoryStream())
{
var val = new File();
val.Name = uploadedFile.FileName;
await uploadedFile.CopyToAsync(memoryStream);
val.Text = Encoding.UTF8.GetString(memoryStream.ToArray());
_dbContext.Files.Add(val);
_dbContext.SaveChanges();
}
// process uploaded files
// Don't rely on or trust the FileName property without validation.
return(Ok());
}
catch (Exception ex)
{
this.logger.LogWarning("", ex);
return(BadRequest());
}
}
public ActionResult <ResponseModel> PutAdd([FromBody] BookModel _book)
{
// var exist = _context.book.SingleOrDefault(tb => tb.user == _book.user && tb.book == _book.book);
// if (exist != null) {
// return new ResponseModel
// {
// status = 404,
// statusText = "failure",
// };
// }
_book.datetime = DateTime.Now;
_context.book.Add(_book);
if (_context.SaveChanges() > 0)
{
var added = _context.book.SingleOrDefault(tb => tb.user == _book.user && tb.book == _book.book && tb.datetime == _book.datetime);
return(new ResponseModel
{
status = 200,
statusText = "success",
data = added
});
}
else
{
return(new ResponseModel
{
status = 404,
statusText = "failure",
});
}
}
public void InsertHashDataForTrack(IEnumerable <HashedFingerprint> hashes, IModelReference trackReference)
{
var subFingerprints = hashes.Select(hash => CopyToSubFingerprint(trackReference, hash))
.ToList();
_context.SubFingerprint.AddRange(subFingerprints);
_context.SaveChanges();
}
public ActionResult <ResponseModel> PostInsert([FromBody] RequestModel req)
{
var todo = new ToDoModel();
var data = new Newtonsoft.Json.Linq.JObject();
var token = new AuthModel();
try
{
todo.name = (string)req.data["name"];
todo.content = (string)req.data["content"];
if ((string)req.data["token"]["token"] != HttpContext.Session.GetString("token"))
{
throw new Exception();
}
token.id = (int)req.data["token"]["id"];
token.token = (string)req.data["token"]["token"];
token = _context.Auth.Single(item => item.id == token.id && item.token == token.token);
todo.uuid = token.uuid;
todo.name = (string)req.data["name"];
todo.content = (string)req.data["content"];
todo.datetime = DateTime.Now;
_context.ToDo.Add(todo);
_context.SaveChanges();
todo = _context.ToDo.Single(item => item.name == todo.name && item.content == todo.content && item.datetime == todo.datetime);
data["id"] = todo.id;
data["name"] = todo.name;
data["content"] = todo.content;
data["datetime"] = todo.datetime;
}
catch (Exception ex) {
data["msg"] = ex.Message;
return(new ResponseModel
{
status = 404,
statusText = "failure",
data = data
});
}
return(new ResponseModel
{
status = 200,
statusText = "success",
data = data,
});
}
public ActionResult <ResponseModel> PostRegister([FromBody] RequestModel req)
{
var user = new UserModel
{
uuid = UUIDModel.GetUUID(),
name = (string)req.data["name"],
password = (string)req.data["password"],
datetime = DateTime.Now
};
_context.User.Add(user);
_context.SaveChanges();
return(new ResponseModel
{
status = 200,
statusText = "success"
});
}
public async Task <IActionResult> PostFile(IFormFile uploadedFile)
{
try
{
using (var memoryStream = new MemoryStream())
{
var val = new Value();
val.Name = uploadedFile.FileName;
await uploadedFile.CopyToAsync(memoryStream);
val.Image = memoryStream.ToArray();
_dbContext.Values.Add(val);
_dbContext.SaveChanges();
}
// process uploaded files
// Don't rely on or trust the FileName property without validation.
return(Ok());
}
catch (Exception ex)
{
return(BadRequest());
}
}
public void Save(Customer customer)
{
var existing = (from c in _dbContext.Customers
where c.Id == customer.Id
select c).SingleOrDefault();
if (existing == null)
{
_dbContext.Customers.Add(customer);
}
else
{
existing.FirstName = customer.FirstName;
existing.LastName = customer.LastName;
}
_dbContext.SaveChanges();
}
public IActionResult NewUser([FromBody] User obj)
{
User user = new User();
user.Name = obj.Name;
user.Email = obj.Email;
try
{
db.Users.Add(user);
db.SaveChanges();
return(Ok(user));
}
catch (Exception e)
{
Console.WriteLine(e);
return(BadRequest());
}
}
public ActionResult Login(string userName, string pwd)
{
User us = null;
try
{
User u = _context.User.ToList().Where(n => (n.LoginName == userName || n.Email == userName || n.Phone == userName) && n.PassWord == pwd).FirstOrDefault();
if (u != null)
{
us = u;
u.LastLoginTime = DateTime.Now;
_context.SaveChanges();
return(Ok(u));
}
return(BadRequest());
}
catch (Exception ex)
{
return(NotFound(ex.Message));
}
}
public void Commit() => context.SaveChanges();
public static IHost Seed(this IHost host)
{
using IServiceScope scope = host.Services.CreateScope();
SQLiteDbContext context = scope.ServiceProvider.GetService <SQLiteDbContext>();
if (context.Users.Any())
{
return(host);
}
var userRole = new Role("User");
var adminRole = new Role("Admin");
string uRoleId = context.Roles.Add(userRole).Entity.Id;
string uRoleId2 = uRoleId;
string aRoleId = context.Roles.Add(adminRole).Entity.Id;
var hasher = new PasswordHasher <User>();
var user1 = new User
{
FirstName = "Teszt",
LastName = "Elek",
UserName = "******",
BirthDate = new DateTime(1996, 6, 5),
Email = "*****@*****.**",
Address = "Itthon",
RoleId = uRoleId
};
user1.PasswordHash = hasher.HashPassword(user1, "123456789aA!");
var user2 = new User
{
FirstName = "Hans",
LastName = "Regenkurt",
UserName = "******",
BirthDate = new DateTime(1978, 10, 9),
Email = "*****@*****.**",
Address = "Otthon",
RoleId = uRoleId2
};
user2.PasswordHash = hasher.HashPassword(user2, "123456789aA!");
var admin = new User
{
FirstName = "John",
LastName = "Doe",
UserName = "******",
BirthDate = new DateTime(1992, 4, 20),
Email = "*****@*****.**",
Address = "Somewhere",
RoleId = aRoleId
};
admin.PasswordHash = hasher.HashPassword(admin, "123456789aA!");
context.Users.Add(user1);
context.Users.Add(user2);
context.Users.Add(admin);
var car1 = new Car
{
Brand = "VW",
Model = "Golf",
Colour = Colour.TurmericYellow,
EngineDescription = "1.4 TSI, 122HP, 200Nm",
LicensePlate = "RPP-469",
Mileage = 6.5
};
var car2 = new Car
{
Brand = "BMW",
Model = "5",
Colour = Colour.Blue,
EngineDescription = "2.5 TFSI, 300HP, 600Nm",
LicensePlate = "FGH-420",
Mileage = 8.3,
};
Premise premise = context.Premises.Add(new Premise
{
Address = "Tiszaújváros Iparipark út 4.",
Name = "Rent a Car"
}).Entity;
car1.PremiseId = premise.Id;
car2.PremiseId = premise.Id;
context.Cars.Add(car1);
context.Cars.Add(car2);
context.SaveChanges();
return(host);
}