public Vaultkeep AddVaultkeep(Vaultkeep vaultkeepData)
{
//construct a vault
Vaultkeep vaultkeep = new Vaultkeep()
{
VaultId = vaultkeepData.VaultId,
KeepId = vaultkeepData.KeepId,
UserId = vaultkeepData.UserId
};
// run a sql command
var success = _db.Execute(@"
INSERT INTO vaultkeeps(
id,
vaultId,
keepId,
userId
) VALUES(
@Id,
@VaultId,
@KeepId,
@UserId
)
", vaultkeep);
if (success < 1)
{
throw new Exception("vaultkeep exception");
}
// return created vault
return(vaultkeep);
}
// UPDATE Vaultkeep
public Vaultkeep Update(Vaultkeep vaultkeep)
{
_db.Execute(@"UPDATE vaultkeeps
SET vaultid = @VaultId, keepid = @KeepId
WHERE id = @Id;", vaultkeep);
return(vaultkeep);
}
public Vaultkeep Post([FromBody] Vaultkeep vaultkeep)
{
if (ModelState.IsValid)
{
return(_db.Add(vaultkeep));
}
return(null);
}
public Vaultkeep AddVaultkeep([FromBody] Vaultkeep vaultkeep)
{
if (ModelState.IsValid)
{
return(_repo.AddVaultkeep(vaultkeep));
}
return(null);
}
public Vaultkeep Post([FromBody] Vaultkeep vaultkeep)
{
if (ModelState.IsValid)
{
vaultkeep.UserId = HttpContext.User.Identity.Name;
return(_repo.Create(vaultkeep));
}
throw new Exception("INVALID VAULTKEEP");
}
public Vaultkeep GetOneByIdAndUpdate(int id, Vaultkeep vaultkeep)
{
return(_db.QueryFirstOrDefault <Vaultkeep>($@"
UPDATE vaultkeeps SET
VaultId = @VaultId,
KeepId = @KeepId,
UserId = @UserId
WHERE Id = {id};
SELECT * FROM vaultkeeps WHERE id ={id};", vaultkeep));
}
//CREATE VaultKeep
public Vaultkeep Create(Vaultkeep vaultkeep)
{
int id = _db.ExecuteScalar <int>(@"
INSERT INTO vaultkeeps (vaultid, keepid, userid)
Values (@VaultId, @KeepId, @UserId);
SELECT LAST_INSERT_ID();", vaultkeep
);
vaultkeep.Id = id;
return(vaultkeep);
}
public ActionResult <Vaultkeep> createVaultKeep([FromBody] Vaultkeep newVaultKeep)
{
newVaultKeep.UserId = HttpContext.User.Identity.Name;
Vaultkeep result = _vkr.createVaultKeep(newVaultKeep);
if (result == null)
{
return(BadRequest("did not create new vault keep"));
}
return(Ok(result));
}
public Vaultkeep DeleteVaultkeep(Vaultkeep vaultkeep)
{
var i = _db.Execute(@"
DELETE FROM vaultkeeps WHERE id = @Id;
", vaultkeep);
if (i > 0)
{
return(vaultkeep);
}
return(null);
}
//Find one
public Vaultkeep GetOneVaultkeep(int id)
{
Vaultkeep vaultkeep = _db.QueryFirstOrDefault <Vaultkeep>(@"
SELECT * FROM vaults WHERE id = @Id
", new { Id = id });
if (vaultkeep == null)
{
throw new Exception("There was an error getting the vaultkeep");
}
return(vaultkeep);
}
public ActionResult <Vaultkeep> Put([FromBody] Vaultkeep value)
{
try
{
var userId = HttpContext.User.FindFirstValue("Id");
value.UserId = userId;
return(Ok(_repo.Delete(value)));
}
catch (Exception e)
{
return(BadRequest(e));
}
}
public Vaultkeep Add(Vaultkeep vaultkeep)
{
int id = _db.ExecuteScalar <int>(@"INSERT INTO vaultkeeps (VaultId, KeepId, UserId)
VALUES (@VaultId, @KeepId, @UserId);
SELECT LAST_INSERT_ID()", new
{
vaultkeep.VaultId,
vaultkeep.KeepId,
vaultkeep.UserId
});
vaultkeep.Id = id;
return(vaultkeep);
}
// internal Vaultkeep NewVaultKeep(Vaultkeep newVaultKeep)
// {
// throw new NotImplementedException();
// }
// // new post vault keep made
public Vaultkeep createVaultKeep(Vaultkeep vaultKeepToCreate)
{
try
{
int id = _db.ExecuteScalar <int>(@"INSERT INTO vaultKeeps (id, vaultId, keepId, userId)
VALUES (@Id, @VaultId, @KeepId, @UserId); SELECT LAST_INSERT_ID();", vaultKeepToCreate);
vaultKeepToCreate.Id = id;
return(vaultKeepToCreate);
}
catch (Exception e)
{
Console.WriteLine(e);
return(null);
}
}
public Vaultkeep UpdateVaultkeep(Vaultkeep vaultkeep, Vaultkeep vaultkeepData)
{
var i = _db.Execute(@"
UPDATE vaultkeeps SET
id = @Id,
vaultId = @VaultId,
keepId = @KeepId,
userId = @UserId
WHERE id = @Id
", vaultkeepData);
if (i > 0)
{
return(vaultkeepData);
}
return(null);
}
public Vaultkeep DeleteVaultkeep(Vaultkeep vaultkeep)
{
return(_repo.DeleteVaultkeep(vaultkeep));
}
internal Vaultkeep NewVaultKeep(Vaultkeep newVaultKeep)
{
throw new NotImplementedException();
}
public Vaultkeep Put([FromBody] Vaultkeep vaultkeep)
{
return(_repo.Update(vaultkeep));
}
public Vaultkeep UpdateVaultkeep([FromBody] Vaultkeep vaultkeepData)
{
Vaultkeep vaultkeep = _repo.GetOneVaultkeep(vaultkeepData.Id);
return(_repo.UpdateVaultkeep(vaultkeep, vaultkeepData));
}
