/// <summary>
/// 수정
/// </summary>
public FiveViewModel Update(FiveViewModel model)
{
var sql = @"Update Fives
Set Note= @Note
Where Id = @Id
";
_db.Execute(sql, model);
return(model);
}
/// <summary>
/// 입력 메서드
/// </summary>
/// <param name="model">FiveViewModel</param>
/// <returns>FiveViewModel</returns>
public FiveViewModel Add(FiveViewModel model)
{
string sql = @"
Insert into Fives (Note) Values (@Note);
Select Cast (SCOPE_IDENTITY() As Int);
";
var id = _db.Query <int>(sql, new { Note = model.Note }).SingleOrDefault();
model.Id = id;
return(model);
}
