public Clothes Add(Clothes employee) { //var sqlQuery = "INSERT INTO Clothes (Name, Quantity) VALUES(@Name, @Quantity); " + "SELECT CAST(SCOPE_IDENTITY() as int)"; var employeeId = this._db.Query<Guid>(INSERT_CLOTHES_QUERY, employee).FirstOrDefault(); employee.Id = employeeId; return employee; }
public Clothes Update(Clothes employee) { var sqlQuery = "UPDATE Clothes " + "SET Name = @Name, " + "Quantity = @Quantity " + "WHERE Id = @Id"; this._db.Execute(sqlQuery, employee); return employee; }