public void Delete(Credential credential)
{
using (var connection = this.databaseService.GetOpenConnection())
{
connection.Execute("DELETE FROM credential WHERE id = @id ", credential);
}
}
public Credential Index(int id)
{
var credential = new Credential();
using (var connection = this.databaseService.GetOpenConnection())
{
credential = connection.Query<Credential>("SELECT * FROM credential WHERE id = @id AND userid = @userid", new { id = id, userid = this.User }).FirstOrDefault();
}
return credential;
}
public Credential Post(Credential credential)
{
var user = this.User;
using (var connection = this.databaseService.GetOpenConnection())
{
connection.Execute("INSERT INTO credential (Name, Login, Password, GroupName, IsFavorite) VALUES (@Name, @Login,@Password, @GroupName, @IsFavorite)", credential);
}
return credential;
}
public Credential Put(Credential credential)
{
using (var connection = this.databaseService.GetOpenConnection())
{
credential = connection.Query<Credential>(
@"UPDATE credential
SET Name = @Name,
Login = @Login,
Password = @Password,
GroupName = @GroupName,
IsFavorite = @IsFavorite
WHERE Id = @id
AND userid = @userid", new { credential, userid = this.User }).FirstOrDefault();
}
return credential;
}
public void Options(Credential credential)
{
return;
}
